Working with Mysql 5.5 and I am having no luck getting a two node multi
master replication setup going. Here are my configs so far:
Server 1 - 10.123.70.10
------------------------------
master.info:
mysql-bin.000007
10.123.70.11
repl
replpassword
3306
1800.000
my.cnf:
bind-address = 10.123.70.10
server-id=1
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=cmgapp,puma
relay-log=mysqld-relay-bin
log-slave-updates
auto_increment_increment = 10
auto_increment_offset = 1
Server 2 - 10.123.70.11
------------------------------
master.info:
mysql-bin.000007
10.123.70.10
repl
replpassword
3306
1800.000
my.cnf:
bind-address = 10.123.70.11
server-id=2
log-bin=mysql-bin
log-error=mysql-bin.err
binlog_do_db=cmgapp,puma
relay-log=mysqld-relay-bin
log-slave-updates
auto_increment_increment = 10
auto_increment_offset = 2
Any advice, or a link to an example setup would be much appreciated.
