Hi, I'm not sure if I understand you but you can't have the datadir/database filesystem monted read-write on the two servers at the same time. At least not with consistensy. Perhaps with innodb on raw devices?
/Jörgen CyberSushi wrote: >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 > > > --------------------------------------------------------------------- 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