9 blog posts in 13 categories
In this post, we will show you how to set up master-slave replication with Postgres.
This post is the first in the “Become a PostgreSQL DBA” blog series and will cover provisioning and deployment.
This is our second post in the “Become a MongoDB DBA” blog series. It covers configuration of MongoDB, especially around ReplicaSet, security, authorization, SSL and HTTP / REST api.
This post is the first in the “Become a MongoDB DBA” blog series and will cover provisioning and deployment.
Learn about how to manage, alter and template your database configurations in ClusterControl for MySQL, MongoDB & PostgreSQL.
You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a backup using xtrabackup. Or, if it is a Galera cluster, you have to recover a galera node using wsrep_sst_method=xtrabackup[-v2].
Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters. From time to time it is necessary to tune and update your configuration. Here we will show you how you can change/update individual parameters using the ClusterControl UI. Navigate to Manage > Configurations.
In this blog post, we’ll discuss some of the settings that are most often tweaked and which can bring you significant improvement in the performance. We will also cover some of the variables which are frequently modified even though they should not. Performance tuning is not easy, but you can go a surprisingly long way with a few basic guidelines.
Drupal’s modular setup allows for different datastores to be integrated as modules, this allows sites to store different types of Drupal data into MongoDB. You can choose to store Drupal’s cache, session, watchdog, block information, queue and field storage data in either a standalone MongoDB instance or in a MongoDB Replica Set in conjunction with MySQL as the default datastore. If you’re looking at clustering your entire Drupal setup, then see this blog on how to cluster MySQL and the file system.