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
One problem I have experienced during logical exporting and importing databases is the tools don’t output any progress indicator (or anything at all really) and using the -v (verbose) switch outputs every single MySQL command being run from the import file. As, importing and exporting of databases is one of the most frequent activity being … Continue reading A Linux Tool to Monitor Progress of MySQL Data Imports and Exports.
ProxySQL supports a feature called clustering from version 1.4.2 .while planning for setting up a cluster ensure to have a version greater than 1.4.2 ( latest is better) . This is still an experimental feature but works well. This blog would be a continuation of our proxysql series of blogs. MySQL replication Read-Write Split up … Continue reading ProxySQL Series : ProxySQL Native Cluster
Recently one of our client approach Mydbops with Query slowness on a MySQL environment . They deployed the new code for generate the huge reports for the year end analytics data . After the deployment the queries were extremely slow and they struggled lot , then they approached us for the solution. After the analysis, … Continue reading 3 Step Migration of MySQL data to Clickhouse for faster analytics.
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
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
We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard. PMM has many advantages Easy to deploy (docker based) Flexible Customizable Query Analytics One-stop solution for MySQL,Mongo,ProxySQL … Continue reading Setting up a High Availability for PMM
Loading any large file into MySQL server using the LOAD DATA INFILE is a time consuming process , because it is single threaded and it is a single transaction too. But with modern hardwares system resource is not a bottle neck. At Mydbops we focus on improving the efficiency of process as we value performance … Continue reading MySQL load data infile made faster .
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