Percona announces the release of Percona XtraDB Cluster 5.7.19-29.22 on September 22, 2017. Binaries are available from the downloads section or our software repositories.
NOTE: You can also run Docker containers from the images in the Docker Hub repository.
Percona XtraDB Cluster 5.7.19-29.22 is now the current release, based on the following:
We are pleased to announce that MySQL Enterprise Monitor 3.4.3 is now available for download on the My Oracle Support (MOS) web site. It will also be available for download via the Oracle Software Delivery Cloud in a few days. MySQL Enterprise Monitor is the best-in-class tool for monitoring and management of your MySQL assets and is included with your MySQL Enterprise Edition and MySQL Cluster Carrier Grade Edition subscriptions.
You can find more information on the contents of this release in the change log.
Highlights of MySQL Enterprise Monitor 3.4 include:
We are pleased to announce that MySQL Enterprise Monitor 3.3.5 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.
You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.
Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here:
We are pleased to announce that MySQL Enterprise Monitor 3.2.9 is now available for download on the My Oracle Support (MOS) web site. This is a maintenance release that includes a few new features and fixes a number of bugs. You can find more information on the contents of this release in the change log.
You will find binaries for the new release on My Oracle Support. Choose the "Patches & Updates" tab, and then choose the "Product or Family (Advanced Search)" side tab in the "Patch Search" portlet.
Important: MySQL Enterprise Monitor (MEM) 3.4 offers many significant improvements over MEM 3.2 and MEM 3.3 and we highly recommend that you consider upgrading. More information on MEM 3.4 is available here:
For most people (including me until recently) database XA transactions are a fuzzy concept. In over eight years with Percona, I have never had to deal with XA transactions. Then a few weeks ago I got two customers having issues with XA transactions. That deserves a post.
XA 101
What are XA transactions? XA transactions are useful when you need to coordinate a transaction between different systems. The simplest example could be simply two storage engines within MySQL. Basically, it follows this sequence:
Once prepared, the XA transaction survives a MySQL crash. Upon restart, you’ll see something like this in the MySQL error log:
2017-08-23T14:53:54.189068Z 0 [Note] …[Read more]
subtitle: How to use awk to filter binlogs for specific tables
The task: Find out how many inserts were done to a set of tables over a period of time. Specifically avg inserts/min, avg inserts/hour, avg inserts/day, for the past week. Seems simple, right?
I was surprised that there was no good way to get what was done to a specific table, for data gathering AND forensic purposes!
These tables are be deleted from, so just using rows and timestamps is not valid. We have binary logs, which log when an insert was done. My first thought was to use pt-query-digest, since the tool has a “Tables” section in the output, so it already parses out which tables are in a query.
Sadly, tables is not an attribute I can --filter on,
at least not in my version of pt-query-digest. (insert sad
trombone here)
Do you want to hear how popular, innovative and leading companies are using MySQL to scale their large workload ? Join Oracle Open World to learn from these successful players how to achieve strong business constraints using the most popular Open Source database !
We have the honor to welcome some of the most famous companies in the Web and host their sessions or invite them on stage during our keynote !
Facebook and Booking.com will share their experience during Rich Mason and Tomas Ulin keynote on Monday Oct 2nd in the Marriott Marquis, room Golden Gate A at 4.45PM.
Booking.com’s engineers will also propose sessions on Tuesday, Oct 3rd …
[Read more]Like every year, the a MySQL Community Reception will take place during Open World.
If you are using or interested in learning more about MySQL? And if you are attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users? Then join the MySQL team on Tuesday, October 3rd at Jillians to celebrate the dynamics and growth of the MySQL community!
Whether you are attending OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you’re all invited to Oracle’s MySQL Community Reception.
Great news! MySQL 8.0.3 is out and it is a release candidate. In the replication team we have been busy working on interesting new enhancements and also doing some clean up. Some of these new features are out in this release.…
Notes/errata/updates for Chapter 4:
See the official book errata at http://tahaghoghi.com/LearningMySQL/errata.php –
Chapter 4 includes pages 109 – 133.
On page 114, it says “For some applications, no combination of attributes can uniquely identify an entity (or it would be too unwieldy to use a large composite key), so we create an artificial attribute that’s defined to be unique and can therefore be used as a key: student numbers, Social Security numbers, driver’s license numbers, and library card numbers are examples of unique attributes created for various applications.” This is known as a “surrogate key”, because the number is a surrogate for the “real” unique way of identification.
On page 131, it says that reverse engineering an ER model from an existing database in MySQL Workbench is in beta testing phase. This function …
[Read more]
