For instructions on configuring a MySQL cluster (NDB), see Deploying WSO2 Products on MySQL Cluster, which is published in the WSO2 library.
This page explains how to point WSO2AM_DB into a MySQL cluster (NDB), as Fail Over.
After creating the database in a MySQL cluster, modify the default datasourceconfiguration in the
<APIM_HOME>/repository/conf/datasources/master-datasources.xmlfile. Replace the URL, username, password, driver class name and any other values with your custom values.
Connection URL should be in the below format for Fail Over Configuration.
- Copy the MySQL JDBC driver library into
- To create the related API Manager database tables in the MySQL cluster databse, execute the cluster script located inside the
If you prefer to create database tables during server startup, replace the content of the
<APIM_HOME>/dbscripts/mysql.sqlfile with the content of the
<APIM_HOME>/dbscripts/apimgt/mysql_cluster.sqlfile and start the API Manager instance with
-Dsetup vm argument.
Note that we recommend to use Fail Over configuration with the MySQL cluster, over Load Balaced configuration