Skip navigation links

MySQL Forums :: Proxy :: MySQL Proxy: Scenarios, Use Cases

Advanced Search

Re: MySQL Proxy: Scenarios
Posted by: Rick Blundell ()
Date: July 10, 2007 12:01AM

Hi. I am glad to see this forum is well read, I'm happy to discuss HA mysql from my experience.

If mysql-cluster worked like I think it should and could, I don't think mysql-proxy would be completely necessary. LVS+mysql-cluster could create a great hA solution, but the requirement for NDB on -cluster causes some application incompatability issues. Anyway, -cluster does a good job, its just not designed for a straight up mysqld replacement right now. I think -proxy and mysqld-replication can be a replacement for mysqld but allow good HA/distributed work without a replication aware application. What I mean by that is an application that supports reads from mysqld A,b,C and writes to mysqld D.

APP -> mysql-proxy --> write --> master mysqld -|
______________\<-- read <-- slave mysqld 1 -|[replication]
______________\<-- read <-- slave mysqld 2 -|

What I am really after is mysqld distribution without an intelligent application. I am very confident -proxy can deliver this with an LUA script that allows the backend to be selected after the query is read.

HA is rather tiresome because then we need redundant mysql-proxyies and masters ;)

Rick Blundell

Edited 4 time(s). Last edit at 07/10/2007 12:23AM by Rick Blundell.

Options: ReplyQuote

Subject Views Written By Posted
MySQL Proxy: Scenarios, Use Cases 20246 Edwin DeSouza 07/09/2007 11:35PM
Re: MySQL Proxy: Scenarios 7351 Rick Blundell 07/10/2007 12:01AM
Re: MySQL Proxy: Scenarios 7389 Gerry Reno 07/10/2007 11:21AM
Re: MySQL Proxy: Scenarios 5039 Edwin DeSouza 07/10/2007 12:05PM
Re: MySQL Proxy: Scenarios 5013 Gerry Reno 07/10/2007 12:17PM
Re: MySQL Proxy: Scenarios 4630 Edwin DeSouza 07/10/2007 02:37PM
Re: MySQL Proxy: Scenarios 4492 Gerry Reno 07/10/2007 04:07PM
Re: MySQL Proxy: Scenarios 4088 Jason Burnett 02/21/2008 11:26PM
Re: MySQL Proxy: Scenarios 4433 Edwin DeSouza 07/10/2007 11:55AM
Re: MySQL Proxy: Scenarios, Use Cases 7203 Reinis Rozitis 07/20/2007 03:58AM
Re: MySQL Proxy: Scenarios, Use Cases 4411 Jonathon Suggs 07/30/2007 01:21PM
Re: MySQL Proxy: Scenarios, Use Cases 4423 Reinis Rozitis 08/01/2007 05:58AM
Re: MySQL Proxy: Scenarios, Use Cases 4055 Jan Kneschke 08/01/2007 06:03AM
Re: MySQL Proxy: Scenarios, Use Cases 3752 Edwin DeSouza 02/13/2008 02:04PM
Re: MySQL Proxy: Scenarios, Use Cases 3677 Pete Clapham 04/08/2008 04:25AM
Re: MySQL Proxy: Scenarios, Use Cases 4628 Clint Alexander 07/28/2008 09:32PM
Re: MySQL Proxy: Scenarios, Use Cases 3281 Simon Mudd 09/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.