Re: [Maria-discuss] ON update timestamp replication

2016-11-30 Thread Artem Kuchin
ABLE Message193 CHANGE COLUMN LastUpdated timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP". On Wed, Nov 30, 2016 at 6:04 AM, Artem Kuchin wrote: I understand that. I don't understand how it happened that table schema on slave is not the same as on master. An

Re: [Maria-discuss] ON update timestamp replication

2016-11-30 Thread Artem Kuchin
d properly. On Mon, Nov 28, 2016 at 3:13 AM, Artem Kuchin wrote: Hello! Both master and slave run: Server version: 10.1.14-MariaDB FreeBSD Ports Replication is based on mixed format. Slave is used for backups without locking and going off line. I have a script that runs once a day and checksums

[Maria-discuss] ON update timestamp replication

2016-11-28 Thread Artem Kuchin
Hello! Both master and slave run: Server version: 10.1.14-MariaDB FreeBSD Ports Replication is based on mixed format. Slave is used for backups without locking and going off line. I have a script that runs once a day and checksums all tables, so all tables are 100% in match (it wait for sync