MySQL Forums
Forum List  »  Replication

Re: Replication & failover with 4 servers
Posted by: Joao Villa-Lobos
Date: September 27, 2010 11:09AM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
903
September 26, 2010 10:29AM
Re: Replication & failover with 4 servers
813
September 27, 2010 11:09AM
790
September 27, 2010 07:39PM


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.