The white paper shares lessons learned from a careful, component level analysis of China Mobile’s 1000-node OpenStack cloud. They uncovered three major issues in the course of this study, all addressed through OpenStack configuration changes. The result: a more stable and performant China Mobile OpenStack cloud and insights into scale bottlenecks and areas for future work.

Read the full story: Analyzing and Tuning China Mobile’s OpenStack Production Cloud white paper below

performance_analysis_and_tuning_in_china_mobiles_openstack_production_cloud_2

We will demonstrate the ease of monitoring Galera Cluster using Monyog MySQL monitor. By the end of the webinar, you will have a better understanding of how to use Monyog for monitoring Galera Cluster for MySQL to achieve a required balance of high availability and scalability.

Galera Cluster for MySQL is a multi-master active-active cluster. It is an easy-to-use, high-availability solution, which provides high system uptime, no data loss, and scalability for future growth. In this webinar, we will give an overview how does Galera Cluster work and what are the benefits of using Galera Cluster.

Join USA timezone webinar Wed, May 17, 10:00 AM – 11:00 AM PDT

Join EMEA timezone webinar Wed, May 17, 11:00 AM – 12:00 AM CET

This post is just following up my previous blog post which describes how to setup 3-nodes MariaDB Galera Cluster with MySQL-Sandbox on single server.

Today, I’ll try to explain how we can setup MariaDB MaxScale over the Galera Cluster. Before I move ahead, I would like to explain about MaxScale little bit.

MariaDB MaxScale is a database proxy that enables horizontal database scaling while maintaining a fast response to client applications. You can implement MaxScale on either MySQL Replication or Galera cluster. With MySQL Replication, you can either use Read/Write Splitting or Connection routing and same with Galera Cluster. You can get more information here about this product.

…

For the production environment, it’s recommended that we should use separate server for each Galera Cluster node but sometimes, for the testing purpose we have to setup it on one server with different ports. Here are the steps for how to do that with CentOS 6.8, MariaDB Galera Cluster 10.1.21 and MySQL Sandbox

• Download MariaDB 10.1.21 from this location

https://downloads.mariadb.org/mariadb/10.1.21/

• If you want to use sst method = xtrabackup then install it with yum repo    

…

Codership QA Engineer

The QA Engineer/release manager will be responsible for working with the development team at Codership and create and execute tests, make builds of Galera Cluster and develop and extend test automation frameworks.

You will be also working closely with MariaDB development and quality assurance teams to prioritize software bug fixes.

Tasks

• Continuously refine the QA process to improve product qualitY
• Troubleshoot and work with the development team to isolate issues
• Create and maintain automated tests
• Make Galera software builds (our build pipeline uses python, Jenkins, Docker and Qemu)
• Assist customers with their questions and support tickets

Desired Skills and Experience

• 3 years of experience in QA on Linux
• Proven record of implementing test …

Find Galera Cluster developers and experts in our booth.  We would be happy to hear your Galera Cluster story.

Galera presentations in MI17:

Deep Dive: Adding Replication and Scaling with Galera

Wednesday, April 12 1:10 pm – 2:00 pm.

Seppo  Jaakola, Codership CEO

Data inconsistency is the worst problem that can happen for a synchronous database cluster. At some point it will appear during replication processing, simply because the application of replication events is not possible in some cluster nodes due to missing rows, excessive rows or wrong values in the row columns. As a result, this usually stops the replication process ...READ MORE

Step-by-step: Clustering with Galera and Docker Swarm

Wednesday, April 12 2:10 pm – 3:00 pm

…

Description

In this part of the webinar series on best practices for Galera Cluster, we will discuss schema changes and DDL.

We will show how Galera Cluster executes DDLs in a safe, consistent manner across all the nodes in the cluster, and the differences with stand-alone MySQL. We will discuss how to prepare for and successfully carry out a schema upgrade and the considerations that need to be taken into account during the process.

The webinar will conclude with a Q&A session where you can ask any questions you may have about Galera Cluster.

Time: 9-10 AM PST (Pacific time zone), 21st of  February

Speakers: Philip Stoev, Quality and Release Manager, Codership                Sakari Keskitalo, COO, Codership

…

Last year Codership produced a lot of valuable content to help Galera users to get started with Galera and manage Galera. We have gathered  the resources to our website.

Taking Full Advantage of Galera Multi-Master replication video can be watched here.

We have now uploaded Slideshare with many new presentations. Check them out!

The best source of multi-master Galera Cluster help,  Galera Cluster documentation, is being updated constantly.

OK, let me start with saying that a table without a primary key shouldn't be something that a DBA should ever stumble into.  Sure, InnoDB will secretly add one for us without telling - but that's not something we can use at application or administration level, it's just to make the engine happy.

So let's suppose you find some tables that lack a primary key, of course you need to do something about it, right?  Now, put Galera Cluster in the mix - Galera does not support tables without a primary key and will, secretly again, make that table inconsistent at cluster level.

You need to fix the damn table(s)!! And this is where the fun begins...  as you can't afford downtime for the operation so you need to resort to an online schema change of some type.

Galera cluster is …

Helsinki, Finland & London, UK  – January 9th 2017 – Codership, whose Galera Cluster technology brings high availability (HA) and scalability to open source databases worldwide, has seen its technology break the one million download barrier. Codership’s customer roster has grown over 100 percent thanks to the adoption of OpenStack by enterprises and the recent strategic partnership with MariaDB.

Galera has been recognised as the most widely used OpenStack High Availability technology for the second year in a row. According to the OpenStack Survey 2016, one-third of users rely on Galera Clusters running on MariaDB and MySQL.

To cope with an increase of customer demand coming from various industries such as financial services, retail and telecoms, Codership has grown its engineering hires by 50 percent. The new team members will ensure Galera continues to deliver on its mission to …