Re: Replication & failover with 4 servers
Hi Rick,
First of all, thanks for your reply.
I have set up both servers similarly (right now I'm testing with only 2, still expecting for the other machines to arrive...), so the my.cnf files look like this:
server-id = 51 # last octet from the physical IP. The other server's id = 115
log-bin = mysql-bin
log-error = mysql-log-error
relay_log = mysql-relay-bin
relay_log_index = mysql-relay-bin.index
log_slave_updates = 1
read_only = 1
innodb_flush_log_at_trx_commit = 1
innodb_support_xa = 1
skip_slave_start
sync_binlog = 1
Is there anything else I should use? Is there something that might be considered useless/irrelevant on my current setup?
Thanks in advance,
João
Subject
Views
Written By
Posted
2425
September 20, 2010 10:17AM
903
September 26, 2010 10:29AM
Re: Replication & failover with 4 servers
813
September 27, 2010 11:09AM
790
September 27, 2010 07:39PM
719
September 28, 2010 07:07AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.