[CentOS] MariaDB 10.X Master-Slave Replication

Thu Nov 12 11:09:59 UTC 2015
melkor.kp <melkor.kp at gmail.com>

Hi,

I am configuring master-slave replication in a MariaDB 10.X over Centos 7.1
and I am having some troubles.

When I configure the slave I use the following directies in my.cnf:

...
master-host             = 192.168.122.2
master-user             = slave_user
master-password         = qwerty
master-connect-retry    = 60
...

But is seems that the daemon doesn't like them and it refuses to start.

Does anybody know if those directives have been removed on that version?

Setting up them with the following mysql commands inside works.

mysql> slave stop;
mysql> CHANGE MASTER TO MASTER_HOST='*192.168.122.2*',
MASTER_USER='*slave_user*', MASTER_PASSWORD='*qwerty*',
MASTER_LOG_FILE='*mysql-bin.000003*', MASTER_LOG_POS=*11128001*;
mysql> slave start;
mysql> show slave status\G;


Cheers,
Roberto Nebot
-- 
It's a dangerous business, Frodo, going out your door. You step onto the
road, and if you don't keep your feet, there's no knowing where you might
be swept off to.

Bilbo Baggins.

http://vanishedintheshell.apsila.org
<http://vanishedintheshell.blogspot.com>