I've searched the lists, newsgroups, etc... The info that's out there is somewhat confusing or not as complete as it should be. This is a bit more of a Linux question than a MySQL one but folks on here are likely to be the ones to know the answer. Can anyone give a suggestion as to the best way to do this? I want to install 2 servers running Linux and MySQL which do NOT serve web pages or much of anything else besides deliver the MySQL databases and provide some shared printers via Samba. I want some type of HACMP type software so that if server 1 goes down the client PCs switch to server 2 as smoothly and as unobtrusively as possible. I can obviously set up replication so that the 2 MySQL database servers stay 99.9% in sync right up to the point of service interruption on one of the servers. What I'm wondering is the best way to do this with 2 servers, just MySQL and Samba/Printers being served, no "load balancing" necessary and turnkey users who won't know how to initiate a switch like this themselves or anything of that sort. www.linux-ha.org looks like they might have (or will soon have?) just the thing but it's difficult to digest all the info there as well. Is a "heartbeat" program from server 2 watching to see if server 1 is alive and if not changing it's own IP address to that of server 1 to "take over" the right way? I assume Windows PCs running VB apps and ODBC drivers to the MySQL database will barf at this BUT will link right back up after restarting the app or rebooting? I assume I could have Samba turned off on server 2 and as a part of "takeover" turn it on with the same netbios name as 1. What about getting things back in sync as painlessly as possible after server 1 gets repaired? I'd be interested in an open source or commercial solution to this. Thanks in advance! --------------------------------------------------------------------- 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
