Ich habe die MySQL-Master-Slave-Replikation in der Microsoft Cloud erstellt
Ich habe das Bitnami mit Replikationsimage verwendet
my.cnf-Konfiguration im Spiegel (Hauptserver)
[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-Konfiguration im Spiegel (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
Es gibt keine Einstellung für den REPLICATE_DO_DB-Parameter
Nachdem Sie eine Verbindung zu MySQL hergestellt haben, führen Sie SQL aus, um REPLICATE_DO_DB zu ändern.
CHANGE REPLICATION FILTER REPLICATE_DO_DB = ();
这种情况肯定是在默认启动参数中配置了才会按这个启动(猜测要么你看的配置文件不对,要么可能在你创建的时候就配置的),你需要将你的自定义参数写到配置文件中尝试一下
把主从配置信息写入配置文件!
自己linux不熟出现的问题,是在配置文件里面
配置文件最后 !include /bitnami/mysql/conf/my_custom.cnf
linux文件链接
这里配置。。。文件找了很久