thanks gary:
of course this is the perfect solution, and it will be a very good open
source project, but: how is it posible that the mysql team has not
implemented this proxy solution all ready?
i am not a lazy guy, of course if a need to implement this i will do,
but i prefer a mysql's solution becouse i want the mysql's products
guaranty.
thanks
fernando (aka d2clon)
Gary Richardson wrote:
What about writing a proxy server for each of your application nodes?
It probably wouldn't be hard to "fake" the mysql protocol and proxy to
an active server.. You could have a listener on each of your
application nodes bound to port 3306.
On 6/27/05, d2clon <[EMAIL PROTECTED]> wrote:
thanks for the reply.
but this solution its imposible because my applications are done
allready, or perhaps the applications are not mine.
i need a transparent balancer, and i dont anderstand how is possible
thet it does not exists.
grettings
d2clon
Gary Richardson wrote:
You're probably best to implement it as a layer in your application.
You could put a layer around DBI (or whatever programming API you're
using) to retry the query on another node if it fails.
On 6/23/05, d2clon <[EMAIL PROTECTED]> wrote:
(sorry for my english)
hello people:
i want to answer if do exists any mysql solution that implements load
balancer and redundancy between 'application layer' and 'mysqld layer'
i will try to explain me:
i want to implement a completed mysql cluster system, and the
documentation is very good, but i see a problem:
we need to look the picture in this page:
http://dev.mysql.com/doc/mysql/en/mysql-cluster-overview.html
in this picture we can see that the 'storage layer' implements correctly
redundance and load balancer feature, because the 'SQL layer' ask for
data to a 'storage layer' but not to a one particular node.
but the applications in the 'application layer' do the petitions to the
'SQL layer' directly to a particular node, and them:
what happen if a node in the 'SQL layer' is off?
how i can offer a load balancer feature between 'application layer' and
'SQL layer'.
i searched a lot on the web but i only founded out answers but not
solutions..
i also see this thread in this mail list:
http://lists.mysql.com/search.php?q=load+balancer&list=&m=a&begin=60
but i did not found an answer in this thread.
any help?
thanks a lot
fernando guillen (aka d2clon)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]