Database - General

The SELinux enforcing mode requires some configuration on the MongoDB installation in order to run properly at the same time the enhanced security is applied. In this blog post, we will go through the steps to configure SELinux for MongoDB replica sets.

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.

There are many questions regarding database performance, including its definition, measurement metrics and performance assessment and improvement. This blog attempts to answer the trivial questions on measuring database performance and how to improve it.

Ansible is a popular and trendy open-source agentless IT engine that can automate application deployment, configuration management and IT orchestration.This blog shows how to automate the deployment of PostgreSQL database by using Ansible as well as ClusterControl.

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.

In this blog post we will go through some of the things that you can do to automate security audits for MySQL.

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.

In this blog we discuss processes in database maintenance and infrastructure that can be automated to reduce the total cost of ownership. If you automate a process, it typically takes less time for your employees to accomplish, and reduces the chance of something going wrong while performing it.

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.

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.

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.

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.

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.

Benefits for organisations who have adopted a public cloud environment for databases include quick provisioning, data redundancy, traffic workload distribution, and also failover scenarios. In this blog, we review two different database server architectures when running in a hybrid cloud environment. Benefits for organisations who have adopted a public cloud environment for databases include quick provisioning, data redundancy, traffic workload distribution, and also failover scenarios. In this blog, we review two different database server architectures when running in a hybrid cloud environment.

Prior to MySQL 5.5, MyISAM was the default storage engine. In this blog post we will cover when, how, and why should you use MyISAM for MySQL.

This blog will guide you through the database options for Moodle and explain why MySQL or PostgreSQL is your best option for easy management, lower costs, and high availability.