Over the decades we have been reading the MySQL error log from the server system file, if there are any issues in MySQL or any unknown restart happened , generally we look at the mysql error log. By default MySQL error log can be found in the default path /var/log/mysqld.log , or it can be … Continue reading MySQL ERROR Log Table Explained
From MySQL 5.7, we had a Multi-threaded Slave (MTS) Applier mechanism called LOGICAL_CLOCK to overcome the problems of parallel replication within a database. To further improve the parallelisation mechanism, from MySQL 8 (5.7.22) we have write-set replication, so before going further , lets look at the difference between Logical clock (LC) and Writeset. LOGICAL_CLOCK Transactions that … Continue reading Fastest Parallel replication method in MySQL 8.
In my previous Blog i have explained how we can integrate MySQL tools ( Percona Tool kit ) with systemd service, At Mydbops works with multiple clients ,we get various requirements from customers a few may be a complex ones ,one of the requirement was to setup a binlog server and copy the Production binlogs … Continue reading Creating a Simple MySQL Binlog Server
In my day to day tasks as a DB Engineer at Mydbops we have been using multiple MySQL tools for multiple use cases to ensure an optimal performance and availability for servers managed by our Remote DBA Team. A tool like pt-online-schema can be used for any DDL changes ( Overview to DDL algorithm ), … Continue reading Integrating MySQL tools with Systemd Service
We are aware of ProxySQL as an SQL load balancing tool with a lot of features bundled in it.Now it has added firewall rules integrated too. Below are a few interesting features explained and explored by our Mydbops team. MySQL replication Read-Write Split up Replication Switchover using ProxySQL And MHA HA for Proxysql with keepalived … Continue reading Building a MySQL Firewall with ProxySQL
Database schema change is becoming more frequent than before, Four out of five application updates(Releases) requires a corresponding database change, For a DBA schema change is a more often a repetitive task, it might be a request from the application team for adding or modifying columns in a table and many more cases. MySQL supports … Continue reading An Overview of DDL Algorithm’s in MySQL ( covers MySQL 8)
ProxySQL is a high-performance load balancer that helps DBAs a lot and gives more control over MySQL Database. At Mydbops we use ProxySQL extensively to support our customers. We have seen a variety of use cases with ProxySQL and blogged a few We have written a series of blogs on ProxySQL (ProxySQL Series) MySQL replication … Continue reading Monitoring MySQL using ProxySQL
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
Recently we had encountered a strange issue with replication and temp directory(tmpdir) change while working for one major client. All the servers under this were running with Percona flavor of MySQL versioned 5.6.38 hosted on a Debian 8(Jessie) The MySQL architecture setup is as follows one master with 5 direct slaves under it Through this … Continue reading Impact of “tmpdir” change in MySQL replication
Introduction - Recently i worked on a production issue for one of our client under support .They have a architecture of a three node Galera cluster with one asynchronous slave . Node1 - 220.127.116.11Node2 - 18.104.22.168Node3 - 22.214.171.124Replica - 126.96.36.199 Architecture - The slave(replica) was configured with node3 as replica master. Unfortunately the node 3 was … Continue reading How to Switch Replica Master of a non-GTID Slave in Percona Cluster ?