Join Percona’s MySQL Practice Manager Kenny Gryp and QA Engineer, Ramesh Sivaraman as they present a high availability webinar around Percona XtraDB Cluster, Galera Cluster, MySQL Group Replication on Wednesday, June 21, 2017 at 10:00 am PDT / 1:00 pm EDT (UTC-7).
What are the implementation differences between Percona XtraDB Cluster 5.7, Galera Cluster 5.7 and MySQL Group Replication?
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
…[Read more]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.
…
[Read more]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
https://downloads.mariadb.org/mariadb/10.1.21/
…
[Read more]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
Desired Skills and Experience
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
…
[Read more]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
…
[Read more]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 …
