This blog post was originally published in November 2017 and was updated in June 2023.

In this blog, we’ll provide a comparison between MariaDB vs. MySQL (including Percona Server for MySQL).

Introduction: MariaDB vs. MySQL

The goal of this blog post is to evaluate, at a higher level, MariaDB vs. MySQL vs. Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation.

It is worth noting that Percona Server for MySQL is a drop-in compatible branch of MySQL, where Percona contributes as much as possible upstream. MariaDB Server, on the other hand, is a fork of MySQL 5.5. They cherry-picked MySQL features and don’t …

I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure: Using MySQL Database Service for WordPress Deploying WordPress on OCI with MySQL Database Service: the easy way ! Deploy WordPress on OCI using MySQL Database Service Deploy WordPress on OCI with MySQL Database Service […]

ProxySQL is a high-performance MySQL proxy with a small footprint that can be installed in multiple environments such as VM, K8s, bare-metal, and Docker containers. In this guide, you will install and set up load balancing of MySQL Cluster via ProxySQL on a Debian 11 server.

There are some scenarios where application do require to show datetime with regional time zone(let’s say application user wanted to show data in India IST time zone). By default MySQL database service(MDS) has UTC time zone and in order to change the system variable of time_zone you can’t do at this moment by SQL commands […]

This blog walk through an easy way to change global system variable time_zone using OCI dashboard

Learn how the parallel index rebuild feature in MySQL 8.0.31 improves performance by optimizing index and column additions. Explore the multithreaded insert phase, sort index build process, and system configurations for enhanced efficiency.

1. Understanding Sorted Index Build
   1. When does InnoDB use a sort index build approach?
2. Phases of Sort …

Node and MySQL are a go-to combination for a quick prototype build and in various cases for production build as well. In this tutorial, we will learn how to connect Node with MySQL and how to pool the connections for better performance and optimization of resources. You need Node and MySQL installed in your system before proceeding towards the tutorial. Click here to read a comprehensive guide on the installation and setup of Node.js. And if you want to know how to run and connect to a MySQL server, check out: NodeJS Create MySQL Connection. Node MySQL Connection To begin…

Updated June 1, 2023.

Suboptimal MySQL ORDER BY implementation, especially together with MySQL LIMIT is often the cause of MySQL performance problems. Here is what you need to know about MySQL ORDER BY LIMIT optimization to avoid these problems.

Try Now: Free your applications with Percona Distribution for MySQL

MySQL LIMIT clause

The MySQL LIMIT clause is a valuable tool for controlling the number of rows returned by a SELECT statement. By specifying the maximum number of rows to retrieve from the result set, it enables you to work with subsets of data, especially in situations involving large tables. This feature enhances query performance and optimizes resource usage by fetching only …

Our pleasure to inform you about the events and conferences where you can find MySQL Community or MySQL during June to August 2023. Please join us at any of them below! We are looking forward to meeting and talking to you at any of the conferences above!

List of shows 6-8/2023