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. The good news is MySQL by default has a feature for …
The post Export MySQL query results as JSON appeared first on Geeky Hacker.
The new MySQL-8.0.20 release is coming with re-designed InnoDB Double Write Buffer (DBLWR), and, indeed, it's one huge historical PITA less.. -- why it was so painful and cost us much blood in the past, I could not better explain than already done it in the following article yet from 2018 about MySQL on IO-bound workloads.. The story is not complete, as it's missing the 2019's chapter (will tell it later, np) -- but if you'll (re)read the mentioned above article first, you'll better understand the next ;-))
But at least the current post is only about good news now -- the new DBLWR and how it helps to solve historical MySQL performance problems ! -- and as one picture is better than million words, I'll try to save 3M words here (as there are 3 pictures in this article ;-))
Well, I'll also skip all new design details …
[Read more]Peter Zaitsev, Founder and CEO at Percona, presents a webinar focused on dealing with an unexpected high traffic event as it is happening. He’ll address the impact a traffic spike can have on your database – from poor query response time to replication lag issues – and provide actionable tips and tricks. Join us and learn how to bring your database under control, earn performance gains, and delight your customers!
Please join Peter Zaitsev, CEO of Percona, on Wednesday, May 13 at 12 pm EDT for his webinar “18 Things To Do When You Have a MySQL Bottleneck“.
If you can’t attend, sign up anyway and we’ll send you the slides and recording afterward.
April 29, 2020 – Percona is pleased to announce the release of Percona XtraDB Cluster 8.0. This release, based on Percona Server for MySQL 8.0 and Galera 4, brings together the best features of these and other products to deliver an open-source high availability MySQL solution that helps enterprises minimize unexpected downtime and data loss, improve data security, and ensure data integrity of your database environments supporting your critical business applications in the most demanding public, private, and hybrid cloud environments.
Percona XtraDB Cluster 8.0 enables enterprises to improve data security and ensure data integrity with new encryption and streaming replication features. …
[Read more]Writing MySQL Proxy in GO for self-learning: Part 2 — decoding handshake packet
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 connections threads
Each client connection to MySQL Server handled by a thread. MySQL is portable, so the underhood threads implementation is system dependent (Windows, macOS, and Linux have their own threads implementation).
What important to us, it’s to understand that a single client connection …
[Read more]We have just released MySQL 8.0.20. And it has some interesting replication enhancements. In particular one big and exciting feature: binary log compression. Here is the list of things in this release:
… Tweet Share
Update: Percona XtraBackup 8.0.12 now supports backup and restore processing for versions of MySQL 8.x; previous versions of Percona XtraBackup will not work with MySQL 8.0.20 and higher. More information
On Monday, April 27, 2020, Oracle released the highly anticipated 8.0.20 version of the MySQL database server. This release contains changes to the InnoDB redo log format which breaks compatibility with all currently released versions of the Percona XtraBackup 8.x series.
At this time, there are no known workarounds that will allow any version of Percona XtraBackup 8.x to function properly with MySQL 8.0.20.
We have identified the specific cause of the issue and diligently working towards a new release that will safely solve this issue as soon as possible.
Thank you for your …
[Read more]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. I have created a three-node cluster with Group Replication using a single Primary and a three-node PXC, both with default settings. I am also going to use ProxySQL to interface with both clusters.
In both clusters, the name of the nodes are mysql1,
mysql2, and mysql3. In Group
Replication the Primary node is where the writes go if we are
using single primary configuration. In PXC, I will use the same
term as well and will call the node Primary where I am sending
the writes. Just to note, in PXC there is no concept of primary
node, …
The MySQL Development team is proud to announce version 8.0.20 of the MySQL Shell, with the following features:
… Facebook Twitter LinkedIn
As you know, today, MySQL 8.0.20 has been released. I started this new thread category with 8.0.19 (see this post).
A late thanks to Guoji Ma, for a contribution to bug #95801 “show create table output can’t be executed” that was used as inspiration for the actual fix that was pushed in MySQL 8.0.18.
MySQL 8.0.20, includes contributions from Daniel Black, Cai Yibo, Jericho Rivera, Matti Sillanpää, Nick Pollett, Bruce Feng, Kamil Holubicky, Facebook.
Thank you all for your great contributions. MySQL is an Open Source project, GPL, and we accept contribution of course. Sometimes it’s also good to remind it
Here is the list of the contributions above: