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.