MySQL 8.0

Upcoming Webinar Wed 12/12: MySQL 8 for Developers

MySQL 8 for Developers

Please join Percona’s CEO Peter Zaitsev as he presents MySQL 8 for Developers on Wednesday, December 12th, 2018 at 11:00 AM PST (UTC-7) / 2:00 PM EST (UTC-5).
Register Now
There are many great new features in MySQL 8, but how exactly can they help your application? This session takes a practical look at MySQL 8 […]

Read more

Percona XtraBackup 8.0.4 Is Now Available

Percona XtraBackup 8.0

Percona is glad to announce the release of Percona XtraBackup 8.0.4 on December 10, 2018. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, […]

Read more

Oracle Recognizes Percona Fixes in MySQL 8.0

MySQL 8.0 Code Contributions

MySQL 8.0 Code Contributions (Shutterstock)
An Oracle engineer thanked two Percona engineers by name, along with engineers from Facebook and elsewhere, for their recent MySQL 8.0 source code contributions. Oracle incorporated their work into its latest MySQL production release (8.0.13).
Percona’s Zsolt Parragi authored a patch for a rare replication bug that left locked mutexes […]

Read more

Percona XtraBackup 8.0-3-rc1 Is Available

Percona XtraBackup 8.0

Percona is glad to announce the release candidate of Percona XtraBackup 8.0-3-rc1 on October 31 2018. You can download it from our download site and apt and yum repositories.
This is a Release Candidate quality release and it is not intended for
production. If you want a high quality, Generally Available release, use the current stable version (the most recent stable version at […]

Read more

Release Candidate for Percona Server 8.0.12-2rc1 Is Available

Percona Server for MySQL

Following the alpha release announced earlier, Percona announces the release candidate of Percona Server for MySQL 8.0.12-2rc1 on October 31, 2018. Download the latest version from the Percona website or from the Percona Software Repositories.
This release is based on MySQL 8.0.12 and includes all the bug fixes in it. It is a Release Candidate […]

Read more

One Billion Tables in MySQL 8.0 with ZFS

one billion tables MySQL

The short version
I created > one billion InnoDB tables in MySQL 8.0 (tables, not rows) just for fun. Here is the proof:

MySQL

$ mysql -A
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1425329
Server version: 8.0.12 MySQL Community Server – GPL

Copyright (c) 2000, 2018, Oracle and/or its […]

Read more

Instrumenting Read Only Transactions in InnoDB

Instrumenting read only transactions MySQL

Probably not well known but quite an important optimization was introduced in MySQL 5.6 – reduced overhead for “read only transactions”. While usually by a “transaction” we mean a query or a group of queries that change data, with transaction engines like InnoDB, every data read or write operation is a transaction.
Now, as a […]

Read more

Announcement: Second Alpha Build of Percona XtraBackup 8.0 Is Available

Percona XtraBackup 8.0

The second alpha build of Percona XtraBackup 8.0.2 is now available in the Percona experimental software repositories.
Note that, due to the new MySQL redo log and data dictionary formats, the Percona XtraBackup 8.0.x versions will only be compatible with MySQL 8.0.x and Percona Server for MySQL 8.0.x. This release supports backing up Percona Server […]

Read more

Persistence of autoinc fixed in MySQL 8.0

MySQL 8.0 autoinc persistence fixed

The release of MySQL 8.0 has brought a lot of bold implementations that touched on things that have been avoided before, such as added support for common table expressions and window functions. Another example is the change in how AUTO_INCREMENT (autoinc) sequences are persisted, and thus replicated. (more…)

Read more

Announcement: Alpha Build of Percona Server 8.0

Percona Server for MySQL

Alpha Build of Percona Server 8.0 released
An alpha version of Percona Server 8.0 is now available in the Percona experimental software repositories. This is a 64-bit release only. 
You may experiment with this alpha release by running it in a Docker container:
$ docker run -d -e MYSQL_ROOT_PASSWORD=password -p 3306:3306 perconalab/percona-server:8.0.12.alpha
When the container starts, connect to […]

Read more