In this post, we introduce a configuration option that controls whether replication channels allow the creation of tables without primary keys. This continues our recent work on replication security, where we allowed users to enforce privilege checks, and/or enforce row-based events.…
Tweet Share
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.
Dear MySQL Users,
MySQL Connector/J 5.1.49, a maintenance release of the production
5.1
branch, has been released. Connector/J is the Type-IV pure-Java
JDBC
driver for MySQL.
MySQL Connector/J is available in source and binary form from
the
Connector/J download pages at
http://dev.mysql.com/downloads/connector/j/5.1.html
and mirror sites as well as Maven repositories.
MySQL Connector/J (Commercial) is available for download on the
My Oracle
Support (MOS) website. This release will shortly be available
on
eDelivery (OSDC).
As always, we recommend that you check the “CHANGES” file in
the
download archive to be aware of changes in behavior that might
affect
your application.
MySQL Connector/J 5.1.49 includes the following …
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
To celebrate the publishing of my new book MySQL 8 Query Performance Tuning, the Apress team invited me (thanks Jonathan and Liz) to write a post for the Apress blog. I decided to write about my top six best practices:
Yes, my first best practice is to be wary of best practices. Read why I added that and the other best practices at MySQL Performance Tuning Best Practices.
The post Apress Blog: …
[Read more]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