Setting up WSO2 Carbon Products with MySQL

 Downlaod and install WSO2 Product  and Mysql


 Setup Configuration Files

1. Edit the default database configuration defined in the  master-datasources.xml  file located at  $CARBON_HOME/repository/conf/datasources  directory as below. Both the database configurations in  registry.xml  and  user-mgt.xml  refer this data source.

 <datasource>
       <name>WSO2_CARBON_DB</name>
       <description>The datasource used for registry and user manager</description>
       <jndiConfig>
           <name>jdbc/WSO2CarbonDB</name>
       </jndiConfig>
       <definition type="RDBMS">
           <configuration>
               <url>jdbc:mysql://localhost:3306/wso2</url>
               <username>root1</username>
               <password>root1</password>
               <driverClassName>com.mysql.jdbc.Driver</driverClassName>
               <maxActive>80</maxActive>
               <maxWait>60000</maxWait>
               <minIdle>5</minIdle>
               <testOnBorrow>true</testOnBorrow>
               <validationQuery>SELECT 1</validationQuery>
               <validationInterval>30000</validationInterval>
           </configuration>
       </definition>
</datasource>


The database configuration options

url - The URL of the database.
username  - The name of the database user.
password - The password of the database user.
driverClassName  - The class name of the database driver.
maxActive - The maximum number of active connections that can be allocated from this pool at the same time or negative for no limit.
maxWait - The maximum number of milliseconds that the pool will wait (when there are no available connections) for a connection to be returned before throwing an exception or <= 0 to wait indefinitely.
minIdle - The minimum number of active connections that can remain idle in the pool without extra ones being created or 0 to create none.

Create Database
(Start WSO2 and Automatic Database Creation)

 When you start the server for the first time, use the -Dsetup option. It will create all the tables in the given MySQL database.

For Linux:

wso2server.sh -Dsetup


For Windows:

wso2server.bat -Dsetup