The MySQL Server Team has announced the General Availability of MySQL 8.0. You can download it here. Quoting their blog post, some key enhancements include:
SQL Window functions, Common Table Expressions, NOWAIT and SKIP LOCKED, Descending Indexes, Grouping, Regular Expressions, Character Sets, Cost Model, and Histograms.
JSON Extended syntax, new functions, improved sorting, and partial
Well here we go another MySQL conference / Percona Live.
Another huge and important event/milestone for the MySQL community.
But this time I will not be there.
First time in many years I had to decline, drop my speech and say... "No I am so sorry, this time I cannot come".
Was not an easy choice, not only because I am always excited to meet old colleagues, but also because PLSC is a great moment for brainstorming and to identify what could be good to push-on or to investigate better.
Especially this year where we have so many different interesting topics and so many different technologies as well.
And of course the MySQL 8 GA will make a huge wave, but that was expected. To be honest what I am more interested to see is... what the real adoption of it will means. In Percona, we are working to be able to have it's adoption to happen as smoother as possible.
…
[Read more]Introduction
We can categorize the InnoDB tablespaces created by users, broadly in following categories.
External tablespaces are sometimes called remote tablespaces, but both refer to a single or shared, file-per-table tablespace outside of the datadir.
Prior to MySQL 8.0, the …
[Read more]I am now in an airport, waiting for one of the four flights that will bring me to Percona Live Santa Clara 2018. This is a good time to write some details about my tutorial on parallel replication. But before talking about Percona Live, I will share thoughts on MySQL/MariaDB bugs that caught my attention in the last weeks/months (Valeriy: you clearly have an influence on me).
MySQL/MariaDB
It is a great today for whole MySQL community: MySQL 8.0 was just released as GA!
Geir Høydalsvik has a great summary in his “What’s New in MySQL 8.0” blog post. You can find additional information about MySQL 8.0 Replication and MySQL 8.0 Document Store that is also worth reading.
If you can’t wait to upgrade to MySQL 8.0, please make sure to read the …
[Read more]We are very happy to announce the general availability of MySQL Enterprise Monitor, Version 8.0. 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 Enterprise Carrier Grade subscriptions.
You can find more information on the contents of this release in the change log.
Highlights of MySQL Enterprise Monitor 8.0 include:
Dear MySQL users,
MySQL Connector/Python 8.0.11 is the first GA release version of the MySQL Connector Python 8.0 series. This series adds support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI, see http://dev.mysql.com/doc/x-devapi-userguide/en/. For more information about how the X DevAPI is implemented in MySQL Connector/Python, and its usage, see http://dev.mysql.com/doc/dev/connector-python.
Please note that the X DevAPI requires MySQL Server version 5.7.12 or higher with the X Plugin enabled. For general …
[Read more]
By now you’ve read Mike Frank’s excellent introduction to the MySQL 8.0 release and it’s Document Store. In that post Mike laid out the benefits of the new Document Store model and briefly outlined the different components involved. While it’s fair to consider the Document Store as the first pillar of the new MySQL 8 Document story, we must identify the X DevAPI to be the second. The post covers our motivation, goals, and overall design principles of this new API.
Motivation
Most of our connectors have not implemented their own API. Rather, most of them implement externally defined interfaces. Examples include our Connector/J that implements the JDBC standard, Connector/Net that implements the ADO.Net standard, and our Connector/ODBC. None of these standards work well for a document-oriented database. In …
[Read more]It is with extreme delight and a big smile on our face that we share the news that a new major MySQL release has been declared Generally Available (GA). The road to MySQL 8 was pretty eventful, sometimes painful and sometimes hard, always challenging, but nonetheless a great ride and an extremely rewarding journey for the engineers that have worked on it.…
As you may have heard, MySQL 8.0 is now officially GA, and it comes with a bunch of additional goodies. Among those is the brand new Connector/Node.js, which is the official MySQL driver for Node.js and, currently, the only one with support for the latest server versions and features (such as the MySQL document store).
Here’s a rundown of what’s available:
MySQL 8.0
…
[Read more]