June 17, 2014 By Severalnines

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 …

May 19, 2014 By Severalnines

Thanks to everyone who attended and participated last week’s joint webinar on ClusterControl 1.2.6! We had great questions from participants (thank you), most of which are transcribed below with our answers to them.

If you missed the sessions or would like to watch the webinar again & browse through the slides, they are now available online.

Webinar topics discussed: 

• Database Infrastructure Lifecycle
• Deploy, Monitor, Manage, Scale
• MySQL, MariaDB & MongoDB Clusters
• ClusterControl Overview & Demo
• ClusterControl New Features in 1.2.6 & Demo
• Centralized Authentication using LDAP or Active Directory
…

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 …

One of our customers had a question related to the right value of Galera Cache size (gcache.size) in Galera Cluster for MySQL which I would like to share with you.

The question was: My maintenance window takes 4 hours for my 5TB DB. How can I avoid an SST ?!

Basically, having too small GCache size will lead to SST (Snapshot State Transfer) instead of IST (Incremental State Transfer), thus we can avoid the SST by setting the GCache to the appropriate value.

To check the current value of the GCache size:

mysql> SHOW GLOBAL VARIABLES LIKE 'wsrep_provider_options'\G
Variable_name: wsrep_provider_options
        Value: base_host = 192.168.1.12;
.
.
.
gcache.page_size = 128M; gcache.size = 128M; gcs.fc_debug = 0;
.
.
.

The value of GCache size could be changed by adding …

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 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:

…

February 13, 2014 By Severalnines

Galera is slowly but surely establishing itself as a credible replacement for traditional MySQL master-slave architectures. 

The benefits are clear - a true multi-master InnoDB setup with built-in fail-over, potentially across data centers. 

But how do you migrate? Does the schema or application change? What are the limitations? Can migration be done online, without service interruption? What are the potential risks, and how to address those?

Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster

Tuesday, March 11th 2014

Register now - Europe/MEA/APAC

Register now - North …

January 23, 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 and browse through the slides, they are now available online.

Special thanks to Seppo Jaakola from Codership, the creators of Galera Cluster, for walking us through the various scenarios of Galera recovery. 

Webinar topics discussed: 

• Redundancy models for Galera, NDB and MongoDB / TokuMX
• Failover & Recovery (Automatic vs Manual)
• Zooming into Galera recovery procedures
• Split brains in multi-datacenter setups

Watch the replay:

…

December 5, 2013 By Severalnines

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

Thanks again to our speaker, Seppo Jaakola from Codership, the creators of Galera Cluster, for this in-depth talk on Galera Cluster Best Practices - Zero Downtime Schema Changes.

Webinar topics covered

• How to perform Zero Downtime Schema Changes
• 2 main methods: TOI and RSU
• Total Order Isolation: predictability and consistency
• Rolling Schema Upgrades
• pt-online-schema-change
…