"Angel" writes: > 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).
It certainly works; I have my MySQL server's filesystem on NFS. > Do you know if there is any problem to run MySQL over a NFS > filesystem? Personally I wouldn't recommend it in a production environment. My system is in my room and I'm the only one who uses it. Since the database is operating via the network (assuming your MySQL server is receiving commands from another host), having its backing store via NFS will just enlarge the network traffic (assuming NFS and the other host are on the same network channel). If this is the case then there may be some speed problem. > Or do you know any other way to configure MySQL with > high availabiliy? Replication. From: http://www.mysql.com/news/article-54.html One way replication can be used is to increase both robustness and speed. For robustness two (or more) systems can used to switch to a backup server if you have problems with the master. The extra speed is achieved by sending part of the non-updating queries to the replica server. Replication can also benefit database backup operations. Live backups of the system can be done on a slave instead of a master, eliminating potential problems and possible downtime. Elizabeth -- To UNSUBSCRIBE, email to [EMAIL PROTECTED] with a subject of "unsubscribe". Trouble? Contact [EMAIL PROTECTED]
