badwolfff
asked on
I am trying to set up a master-master replication between my cpanel server and another VPS but when I define log files in the my.cnf files, mysql does not reboot.
I am following this guide:
https://www.linode.com/docs/databases/mysql/mysql-master-master-replication
I needed to edit my.cnf file to set the values you will see below.
The steps I took were:
sudo cp -rp /etc/my.cnf /etc/my.cnf.bakup
sudo nano /etc/my.cnf
(added to the bottom)
server_id = 1
log_bin = /var/log/mysql-bin.log
log_bin_index = /var/log/mysql-bin.log.ind ex
relay_log = /var/log/mysql-relay-bin
relay_log_index = /var/log/mysql-relay-bin.i ndex
expire_logs_days = 10
max_binlog_size = 100M
log_slave_updates = 1
auto-increment-increment = 2
auto-increment-offset = 1
I tried to reboot mysql using WHM but it always failed saying the four log files I had defined did not exist. So I manually used nano to create them but even now I am getting the same problem.
Could you please help me understand how to create these files so that might be able to reboot mysql successfully?
https://www.linode.com/docs/databases/mysql/mysql-master-master-replication
I needed to edit my.cnf file to set the values you will see below.
The steps I took were:
sudo cp -rp /etc/my.cnf /etc/my.cnf.bakup
sudo nano /etc/my.cnf
(added to the bottom)
server_id = 1
log_bin = /var/log/mysql-bin.log
log_bin_index = /var/log/mysql-bin.log.ind
relay_log = /var/log/mysql-relay-bin
relay_log_index = /var/log/mysql-relay-bin.i
expire_logs_days = 10
max_binlog_size = 100M
log_slave_updates = 1
auto-increment-increment = 2
auto-increment-offset = 1
I tried to reboot mysql using WHM but it always failed saying the four log files I had defined did not exist. So I manually used nano to create them but even now I am getting the same problem.
Could you please help me understand how to create these files so that might be able to reboot mysql successfully?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.