PHP code example of furan / magento-read-write-split
1. Go to this page and download the library: Download furan/magento-read-write-split library . Choose the download type require .
2. Extract the ZIP file and open the index.php.
3. Add this code to the index.php.
<?php
require_once('vendor/autoload.php');
/* Start to develop here. Best regards https://php-download.com/ */
furan / magento-read-write-split example snippets
'db' => [
'connection' => [
'default' => [
'host' => 'master-db-host',
'dbname' => 'magento',
'username' => 'dbuser',
'password' => 'dbpass',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false
]
],
'indexer' => [
'host' => 'master-db-host',
'dbname' => 'magento',
'username' => 'dbuser',
'password' => 'dbpass',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1'
]
],
'reader_connections' => [
'default' => [
// Note this is an array, even if only using 1 you must keep this structure
[
'host' => 'reader-1-host',
'dbname' => 'magento',
'username' => 'dbuser',
'password' => 'dbpass',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false
]
],
[
'host' => 'reader-2-host',
'dbname' => 'magento',
'username' => 'dbuser',
'password' => 'dbpass',
'model' => 'mysql4',
'engine' => 'innodb',
'initStatements' => 'SET NAMES utf8;',
'active' => '1',
'driver_options' => [
1014 => false
]
]
]
]
],