Skip to end of metadata
Go to start of metadata

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.

  1. After creating the database in a MySQL cluster, modify the default datasourceconfiguration in the <APIM_HOME>/repository/conf/datasources/master-datasources.xml file. Replace the URL, username, password, driver class name and any other values with your custom values.

             <description>The datasource used for API Manager database</description>
             <definition type="RDBMS">
                     <validationQuery>SELECT 1</validationQuery>

    Connection URL should be in the below format for Fail Over Configuration.


  2. Copy the MySQL JDBC driver library into <APIM_HOME>/repository/components/lib directory.
  3. To create the related API Manager database tables in the MySQL cluster databse, execute the cluster script located inside the <APIM_HOME>/dbscripts/apimgt/mysql_cluster.sql file.
  4. If you prefer to create database tables during server startup, replace the content of the <APIM_HOME>/dbscripts/mysql.sql file with the content of the <APIM_HOME>/dbscripts/apimgt/mysql_cluster.sql file 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

  • No labels