Severalnines Blog
The automation and management blog for open source databases

Severalnines blog

Filter by:
Clear
Apply (1) filters
471 blog posts in 13 categories

How to Upgrade ClusterControl

Every now and then, we come out with updates for ClusterControl, and we warmly recommend that you keep your software up-to-date. Let alone all the new features that help you better manage your database cluster, using the latest version ensures that you can avoid issues that have already been corrected.

Posted in:

How to Cluster Magento, nginx and MySQL on Multiple Servers for High Availability

Magento is an open-source e-commerce platform built on Zend PHP and MySQL. It is widely adopted by online retailers with some 150,000 sites known to use it. Single server setups are easy to set up, but if your store is a huge success, then you probably need to think about clustering your environment with multiple servers. Clustering is done at the web, database and file-system level, as all web nodes need access to catalog images. 

Posted in:

Scaling Wordpress and MySQL on Multiple Servers for Performance

Over the years, WordPress has evolved from a simple blogging platform to a CMS. Over seven million sites use it today, including the likes of CNN, Forbes, The New York Times and eBay. So, how do you scale Wordpress on multiple servers for high performance? 

Posted in:

Several Ways to Install ClusterControl

With ClusterControl gaining in popularity, we are seeing users coming in from different angles. Some users are deploying their database cluster using our Online Configurators, others are looking to install ClusterControl to manage an existing database cluster. And some other users prefer to install ClusterControl first, and then use it to deploy database clusters on-premises.

Posted in:

Turning MongoDB Replica Set to a Sharded Cluster

Replica Sets or Sharded Clusters?

** Diagrams updated on May 22nd. Thanks to Leif Walsh from Tokutek for his feedback.

Replica Sets are a great way to replicate MongoDB data across multiple servers and have the database automatically failover in case of server failure. Read workloads can be scaled by having clients directly connect to secondary instances. Note that master/slave MongoDB replication is not the same thing as a Replica Set, and does not have automatic failover. 

Posted in:

Using HAProxy with Your Database Cluster

Severalnines s9s_haproxy script allows you to install HAProxy and loadbalance over the MySQL servers in your cluster. To learn more about HAProxy and SQL load balancing, see this HAProxy Tutorial.

Posted in:

Scaling Drupal on Multiple Servers with Galera Cluster for MySQL

This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single points of failure. Components used are Apache, PHP, csync2, lsyncd, Keepalived, HAproxy,&MySQL Galera ClusterClusterControl.

Posted in:

Nagios Plugin for ClusterControl

Nagios is a very popular open source IT infrastructure monitoring tool, used by sysadmins to watch out for problems in their systems. If you use Nagios and would like to utilize it to monitor your database cluster, we have built a simple Nagios plugin for ClusterControl which can report on the status of your database cluster. The plugin is Nagios Plugin API v3.0 compatible.

Posted in:

ARCHIVE - Install ClusterControl on Top of Existing MongoDB Sharded Cluster

**Attention: The instructions in this blog post are outdated. Please refer to ClusterControl Quick Start Guide for updated instructions.

In this post, we are going to show you on how to install and integrate ClusterControl on top of an existing MongoDB Sharded Cluster with a replica set of 3 nodes

Posted in:

MongoDB Sharding - On-premises Deployment and Monitoring of MongoDB Sharded Clusters

Last year, we did a survey asking our users about any other databases they were using alongside MySQL. A clear majority were interested in using other databases alongside MySQL, these included (in order of popularity) MongoDB, PostgreSQL, Cassandra, Hadoop, Redis.

Posted in: