redundant servers

[ggggus]

I've been searching google, but maybe I'm not using the right terminology....I'm looking for information on having duplicate mysql databases on two servers that house the same information.

So physical Server A has a mysql database running on it, and physical Server B has an identical database running on it. so if one of the physical servers goes down, I can get information from the other mysql server. I also want them to keep identical information on each other, so if a user updates his password, it's updated in both databases in real time....and when one of the servers comes back online, it gets rebuilt by server that stayed up.

***************************************
J. Jacobs

http://www.piercedmedia.com

 

[TonyGroves]

It's "replication" you're looking for, at

http://dev.mysql.com/doc/refman/5.1/en/replication-intro.html

.