I already wrote on how to deploy WordPress on OCI using MySQL HeatWave, the MySQL Database Service in Oracle Cloud Infrastructure:
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]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]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 …
[Read more]This blog post serves as a work-log detailing the process of uninstalling and installing a specific version of Percona MySQL Server on CentOS. The post includes instructions for installation using…
The post Install exact version of Percona Server for MySQL on CentOS first appeared on Change Is Inevitable.
A friend needed to analyze slow queries and for that he decides to use pt-query-digest tool. Though he got stuck at exporting slow queries from slow logs in RDS for…
The post MySQL Slow query log export and review in RDS first appeared on Change Is Inevitable.
If you’re looking for your PHP, MySQL, and LAMP stack media source, you’ve found it in OpenLampTech. I have one massive – and excellent – newsletter for you this week. Check it out!
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
OpenLampTech issue #80 is sharing content on:
I am finalizing my Percona Live talk MySQL and Vitess (and Kubernetes) at HubSpot. In this talk, I mentioned that I like that Percona is providing better MySQL with Percona Server. This comes with a little inconvenience though: with improvements, sometimes comes regression. This post is about such regression and a workaround I implemented some time ago (I should have shared it
Welcome to the OpenLampTech developer newsletter. Thank you so much for reading each week. I am bringing you the media source for PHP, MySQL, and the LAMP stack you can depend on.
Custom WooCommerce and Shopify Solutions
Discover useful WooCommerce and Shopify custom solutions for your online store today at affordable prices!
The Newsletter for PHP and MySQL Developers
Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.
I am sharing so many good articles this week in OpenLampTech issue #79. Visit those …
[Read more]
