[Gllug] creating a backup machine (my SQL)

[Pooly]

Hi,

the best would be to follow the documentation on http://dev.mysql.com
it will be more precise, and more up to date !
But I can copy the script I use for swaping the two servers if you want.

2005/10/6, munir <munir at 3adl.com>:
> Pooly many thanks for your help, can you pls give a little more infrmation,
> how to do the relication machine?
>
> Many thanks
>
> _________________________________________________________________________
>
>          Munir Ahmad e: munir at 3adl.com
>
>     3A Distribution Ltd, Unit 1 Oakwood Business Park, Standard Road,
>                      London NW10 6EX, English.
>      Tel: +44 208 838 5511 Fax: +44 208 838 0171 w:www.3adl.com
> __________________________________________________________________________
>
>
> -----Original Message-----
> From: Pooly <pooly7 at gmail.com>
> To: Greater London Linux User Group <gllug at gllug.org.uk>
> Date: Wed, 5 Oct 2005 21:43:38 +0100
> Subject: Re: [Gllug] creating a backup machine (my SQL)
>
> > Hi,
> >
> > 2005/10/4, munir <munir at 3adl.com>:
> > > Hello all,
> > >
> > > Can some pls advise me how I can create a backup machine (BSD 3.2)
> > which is
> > > only running mySQL. I would like the new machine to have all the same
> > > attributes/permissions as the original one. In addition I would like
> > to update
> > > the backup (Database) machine once or twice a day!? The allpilcation
> > > connected to the mySQL uses ODBC !
> >
> > You could set up replication, it would an easy solution.
> > If the machine goes down, a script that change hostname and IP for the
> > NIC should do the trick of swaping the database (with some downtime on
> > the clients side though). That's what we use at my office, and it
> > works well. (Results will depend on your own setup ! )
> >
> >
> > --
> > Pooly
> > Webzine Rock : http://www.w-fenec.org/
> > --
> > Gllug mailing list  -  Gllug at gllug.org.uk
> > http://lists.gllug.org.uk/mailman/listinfo/gllug
>
>
>
>
>


--
Pooly
Webzine Rock : http://www.w-fenec.org/
-- 
Gllug mailing list  -  Gllug at gllug.org.uk
http://lists.gllug.org.uk/mailman/listinfo/gllug