README

As mentioned in PR 50044, this package was implemented for lower Laravel version (PHP >= 7.2, Laravel >= 6)

"The current code does multiple round-trips to set all the variables we need for our config, both because there are multiple commands to run, but also because it's using prepare, for many of them - each use of prepare and execute causes 3 round trips - one to prepare, one to execute, and one to close statement (on garbage collection of the statement in PHP land). The MySQL SET command supports setting multiple things in a comma separated fashion. Refactoring to do this enables us to just run one SET statement against the server. This can make a real difference in a cloud situation such as AWS Lambda talking to an RDS database where we have to go cross-AZ with low single digit ms latency, instead of sub-ms latency. This also reduces load on the DB (fewer statements to execute), so spinning up a bunch of Lambdas in a burst will be less of a burden."

Installation

You can install the package via composer:

composer require huy-nguyen/laravel-optimize-init-db-connection

You can publish the config file with:

php artisan vendor:publish --tag="optimize-init-db-connection-config"

This is the contents of the published config file:

return [
     'driver' => 'mysql',
];

Usage

As default, this package will change your "mysql" connection. You can setup new database connection by:

Change your configuration (php config/optimize-init-db-connection.php )

return [
     'driver' => 'optimize-mysql',
];

Update your driver connection to optimize-mysql :

'mysql' => [
            'driver' => 'optimize-mysql',
            'url' => env('DATABASE_URL'),
            'host' => env('DB_HOST', '127.0.0.1'),
            'port' => env('DB_PORT', '3306'),
            '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' => false,
            'engine' => null,
            'options' => []
        ],

Testing

composer test

Changelog

Please see CHANGELOG for more information on what has changed recently.

Contributing

Please see CONTRIBUTING for details.

Security Vulnerabilities

Please review our security policy on how to report security vulnerabilities.

Credits

License

The MIT License (MIT). Please see License File for more information.

huy-nguyen / laravel-optimize-init-db-connection

Maintainers

Details