Tag: Replication

Replication

Replication handler error HA_ERR_KEY_NOT_FOUND and Memory Tables In Replication

 Last_SQL_Error: Could not execute <Update/insert/delete>_rows event on table <dbname>.<tablename>; Can’t find record in ‘<tablename>’, Error_code: 1032; handler error HA_ERR_END_OF_FILE; the event’s master log <master binary log file name>, end_log_pos <master log file position> This is one of the error for MySQL Replication when MASTER and SLAVE replica not in sync. The Reason for replication getting …

Replication

Failover for MySQL Replication (and others) – Should it be Automated?

Automatic failover for MySQL Replication has been subject to debate for many years. Is it a good thing or a bad thing? For those with long memory in the MySQL world, they might remember the GitHub outage in 2012 which was mainly caused by software taking the wrong decisions. GitHub had then just migrated to …

Replication

More P_S Instrumentation for Group Replication

In order to improve observability and manageability of MySQL Group Replication (GR), we enhanced its instrumentation in MySQL 8.0.4. With these goals in mind, we have extended the usage of Performance Schema (P_S) from this plugin to the included Group Communication System (GCS) module as well as its submodule eXtended Communications (XCom) which are responsible for all …

Clustering

How to convert galera node to async slave and vice-versa with MariaDB Galera Cluster

Recently, I was working with one of our customer and this is what their requirement as they want to automate this process for converting galera node to async slave and make async slave to galera node without shutting down any server. ———- I’ve tested locally with my galera cluster and it’s working smoothly. But with …

Replication

Replication Features in MySQL 8.0.4

MySQL 8 second release candidate is out (MySQL 8.0.4). Besides fixes to replication issues we have also delivered a couple of enhancements in this release. Let me quickly summarize them. Additional instrumentation for Group Replication (WL#9856). We have instrumented mutexes and condition synchronization objects on the group communication library. These are exposed as usual through …

Performance, Replication

Replication Performance Enhancements in MySQL 8

Although it feels like it was only yesterday that Oracle released version 5.7 of their acclaimed MySQL Community Server, version 8 is already available as a development milestone release (DMR). No, you didn’t sleep through a bunch of releases; MySQL is jumping several versions in its numbering due to 6.0 being dropped and 7.0 being …

Replication

Replication Will Start On AWS RDS for MariaDB 10.2

AWS recently announced the release of MariaDB 10.2 for RDS. One of customer needs this release for GIS indexing .The recent encounter on a Replication issue with RDS MariaDB 10.2 is briefed here . Problem Statement: After the upgrade of replicas to MariaDB 10.2 on RDS, Once replication is stopped manually through “call mysql.rds_stop_replication;” or …