Load Balancing with two mysql proxies possible?
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
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.