I am having issues with my replication setup. it seems that every few weeks/months something happens, and I have to restart it, skip a row, or delete, rsync and restart replication from scratch.
The databases that are being replicated, are rather large... there are about 12 new tables every year, each consisting of about 2-4g in size each (today's total database size is 83g).
Again, things work fine for a while, and then there are issues. The backup/slave is on the same network/datacenter, so network speed isn't an issue. I just don't understand why inconsistencies keep arising. Is there a better way to do live backups, or have a hot space in the event of a catastrophe? Is there 3rd party software that would better achieve data integrity or something?
Any help here would be appreciated.
Thanks!
Steve.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=listsearcharchive@lassosoft.com
Nov 10
Reindl Harald Re: Relication Issues
Nov 10, 2011; 14:42
Reindl Harald
Re: Relication Issues
Nov 10
Steven Staples RE: Relication Issues
Nov 10, 2011; 09:08
Steven Staples
RE: Relication Issues
Nov 10
Prabhat Kumar Re: Relication Issues
Nov 10, 2011; 09:13
Prabhat Kumar
Re: Relication Issues
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!