We have many ways to install MySQL on linux machines such as source, binary and so on. But most of the Engineers always prefer default package managers (yum for RPM-Based distributions and apt for DPKG-Based distributions) for its ease of use and it can resolve all dependencies on its own. And of course, it is not possible to use package managers in environments where the internet is not allowed, but this is a different case. 

At some point, we need to install exactly specific version of MySQL for the following cases

• To create Production Replicas 
• To simulate an Production Issue on similar kind of environment
• To configure Disaster Recovery(DR)/UAT Setup
• Compatibility with opensource tools ( Eg , …

In the world of the Databases, one of the most important value that we are all trying to achieve is High Availability. Not to loose our valuable data or in case one server fails to always have another to step in and take control.

So, it is critical to have along with our primary database, other identical instances, the replicas.

On this blog post, we will see the most famous ways to set up our replication.

The post Setting up Replication with various methods for MySQL 8 first appeared on dasini.net - Diary of a MySQL experts.

Cloud backup is a strategy increasingly used in organizations. Send copies of your data to the cloud, can help you to prevent a devastating IT crisis and ensure business continuity.

Currently, MySQL Enterprise Backup supports the following types of cloud storage services:

- Oracle Cloud Infrastructure (OCI) Object Storage

- OpenStack Swift or compatible object storage services

- Amazon Simple Storage Service (S3) or compatible storage service

The post Create a Cloud Backup with MySQL Enterprise Backup first appeared on dasini.net - Diary of a MySQL experts.

Having spent the majority of this year programming a custom reporting dashboard for my employer written in PHP and MySQL, it is an understatement to say that I have learned a lot. Nothing beats real-world experience and I really have come into my own with PHP, learning more and more daily as I continue progressing forward on my goal of becoming a Back-End Web Developer. I have written several PHP-related posts this year and wanted to provide them all in one easy-to-access list. Enjoy!

Image by Aleksey Nemiro from …

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 …