Remove mysql-database
article thumbnail

Why Your Next MySQL Database Should Not Be a MySQL Database

Percona

MySQL is a very popular database and a good choice for new projects. Luckily you have several options for this choice.MySQL Community vs. Enterprise EditionsTraditionally, the MySQL Community Edition has been a mainstay in the open source community for decades, and it is available for free. But is it the best choice?Luckily

article thumbnail

Database Server Lifecycle for MySQL and MariaDB

Percona

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. It is worth noting both MySQL and MariaDB have Community and Enterprise versions. This was a departure from matching MySQL versions, as was happening with MySQL 5.1

Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Is ANALYZE TABLE Safe on a Busy MySQL Database Server?

Percona

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 98
article thumbnail

Using Jobs to Perform Schema Changes Against MySQL Databases on K8s

Percona

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. You can just connect to the MySQL service POD and perform the ALTER. Your MySQL connection id is 256 Server version: 8.0.32-24.2

article thumbnail

MySQL Performance Tuning 101: Key Tips to Improve MySQL Database Performance

Percona

While there is no magic bullet for MySQL performance tuning, there are a few areas that can be focused on upfront that can dramatically improve the performance of your MySQL installation. What are the Benefits of MySQL Performance Tuning? A finely tuned database processes queries more efficiently, leading to swifter results.

Tuning 52
article thumbnail

MySQL Backups: Methods & Best Practices

Scalegrid

Regarding MySQL backups , knowing how to secure your data is crucial. This guide cuts through the complexity, providing instructions on creating, managing, and automating a MySQL backup. MySQL is a popular open-source relational database management system for online applications and data warehousing.

article thumbnail

Open Source Software Security: Is Open Source Software Safe?

Percona

Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a cell phone or computer, the question repeatedly arises: “Is open source software safe?” Is open source software as stable as other software? Is open source software secure?