{"id":132,"date":"2017-10-24T05:39:00","date_gmt":"2017-10-24T05:39:00","guid":{"rendered":"https:\/\/linuxadmin.melberi.com\/uncategorized\/glpi-mysql-replicate"},"modified":"2017-10-24T11:55:14","modified_gmt":"2017-10-24T11:55:14","slug":"glpi-mysql-replicate","status":"publish","type":"post","link":"https:\/\/www.melberi.com\/linuxadmin\/glpi\/glpi-mysql-replicate","title":{"rendered":"GLPI Mysql Replication Configuration"},"content":{"rendered":"

How to setup MYSql Database replication in GLPI<\/p>\n

\n

GLPI Mysql Replication<\/b><\/u><\/h2>\n

Login to your secondary Mysql server through console<\/b>
\nCreate database for replication –\u00a0 glpi_replication
\nExample : db name = glpi_replication<\/b>, username = glpiuser , password – glpireppwd<\/b><\/p>\n

#mysql -u root -p ( enter the mysql root password)<\/b><\/div>\n
mysql> create database glpi_replication;<\/div>\n
mysql> grant all privileges on glpi_replication.* to glpiuser@glpiwebserverip identified by ‘glpireppwd’;
\nmysql> exit<\/div>\n

Login to GLPI web as admin<\/b>
\nGo to Setup -> General ->Mysql Replicate<\/b>
\nChange the settings as shown in the below Screen shot<\/p>\n

Enable The Replica – yes<\/b><\/div>\n
Mysql Server\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 – Ip of your slave mysql server<\/div>\n
Database\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 – slave db name<\/div>\n
Mysql user\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 – slave db username<\/div>\n
Password\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 –\u00a0 password of slave db<\/div>\n
Max difference between master and slave\u00a0 – your choice<\/div>\n
Email Notification – your choice<\/div>\n

Click on post<\/b><\/p>\n

 <\/p>\n

\"GLPI<\/div>\n

 <\/p>\n

 <\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

How to setup MYSql Database replication in GLPI GLPI Mysql Replication Login to your secondary Mysql server through console Create database for replication –\u00a0 glpi_replication Example : db name =… Read more »<\/a><\/p>\n","protected":false},"author":1,"featured_media":330,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[92],"tags":[],"class_list":["post-132","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-glpi"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t