XtraBackup incremental backup using page tracking on read-only replication

MySQL & MariaDB
,
1

Hi
There is a new feature “page_tracking” that helps incremental backup to find the changes blocks and speed up backup and also reduce IO.

I was not able to set it up on read-only-slave server/

I"m getting this error when trying to install the plugin

mysql> INSTALL COMPONENT “file://component_mysqlbackup”;
ERROR 1290 (HY000): The MySQL server is running with the --super-read-only option so it cannot execute this statement
mysql>

Any idea how to overcome this issue ?

Thanks

Yehuda

2

Hi @yehudaf1

You can disable super read only temporarily to install the component. Connect as root:

SET GLOBAL super_read_only=OFF;
INSTALL COMPONENT "file://component_mysqlbackup";
SET GLOBAL super_read_only=ON;
3

Hi

thanks you very much I was able to install the plugin and now it is working well and fast.

Yehuda