关于atlas读写分离mysql安装discuz
使用atlas读写分离时,用了atlas所在的服务器ip为安装数据库时的ip,出现报错
run_sql_error SQL:SET sql_mode='' Error:MySQL server has gone away Errno:2006
请问要使用atlas配置读写分离的话,数据库要怎么配置才能正常安装数据库配置文件
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysqldata
server_id=6
binlog_format=row
skip-name-resolve
gtid-mode=on
enforce-gtid-consistency=true
log_bin=/data/binlog/mysql-bin
log-error=/var/log/mysql/error.log
pid-file=/data/mysqldata/mysql.pid
port=3306
wait_timeout=2880000
interactive_timeout=2880000
max_allowed_packet = 64M
init_connect='SET NAMES utf8'
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci
run_sql_error SQL:SET sql_mode='' Error:MySQL server has gone away Errno:2006
请问要使用atlas配置读写分离的话,数据库要怎么配置才能正常安装数据库配置文件
[mysqld]
user=mysql
basedir=/usr/local/mysql
datadir=/data/mysqldata
server_id=6
binlog_format=row
skip-name-resolve
gtid-mode=on
enforce-gtid-consistency=true
log_bin=/data/binlog/mysql-bin
log-error=/var/log/mysql/error.log
pid-file=/data/mysqldata/mysql.pid
port=3306
wait_timeout=2880000
interactive_timeout=2880000
max_allowed_packet = 64M
init_connect='SET NAMES utf8'
default-storage-engine=INNODB
character-set-server=utf8
collation-server=utf8_general_ci