Mysql – Slave error after master upgrade

mariadbMySQLreplication

I have two MySQL servers in replication (master -> slave).

I updated them with apt-get upgrade. It runs well on both except the I get some replication errors on slave now.

Last_Errno: 1005 Last_Error: Error 'Can't create table
performance_schema.cond_instances

(errno: 131 "Command not
supported by database")' on query.

Default database: 'mysql'.

Query:
'CREATE TABLE performance_schema.cond_instances(NAME VARCHAR(128) not
null,OBJECT_INSTANCE_BEGIN BIGINT not null)ENGINE=PERFORMANCE_SCHEMA'

Server versions are as below: 

Master
Server type: MySQL
Server version: 5.5.62-0+deb8u1-log - (Debian)

Slave
Server type: MariaDB
Server version: 10.1.26-MariaDB-0+deb9u1 - Debian 9.1

Best Answer

First, you need to make sure MySQL slave user is active and has the needed permission then check if MySQL OS user on the slave machine has the needed access.

Related Question