MySQL Forums
Forum List  »  Router & Proxy

Load Balancing with two mysql proxies possible?
Posted by: Yukari -chan
Date: December 07, 2009 05:00AM

Hi everyone,

I've got a mysql-cluster ready consisting of three servers:
1. ndb_mgmd, ndb_mgm
2. mysqld, ndbd
3. mysqld, ndbd

Now I want to add load balancing to this and got the tipp to try it with the mysql proxy. But as I want to avoid "single-points-of-failure" there would be two proxy installations needed. My idea was to install each proxy on the 2nd and 3rd server.

But how can applications address this setup then? For example:

If I had a normal mysql-server without load balancing, proxy or whatever, I would give the IP of the server to the application.

If I had the two servers in a regular load balancing, I would give the virtual IP of it to the application.

If I use two proxies, what do I then give to the application?
Or generally said... how would I even set up this?

I hope someone can help me with this questions.

Thanks in advance,
Yukari

Options: ReplyQuote


Subject
Views
Written By
Posted
Load Balancing with two mysql proxies possible?
3452
December 07, 2009 05:00AM


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.