...
| Info |
|---|
This guide is based on CentOS 6 |
| Warning |
|---|
Current reporting design has a problem with concurrent generation of the same report for the same enterprise, please visit Jasper concurrency for a workaround to this issue. |
Install MariaDB on slave server
Install the same MariaDB server package that Abiquo API server is using in the slave server. This can be achieve by installing the corresponding abiquo-release package on the replica server and executing the command below:
| Code Block |
|---|
yum -y install MariaDB-server MariaDB-client |
Configure DB replication on master DB server
Create the replication configuration file in master DB server:
...
| Code Block |
|---|
grant replication slave on *.* to 'REPLICA_USER'@'SLAVE_SERVER' identified by 'REPLICA_PASS'; flush privileges; |
Configure DB replication on slave DB server
Create the replication configuration file in Maria DB slave server:
...
| Code Block |
|---|
service mysql restart |
Initial replication
Open a new session on master DB server and execute the commands below in mysql prompt. This will show master current status. We will need this later when replicating the DB in the slave. Leave this session as it is until replication is completed:
...
| Code Block |
|---|
mysqldump --databases kinton kinton_accounting --routines > dump.sql |
Configure slave replication point
Copy dump.sql from previous step from master DB server to slave DB server. Once copied, import it into slave DB server. If this is a new installation you may need to create kinton database.
...
Once Slave_IO_State is "Waiting for master to send event" replication is finished. Then, close the first session on master DB server where locks were set and master status was requested to release locks and you are done.
References
https://mariadb.com/kb/en/setting-up-replication/
...