Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

High Availability Mysql without virtual IP

⇧
1
⇩
58 views

Hi,

I am trying to design a simple high availability system for our production system at the mysql level. From what I have read so far, the best solution is to set up master-master replication. Unfortunately, we cannot use virtual IP, so scripts like MMM cannot be used as is I believe.

A suggested solution is to connect to mysql through e.g. haproxy, which will "guarantee" that only one master will be written to at a time. I could not find much information for this configuration - what are the pros/cons compared to the usual virtual ip-based configuration ?

mysql high-availability haproxy
asked March 27, 2011 10:00 pm CDT
David Cournapeau
posted via ServerFault

0 Answers

Be the first to answer this question

Join with account you already have

Sign in with Twitter account
Sign in with Facebook account
Sign in with Google Friend Connect

Preview
Similar questions
How To Set Up A Loadbalanced High-Availability Apache Cluster On Windows
March 12, 2011
Mysql query room availability
February 23, 2011
Check availability of my websites
January 14, 2011
Combine multiple room availability queries into one
February 11, 2011
Django-piston: request.data availability within DELETE handlers
February 10, 2011
Testing the availability of external system (ldap, database...) during the startup of Tomcat
January 5, 2011
Very high cost for low limit LIMIT / high OFFSET
January 18, 2011
Mysql and High CPU IO Wait
February 25, 2011
High values of innodb_lock_wait_timeout on Mysql
January 20, 2011
Mysql: less than half of memory used. High load.
February 10, 2011
High MySQL CPU usage but no heavy query
February 7, 2011
Mysql creating high load average
March 15, 2011
High MySQL CPU usage but no heavy query
February 7, 2011
MySQL backup strategy for high-traffic sites
March 25, 2011
What's the optimal DB choice for a high traffic site? (MySQL MyISAM vs. InnoDB vs. PostgreSQL)
January 27, 2011
Transient Mysql::Error: Duplicate entry on a high-traffic site - any ideas?
February 6, 2011
Apache : Making one virtual host subdomain/subdirectory of another virtual host
March 25, 2011
Problem with virtual host on Apache 2 - Not directing to appropriate virtual host.
March 27, 2011
At a high-level, what is the lower level logic used by MySQL to do an INSERT?
February 21, 2011
High request time
March 1, 2011
High Ram usage (Optimization)
January 5, 2011
How to Best Manage High PostgreSQL CPU Use?
February 24, 2011
Scaling a High Score Database
January 31, 2011
PostgreSQL High Performance Setup
March 22, 2011
Tomcat consumes very high CPU usage
March 23, 2011
PostgreSQL High Performance Setup
March 22, 2011
High performance SSL Terminator on Linux
March 15, 2011
High Concurrency Counter (For Credit Management)
February 24, 2011
CentOS: MySQLd running with 333% of CPU sometimes. CPU high load
March 10, 2011
WebException with SecureChannelFailure in high latency situation
February 28, 2011