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
