Starting on DB01 cat /etc/my.cnf [mysqld] log-bin=mysql-bin server-id=1 replicate-wild-do-table=replicateddb.% replicate-ignore-db=test [mysqld_safe] err-log=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid Restart the service to apply the changes service mysqld restart Login to MySQL mysql –u root –p Create replication user account with the host set to the Slave Server’s IP. Make sure the password is 32 characters or less! mysql> CREATE USER… Continue reading Setup Database Master/Master Replication on MySQL Server
Tag: MySQL
Whitelist an IP using denyhosts in CentOS 6 RHEL 6
Hi there, Add your IP to this file and restart if you want to whitelist an IP in denyhosts: /var/lib/denyhosts/allowed-hosts Also make sure to check the /etc/hosts.deny file for the IP if it’s already been blocked. Then restart service denyhosts restart Yo Mm.,
How To Setup MySQL Enterprise Monitoring with Zabbix
This article is NOT about how to setup the application called MySQL Enterprise Monitor but rather how to setup MySQL monitoring in your Zabbix Enterprise Monitoring software. Here’s how this works: – Network communication to the server provided by the Zabbix Agent. – Agent side UserParameter settings allow for needed commands to be run against… Continue reading How To Setup MySQL Enterprise Monitoring with Zabbix