Categories
Products
Technologies
Top Rated docs

June 22, 2020

Online Migration from MySQL 5.6 Non-GTID to MySQL 5.7 with GTID

In this blog post, we are going to look into how to perform online migration from MySQL 5.6 standalone setup to a new replication set running on MySQL 5.7, deployed and managed by ClusterControl.  The...

April 7, 2020

My DBA is Sick – Database Security Tips for SysAdmins

The day happened when your database administrator did not show up on the daily online standup. Shortly after you have learned that he’ll be unavailable for an unknown period of time and it is you,...

April 6, 2020

Preparing a MySQL or MariaDB Server for Production – Part Two

In the previous blog, we have covered some tips and tricks to prepare a MySQL server for production usage from a system administrator perspective. This blog post is the continuation...  Use a Database Backup Tool...

March 26, 2020

Preparing a MySQL or MariaDB Server for Production – Part One

It is extremely important to install and configure a production MySQL server with the necessary packages and tools to smooth-out the operations in the long run. We have seen many cases where troubleshooting or tuning...

March 6, 2020

How to Easy Manage Database Updates and Security Patches

Database security requires careful planning, but it is important to remember that security is not a state, it is a process. Once the database is in place, monitoring, alerting and reporting on changes are an...

February 19, 2020

When Should I Add an Extra Database Node?

The fact that people are not easily convinced to have an additional database node in production due to cost is somewhat absurd and is an idea that should be put aside. While adding a new...

January 21, 2020

Moving from MySQL 5.7 to MySQL 8.0 – What You Should Know

April 2018 is not just a date for the MySQL world. MySQL 8.0 was released there, and more than 1 year after, it’s probably time to consider migrating to this new version. MySQL 8.0 has...

January 14, 2020

Cluster-Wide Database Maintenance and Why You Need It

Undoubtedly, there is a long list of maintenance tasks that have to be performed by system administrators, especially when it comes to critical systems. Some of the tasks have to be performed at regular intervals,...

November 15, 2019

Tips for Migrating from MySQL Replication to MySQL Galera Cluster 4.0

We have previously blogged about What’s New in MySQL Galera Cluster 4.0, Handling Large Transactions with Streaming Replication and MariaDB 10.4 and presented some guides about using the new Streaming Replication feature in a part...

October 21, 2019

What's New in PostgreSQL 12

On October 3rd 2019 a new version of the world's most advanced open source database was released. PostgreSQL 12 is now available with notable improvements to query performance (particularly over larger data sets and overall...

July 25, 2019

How to Run PHP 5 Applications with MySQL 8.0 on CentOS 7

Despite the fact that PHP 5 has reached end-of-life, there are still legacy applications built on top of it that need to run in production or test environments. If you are installing PHP packages via operating...

June 19, 2019

Migrating from MySQL Enterprise to MariaDB 10.3

While it shares the same heritage with MySQL, MariaDB is a different database. Over the years as new versions of MySQL and MariaDB were released, both projects have differed into two different RDBMS platforms. MariaDB...

Subscribe below to be notified of fresh posts