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

ProxySQL Series: MySQL Replication Read-write Split up.

At Mydbops we always thrive to provide the best MySQL Solutions. We are exploring the modern SQL load balancers. We have planned to write a series of blog on ProxySQL. The first blog in this series is  how to set up ProxySQL for MySQL Replication Topology including Read / Write Split and some background over ProxySQL. What … Continue reading ProxySQL Series: MySQL Replication Read-write Split up.

Replication Will not 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 … Continue reading Replication Will not Start On AWS RDS for MariaDB 10.2

Disabling Multi-Source Replication in MySQL 5.7

Multi-channel replication is one of the  great feature shipped with MySQL 5.7, With allowed the capability of slave to have many masters, having a channel for each master by which they replicate. Each channel id has a unique “channel_name” In the above DB Architecture “channel_1, channel_2 and channel_3” represent the channel_name used for replication from … Continue reading Disabling Multi-Source Replication in MySQL 5.7

Xtrabackup for handling Encrypted Tablespace

      ​In this post, we are going to see how we can backup encrypted tables using Xtrabackup. InnoDB supports data encryption for InnoDB tables stored in file per table tablespaces. For the application to access encrypted tablespace, InnoDB will use master encryption key to decrypt the tablespace key. The master encryption key is stored … Continue reading Xtrabackup for handling Encrypted Tablespace

Scale With Maxscale – Part 3 (Replication)

This blog post is continuation of series of blog post on Maxscale, Part-1 which provides detailed introductory to Maxscale, Part-2 deals about the operation and administration of Maxscale. In this we will discusses, How Maxscale can be efficiently used for read scaling with mysql replication (Master - Slave). Replication is a great feature which is … Continue reading Scale With Maxscale – Part 3 (Replication)

Read MySQL Binlogs better with rows query log events

Introduction :  In MySQL the replication is logical. And the DB changes were written to mysqlbinlog. This mysqlbinlog is pulled (IO Thread) and applied ( SQL Thread) by the slave servers. Binlog is the key for MySQL Replication. Binary logging format is of three types. Statement ROW Mixed ROW based replication benefits the smaller writes … Continue reading Read MySQL Binlogs better with rows query log events

Virtual Columns in MySQL and Use cases.

Introduction: MySQL 5.7 introduces a new feature called virtual/generated column. It is called generated column because the data of this column is computed based on a predefined expression or from other columns. What is Virtual Column ? In general virtual columns appear to be normal table columns, but their values are derived rather than being … Continue reading Virtual Columns in MySQL and Use cases.

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)

MySQL Tablespace Encryption ( TDE )

In this blog we are going to explore about innodb tablespace encryption technique, which will be useful for securing data. In MySQL 5.7, a new feature "Innodb Tablespace Encryption"has been added to protect the data at rest. This is a most awaited feature in security. This encryption supports all file per table tablespaces and it … Continue reading MySQL Tablespace Encryption ( TDE )