Hello everybody! So I'm moving a rather large mysql DB from one server to another. It sucks. I can't have any real long downtime so dump/restore, not an option.
It's innodb so I can't rsync and repair. What I'm using now is percona xtrabackup which gives me a window of about three hours from read lock to recovery. Not too bad for a 800+GB DB. Never mind all that. The real question is, "What can I do now to avoid this in the future?" I don't have a second box yet so a slave won't help. This box is already a hybrid master/slave setup as it is. This leave me with DRDB. Has anyone used DRDB with LVM and Mysql? Thoughts? Concerns? What I would really like to work is drdb on the box that exists now and then when I get a new box in the future setup drdb on that and slave to it. Thanks. _______________________________________________ Mid-Hudson Valley Linux Users Group http://mhvlug.org http://mhvlug.org/cgi-bin/mailman/listinfo/mhvlug Upcoming Meetings (6pm - 8pm) MHVLS Auditorium Sep 7 - DIY 3D Printing and the Makerbot Thing-o-Matic Oct 5 - Distributed Authentication Systems Nov 2 - Nov 2011
