Mysql master-slave replication REPLICATE_DO_DB parameter rolls back to the initial settings every time after the slave server reboots
我想大声告诉你
我想大声告诉你 2017-05-18 10:54:55
0
3
656

I built mysql master-slave replication on Microsoft Cloud
I used bitnami with replication mirror

my.cnf configuration in the mirror (main server)

[mysqladmin]
user=

[mysqld]
skip-name-resolve
basedir=/opt/bitnami/mysql
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=16M
bind-address=0.0.0.0
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
log-error=/opt/bitnami/mysql/logs/mysqld.log
character-set-server=UTF8
collation-server=utf8_general_ci

[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
default-character-set=UTF8

[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid

!include /bitnami/mysql/conf/my_custom.cnf

My.cnf configuration in the mirror (slave server)

[mysqladmin]
user=

[mysqld]
skip-name-resolve
basedir=/opt/bitnami/mysql
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
tmpdir=/opt/bitnami/mysql/tmp
max_allowed_packet=16M
bind-address=0.0.0.0
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
log-error=/opt/bitnami/mysql/logs/mysqld.log
character-set-server=UTF8
collation-server=utf8_general_ci

[client]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
default-character-set=UTF8

[manager]
port=3306
socket=/opt/bitnami/mysql/tmp/mysql.sock
pid-file=/opt/bitnami/mysql/tmp/mysqld.pid
    
!include /bitnami/mysql/conf/my_custom.cnf

There is no setting for the REPLICATE_DO_DB parameter

After connecting to mysql, execute sql to modify REPLICATE_DO_DB
CHANGE REPLICATION FILTER REPLICATE_DO_DB = ();
After starting the slave; master-slave replication is available, but REPLICATE_DO_DB will be rolled back to the default after each reboot of the slave server bitnami database

Is there any other place to set REPLICATE_DO_DB?

我想大声告诉你
我想大声告诉你

Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!