ClusterControl runtime configuration options
When you install ClusterControl, it has a default configuration that maybe doesn’t fit your requirements so probably you will need to customize this installation. For this, you can modify the configuration files, but you can...
Redis How To: Installation, setup and configuration
Twitter, GitHub, Pinterest, Snapchat, Craigslist, StackOverflow and Flickr just to name a few are the companies that are adopting Redis either for their storage or as a cache to boost performance. Redis is an in-memory...
Automate Database Configuration Check
Many system administrators commonly overlook the importance of ongoing database configuration tuning. Configuration options are often being configured or tuned once, during the installation stage, and being left out until some unwanted events occur to...
Improving MySQL Performance with Advanced InnoDB Settings
We have discussed how to configure InnoDB for high performance a while ago, however, we have not yet discussed how we can improve MySQL performance while making use of advanced InnoDB settings. This blog post...
MySQL Workbench Alternatives – ClusterControl Configuration Management
MySQL configuration management consists of two major components - MySQL configuration files and runtime configuration. Applying configuration changes on the runtime environment can be done through MySQL server clients with no privilege for session variables...
PGTune Alternatives – ClusterControl PostgreSQL Configuration
If you are new to PostgreSQL the most common challenge you face is about how to tune up your database environment. When PostgreSQL is installed it automatically produces a basic postgresql.conf file. This configuration file...
An Overview of Job Scheduling Tools for PostgreSQL
Unlike other database management systems that have their own built-in scheduler (like Oracle, MSSQL or MySQL), PostgreSQL still doesn’t have this kind of feature. In order to provide scheduling functionality in PostgreSQL you will need...
An Introduction to MySQL Deployment Using an Ansible Role
Ansible automates and simplifies repetitive, complex, and tedious operations. It is an IT automation engine that automates cloud provisioning, configuration management, application deployment, intra-service orchestration, and many other IT needs. It requires no agents, using...
PostgreSQL Replication Setup & Maintenance Using Ansible
Replication is a key feature for most setups and it is supported by most database technologies on the market. The PostgreSQL community introduced replication in version 9.0 (called Streaming Replication or SR), since then the...
PostgreSQL Deployment and Maintenance with Ansible
Ansible is one of the most well-known and widely-used IT automation tools, it helps us in automating IT operational tasks such as... Bootstrapping the host (VM or bare-metal machine) from scratch Configuring hosts and services...
Setting Up an Optimal Environment for PostgreSQL
Welcome to PostgreSQL, a powerful open source database system that can host anything from a few megabytes of customer data for a small-town-business, to hundreds of terabytes of ‘big data’ for multinational corporations. Regardless of...
A Guide to PostgreSQL Server Configuration Parameters
PostgreSQL server configuration parameters play an important role in optimizing and enhancing database performance. Usually in any environment, default parameters are not enough, and this is where an understanding of important server parameters can contribute...