load balanced configuration

[keith smith]

Okay Cool!  We are resync'ing the data every like 15 minutes or 30 minutes to a backup server. I guess I need to look at that also, could be problematic.  Yikes....

So what I was thinking is stopping the backup server MySql and doing a dump, tar it if it is not already or dump lacks that ability, and move the tarball someplace off the server. Restart the server after the dump.  I'm thinking I can set this up on a Cron.

I'm thinking that would work.  Thoughts?

------------------------

Keith Smith

--- On Wed, 5/19/10, Alex Dean <alex at crackpot.org> wrote:

From: Alex Dean <alex at crackpot.org>
Subject: Re: load balanced configuration
To: "Main PLUG discussion list" <plug-discuss at lists.plug.phoenix.az.us>
Date: Wednesday, May 19, 2010, 6:40 PM

On May 19, 2010, at 7:47 PM, Bryan O'Neal wrote:

> mysql dump on a cron job. You write the dump pipe it to gzip and set the name with the date and life is golden.

mysqldump is great if it's OK for your database to be locked while the dump is going on.  If that's acceptable, it's definitely simple, and is what I do for lower traffic databases.

For higher-volume DB servers where that's not an option, it's pretty easy to set up a mysql slave.  Then you can take your dumps from the slave server.  You get a completely consistent backup, but your production database is never down at all.  If dumping to SQL takes up too much disk space, you can also stop the slave server, cp its data files, and start it back up again.

Look into mysqld_multi.  Makes it easy to run multiple instances of mysql on the same machine.  Your slave & master can be on the same hardware.

http://www.howtoforge.com/mysql_database_replication
http://dev.mysql.com/doc/refman/5.0/en/replication.html
http://dev.mysql.com/doc/refman/5.0/en/mysqld-multi.html

alex
---------------------------------------------------
PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us
To subscribe, unsubscribe, or to change your mail settings:
http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss



      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.PLUG.phoenix.az.us/pipermail/plug-discuss/attachments/20100519/eae86106/attachment.htm>