Hi Samith, There is a java connector called Clusterj which provides APIs to connect MySQL NDB cluster. Please see the links below.
[1] https://dev.mysql.com/doc/ndbapi/en/mccj.html [2] http://www.clusterdb.com/mysql-cluster/using-clusterj-part-of-mysql-cluster-connector-for-java-a-tutorial Thanks Godwin On Mon, Jan 8, 2018 at 9:02 PM, Samitha Chathuranga <[email protected]> wrote: > Hi, > > How to configure a wso2 product with a MySQL NDB cluster database so as > the High availability as well the load balancing can be catered altogether. > We can have these two capabilities separately by configuring the database > connection url appropriately as below. > > *For High Availability [1]* > > jdbc:mysql://[*primary host*][:*port*],[*secondary host > 1*][:*port*][,[*secondary host > 2*][:*port*]]...[/[*database*]]»[?*propertyName1*=*propertyValue1*[&*propertyName2*=*propertyValue2*]...] > > *For Load balancing [2] * > > jdbc:mysql:loadbalance://[*host*1][:*port*],[*host*2][:*port*][,[*host*3][:*port*]]...[/[*database*]] > »[?*propertyName1*=*propertyValue1*[&*propertyName2*=*propertyValue2*]...] > > > The query is how to achieve both these capabilities with mysql ndb cluster > if that is possible. > > [1] - https://dev.mysql.com/doc/connector-j/5.1/en/connector- > j-config-failover.html > [2] - https://dev.mysql.com/doc/connector-j/5.1/en/connector- > j-usagenotes-j2ee-concepts-managing-load-balanced-connections.html > -- > Samitha Chathuranga > Software Engineer, WSO2 Inc. > lean.enterprise.middleware > Mobile: +94715123761 > > [image: http://wso2.com/signature] <http://wso2.com/signature> > > _______________________________________________ > Dev mailing list > [email protected] > http://wso2.org/cgi-bin/mailman/listinfo/dev > > -- *Godwin Amila Shrimal* Associate Technical Lead WSO2 Inc.; http://wso2.com lean.enterprise.middleware mobile: *+94772264165* linkedin: *https://www.linkedin.com/in/godwin-amila-2ba26844/ <https://www.linkedin.com/in/godwin-amila-2ba26844/>* twitter: https://twitter.com/godwinamila <http://wso2.com/signature>
_______________________________________________ Dev mailing list [email protected] http://wso2.org/cgi-bin/mailman/listinfo/dev
