MySQL

Advanced failover is very important - it might even be necessary when you have a very complex database setup. When dealing with disasters that can happen in unanticipated events, pre/post scripts can be very helpful to determine how feasible and how true is the alarm that was triggered. Proceeding on a failover after a false positive is a waste of money, resources, and waste of time. ClusterControl has these features and this blog demonstrates how you can take advantage of them dedicated for advanced failover.

MySQL replication is easy to set up, but also easy to break! What do you do when replication stops, and will not restart? In cases where replication cannot be restarted, how do you failover to a new master? This blog post discusses some of the common replication issues in MySQL setups, and how to fix them with ClusterControl.

MySQL Replication is commonly used by organizations and companies for running their large production environments. There are certain practices that are adopted to avoid disasters or mishaps in this topology. Some issues can lead to a huge downtime and loss of business caused by lack of expertise and improper setup. This blog will cover the best practices that are usually adopted by MySQL experts in the industry.

ClusterControl offers you a different approach of managing databases which can not be observed and experienced in other platforms. It can be deployed on-prem, on the cloud, or on a containerized type of environment. It can be deployed flexibly and has a massive feature that offers rich and powerful operations that makes it easier to manage your database and without requiring you to create your automated scripts. ClusterControl will handle this for you as shown by this blog. This blog showcases how it is feasible to manage multiple database technologies with ClusterControl.

Data governance defines a set of principles to ensure data quality in a company. It describes the processes, roles, policies or responsibilities, and metrics to ensure accountability and ownership of data assets across the enterprise. This blog discusses the six critical components to successful data governance for better data quality.

In this blog post, we are going to focus on SNMP traps and alerting. SNMP Traps are the most frequently used alert messages sent from a remote SNMP-enabled device (an agent) to a central collector, the “SNMP manager.” In the case of ClusterControl, a trap could be an alert after the critical alarm for a cluster is not 0, indicating something bad is happening.

In this blog series, we are going to showcase a proof-of-concept (PoC) on how to integrate ClusterControl with SNMP protocol. At the end of the blog series, we would ultimately be able to send an SNMP trap to an SNMP manager (Nagios, Zabbix, etc). In this first part, we are going to cover the MIB and SNMP agent.

Scaling databases is not the easiest task for multiple reasons. In the first blog, we discussed the basic concepts related to the process of scaling databases. This second part of the series discusses the challenges of scaling and how you can deal with the increase of the load on your database environment

Managing a very large database incurs huge challenges and fears in case of data loss, disasters, or lack of experience of the database to use. However, knowing the basics that could help you determine beforehand to prepare things and make it efficient is the most important thing to have. This blog covers these things on how to manage a very large database and what are the things you have to know.

This blog post is the third part of a series about indexes in MySQL where we help you understand what indexes are, what they do and how they can be used in order to push your database performance to the max. The second part of the blog post series on MySQL indexes, covered indexes and storage engines and touched upon some PRIMARY KEY considerations. The discussion also included how to match a column prefix, some FULLTEXT index considerations, B-Tree indexes with wildcards and how to use ClusterControl to monitor your queries' performance, subsequently, indexes. 

This blog post is the second part of a series about indexes in MySQL where we help you understand what indexes are, what they do and how they can be used in order to push your database performance to the max.In the first part of the blog post series about MySQL indexes, we have covered quite many things, including what they are, what they do, what their types are, how to choose optimal data types, and MySQL character sets for indexes that you use. 

This blog post is a part of a series about indexes in MySQL where we help you understand what indexes are, what they do and how they can be used in order to push your database performance to the max.

Database scaling gives the database systems the ability to handle higher load. In this blog, we discussed the basic concepts related to the process of scaling databases, including its definition, the need for database scaling and the available scaling types.

Data Analytics is important in any company as you can see what happened in the past to be able to make smart decisions or even predict future actions using the existing data. In this blog, we will see what HeatWave is, and how it can help you on Data Analytics.

In this blog post, we are going to look into the new user management system introduced in ClusterControl 1.8.2, and to see how it is different from the previous ones. Just for clarification, the old user management system will still work side-by-side with the new user authentication and management system until Q1 2022. From now on, all new installations for ClusterControl 1.8.2 and later will be configured with the new user management system.

Automating the database schema object check or schema changes operations eases DBA's daily monitoring activity. This blog guides you through an exercise to automate the database schema object check using Puppet and ClusterControl.

Database automation is a necessity to avoid replicated time consuming tasks. This blog covers a short discussion on tools and how to automate MySQL database deployment using tools like ClusterControl.

Configuration check and tuning are an important part of the DBA and SysAdmin routine to ensure a critical system like database and reverse proxies are always relevant and optimal as your workloads grow. Our focus in this blog post is to automate the database configuration check and validation process.

Upgrades are always a hard and time-consuming task and testing your application before every upgrade is even worse. If you want to do all the necessary steps for doing this task manually, there is a big chance of human error and the process will be slow. In this blog, we will see how to automate testing for upgrading your MySQL, MariaDB, or Percona Server databases using ClusterControl.

Automated Testing of the upgrade process is often overlooked or even not existed in practice to some organizations or companies that are managing their PXC/MariaDB Galera Cluster. In this blog, we emphasize the importance of this and how it can be drastic and risky if the DBAs and your technical team just do their own thing without adhering to the industry standards and performing best practices while upgrading your PXC/MariaDB Galera Clusters.

The way Galera Cluster works is that it handles schema changes in a specific manner. It is possible to execute a schema change on a single node in the cluster, but it is tricky. This blog describes the aspects you should keep in mind while planning to automate release tests in a database environment