Online Schema Change for Tables with Triggers.

In this post, We will learn how to handle online schema change if the table has triggers. In PXC, an alter can be made directly ( TOI ) on tables with less than a 1G ( by default) , but on a 20GB or 200GB table we need some downtime to do ( RSU ). … Continue reading Online Schema Change for Tables with Triggers.

Advertisements

Binlog expiry now in seconds (MySQL 8.0)

In this blog we are going to view about a ┬ánew feature in latest release MySQL 8.0.1 for MySQL Replication . It is binlog_expire_logs_seconds. Previously we can set the expire logs for binlogs in number of days. By using the new feature (binlog_expire_logs_seconds) we can see set the expire time into number of seconds. The … Continue reading Binlog expiry now in seconds (MySQL 8.0)