Galera replicates the data across the cluster in a virtually synchronous fashion. Based on the availability of cluster nodes the type of data transfer can vary. The important factor which decides the type of data transfer required here is the existing write set in gcache. Galera Cluster stores write-sets in a special cache called the … Continue reading Major SST methods In XtraDB / MariaDB Cluster and its supporting files.
Galera is the core tech behind the Percona XtraDB Cluster and MariaDB Cluster. When using the Galera cluster we might have come across multiple files in the data directory beyond the Native MySQL or InnoDB Files. It is always good to understand these files to know what is happening internally. Each file present in the … Continue reading MariaDB/XtraDB Cluster Default Disk Files and its Significance
Recently one of our customers ran into an issue, wherein a bad actor(code) from the application had made the wrong update to 16 M records of a critical table in the database, causing the entire production process to go down. The application Team was able to find the bad actor and block it, our Remote … Continue reading 6 Step MySQL Point-In-Time recovery on AWS RDS
A Database Engineer should always be aware of how the database stores valuable data and also to safeguard it. Data may be lost due to a lot of reasons like some critical problems in the hardware, crashes, human mistakes, and more other reasons. That is why we need to take database backups. To make backups … Continue reading Backup and Recovery using Mariabackup.
Basically, Auditing is the process of monitoring and recording the activity happening inside the Server. MariaDB Audit Plugin works with MariaDB, MySQL and Percona Servers. It is used to log the database Operations like, SQL Statements, User informations, Connections. The information is stored in a user defined log file or in Syslog. Available audit plugins … Continue reading Integrating MariaDB Audit plugin in MySQL 5.7
Galera 4 came up with the lot of new features , which helps to effectively handle the cluster . In this blog I am going to explain in detail about the Galera 4 functions which were introduced for Global Transaction ID ( GTID ) . GTID functions in Galera 4 wsrep_last_written_gtid()wsrep_last_seen_gtid()wsrep_sync_wait_upto_gtid() Actually i have planned … Continue reading New GTID functions in Galera 4
This is the our next blog in Maxscale series, Below is a 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 MySQL Binlog server with Maxscale
Data is an invaluable asset to any organisation and every data should not be viable to all DB users. I had a requirement from one of our Support client to hide (mask) a few columns to the end user. Those columns contains sensitive information like payment details and mobile numbers. In this blog post I … Continue reading Column Level Masking on MySQL
In this blog, we will see how to do a flashback recovery or rolling back the data in MariaDB, MySQL and Percona. As we know the saying "All humans make mistakes", following that in Database environment the data modified accidentally can bring havoc to any organisations. Recover the lost data The data can be recovered … Continue reading Flashback Recovery in MariaDB/MySQL Servers
Monitoring MySQL server has never been an easy task. Monitoring also needs to go through many Complex and difficult queries to get the details. All these problems can be overcome by an excellent command line monitoring tool called “Innotop”. Innotop comes with many features and different types of modes/options, which helps to monitor different aspects … Continue reading Innotop – A Monitoring tool for MySQL