(In the previous post, Part 5, we covered Data Reads.)

In this blog post, we continue our series of exploring MyRocks mechanics by looking at the configurable server variables and column family options. In our last post, I explained at a high level how reads occur in MyRocks, concluding the arc of covering how data moves into and out of MyRocks. In this post, we’re going to explore replication with MyRocks, more specifically read-free replication.

Some of you may already be familiar with the concepts of read-free replication as it was a key feature of the TokuDB engine, which leveraged fractal tree indexing. TokuDB was similar to MyRocks in the sense that it had a pseudo log-based storage …

Tweet

The sys schema was created to make it easier to use the Performance Schema. This included several functions, for example to convert the picoseconds used by the Performance Schema into human readable strings. In MySQL 8.0.16, three of these functions have been implemented as native functions in MySQL Server.

Why do away with the sys schema functions? There are two reasons: performance and ease of use. The native functions are written in C++ like the rest of the server whereas the sys schema functions were written as stored functions. Function written in C++ are inherently faster than stored functions. Additionally, that the functions are native means you no longer need to prefix them with sys. to tell MySQL where …

Percona announces the release of Percona Server for MySQL 5.7.26-29 on May 27, 2019 (downloads are available here and from the Percona Software Repositories). This release merges changes of MySQL 5.7.26, including all the bug fixes in it. Percona Server for MySQL 5.7.26-29 is now the current GA release in the 5.7 series. All of Percona’s software is open-source and free.

New Features:

• New …

There are already many tools for MySQL to perform backups and consistent restores, but this time I’d like to elaborate on how to take advantage of the kindness the cloud, which gives us Persistent Disk Snapshots (PSD) to restore our data set in a consistent way.

In this entry, I’ll describe in detail how to restore a backup of our MySQL dataset in a Cloud Compute VM instance making use of persistent disk snapshots and using code examples that can be used as part of an automation strategy. This method will allow us to switch between datasets in less than a minute, as opposed to the several hours that would be required to perform a restore via xtrabackup, or even longer via mysqldump.

Considerations

I’ve been working in Google Cloud Platform (GCP) and chose a simple master/slave replication scenario consisting of two VM instances running Percona Server 5.7 with xtrabackup installed on the slave.

…

Our pleasure to remind everyone about three events which are happening this week and MySQL is part of. Please find them below.

• PerconaLive, Austin, TX, US, May 28-30, 2019

  • as we previously announced MySQL is Silver sponsor w/ booth and several MySQL related talks as follows:
    • Tuesday, May 28, 2019:
      • MySQL Tutorial on: "MySQL InnoDB Cluster in a Nutshell: The Saga Continues with 8.0, the full guide" by Frederic Descamps & Kenny Gryp. Time: 9:30-12:30pm.
    • Wednesday, May 29:
      • 11:00-11:50, Room: Hill Country A: "Complex Stateful Applications Made Easier with Kubernetes" by Patrick Galbraith, the Principal Member of MySQL …

Trefft Carsten und Henry vom MySQL Team Deutschland auf der DOAG Datenbank 2019 (#DOAGDB19) am 3. und 4. Juni in Düsseldorf.

Wir sind mit einem kleinen Stand vertreten und Carsten wird am Montag von 14:15 bis 15:00 einen Vortrag zum Thema „MySQL, ein Einstieg in die 'andere' Datenbank von Oracle“ im Raum Amsterdam 2 halten. Das gesamte Programm für Montag und Dienstag lässt sich hier einsehen.

Wenn es im Vorfeld Fragen von Eurer Seite aus gibt, wendet Euch gerne per E-Mail an Henry [henry.kroger(at)oracle(dot)com].

Wir freuen uns …

We at Aiven are big believers in Open Source. Not only do we provide Open Source databases as a service, we are contributors to several of those and many related projects. Additionally, we open source our in-house tools we’ve developed to provide Aiven services whenever we can.

Getting the details just right to fully automate MySQL backups isn't simple. Find out how we accomplished it with our Open Source tool, MyHoard.

Getting the details just right to fully automate MySQL backups isn't simple. Find out how we accomplished it with our Open Source tool, MyHoard.

How to Prepare for MySQL Certification Exam

Here I am going to suggest MySQL DBA, student or any newbie that how they can prepare for "Oracle's MySQL 5.x Database Administrator" certification exam. 
Step 1: Lab
-- Prepare your local MySQL lab environment and make sure to install the respective MySQL version on your lab. (i.e., if you are going to appear on MySQL 5.6 DBA exam 1Z0-883 then install MySQL 5.6 on your lab) 
-- You can follow my below blog post to create your local MySQL lab …