Hi All,

I have a server that i need to mirror elsewhere for data redundancy
purposes. What is the best way to have this done? The sites on my box
are MySQL and PostgreSQL driven so those need to be on both machines as
well. Ideally id like to have a main server and in any event that the
main server went down, switch to the other server.

Any info greatly appreciated

Cheers

Will


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On Mon, Jan 22, 2007 at 03:43:05PM +1000, Will Parkinson wrote:
> Hi All,
>
> I have a server that i need to mirror elsewhere for data redundancy
> purposes. What is the best way to have this done? The sites on my box
> are MySQL and PostgreSQL driven so those need to be on both machines as
> well. Ideally id like to have a main server and in any event that the
> main server went down, switch to the other server.
>
Have you tried searching on "linux high availability" yet? The short
answer is: "it is neither easy nor cheap."

Regards,

-Roberto

--
Roberto C. Sanchez
http://people.connexer.com/~roberto
http://www.connexer.com

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFtFSi1snWssAFC08RApr5AJwNvQFONSz7Si7FmRVXCh zEKew9uwCggalv
XGoK/s7MfFouKYtgVTS+nPY=
=rDYk
-----END PGP SIGNATURE-----

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On 01/21/07 23:43, Will Parkinson wrote:
> Hi All,
>
> I have a server that i need to mirror elsewhere for data redundancy
> purposes. What is the best way to have this done? The sites on my box
> are MySQL and PostgreSQL driven so those need to be on both machines as
> well. Ideally id like to have a main server and in any event that the
> main server went down, switch to the other server.
> Any info greatly appreciated

Do you mean that you need to mirror the MySQL & PostgreSQL
databases, or some non-database files, or both?


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFtF94S9HxQb37XmcRAkpPAJ9j3tOas1wGYgKqEjjq+V UazU1oSwCglm25
0Jqjnu59/XZDos8E9WuTbT0=
=B/MW
-----END PGP SIGNATURE-----


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

Yes i need to mirror all functions, programs, crons, databases etc to do
with a web server. I have been looking this up and it seems, as roberto
said in an earlier post, its is going to be an expensive exercise. I
really need a cheap option at the moment if there is such a thing.

Cheers

Will

Ron Johnson wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> On 01/21/07 23:43, Will Parkinson wrote:
>
>> Hi All,
>>
>> I have a server that i need to mirror elsewhere for data redundancy
>> purposes. What is the best way to have this done? The sites on my box
>> are MySQL and PostgreSQL driven so those need to be on both machines as
>> well. Ideally id like to have a main server and in any event that the
>> main server went down, switch to the other server.
>> Any info greatly appreciated
>>
>
> Do you mean that you need to mirror the MySQL & PostgreSQL
> databases, or some non-database files, or both?
>
>
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.6 (GNU/Linux)
>
> iD8DBQFFtF94S9HxQb37XmcRAkpPAJ9j3tOas1wGYgKqEjjq+V UazU1oSwCglm25
> 0Jqjnu59/XZDos8E9WuTbT0=
> =B/MW
> -----END PGP SIGNATURE-----
>
>
>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

MySQL & PostgreSQL each have database-specific replication options.

For non-database files, I'd first look at rsync. If that does not
do what you want, next look at OCFS2 and think about clustering
(non-database) partititions.

On 01/22/07 17:30, Will Parkinson wrote:
> Yes i need to mirror all functions, programs, crons, databases etc to do
> with a web server. I have been looking this up and it seems, as roberto
> said in an earlier post, its is going to be an expensive exercise. I
> really need a cheap option at the moment if there is such a thing.
>
> Cheers
>
> Will
>
> Ron Johnson wrote:
> On 01/21/07 23:43, Will Parkinson wrote:
>
>>>> Hi All,
>>>>
>>>> I have a server that i need to mirror elsewhere for data redundancy
>>>> purposes. What is the best way to have this done? The sites on my box
>>>> are MySQL and PostgreSQL driven so those need to be on both machines as
>>>> well. Ideally id like to have a main server and in any event that the
>>>> main server went down, switch to the other server.
>>>> Any info greatly appreciated
>>>>
>
> Do you mean that you need to mirror the MySQL & PostgreSQL
> databases, or some non-database files, or both?

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)

iD8DBQFFtV/QS9HxQb37XmcRAtaNAKCCEY0RmPYnu6blSLDQK/lVYF+OgACg6tsV
kjjqCdp3dTkO6Xmi0owcloo=
=uMvM
-----END PGP SIGNATURE-----


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org

On Mon, 2007-01-22 at 15:43 +1000, Will Parkinson wrote:
> Hi All,
>
> I have a server that i need to mirror elsewhere for data redundancy
> purposes. What is the best way to have this done? The sites on my box
> are MySQL and PostgreSQL driven so those need to be on both machines as
> well. Ideally id like to have a main server and in any event that the
> main server went down, switch to the other server.

That's exactly what drbd+heartbeat does for you. drbd mirrors your data
and heartbeat handles the fail over. (see drbd.org and linux-ha.org)
This has worked for me. I think I saw someone mention heartbeat and
linux-ha already, so sorry if this is redundant. The ideal scenario is
to have both machines identical, but that is not necessary. So, if you
have another server you can use, it may be cheap that way. However,
there is a time commitment to learning how to use the two tools.

Good luck,
Tom


--
To UNSUBSCRIBE, email to debian-user-REQUEST@lists.debian.org
with a subject of "unsubscribe". Trouble? Contact listmaster@lists.debian.org