How to setup MYSql Database replication in GLPI
GLPI Mysql Replication
Login to your secondary Mysql server through console
Create database for replication – glpi_replication
Example : db name = glpi_replication, username = glpiuser , password – glpireppwd
#mysql -u root -p ( enter the mysql root password)
mysql> create database glpi_replication;
mysql> grant all privileges on glpi_replication.* to glpiuser@glpiwebserverip identified by ‘glpireppwd’;
mysql> exit
mysql> exit
Login to GLPI web as admin
Go to Setup -> General ->Mysql Replicate
Change the settings as shown in the below Screen shot
Enable The Replica – yes
Mysql Server – Ip of your slave mysql server
Database – slave db name
Mysql user – slave db username
Password – password of slave db
Max difference between master and slave – your choice
Email Notification – your choice
Click on post
