MySQL Group Replication and its Memory consumption (troubleshooting).

This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of  3 . Due to OOM, the MySQL process in the primary node got killed, this repeated over the course of … Continue reading MySQL Group Replication and its Memory consumption (troubleshooting).

ProxySQL Series : ProxySQL Native Cluster

ProxySQL supports a feature called clustering from version 1.4.2 .while planning for setting up a  cluster ensure to have a version greater than 1.4.2 ( latest is better) . This is still an experimental feature but works well. This blog would be a continuation of our proxysql series of blogs. MySQL replication Read-Write Split up … Continue reading ProxySQL Series : ProxySQL Native Cluster

3 Step Migration of MySQL data to Clickhouse for faster analytics.

Recently one of our client approach Mydbops with Query slowness on a MySQL environment . They deployed the new code for generate the huge reports for the year end analytics data . After the deployment the queries were extremely slow and they struggled lot , then they approached us for the solution. After the analysis, … Continue reading 3 Step Migration of MySQL data to Clickhouse for faster analytics.