[PHP-DB] Mirroring two DB
Hi, I want to know how to mirror one MySQL database installed in two different servers so they can be synchronized. Any idea? thanks, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mirroring two DB
> I want to know how to mirror one MySQL database installed in two > different servers so they can be synchronized. > >Any idea? Search the MySQL docs/manual for "master" and/or "slave". There are good examples for setting up replication from many different web sites as well. David -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Mirroring two DB
thanks to all for the answers. I'm reading the Replication section of MySQL manual. It is exactly what I need. My scenary is of of one Mysql working in Intranet, and the replication in another server in Internet. Both working with Linux, I expect people indexing information in both sides at same time. As I am reading in MysQL manual, I will need to establish the connection by some port. I ignore the security and performance consequences in the Internet server side. It can be better using an alternative port? Also, I can expect some decrement in my internet server? There is some advice regarding authomatic updates in the MySQL engine? Any advice will be of great help thanks again, > You can setup two servers in a master slave situation, you'll need to do all > your inserts on the master, but the slave will stay synced. There is some > latency to that setup, but depending on a few variables it's not too long. > > MySQL Cluster is released now too, which may provide a better solution, but > I've never looked at it. Just go to their website and read up on it. > > -Micah -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] Mirroring two DB
http://dev.mysql.com/doc/refman/5.1/en/replication-intro.html bastien From: Vicente <[EMAIL PROTECTED]> Reply-To: Vicente <[EMAIL PROTECTED]> To: php-db@lists.php.net Subject: [PHP-DB] Mirroring two DB Date: Tue, 28 Feb 2006 18:50:46 +0100 Hi, I want to know how to mirror one MySQL database installed in two different servers so they can be synchronized. Any idea? thanks, -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php