Web Host Chat - View Single Post

Dhosting · 21st June 2008

We had two w2k3 boxes doing master to master MySQL 5 replication between two data centers never an issue, always helps if you set the auto increment offset properly etc.

Also did a MySQL 4.1 master to slave in the event of the master failing we could handle transactions on the slave and essentially switch the roles so the slave became the master etc.

It can generate some super large files though log wise so watch out for it, you can usually clean them out if you set MySQl up right.

Naturally your App needs to look for the backup mysql box if the primary times out etc.

21st June 2008	#4 (permalink)
Dhosting I am Staff at Dwebs Ltd About My Company! Certified Host Join Date: Jan 2006 Location: Blackpool Age: 20 Posts: 1,301	We had two w2k3 boxes doing master to master MySQL 5 replication between two data centers never an issue, always helps if you set the auto increment offset properly etc. Also did a MySQL 4.1 master to slave in the event of the master failing we could handle transactions on the slave and essentially switch the roles so the slave became the master etc. It can generate some super large files though log wise so watch out for it, you can usually clean them out if you set MySQl up right. Naturally your App needs to look for the backup mysql box if the primary times out etc. __________________ Chris Daley Dwebs Ltd :: Company No. 05603664 :: 08000 141 942 2008hosting.net - Windows 2008 Server Hosting Solutions Dhosting.co.uk - Web Hosting, Managed Servers Dwebs.ltd.uk - Web Design & Other Services My views are my own and not those of my company. __________________ Web Host - VIP Member