Automate Your Database with CCBot: ClusterControl Hubot Integration
With our new ClusterControl 1.2.12 release we have added many new features like operational reports, enhanced backup options, SSL Encryption for Galera replication links and improved the support for external tools. One of these tools...
ClusterControl 1.2.12 – The Full Monty Release for MySQL, MariaDB, MongoDB & PostgreSQL
The Severalnines team is pleased to announce the release of ClusterControl 1.2.12. This release contains key new features, such as support for the latest versions of MySQL, MariaDB, MongoDB & PostgreSQL, operational reports and enhanced...
High Availability Read-Write Splitting with php-mysqlnd, MySQL Replication and HAProxy
MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application...
Integrating ClusterControl Alarms with Splunk
Splunk is a popular log management tool for our syslog facility. In this blog, we will show you how to integrate ClusterControl alarms with Splunk. We are going to forward the alarm event through the...
A Guide to the Syslog Plugin for ClusterControl
Logging is a fundamental tool for the system administrator. It helps identify whether systems are running as configured, and track any unusual activity when trying to diagnose and isolate problems. Without even basic logging, when...
ClusterControl Developer Studio: Creating Advisors Using the MySQL Performance Schema
In the previous blog post, we gave a brief introduction to ClusterControl Developer Studio and the ClusterControl Domain Specific Language that you can use to write your own scripts, advisors and alerts. We also showed...
Managing Your Database logfiles with ClusterControl
Earlier in the blog series, we touched upon deployment of clustering/replication (MySQL / Galera, MySQL Replication, MongoDB & PostgreSQL), management & monitoring of your existing databases and clusters, performance monitoring and health, how to make...
A Guide to Max Open Files for MySQL
Requires ClusterControl 1.2.11 or later. Applies to MySQL single instances, replications and Galera clusters. You have created a large database with thousands of tables (> 5000 in MySQL 5.6). Then you want to create a...
wtmp Log Rotation Settings for Sudo User in ClusterControl
Requires ClusterControl. Applies to all supported database clusters. Applies to all supported operating systems (RHEL/CentOS/Debian/Ubuntu). ClusterControl requires a super-privileged SSH user to provision database nodes. If you are running as non-root user, the corresponding user...
How to Deploy and Manage MaxScale Using ClusterControl
We were delighted to announce that ClusterControl now supports MaxScale, the intelligent database gateway from the MariaDB team. In this blog, we will show you how to deploy and manage MaxScale from ClusterControl. We previously...
ClusterControl 1.2.11 Released
The Severalnines team is pleased to announce the release of ClusterControl 1.2.11. This release contains key new features, such as support for MariaDB’s MaxScale, along with performance improvements and bug fixes. This is also our...
High Availability Galera Clusters for Indonesia’s leading eCommerce Payment Gateway
Indonesia, the fourth most populous country in the world, is emerging as an economic powerhouse in Asia Pacific. With 60% of a population of 250 million being under 30 years of age, growing internet penetration...