Database - General

What are the pros and cons of running Microsoft SQL Server on Linux, as opposed to running it on Windows? This article looks more closely at how SQL Server 2019 edition compares when running on Linux vs Windows operating systems.

Can SQL Server run on Linux? The answer is yes! In this blog we will get an overview of SQL Server on Linux.

ClusterControl will soon support SQL Server 2019 on Ubuntu 20.4 and CentOS 8. Find out everything you need to know about the upcoming release in this post.

In this blog post, we will discuss one of the common errors in MySQL, the reason why it happens as well as some tips on troubleshooting this.

This blog is a comparison between Redis and DynamoDB and when shall you choose the other one and when it is applicable.

Are you a MariaDB DBA? This webinar replay is for you! If you have missed it, we have taken a look into the top five tips that you can use to improve MariaDB Galera Cluster performance for Nextcloud. Tune in!

In this blog post, we will compare Redis and Memcached from the administration and management point of view.

Two of the most popular NoSQL databases supported by ClusterControl are MongoDB and Redis. How they come into existence and gain attraction, popularity and changing the landscape of the database management system is the primary essence of this blog post.

In this blog post, we are going to walk you through the deployment of a cluster of two MariaDB shards using ClusterControl. We are going to deploy a handful of MariaDB servers (for redundancy and availability) to host a partitioned table based on a range of a selected shard key.

In this blog post, we will go through key-value stores, the advantages & disadvantages, some of the use cases as well as some of the examples or providers for key-value stores/databases.

Redis has been in existence for more than 12 years. It has been applied in a wide-array of applications and its use cases have been well tested for where  it is ample and sufficient to amplify the requirements of the applications. From web solutions, analytics, cloud solutions, corporate services, ad techs, IoTs, and enterprise services. This blog will cover where this database can be useful and where it is applicable and why you need to use it other than using existing mainstream databases such as the most common RDBMS or NoSQL ones.

In this blog post we go through an overview of different backup tools available when using Redis.

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.