Hi, I've got 2 mysql server that I want to configure in a hot-standby config in the following manner:
Two servers with a fibre channel connection to a central storage array. The data dir of the database is on this storage array. The OS (linux or solaris, haven't decided yet) sees this datadir as a normal part of its filesystem. The two servers are both connected to a layer 7 switch that can do loadbalancing and hotstandby switching. I'd like to configure the switch to do the last. The switch makes use of a virtual IP address an to this VIP a pool of real addresses is asigned. The switch is configured to 'route' all traffic on port 3306 via a primary path. In case of failure in this path (for instance by crashing of the mysqld) the switch wil start using the secondary path. This setup is completely transparant for the mysql client, because the client is communicating with the VIP of the switch. I'd like to use this setup because a master/slave config is too slow in case of failover for our situation (we need a very fast failover config). Now I'd like to know the following: Can two mysqld's use the same datadir/database (remember they are not writing to the same database at the same time!)? Which OS will support this best in terms of filelocking etc. Linux or Solaris (the fibre channel adapters are well supported in both OSes). Any other views on this type of setup. Regards, Danny --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
