Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 853
  • Last Modified:

Best option for MySQL redundancy

Would someone describe in detail the simplest solution for higher availability on MySQL 5 Community Edition?

I can stand a few minutes of downtime on an unexpected outage but need automated recovery and need to maintain data integrity (this is a DSS system so transaction integrity is not critical).  Data is on a SAN and I have plenty of harware.  Running instances on CentOS and Win 2003.

Thanks in advance!!!
0
goknows
Asked:
goknows
  • 2
  • 2
1 Solution
 
mankowitzCommented:
Cluster is usually the best way to provide redundancy and high availability, but the docs are pretty clear that keeping data on "SANs is not recommended or supported"

If, like most db's, you have many more SELECT queries than UPDATE or INSERTs, then you should probably have several slaves and one master. Aim as many of the select queries at the slaves and the updates at the master. That way you have multiple up-to-date copies of the db, but still have high availability.

Cluster: http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-overview.html
Master/Slave replication: http://dev.mysql.com/doc/refman/5.0/en/replication-configuration.html
0
 
goknowsAuthor Commented:
an OS cluster?  MySQL Cluster is really a different beast that I am not interested in.  Not sure why MySQL would care if the data is laid down on a SAN or not ... but thank you for the response.
0
 
goknowsAuthor Commented:
I think I'll just use VMWare under MySQL enterprise and be done with it....
0
 
mankowitzCommented:
You are right. I am not sure why mysql would care about SAN. For that matter, I am not sure how mysql would even know if the disk is san or not, but the docs forbid it. Perhaps the latency is too much, or the file locking doesn't work as well. I dunno.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now