In previous post we analyzed MySQL performance on x86 and ARM using the Cost-Performance Model (#cpm) where-in Cost and other resources (except compute power) was kept constant allowing compute power to differ. ARM being cheaper got more compute power for the same cost. That was a user perspective story but developers were also interested to understand how MySQL scale if we provide the same computing power.

We decided to go ahead with this and benchmark MySQL on x86 and ARM except this time with the same compute power (keeping all other resources memory, storage, etc… same) and allowing cost to differ with ARM variant cheaper than x86 variant. It would also help understand if ARM is really powerful for High-Performance Computing like databases.

Benchmarking Setup

…

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.

Mysqldump is a popular logical backup tool for MySQL which was originally written by Igor Romanenko.

Mysqldump performs logical backups (set of SQL statements). By default, mysqldump does not dump information_schema tables and it never takes performance_schema. But the major drawback of mysqldump is that it uses only one thread while doing backup and restore. (Even your server has 64 cores). To overcome this drawback, MySQL introduced new utilities on the Shell client. In this blog I am going to explain these new backup utilities.

Overview of MySQL Shell 

The …

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 …

Since Covid situation we are - same as the rest of the world - switching most of our MySQL sessions & workshops to the online word. Below you can find the list of events with MySQL recorded sessions we run during the time from September to end of November and also some interesting videos as well. So, the list below includes publicly available recorded MySQL sessions (or slides only) from conferences end other events we attended. 

• September 2020:

  • Open Source Conference Hiroshima, September 19, 2020

    • MySQL Session: "MySQL Update"
    • Speaker: Yoshiaki Yamasaki, the MySQL Principal Solution Engineer
    • URL:  …

Since Covid situation we are - same as the rest of the world - switching most of our MySQL sessions & workshops to the online word. Below you can find the list of events with MySQL recorded sessions we run during the time from September to end of November and also some interesting videos as well. So...

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