In this blog post, We will be explaining about the timeouts in SST on systemd implementation which we faced recently in Percona XtraDB Cluster during our Consulting with a client. State Snapshot Transfers (SST) refers to complete data sync from one of the nodes from the cluster to the joining node. SST will happen for one or … More Handling long duration SST(timeout) in PXC with systemd
This is our second blog in the ProxySQL Series ( Blog I MySQL Replication Read-write Split up ). Will cover how to integrate ProxySQL with MHA to handle failover of Database servers. We already have Master – Slave replication setup behind ProxySQL from previous blog [ProxySQL On MySQL Replication] For this setup we have added one more … More ProxySQL Series: Seamless Replication Switchover Using MHA
This presentation was made at LSPE event in Bangalore (India) held at Walmart labs on 10-03-2018. This presentation focuses how we have harnessed the power of Ansible at Mydbops.
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 ). … More Online Schema Change for Tables with Triggers.
This is part-4 of the Maxscale Blog series Maxscale and Galera Maxscale Basic Administration Maxscale for Replication Maxscale started supporting Amazon Aurora lately from its version 2.1 which comes with a BSL license, we are good until we use only 3 nodes, Amazon Aurora (Our Previous blog ) is a brilliant technology built by AWS team which … More Scale with Maxscale part-4 (Amazon Aurora)
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 … More ProxySQL Series: MySQL Replication Read-write Split up.
I was involved in one of the development support for MySQL. Here is an interesting case The application needs a Sequence generator as it was not present inbuilt with MySQL ( MariaDB will have it in 10.3 ) they have made sequence generator function with ‘select for update‘ statement. But it tends to cause more locking … More Investigating a MySQL dead lock
Introduction – Maxscale is an excellent Proxy from Mariadb Corporation, which providing the High Availability, Realtime RW split with replication Glaera cluster Amazon RDS Amazon Aurora, binlog streaming and many more advanced features, here in this blog we will discuss one such feature, In this blog post, i am going to share my … More Maxscale Data Archiving with filters Mq & Tee ( Mirror)
As Mydbops we are implementing Load Balancer using Maxscale or ProxySQL ( Our presentation ) for lot our client, but these load balancers will become a SPOF (Single Point of failure) . We have tried to explore services like HAProxy, Nginx, and Keepalived etc. Except Keepalived, all the services need to run on the standalone instance … More Making Maxscale/ProxySQL Highly Available ( 2 > 1 )
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 … More Replication Will not Start On AWS RDS for MariaDB 10.2