Mailinglist Archive: opensuse-security (757 mails)

< Previous Next >
Re: [suse-security] MySQL cluster
  • From: Carlos Manuel Duclos Vergara <carlos@xxxxxxxxxxx>
  • Date: Tue, 15 Jan 2002 10:14:21 -0300
  • Message-id: <02011510132804.02278@cyrano>
On Tuesday 15 January 2002 09:47, you wrote:
> Hi,
>
> working with a MySQL-Database (or s.th. similar) gives you always a
> single point of failure. Does anyone of you know a solution how to keep
> e.g. 2 MySQL datbases in sync all the time, so if one of them fails, no
> user of the db has to care of his data?
>
> Thanks for any hint to solve this.
>
> Ralf
>
> *

Hi,
the only way to have an "online" redundancy of data is trhough a wrapper. It
may be provided for the guys of MySQL (i don't know if they have something
like that) or you. The wrapper will listen transactions and then assign each
transactions to both servers, so they can process and record it. Note that
this kind of thing is very similar to journaling filesystems or raid (with
obviuos diferences).
The other form (not "online") is to keep the db files on rsync or cvs or such
a thing and let them to take care of the data syncronization. Obviuosly there
is still a chance to get a loss of data or data offset between databases.
Bye


--
Carlos Manuel Duclos Vergara


< Previous Next >
Follow Ups
References