Not the answer you need?
Register and ask your own question!

problem with replication

cmcguirecmcguire EntrantInactive User Role Beginner
I have been following the tutorial to set up database replication. I am running two centos 5 vm's with Percona-Server-server/client 51.



datadir = /var/lib/mysql

server-id = 2

log-bin = /var/lib/mysql/mysql-bin.log

max_binlog_size = 104857600

Everything works fine up until the point I replace the slave mysql dir with the snapshot of the masters after which mysql won't start. All my log is showing me is:

130513 09:54:13 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql

130513 09:54:13 mysqld_safe mysqld from pid file /var/lib/mysql/ ended

If I swap back to the slaves original mysql dir mysql starts fine.

Any help greatly appreciated



  • scott.nemesscott.nemes MySQL Sage Current User Role Patron
    Do you mean that you are emptying the data dir on the slave, and loading the snapshot from the master into that directory? If so, make sure you prepared the backup properly using --apply-log, that the file ownership is set correctly (i.e. owned by mysql) on the data dir and contents, and if you have something like AppArmor or SELinux enabled make sure that the permissions for those are set correctly.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.