先写入代码
'mysql' => [
'read' => [
'host' => [
'192.168.1.1',
'196.168.1.2',
],
],
'write' => [
'host' => [
'196.168.1.3',
],
],
'sticky' => true,
'driver' => 'mysql',
'database' => 'database',
'username' => 'root',
'password' => '',
'charset' => 'utf8mb4',
'collation' => 'utf8mb4_unicode_ci',
'prefix' => '',
],
默认情况下sticky是true,它代表的含义是当一个请求周期开始执行了write炒作,往下面的read操作也会从写write对应的host数据库进行读操作,这样能在读写分离的情况下保证数据展现的正确性(读写分离可能存在时间差异问题)