load balanced configuration

[Bryan O'Neal]

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.

On Wed, May 19, 2010 at 3:50 PM, keith smith <klsmith2020 at yahoo.com> wrote:

>
> Very good points!  What is an easy way to automate backing up a dozen or so
> tables on a MySql Server?
>
> ------------------------
> 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, 3:07 PM
>
>
>
> On May 19, 2010, at 4:07 PM, keith smith wrote:
>
> >
> > In a nutshell I am trying to create an automated backup that is a
> automated fail over solution.
>
> Keep in mind that failover/HA is not the same as backup.  It makes sense
> that both servers can do both jobs (you could keep your backups on both your
> production servers), but the failover/replication process should not be
> considered a backup process.
>
> I understand 'high availability' to mean that both servers will have access
> to the same (or nearly the same) data, so either one could be primary.  In
> that case, anything which happens on your primary should automatically be
> replicated/synced/whatever to your secondary.  If you get hacked and someone
> does 'DROP DATABASE yourcart;', it's gone from both servers.
>
> Making an hourly or daily backup of your data & critical files, and storing
> them elsewhere, is crucial.  Then... practice the steps needed to actually
> use those backups.  Discovering that your backups require 18 hours of
> restore time before you can get them into production is awful.  Doubly awful
> if you discover it only when you actually need to use them.  Yes, it
> happened to me. :)
>
> alex
> ---------------------------------------------------
> PLUG-discuss mailing list - PLUG-discuss at lists.plug.phoenix.az.us<http://mc/compose?to=PLUG-discuss@lists.plug.phoenix.az.us>
> To subscribe, unsubscribe, or to change your mail settings:
> http://lists.PLUG.phoenix.az.us/mailman/listinfo/plug-discuss
>
>
>
> ---------------------------------------------------
> 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/2d8b058f/attachment.htm>