MySQL Forums
Forum List  »  NDB clusters

Re: Application connecting to MySQL Cluster
Posted by: Mikael Ronström
Date: March 06, 2018 04:14AM

Not sure what the best practice is, but here are some options and
their characteristics.

1) Java Connector
This can be setup with the 4 MySQL servers in a load balancing
setup. This has the advantage that the Java app is connected
directly to the MySQL Server. Pretty sure some other MySQL
connector has similar capabilities as well.

2) MySQL Router
This can be setup for load balancing as well. The configuration
of the MySQL Router I think uses the read only setting of MySQL
Router which in the case of MySQL Cluster is read-write.
This gives load balancing on the 4 MySQL servers at the cost of
an extra hop from the application to the MySQL server.

Connecting directly in the application is ok as well, if the application
knows how to fail over to any of the other 3 MySQL servers.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Application connecting to MySQL Cluster
50
March 06, 2018 04:14AM


Sorry, only registered users may post in this forum.

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.