MySQL Invisible Column: part III
We recently saw how the new Invisible Column feature works in MySQL since 8.0.23 and how we can use it as a Primary Key for InnoDB tables when no Primary Key was defined. As I wrote earlier, a good Primary…
We recently saw how the new Invisible Column feature works in MySQL since 8.0.23 and how we can use it as a Primary Key for InnoDB tables when no Primary Key was defined. As I wrote earlier, a good Primary…
This article is the second part of the series related to MySQL Invisible Column started here. This post covers why Invisible Column is important for InnoDB Storage Engine. To start, let me explain briefly how InnoDB deals with Primary Key…
With the new MySQL 8.0.23, something very interesting has been released: Invisible Column. This is the first post dedicated to this new feature, I expect to write a series of 3. This one is the introduction.
The expected version 8.0.23 of MySQL has been released yesterday \o/ For new features and resolved bugs, I recommend Geir‘s traditional blog post announcing the release. Of course, as usual, this release contains contributions from our great Community and let…
If you plan to deploy a Drupal site to OCI using MySQL Database Service, there is a very easy way to perform that deployment: using OCI’s Resource Manager ! As you know, security is something very important for Oracle in…
Magento is a very popular e-commerce platform using MySQL as backend. The latest version is compatible with MySQL 8.0, however it’s not that easy to deploy. Magento has multiple dependencies like Elasticsearch for example. Additionally, the Open Source version seems…
Recently (earlier today), I blogged about how to use PHPMyAdmin with a MDS instance. I also showed at the end of the video that it’s possible to open MySQL Router on the compute instance to connect from anywhere. However this…
I recently received several messages from developers not being comfortable with command line when they need to create schemas, tables, … They were asking me for an easy alternative when testing MDS. There is a very popular tool in the…
The amount of transactions committed is an important information, but how could you return an accurate value? This is a question I got from my colleague Ivan, he was challenging with global status values like COM_COMMIT or HANDLER_COMMIT, then checking…
Since 8.0.17, MySQL Router allows you to performs API call to retrieve statistics to monitor it.
Wooohooo MySQL 8.0.22 has been released today ! As usual, this release contains contributions from our great Community and let me thanks all the contributors on behalf of the MySQL Team. MySQL 8.0.22 includes contributions from Denis Yarkovoy, Gord Thomson,…
This post was first published on Oracle MySQL Blog. If you are running MySQL on premise, it’s maybe the right time to think about migrating your lovely MySQL database somewhere where the MySQL Team prepared a comfortable place for it…
As MySQL Community Manager, I am an employee of Oracle and the views expressed on this blog are my own and do not necessarily reflect the views of Oracle.
You can find articles I wrote on Oracle’s blog.