MySQL

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

Backing up your databases is an absolutely essential part of running MySQL in production. In this blog post, we will discuss your options when it comes to securing your MySQL backups.

Each MySQL storage engine supports different levels of granularity for their locks .This blog describes what lock granularity is and when it can be useful for you to use as a MySQL DBA.

This blog provides a brief guide on how to start with database automation. It will walk you through the main points and essentials of database automation, such as what can be and what should not be automated, and discusses some useful automation tools.

This blog will act as a guide to database automation. We will explain what it is, and what it can do for you or your business. We will also explain how you can use Severalnines’ flagship product - ClusterControl - to get the best in database automation.

Role-Based Access Control (RBAC) in ClusterControl allows super administrators to provide fine-grained restrictive access based on a role.  This blog guides you in using RBAC, teaching you the differences among available roles and how to use roles and their privileges to achieve a desired level of security.

MariaDB included Audit Plugin from versions 10.0.10 and 5.5.37, and it can be installed in any version from MariaDB 5.5.20. In this blog post, we will show you some best-practice tunings and tips on how to configure audit logging for a MariaDB server. The writing is based on MariaDB 10.5.9, with the latest version of MariaDB Audit Plugin 1.4.4.

In this blog post we describe how to make use of data access privileges and MySQL’s new roles for added MySQL security. Each step is clearly detailed and sample code is provided. It provides best practice advice, such as following the principle of least privilege.

Role-based access controls (RBAC) restrict database resources based on a set of pre-defined groups of privileges. This blog post covers some tips and tricks on using the database role to manage user privileges and as an advanced access control mechanism for MariaDB.

Managing database security is important to protect your valuable data in the database. However, designing a secure infrastructure design can be a daunting task if you are not sure of what to be configured to secure your databases. This blog discusses the best practices to architect a secure environment for MySQL.

Running a Galera Cluster in a hybrid cloud should consist of at least two different geographical sites, connecting hosts in the on-premises or private cloud with the ones in the public cloud. Whether you use unbreakable private cloud or public cloud platforms, Disaster Recovery (DR) is indeed a key component in the business continuity when disaster strikes. In this blog post, we will look into different ways of designing your Galera Clusters for fault tolerance in a hybrid cloud environment.

Database encryption is vital to protect your company and, most importantly, customer data, but you don't need data encryption for all data. It is important to understand the core purpose of data encryption. This blog discusses database encryption focusing on data encryption for better security.

This blog post covers the fundamental aspects of auditing our open-source database systems, especially MySQL, MariaDB, PostgreSQL and MongoDB. This article is targeted towards DevOps engineers who commonly have less experience or exposure in audit compliance best-practice and good data governance when managing the infrastructure primarily for the database systems.

Security is the most important thing to consider protecting the data, to properly secure an open source database requires significant effort and often to implement some security layer. In this blog we explained security in open source databases.