ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes. ProxySQL is simple in design, lightweight, highly efficient and feature rich, We have been working with ProxySQL … Continue reading ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split
This is the 5th blog in series of Maxscale blog, Below is the list of our previous blogs, Which provides deep insight for Maxscale and its use cases for different architectures. Scale with Maxscale part -1 (Intro & Galera Cluster) Scale with Maxscale part - 2 (Administration, Installation & operation) Scale with Maxscale part - … Continue reading Scale-with-Maxscale-part5 (Multi-Master)
Encryption is a very important form of security and It's becoming a standard from a compliance perspective to ensure PCI, PII and HIPPA compliances. Encryption needs to be performed for Data at Rest, Data over Wire. Data At Rest: Until 5.6, To encrypt the MySQL data files, Only disk level encryption possible (Gazzang, Luks) From … Continue reading Fulfilled Tablespace Encryption (TDE) in Percona Cluster
Managing Heterogeneous environment without automation can be tricky. We are using Ansible as an automation tool for install, configure and manage DB infra for Mydbops. Using Ansible, we overcome a lot of obstacle's and we would like to share our learning with the community ( Our Presentation on Ansible ) Best Practices to write … Continue reading Ansible Best Practices
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 … Continue reading Handling long duration SST(timeout) in PXC with systemd
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.
Xtrabackup is the most widely open source hot backup tool for MySQL. Xtrabackup support InnoDB and MyISAM engines.It supports both MySQL Server , Percona Server and MariaDB. This presentation covers some of the important features in Xtrabackup. Pic Courtesy : https://www.flickr.com/photos/robbiewendt/8108744459/
The TokuDB engine must be separately downloaded and then enabled as a plug-in component in previous versions. This package can be installed alongside with standard Percona Server 5.6 releases starting with 5.6.19-67.0 and does not require any specially adapted version of Percona Server. After acquisition Percona has integrated the TokuDB with their standard Percona Server distribution. … Continue reading Enabling TokuDB in Percona server 5.7