MariaDB Galera Cluster involves more effort and resource to administer than standalone MariaDB systems. If you would like to learn how to better manage your MariaDB cluster, then this webinar series is for you.
We will give you practical advice on how to introduce clusters into your MariaDB / MySQL environment, automate deployment and make it easier for operational staff to manage and monitor the cluster using ClusterControl.
English - Tuesday, September 30th @ 11am CEST: Management & Automation of MariaDB Galera Clusters
French - Tuesday, October 7th @ 10am CEST: Gestion et Automatisation de Clusters Galera pour MariaDB
German - Wednesday, October 8th @ 10am CEST: Verwaltung und Automatisierung von MariaDB Galera Cluster
High availability cluster configurations tend to be complex, but once they are designed, they tend to be duplicated many times with minimal variation. Automation can be applied to provisioning, upgrading, patching and scaling. DBAs and Sysadmins can then focus on more critical tasks, such as performance tuning, query design, data modeling or providing architectural advice to application developers. A well managed system can mitigate operational risk, that can result in significant savings and reduced downtime.
And if you’re in London this September, do join us at the MariaDB Roadshow event on Thursday, September 18th. We’ll be talking about Automation & Management of Database Clusters there as well and would love to talk to you in person!
There are several ways to get ClusterControl installed on your database infrastructure, as described in the ClusterControl Quick Start Guide. One simple way is to use an installation script, install-cc.sh. This script automates the whole process, and is executed on the host where you want to install ClusterControl. By default, it assumes the host has internet connectivity during the installation process.
For users who are not able to have their ClusterControl hosts connect to the Internet during the installation, we have some good news! The installer script now supports offline installations.
Prior to the offline install, make sure you meet the following requirements for the ClusterControl node:
We will now explain these steps in the following sections.
The installer script requires an offline repository so it can automate the installation process by installing dependencies.
1. Insert the DVD installation disc into the DVD drive.
2. Mount the DVD installation disc into the default media location at /media/CentOS:
$ mount /dev/cdrom /media/CentOS
We're looking for an energetic and talented web developer to join our small but agile web team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely.
Severalnines is a self-funded startup with a dozen employees; headquartered in Stockholm, Sweden and with a globally distributed, home-office based team. We provide automation and management software for database clusters. Our ClusterControl product is the leading management application for database clusters and is used by thousands of companies.
We were founded in 2010 and launched our product that same year, so you’ll be working on a popular, tried & tested product. There is opportunity to have an immediate impact though as we’re a small team and there is plenty of work to be done as we continue to enhance our product.
|As a follow-up to our previous webinar on MySQL Load Balancing and HAProxy, we are glad to organize a new webinar on Performance Tuning of HAProxy. Tuning your HAProxy instances can significantly increase the performance of your application and decrease response times. Joint us for this special session to find out more!|
Tuesday, September 9th @10am CEST (Europe & MEA / Asia Pacific)
Tuesday, September 9th @6pm CEST (North America / LATAM)
This webinar will cover the performance tuning basics for HAProxy and explain how to take advantage of some of the new features in 1.5, released in June 2014 after 4 years of development work. We’re delighted to be joined by a well known HAProxy expert, Baptiste Assmann.
Moodle is an open-source e-learning platform (aka Learning Management System) that is widely adopted by educational institutions to create and administer online courses. For larger student bodies and higher volumes of instruction, moodle must be robust enough to serve thousands of learners, administrators, content builders and instructors simultaneously. Availability and scalability are key requirements as moodle becomes a critical application for course providers. In this blog, we will show you how to deploy and cluster moodle/web, database and file-system components on multiple servers to achieve both high availability and scalability.
We are going to deploy moodle on top of GlusterFS clustered file system and MariaDB Galera Cluster 10. To eliminate any single point of failure, we will use three nodes to serve the application and database while the remaining two are used for load balancers and the ClusterControl management server. This is illustrated in the following figure:
All hosts are running on CentOS 6.5 64bit with SElinux and iptables disabled. The following is the host definition inside /etc/hosts:
192.168.197.100 moodle web db virtual-ip mysql 192.168.197.101 moodle1 web1 db1 192.168.197.102 moodle2 web2 db2 192.168.197.103 moodle3 web3 db3 192.168.197.111 lb1 192.168.197.112 lb2 clustercontrol
Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping or intercepting replication traffic. Encrypted replication hides what is sent between the Galera nodes, and makes sure each node is only communicating to the ones it trusts. But how expensive is encryption?
In this blog, we will show you how to encrypt the replication traffic between your Galera nodes. We will also look into the performance impact of this encryption.
Galera supports SSL for the encryption of replication traffic. When encryption is enabled, Galera group communication and Incremental State Transfer (IST) happens over an SSL-encrypted connection. The default SST methods do not support SSL, however this can be scripted.
All nodes in a Galera Cluster communicate via a group communication protocol (default port is 4567), whereby writesets are replicated from originating nodes to the rest of the nodes for certification and possibly commit. This communication protocol can be encrypted with an SSL certificate and a private key.
Note that this does not encrypt the communication between the MySQL client (the application) and the MySQL instances. Finally, at the time of writing, some extra steps are required when adding nodes automatically via ClusterControl.
Enabling encryption is now supported by the s9s tools available from our Github repository. This feature will be included in the next release of ClusterControl, scheduled by the end of August. The implementation flow is based on Codership’s Galera Cluster documentation.
The following requirements must be met if you would like to run encrypted Galera replication:
Well over a thousand sessions have been submitted for the OpenStack Summit and two of them includes our good selves! We’ve submitted two talks with partners of ours:
… and would love it if the talks were included in the final agenda. For that to happen, we need a few more of your votes today!
The OpenStack Summit is a five-day conference for developers, users, and administrators of OpenStack Cloud Software. It takes place in Paris this November.
You must be an OpenStack Foundation member to vote for the talks that have been submitted. If you aren’t a member, sign up here – it’s free and only takes a minute.
Speakers: Peter Boros (Percona), Vinay Joosery (Severalnines)
Speakers: Matt Griffin, Jay Pipes (Mirantis), Amrith Kumar (Tesora), Vinay Joosery (Severalnines)
MySQL plays a critical role in OpenStack. It serves as the host database supporting most components such as Nova, Glance, and Keystone and is the most mature guest database in Trove. And we provide the tools necessary to automate and manage your MySQL database clusters. Please vote for our talk to hear more about what we do!
Thank you for your support and we hope to see you at the Paris OpenStack Summit in November!
We just wanted to make it official: Severalnines ClusterControl now supports MariaDB 10!
As most of you know will know by now, MariaDB 10 is the newest and most advanced version of the popular MariaDB relational database system. Whilst remaining application-compatible with the MySQL database, it adds many new capabilities to address the most challenging web and enterprise application use cases. Cluster deployments would be based on MariaDB Galera Cluster 10, which is a complete merge of MariaDB 10.0.12 and Galera Cluster.
ClusterControl gives you the power to deploy, manage, monitor and scale entire MariaDB Galera clusters efficiently and reliably. ClusterControl acts as a virtual DBA assistant and frees system administrators and developers from the complexity and learning curves associated with database clusters.
We had the opportunity to showcase ClusterControl for MariaDB 10 recently during the European MariaDB Roadshow, which took us to Helsinki, Amsterdam, Paris, Hamburg, Berlin and Frankfurt. We were delighted of course to be invited by SkySQL as guest speakers and to have the opportunity to talk to existing and future MariaDB users.
There is one more date scheduled at the moment for this roadshow - London in September.
If you’ve missed the European Roadshow and/or would like a more in-depth presentation and demo of ClusterControl, please do register for our joint webinar with SkySQL on 30th September 2014.
ClusterControl uses the Apache HTTP Server to serve its web interface, but it is also possible to use nginx. nginx + PHP fastcgi is well-known for its capabilities to run on a small memory footprint compared to standard Apache + PHP DSO.
In this post, we will show you how to run ClusterControl on nginx web server by swapping out the default Apache web server installed during the initial deployment. This blog post does not mean that we officially support nginx, it just an alternative way that a portion of our users have been interested in. For instance, Phil Bayfield wrote a blog on the same topic a while back.
Before we jump into nginx configurations, let’s look at how the ClusterControl web application is configured with Apache web server. ClusterControl consists of two web components, a web UI and CMONAPI. These components are located in the Apache’s document root which might vary depending on the operating system.
1. Make sure ClusterControl UI and CMONAPI exist in the document root. Document root for RedHat/CentOS and Ubuntu 14.04 LTS (Apache 2.4) is located at /var/www/html while Debian and Ubuntu 12.04 and lower is located at /var/www. ClusterControl will be installed under this root directory and you should see something like this:
$ ls -l /var/www/html drwxr-xr-x. 6 apache apache 4096 Jul 9 16:31 cc-cmonapi-1.2.6 drwxr-xr-x. 5 apache apache 4096 Jul 9 16:31 cc-ui-1.2.6 lrwxrwxrwx. 1 root root 26 Jul 9 16:31 clustercontrol -> /var/www/html//cc-ui-1.2.6 drwxr-xr-x. 4 apache apache 4096 Jul 8 18:34 cmon lrwxrwxrwx. 1 root root 31 Jul 9 16:31 cmonapi -> /var/www/html//cc-cmonapi-1.2.6
2. Apache must be able to read custom configuration file (.htaccess) under the document root directory, by setting AllowOverride options to All. Example in /etc/httpd/conf/httpd.conf:
<Directory "/var/www/html"> Options Indexes FollowSymLinks AllowOverride All Order allow,deny Allow from all </Directory>
3. Require the following PHP modules to be installed and enabled:
The standard Apache installation via package manager will install PHP to run as dynamic shared object (DSO). Running on this mode will require you to restart Apache in case of php configuration changes.
We continuously see great interest in MySQL load balancing and HAProxy, so we thought it was about time we organised a live webinar on the topic!
As most of your will know, database clusters and load balancing go hand in hand.
Once your data is distributed and replicated across multiple database nodes, a load balancing mechanism helps distribute database requests, and gives applications a single database endpoint to connect to.
Instance failures or maintenance operations like node additions/removals, reconfigurations or version upgrades can be masked behind a load balancer. This provides an efficient way of isolating changes in the database layer from the rest of the infrastructure.
Wednesday, July 9th 2014
In this webinar, we will cover the concepts around the popular open-source HAProxy load balancer, and show you how to use it with your SQL-based database clusters. We will also discuss HA strategies for HAProxy with Keepalived and Virtual IP.