Angel L. Mateo said: > Hi, > > I've got to install a MySQL server with a hihg availabity > configuration: one MySQL server running and the other in standby. I was > thinking about using a NAS serving NFS partitions. But I have read > documents about database servers (like oracle and others) not running well > over NFS filesystems (because they use raw files).
I would for sure strongly reccomend against MySQL over NFS. NFS locking on linux is pretty bad still, and NFS in general isn't the most reliable thing. Nor is it secure. And it will probably destroy your performance. a quick search on mysql replication came up with this: http://www.phpbuilder.com/columns/tanoviceanu20000912.php3?page=3 http://www.mysql.com/documentation/mysql/bychapter/manual_MySQL_Database_Administration.html#Replication http://www.zeus.com/products/zlb/questions.html#other I haven't needed mysql replication in my configurations, my mysql servers have never gone down(e.g. unless I was physically moving them or switching hardware), so I haven't tested it in such a fashion. In any case I reccomend stunnel or some sort of vpn between the machines, or a 2nd nic in each one connected to an isolated switch for the communications between them(even a VLAN on an existing switch is probably good enough though not perfect). nate -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
