MySQL

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.

Data breach and data theft is always a major concern, especially in a database world. With a lack of understanding and implementation of your data security, the chances of being hacked or theft is very high. You do not want your customer's passwords and accounts to be stolen, and losing your customers' trust is a big concern and risk to your company and whole organizations. This blog discusses the limits of database access privileges and what you avoid to escape from these dangers amongst hackers and intruders.

MySQL 5.6 has reached its EOL in February 2021. This blog announces ClusterControl no longer offers the option for deploying or importing MySQL 5.6 but will continue to support existing MySQL5.6 users on ClusterControl for bugfixes.

Performance commonly has lower priority in a hybrid cloud, since the focus of having hybrid cloud infrastructure is commonly towards disaster recovery, availability and scalability. In this blog post, we are going to cover some general tips to drive the performance of our applications, workloads and clusters running on a hybrid cloud setup.

In distributed hybrid cloud environments, where database instances and applications are in different datacenters, encryption of in-transit data allows us to protect against network eavesdropping. In this blog, we will explain how to encrypt hybrid cloud mysql database traffic.

Hybrid Cloud vs Full Public Cloud dares how organizations and companies have to decide and design the infrastructure to achieve high availability, scalability but with tightened security. In this blog, we showcase how both differ and how you are going to utilize them whenever you engage with these infrastructure solutions for your business requirements.

A hybrid cloud database is a mix of active database hosts residing on both on-premises and cloud infrastructures in a single operational system. In this blog, we’ll use ClusterControl to deploy a hybrid cloud MySQL database.

Hybrid environments database setups are not uncommon and are usually used for reasons like scalability, flexibility, high availability, disaster recovery. The blog describes how the MySQL replication can be used in mixed, on-prem and cloud environments.

This blog guides you on the things you have to keep in mind when deploying your Percona Server to a Hybrid Cloud. There's no differentiation with deploying on the regular ones, but there are drivers that you have to consider when deploying on a Hybrid Cloud.

Data is an essential part of a running Chamilo LMS platform, and backups are one of the most important things to take care of. In this blog we are going to look into how to backup your Chamilo data using ClusterControl.

With the increased usage of LMS systems, IT teams are struggling with the increased demand on their Moodle database. In this blog we will show you how to scale the Moodle MySQL database to increase performance.

Chamilo is a platform that allows educational institutions to transfer their educational activities to the internet. In this blog we will show you how to use ClusterControl to deploy a highly available MySQL database for the Chamilo LMS platform.

The Moodle MySQL database requires high-availability, especially when it's accessed by a large number of users. If your primary or master database crashes, an automatic failover must take over but managing your automatic failover requires careful planning and checks before finalizing the triggers for failover. This blog covers the solutions you can use to manage your database failover for MySQL and how to use them.

This blog post covers how to perform a benchmark of your Moodle site, allowing us to understand how our Moodle site performs in a given period of time. In a clustered setup, the performance of a Moodle cluster can be influenced by various factors like hardware resources, virtualization overhead, network latencies between servers, firewalls, caching and many more, and performing benchmarks is a solid way to test and estimate the Moodle performance before it goes live in production.

High availability Moodle requires a highly available database, and automatic failover plays a central role in minimizing the time to recover from a database failure. In this blog post, we will discuss how you can implement automatic failover for MySQL.

Data is an essential part of running a Moodle platform, and backups are one of the most important things to take care of while managing its databases. In this blog we are going to look into how to backup your Moodle data using ClusterControl.