MySQL is the most widely used Relational Database Management System in the open source world. MySQL stepped into the NoSQL world by introducing the JSON Data Type in MySQL 5.7 release. In this blog post I am going to explain one of the major advantage of optimisation made in JSON … Continue reading Partial (Optimised) JSON updates and Replication in MySQL 8.0
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.
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
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
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)
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
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)
One of the prime feature that makes MySQL popular as an open source database from early days was Replication. MySQL Replication has under gone various improvements in MySQL 5.7. The prominent replication features in MySQL 5.7 are True Multi Threaded Replication ( MTS ) , Multi-source replication and Group Replication ( in lab) . Multi … Continue reading Multi-Source Replication in MySQL 5.7