Page Comparison

...

1. To use the separate database cluster in Abiquo, edit the tomcat configuration at:
   

   Code Block
   /opt/abiquo/tomcat/conf/Catalina/localhost/api.xml

   Change the DB endpoint from localhost to the Galera cluster.
   Remove:

   Code Block
   driverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost:3306/kinton?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8"/>

   Add:

   Code BlockdriverClassName="com.mysql.jdbc.Driver" url="jdbc:mysql://{CLUSTERIP01}:3306,{CLUSTERIP02}:3306,{CLUSTERIP03}:3306/kinton?autoReconnect=true&useUnicode=true&characterEncoding=

2. UTF-8"/>

   Edit the Context with this default format.

   Code Block

   <Context> <Resource name="jdbc/abiquoDB" auth="Container" type="javax.sql.DataSource" factory="com.zaxxer.hikari.HikariJNDIFactory" dataSourceClassName="org.mariadb.jdbc.MariaDbDataSource" connectionTimeout="120000" maximumPoolSize="100" username="${server.database.username}" password="${server.database.password}" dataSource.url="jdbc:mariadb://${server.database.host}:${server.database.port}/kinton" /> </Context>

   Change the datasource.url to add the cluster. Note that this configuration does not affect the multi-master configuration of the cluster.

   Code Block
   dataSource.url="jdbc:mariadb:loadbalance://address=(host=dbmain)(port=3306)(type=master), address=(host=dbr1)(port=3306)(type=slave), address=(host=dbr2)(port=3306)(type=slave)/kinton"

3. Change the user and password. Please contact Abiquo Support for more information

4. To point to the services cluster instead of the local host for RabbitMQ and Redis, edit the abiquo.properties file at:

   Code Block
   /opt/abiquo/config/abiquo.properties

5. Set the RabbitMQ property

   Code Block
   abiquo.rabbitmq.addresses=

   Enter the three IPs in the datanode services cluster, separated by commas.
   For example:

   Code Block
   abiquo.rabbitmq.addresses=10.60.30.185,10.60.30.186,10.60.30.187

6. Set the Redis host property

   Code Block
   abiquo.redis.host=

   Enter the master IP of the cluster, which be the IP of the first VM deployed in the cluster.
   For example:

   Code Block
   abiquo.redis.host=10.60.30.185

...