MySQL 5.7.11 broken replication after just service mysql restart on slave
i try upgrade to Percona Server 5.7.11-4 over Percona-Server 5.6 on my Ubuntu 14.04
mysq upgrade steps
# on master and slave both
service mysql stop
apt-key adv --keyserver keys.gnupg.net --recv-keys 1C4CBDCDCD2EFD2A
echo "deb http://
apt-key adv --keyserver keys.gnupg.net --recv-keys 8C718D3B5072E1F5
echo "deb http://
echo "deb http://
apt-get update
apt-get install -y mysql-utilities
apt-get install -y percona-
#after fix some problems with apparmor and file limits
service mysql start
mysql_upgrade -u root -p --force
service mysql restart
#dump on master
mysqldump --master-data --databases db1,db2,db3 > master.sql
#restore restore to slave server
mysql --defaults-
and on master all working fun
slave have forking fun
Read_
Relay_
Seconds_
after this i just run
service mysql restart
and i have stop my replictation proccess
's master log mysql-bin.003033, end_log_pos 25161015
why this happend? what's i wrong doing? how
Question information
- Language:
- English Edit question
- Status:
- Solved
- Assignee:
- No assignee Edit question
- Solved by:
- Eugene Klimov
- Solved:
- Last query:
- Last reply: