I am facing error when running Master-Slave setup with PCNTL.
exception ‘CDbException’ with message ‘CDbCommand failed to execute the SQL statement: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away’ in /home/mailwizzbuynbag/public_html/mail/apps/common/framework/db/CDbCommand.php:631
If PCNTL is off. Master/Slave setup works perfectly.
Following is the configuration of Master/Slave setup
return array(
‘components’=>array(
‘db’=>array(
‘class’=>‘system.db.CDbConnectionRwMaster’,
‘connectionString’=>‘mysql:host=<MasterHost>;dbname=<dbname>’,
‘charset’=>‘utf8’,
‘username’=>’<dbuser>’,
‘password’=>’<dbpassword>’,
‘slaves’=>array(‘db_readonly1’), // List of read-only slaves
‘enableRwSplitting’=>true, // Enable read-write-splitting for this connection
‘tablePrefix’ => ‘mw_’,
),
‘db_readonly1’=>array(
‘class’=>‘CDbConnection’,
‘connectionString’=>‘mysql:host=<SlaveHost>;dbname=<dbname>’,
‘charset’=>‘utf8’,
‘username’=>’<dbuser>’,
‘password’=>’<dbpassword>’,
‘tablePrefix’ => ‘mw_’,
),
)
);
Thanks