Percona server 5.7 MTS is slower than 5.6

[johndo...@gmail.com]

We are plan to upgrade Percona Server 5.6 to 5.7 because of the replication delay problem during peak hour and hope 5.7 MTS will fixed the problem. We make a test at stating server, before the upgrade we can do about 6000 insert/s without delay. But after the upgrade we can only do 3000 inserts/s. The 5.7 version is  5.7.13-6-log. we only changed these parameters:

slave_parallel_type          changed from database to LOGICAL_CLOCK 
slave_parallel_workers     changed from 2 to 8     // we only have 2 databaases so we use 2 in 5.6 for parallel replication
sync_binlog                     changed from 1 to 0    //with 1 it is even worth 

Is there anything need to change?

Thanks

[ramesh.s...@percona.com]

Hi,

Could you please review this article : http://mysqlhighavailability.com/multi-threaded-replication-performance-in-mysql-5-7/

And please let us know if you any further questions.

[johndo...@gmail.com]

The xtrabackup_logfile file is about 500G, it is very slow to apply the apply the log record, after one day it only apply 10%.

Thanks,

James

[johndo...@gmail.com]

Try to backup and resotore the same data with MySQL 5.6 and Xtrabackup 2.3, this time the prepare is very fast only take about 5 hours, the xtrabackup_logfile is about 600G. seems xtrabackup 2.4 has problems

[Ramesh Sivaraman]

Hi John,

Could you please log an issue here with all details.

--

Best Regards,

Ramesh Sivaraman

QA Engineer, Percona

http://www.percona.com/

Phone : +91 8606432991

Skype : rameshvs02