我在微軟雲上搭建mysql主從複制master-slave
使用了bitnami with replication 的鏡像
鏡像中my.cnf配置(主伺服器)
[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配置(從伺服器)
[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
并沒有關于REPLICATE_DO_DB 參數的設定
連接配接進入mysql後執行sql修改REPLICATE_DO_DB
CHANGE REPLICATION FILTER REPLICATE_DO_DB = ();
在啟動slave；主從複制是可以得的，可是每次reboot從伺服器後REPLICATE_DO_DB都會復原回預設bitnami資料庫
是不是還有其他地方設定REPLICATE_DO_DB？