As you may know, MySQL 5.6 will reach EOL (“End of Life”) in February 2021. This means in about two months, there will be no more updates, and more importantly, no more security fixes for discovered vulnerabilities.     

You may be well ahead of the curve and have already updated to MySQL 5.7 or MySQL 8.0, or even better, migrated to Percona Server for MySQL, or maybe not. Perhaps it takes more time than anticipated to adjust your application to be compatible with MySQL 5.7 or higher, or maybe you planned to decommission your application, but life got in the way. Now the EOL date is looming, and there is just no way to decommission your last MySQL 5.6 instance in time.

We have great news for our MySQL Luddites! Percona is pleased to …

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 to require Highly Technical knowledge to be deployed correctly.

If you would like to test it with MySQL Database Service (MDS) in OCI, you can find a stack file on this GitHub repository that easily deploys everything you need.

After applying the Stack in OCI’s Resource Manager, you have a brand new Magento ready to use !

Let’s see this in action:

As you could see this is very easy. Enjoy MySQL Database Service on OCI and I’m always please to …

At my FOSDEM talk earlier this year, I gave a trick for fixing a crashed GTID replica.  I never blogged about this, so now is a good time.  What is pushing me to write on this today is my talk at MinervaDB Athena 2020 this Friday.  At this conference, I will present more details about MySQL replication crash safety.  So you know what to do if you want to learn more about

If you started looking at running your MySQL database on the cloud and thought that taking your data to Oracle Cloud Infrastructure (OCI) is an option (and wondering about integrating to the new MySQL Acnalytics service), well that is probably the natural choice, because MySQL can integrate easily with OCI services like cloud backups in OCI Object Storage service and OCI keyring for transparent data encryption. I will share a few options with advantages of every solution, so to put the idea into practice.

• MySQL Database Service (MDS)
• MySQL on the OCI Marketplace
• MySQL on OCI do-it-yourself

MySQL Database Service (MDS)

The brand new MySQL Database Service is the easiest way to run your Server in OCI, as it offers several …

Getting MySQL working with self-signed SSL certificates is pretty simple. Having it working with a certificate signed by a trusted authority is also very simple, we just need to set the correct path and privileges to the file. The problem comes when we need to make MySQL validate the certificate signature against the authority public key.

I’ve searched on the internet but wasn’t able to find much information about it. There are a good number of posts on how to set up your own certificate authority and self-sign your certificates, but not much about how to use one signed by a public trusted authority.

I used a certificate signed by a Let’s Encrypt on my tests but the concepts and steps shared here should work for any public trusted authority. I also generated one certificate to be used by MySQL server and another one to be used by the client. It is possible to use the …

As you already read, MySQL Devroom will be present during FOSDEM’21. The selection committee has been announced yesterday and
today we open the Call for Paper !

This event is a real success story for the MySQL ecosystem; the content, the speakers and the attendees are growing every year.

The MySQL Developer room focuses on MySQL and its Ecosystem.

It will run on Sunday 7th February.

New rules / What changes since last year:

• For obvious reasons, this year the event will not take place in a physical location but online.
• The reference time will be Brussels local time (CET).
• Talks will be pre-recorded, and streamed during the event – Before proposing a …

The MySQL Devroom is pleased to announce the committee that will decide on the talks to be presented for this totally new format of the next FOSDEM edition. Indeed, if you are not yet aware of it, FOSDEM 2021 will be an online event. Every year we are overwhelmed with submissions and it’s the committee that has the thankless task of deciding on the final selections and agenda.

Every year, we try to have a mix of experienced members knowing the process of the devroom talks rating and expect them to mentor the new members.

This year’s committee members are:

• Elisa Usai
• Gabriela D’Ávila Ferrara
• Liz Van Dijk
• Silvia …

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 has security risks of course. Therefor, it’s not recommended.

If you want to connect from on-premise to your MDS instance you should use a VPN or a SSH tunnel. Take a look at these previous post:

• https://lefred.be/content/migrate-from-on-premise-mysql-to-mysql-database-service/
• …

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 developer community to manage their databases in MySQL: PHPMyAdmin.

So if you are trying MDS (MySQL Database Service in Oracle Cloud Infrastructure), it’s possible to deploy such instance with a compute instance hosting PHPMyAdmin very easily using OCI’s Resource Manager and a stack (zip file) that you can find here: https://github.com/lefred/oci-phpmyadmin-mds/releases/tag/1.1.0

If you want to try MDS in OCI, you can get free credits using this url: …

We are happy to inform you know about regular MySQL Webinars run by Carsten Thalheimer, the MySQL Solution Engineer. They are scheduled once a month and they are fully virtual. See details below:

• In English:
  • Timing: every first Thursday of a month
  • Focus: English speaking audience (focus Middle East)
  • Webinar Title: Things I should have known before I installed MySQL... 
  • URL for Zoom: https://oracle.zoom.us/webinar/register/WN_uMez9v1dQfiw7WucMyuxXw
• In German
  • Timing: every first Friday of a month
  • Focus: German speaking audience (focus D-A-CH)
  • Webinar Title: Things I should have known before I installed MySQL... …