oh86/laravel-mysql-lb

Laravel database driver for mysql cluster

1.0.0 2025-03-19 09:11 UTC

Requires (Dev)

• laravel/framework: *

MIT

• chengj

README

1.配置 config/database.php

return [
    'connections' => [
        // ...
        'mysql-lb' => [
            'driver' => 'mysql-lb',
            'servers' => env('DB_SERVERS', '127.0.0.1:3306'),
            'servers_weight' => env('DB_SERVERS_WEIGHT', ''),

            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'unix_socket' => env('DB_SOCKET', ''),
            'charset' => 'utf8mb4',
            'collation' => 'utf8mb4_unicode_ci',
            'prefix' => '',
            'prefix_indexes' => true,
            'strict' => true,
            'engine' => null,
            'options' => extension_loaded('pdo_mysql') ? array_filter([
                PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
            ]) : [],
        ],
    ],
];

2.配置 .env

DB_CONNECTION=mysql-lb
DB_SERVERS=127.0.0.1:3307,127.0.0.1:3308,127.0.0.1:3309,127.0.0.1:3306
DB_SERVERS_WEIGHT=4,3,2,1   # 非必须
DB_DATABASE=
DB_USERNAME=
DB_PASSWORD=