Description:
Documentation says:
" * `--replicate-do-db=DB_NAME'
Tell the slave to restrict replication to statements where the
default database (that is, the one selected by `USE') is DB_NAME.
To specify more than one database, use this option multiple times,
once for each database..."
When mysqld is started via mysqlmanager it is impossible to replicate more than one db due to the fact that mysqlmanager acctually drops all but last invocations of replicate-do-db in my.cnf from command line
How to repeat:
rathamahata@bbdb-dev ~ $ grep replicate-do-db /etc/mysql/my.cnf
replicate-do-db=bb_blog
replicate-do-db=bb_forum
replicate-do-db=bb_geo
replicate-do-db=bb_wiki
replicate-do-db=cookier
replicate-do-db=stat_all
rathamahata@bbdb-dev ~ $
rathamahata@bbdb-dev ~ $ ps aux --cols=8192 | grep mysqld | grep -v grep
mysql 15765 0.0 0.0 12784 696 ? Ss Dec11 0:00 /usr/sbin/mysqlmanager --defaults-file=/etc/mysql/my.cnf --pid-file=/var/run/mysqld/mysqlmanager.pid --socket=/var/run/mysqld/mysqlmanager.sock
mysql 15766 0.0 0.0 13024 1244 ? Sl Dec11 0:05 /usr/sbin/mysqlmanager --defaults-file=/etc/mysql/my.cnf --pid-file=/var/run/mysqld/mysqlmanager.pid --socket=/var/run/mysqld/mysqlmanager.sock
mysql 15774 0.1 1.4 478396 58480 ? Sl Dec11 1:34 /usr/sbin/mysqld --no-defaults --port=3306 --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql/mysql.err --datadir=/var/lib/mysql --skip-locking --key_buffer=8M --max_allowed_packet=16M --table_cache=512 --sort_buffer=16M --record_buffer=2M --myisam_sort_buffer_size=8M --thread_cache=4 --tmp_table_size=64M --max_heap_table_size=512M --max_connections=100 --set-variable=thread_concurrency=8 --server-id=1001 --log-bin=/var/log/mysql/binlog --expire_logs_days=1 --relay-log=/var/log/mysql/bbdb-relay-bin --relay-log-index=/var/log/mysql/bbdb-relay-bin.index --relay-log-info-file=/var/log/mysql/bbdb-relay-log.info --replicate-do-db=stat_all --slave_compressed_protocol=1 --report-host=bbdb.int.bb.ru --default-character-set=cp1251 --query_cache_size=8M --query_cache_type=1 --innodb_data_home_dir=/var/lib/mysql-innodb/ --innodb_log_group_home_dir=/var/lib/mysql-innodb/ --innodb_data_file_path=ibdata1:100M:autoextend:max:12000M --innodb_mirrored_log_groups=1 --innodb_log_files_in_group=3 --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_flush_log_at_trx_commit=1 --innodb_buffer_pool_size=256M --innodb_additional_mem_pool_size=8M --innodb_file_io_threads=4 --innodb_lock_wait_timeout=50 --tmpdir=/tmp/
rathamahata@bbdb-dev ~ $
Note that there is only last of `replicate-do-db' options and others are gone.
Description: Documentation says: " * `--replicate-do-db=DB_NAME' Tell the slave to restrict replication to statements where the default database (that is, the one selected by `USE') is DB_NAME. To specify more than one database, use this option multiple times, once for each database..." When mysqld is started via mysqlmanager it is impossible to replicate more than one db due to the fact that mysqlmanager acctually drops all but last invocations of replicate-do-db in my.cnf from command line How to repeat: rathamahata@bbdb-dev ~ $ grep replicate-do-db /etc/mysql/my.cnf replicate-do-db=bb_blog replicate-do-db=bb_forum replicate-do-db=bb_geo replicate-do-db=bb_wiki replicate-do-db=cookier replicate-do-db=stat_all rathamahata@bbdb-dev ~ $ rathamahata@bbdb-dev ~ $ ps aux --cols=8192 | grep mysqld | grep -v grep mysql 15765 0.0 0.0 12784 696 ? Ss Dec11 0:00 /usr/sbin/mysqlmanager --defaults-file=/etc/mysql/my.cnf --pid-file=/var/run/mysqld/mysqlmanager.pid --socket=/var/run/mysqld/mysqlmanager.sock mysql 15766 0.0 0.0 13024 1244 ? Sl Dec11 0:05 /usr/sbin/mysqlmanager --defaults-file=/etc/mysql/my.cnf --pid-file=/var/run/mysqld/mysqlmanager.pid --socket=/var/run/mysqld/mysqlmanager.sock mysql 15774 0.1 1.4 478396 58480 ? Sl Dec11 1:34 /usr/sbin/mysqld --no-defaults --port=3306 --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --log-error=/var/log/mysql/mysql.err --datadir=/var/lib/mysql --skip-locking --key_buffer=8M --max_allowed_packet=16M --table_cache=512 --sort_buffer=16M --record_buffer=2M --myisam_sort_buffer_size=8M --thread_cache=4 --tmp_table_size=64M --max_heap_table_size=512M --max_connections=100 --set-variable=thread_concurrency=8 --server-id=1001 --log-bin=/var/log/mysql/binlog --expire_logs_days=1 --relay-log=/var/log/mysql/bbdb-relay-bin --relay-log-index=/var/log/mysql/bbdb-relay-bin.index --relay-log-info-file=/var/log/mysql/bbdb-relay-log.info --replicate-do-db=stat_all --slave_compressed_protocol=1 --report-host=bbdb.int.bb.ru --default-character-set=cp1251 --query_cache_size=8M --query_cache_type=1 --innodb_data_home_dir=/var/lib/mysql-innodb/ --innodb_log_group_home_dir=/var/lib/mysql-innodb/ --innodb_data_file_path=ibdata1:100M:autoextend:max:12000M --innodb_mirrored_log_groups=1 --innodb_log_files_in_group=3 --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_flush_log_at_trx_commit=1 --innodb_buffer_pool_size=256M --innodb_additional_mem_pool_size=8M --innodb_file_io_threads=4 --innodb_lock_wait_timeout=50 --tmpdir=/tmp/ rathamahata@bbdb-dev ~ $ Note that there is only last of `replicate-do-db' options and others are gone.