May 7, 2014 By Severalnines

Following the release of ClusterControl 1.2.6 a couple of weeks ago, we are now looking forward to demonstrating this latest version of the product on Tuesday next week, May 13th.

This release contains key new features (along with performance improvements and bug fixes), which we will be demonstrating live during the webinar. 

Highlights include:

• Centralized Authentication using LDAP or Active Directory
• Role-Based Access Control
• OpenStack: Galera Deployment Automation
• Hybrid setups with Galera and Asynchronous MySQL Replication
• Manage single instance …

April 24, 2014 By Severalnines

ClusterControl 1.2.6 introduces integration with Active Directory and LDAP authentication. This allows users to log into ClusterControl by using their corporate credentials instead of a separate password. LDAP groups can be mapped onto ClusterControl user groups to apply roles to the entire group, so it is very convenient for larger organizations who have a centralized LDAP-compliant authentication system. This blog shows you how to configure LDAP authentication in ClusterControl, and allow users to use their Active Directory or LDAP username and password to log in to ClusterControl. 

LDAP authentication can be configured from ClusterControl, in the Admin dashboard (ClusterControl > Admin > LDAP Settings). If you are running ClusterControl v1.2.5 or older, please …

April 10, 2014 By Severalnines

In the wake of recent concerns and debates raised around the Heartbleed bug, we wanted to update Severalnines ClusterControl users on any impact this bug might have on ClusterControl & associated databases and/or applications.

Background

If your ClusterControl's web application has been accessible on the internet, then most likely you have also been exposed to the Heartbleed OpenSSL security bug, see: http://heartbleed.com for more details. 

By default, our database deployment script enables SSL encryption for the Apache web server on the Controller host with a generated private SSL key and a self-signed certificate. SSL encryption is used between the UI and the Controller REST API if you have clusters added with HTTPS, which we do by default. The content that is …

March 28, 2014 By Severalnines

Percona Live MySQL Conference & Expo - March 31st to April 4th

The Severalnines Team Will Be Onsite at Booth 418 - Come Say Hello!

If you’re still thinking about whether or not you should be attending the Percona Live MySQL Conference & Expo that starts on Monday 31st of March, here are 9 reasons (we are Severalnines after all) on why we’ll be there. May these help you positively in your decision making ;-)

1. The 2014 edition showcases the most promising program yet

Sounds like a cliché-reason to be listed here, but this year’s program is in fact quite diversified …

March 27, 2014 By Severalnines

With datacenters being stretched by resource-intensive applications, more and more businesses are outgrowing their existing in-house capacity and having to reconfigure their IT operations. But how do you migrate a busy application to a totally new data center without downtime? How will the application scale in a virtualized cloud environment? And how do you guard against cloud server failures and keep a high level of uptime?

In this example, we will show you how to migrate a Web application (Wordpress) from a local data center to a AWS VPC. Without downtime even! 

Main steps:

• Setup the cloud servers (for web server + database)
• Install Galera Cluster and ClusterControl
• Setup MySQL replication between the single instance MySQL (local) to Galera Cluster (remote)
• Sync your application …

March 20, 2014 By Severalnines

SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

In this blog post, we will show you how to cluster SugarCRM Community Edition with MySQL Galera Cluster. For simplicity, we will use NFS as the shared storage system (storage1) but keep in mind that storage1 is a single point of failure. Have a look at our previous blogs on how to deploy other shared file systems like …

March 13, 2014 By Severalnines

Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

Special thanks to Seppo Jaakola, CEO at Codership, the creators of Galera Cluster, and to Johan Andersson, CTO at Severalnines, for their presentations and the live demo.

Webinar topics discussed: 

• Application use cases for Galera
• Schema design
• Events and Triggers
• Query design
• Migrating the schema
• Loading initial data into the cluster
• Limitations
• Performing Online Migration to Galera
• Operational management checklist
• Belts and suspenders: Plan B
• Demo

Watch the replay:

…

March 11, 2014 By Severalnines

For ops folks with multiple environments and instances to manage, a fully programmable infrastructure is the basis for automation. ClusterControl exposes all functionality through a REST API. The web UI also interacts with the REST API to retrieve monitoring data (cluster load, alarms, backup status, etc.) or to send management commands (add/remove nodes, run backups, upgrade a cluster, add/remove load balancer, etc.). The API is written in PHP and runs under Apache. The diagram below illustrates the architecture of ClusterControl.

Figure: ClusterControl - Agentless Architecture

In this blog post, we will show you how to interact directly with the ClusterControl API to retrieve monitoring data or to perform management tasks.

All requests against …

March 6, 2014 By Severalnines

Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters

Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!

ClusterControl 1.2.5 released

We are pleased to announce the release of ClusterControl 1.2.5, which now supports MySQL 5.6 and Global Transaction IDs to enable cross-datacenter and cloud replication over high latency networks. Galera users are now able to assign nodes to their respective datacenter. Other features include User Defined Alerts and agent-less monitoring.

…

March 3, 2014 By Severalnines

Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier with MySQL 5.6 and GTID. Although it was fairly straightforward to replicate from a standalone MySQL server to a Galera Cluster, doing it the other way round (Galera → standalone MySQL) was a bit more challenging. At least until MySQL 5.6 and GTID. 

There are a few good reasons to attach an asynchronous slave to a Galera Cluster. For one, long-running reporting/OLAP type queries on a Galera node might slow down an entire cluster, if the reporting load is so intensive that the node has to spend considerable effort coping with it. So reporting queries can be sent to a standalone server, effectively isolating Galera from the reporting load. In a belts and suspenders approach, an …