myslq update same table / two separate PC's 1

[busster]

Have a customer who wants to have an active server and a backup server sitting side by side. The two servers will be exact mirror images of each other. Ultimately would like any changes made to the Mysql database made to the primary, be simultaneously written to the same database in the backup server.

It is my understanding that this can be done. Can someone point me in the right direction to get this accomplished? Additionally, I am pretty new at this, so please forgive my ignorance.

 

[vacunita]

Start here:

Replication:

http://dev.mysql.com/doc/refman/5.0/en/replication.html

How To Set Up Database Replication In MySQL

http://www.howtoforge.com/mysql_database_replication

----------------------------------
Phil AKA Vacunita
----------------------------------
Ignorance is not necessarily Bliss, case in point:
Unknown has caused an Unknown Error on Unknown and must be shutdown to prevent damage to Unknown.

 

[busster]

thanks.