Re: MySQL over NFS
"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
Reply to: