Ideas, releases, practical guides, and perspectives from the people building with MySQL.
I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure:
Fastest and easiest method to deploy WordPress and MySQL 8.0 on OCI with an always free tier.
The Vitess Maintainer team is pleased to announce the results of a recent third-party security audit of the Vitess code base. Vitess had previously been audited in 2019. Given the amount of time that has passed, and the magnitude of change during that time, the maintainer team decided to request a fresh audit. Starting in March 2023, an independent team from Ada Logics performed a full security audit of Vitess with a special focus on VTAdmin, which is a relatively new addition to Vitess.
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 …
[Read more]Setting up replication in MySQL is a common DBA task. The replication could be traditional binary log replication or based on GTID replication. This blog is a work log and…
The post How to MySQL Replication setup, Master GTID & SSL Encryption first appeared on Change Is Inevitable.
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.
[Read more]