MySQL has come up with window function in latest GA MySQL 8.0 . It is a major leap in SQL for MySQL. This presentation provides an overview to window function in MySQL 8.0. https://www.slideshare.net/MyDBOPS/window-functions-in-my-sql-8 Window Function in MySQL 8.0
Data security plays a major role in current age. Privacy matters a lot. Data masking is one of the Key Features when comes to security. In MySQL community versions if you want to mask your data, You can go with a Maxscale load balancer. They introduced a new masking filter on the Maxscale 2.1 version. … Continue reading Security: Data Masking in MySQL 8.0 server
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.
A few days ago one of our intern @mydbops reached me with a SQL query. The query scans only a row according to the execution plan. But query does not seems optimally performing. Below is the SQL query and its explain plan. ( MySQL 5.7 ) select username, role from user_roles where username= '9977223389' ORDER … Continue reading Row scanned equals to 1, Is the query is optimally tuned ?
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)
This blog is about one of the issues encountered by our Remote DBA Team in one of the production servers. We have a setup of MySQL 5.7 Single Primary (Writer) GR with cluster size of 3 . Due to OOM, the MySQL process in the primary node got killed, this repeated over the course of … Continue reading MySQL Group Replication and its Memory consumption (troubleshooting).
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
We will have a look at a new feature in MySQL 8.0 called binlog encryption. This feature is available from the MySQL version 8.0.14 or above. Our previous blogs discussed about table space encryption in MySQL and Percona servers. In Mydbops, we are giving high importance about achieving security compliances. The binary log records changes … Continue reading Securing MySQL Binary logs at Rest in MySQL 8.0