This documentation is for WSO2 API Manager 2.0.0 View documentation for the latest release.
Setting up MySQL Cluster - API Manager 2.0.0 - WSO2 Documentation
||
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.

    <datasource>
             <name>WSO2AM_DB</name>
             <description>The datasource used for API Manager database</description>
             <jndiConfig>
                 <name>jdbc/WSO2AM_DB</name>
             </jndiConfig>
             <definition type="RDBMS">
                 <configuration>
    				 <url>jdbc:mysql://192.168.58.215:3306,192.168.58.216:3306/WSO2AM_DB?autoReconnect=true&amp;relaxAutoCommit=true&amp;useSSL=false&amp;failOverReadOnly=false</url>
      				 <username>root</username>
                     <password>root123</password>
                     <defaultAutoCommit>false</defaultAutoCommit>
    				 <driverClassName>com.mysql.jdbc.Driver</driverClassName>
                     <maxActive>50</maxActive>
                     <maxWait>60000</maxWait>
                     <testOnBorrow>true</testOnBorrow>
                     <validationQuery>SELECT 1</validationQuery>
                     <validationInterval>30000</validationInterval>
                 </configuration>
             </definition>
         </datasource>

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

    <url>jdbc:mysql://[primary_mysql_node_IP]:[port],[secondary_mysql_node_IP]:[port]/[DB_Name]?autoReconnect=true&amp;relaxAutoCommit=true&amp;useSSL=false&amp;failOverReadOnly=false</url>

  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