(Kasra Madadipouya) In one of the latest post, I discussed how to transform a large MySQL table to JSON using Apache Spark. Well, that approach works for any tables with any volume. But it’s an overkill for simple and small tables.
Tag: Open Source
Enforce Primary Key constraints on Replication
(Pedro Gomes) In this post, we introduce a configuration option that controls whether replication channels allow the creation of tables without primary keys.
Writing MySQL Proxy in GO for self-learning: Part 2 — decoding handshake packet
(Alexander Ravikovich) After we built a generic TCP proxy, we can continue with our journey. Today’s goal will be to understand the MySQL Protocol, receive, decode, encode and send to the client the first packet sent by the MySQL Server.
MySQL Security – Password Reuse Policy
(Olivier Dasini) When thinking about security within a MySQL installation, you can consider a wide range of possible procedures / best practices and how they affect the security of your MySQL server and related applications.
MySQL 8.0.20: Index-Level Optimizer Hints
(Jesper Krogh) MySQL introduced optimizer hints in version 5.7 and greatly extended the feature in MySQL 8. One thing that has been missing though is the ability to specify index hints using the syntax of optimizer hints.
What makes MySQL LRU cache scan resistant
(Arpit Bhayani) Disk reads are 4x (for SSD) to 80x (for magnetic disk) slower as compared to main memory (RAM) reads and hence it becomes extremely important for a database to utilize main memory as much as it can, and be super-performant while keeping its latencies to a bare minimum.
Group Replication and Percona XtraDB Cluster: Overview of Common Operations
(Tibor Korocz) In this blog post I would like to give an overview of the most common failover scenarios and operations when using MySQL Group Replication 8.0.19 (aka GR) and Percona XtraDB Cluster 8 (PXC) (which is based on Galera), and explain how each technology handles each situation.
How Hard is MySQL Working?
Queries per second (QPS) measures database throughput, but it does not reflect how hard MySQL is working. The latter is measured by Threads_running, expressed as a gauge (whereas QPS is a rate).
What’s the Best Way to Enable (And Test) Encryption at Rest in RDS?
(Mike Benshoof) The other day on a call, a client asked me an interesting question. We were discussing some testing they were doing in Amazon Relational Database Service (RDS).
Logging all MySQL queries into the Slow Log
(Federico Razzoli) MySQL optionally logs slow queries into the Slow Query Log – or just Slow Log, as friends call it. However, there are good reasons to log all the queries, not just some of them.