MySQL Forums
Forum List  »  Router & Proxy

Re: MySQL Proxy: Scenarios, Use Cases
Posted by: Clint Alexander
Date: July 28, 2008 09:32PM

I just wanted to comment on the SPOF issue. I see a lot of suggestions about running 2+ individual systems/proxies that clients can connect to for failover. We're just starting to use Replication and Proxy as it is a perfect solution for our web environment. Since we are in control of all of our web nodes, we approached the SPOF regarding Proxy a little differently.

Our setup is 4 Web servers (nodes) that pull data from a replicated service - 1 Master and 2 Slaves. Each web node is round-robin/load balanced. We installed MySQL-Proxy on each of the web nodes and placed a cronjob to check the process and restart if/when necessary. Depending on what connection protocol we use (sock or tcp), the web developers simply use "localhost" or "127.0.0.1" as the MySQL host address. Complete with rw-splitting.lua (with a small bit of customization), there is no single point of failure. If the proxy service goes down, it is restarted or alerts us on failure. If a web node goes down, the other web nodes are autonomous and use their own local copy.

With this setup we believe we achieved the least expensive configuration for redundancy. However, we are still new at using Replication and Proxy so we're always on the hunt for something we have overlooked. Hopefully, this is not the case and our configuration continues to work as expected.

Kudos to Jan and the rest of the team -- this is an application well worth the time and effort!

Clint Alexander
Project Manager
Database, Systems & Web Administration

Options: ReplyQuote


Subject
Views
Written By
Posted
21458
July 09, 2007 11:35PM
7972
July 10, 2007 12:01AM
8097
July 10, 2007 11:21AM
5709
July 10, 2007 12:05PM
5802
July 10, 2007 12:17PM
5193
July 10, 2007 02:37PM
5176
July 10, 2007 04:07PM
4637
February 21, 2008 11:26PM
5026
July 10, 2007 11:55AM
4255
February 13, 2008 02:04PM
Re: MySQL Proxy: Scenarios, Use Cases
5246
July 28, 2008 09:32PM
3839
September 24, 2008 02:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.