Showing entries 1 to 10 of 40
10 Older Entries »
Displaying posts with tag: Galera cluster (reset)
Taking Full Advantage of Galera Multi-Master Webinar – Dec 13th

Description

 

This webinar will be the second in our series on best practices to follow when using Galera Cluster.

In this part, we will discuss important topics related to multi-master setups:
* Practical considerations when using Galera in a multi-master setup
* Evaluating the characteristics of your database workload
* Preparing your application for multi-master
* Detecting and dealing with transaction conflicts

This is a webinar presented by Codership, the developers and experts of Galera Cluster.

DATE AND TIME FOR USA:  Tuesday, 9-10 AM PST (Pacific ), 13th of December

REGISTER TO USA WEBINAR WITH THIS LINK 

 

DATE AND TIME FOR …

[Read more]
Codership is hiring Software Packaging Engineer!

Software Packaging EngineerJob Description & Main Responsibilities

 

Codership is looking for a part-time Build and Packaging Engineer. We use Jenkins to build various packages for multiple distros and the engineer will take ownership of the build pipeline and extend it to cover additional platforms and testing scenarios.

There are plenty of interesting problems to tackle on the job, from crafting .spec files with complex dependencies to automatically testing no-downtime rolling upgrades of a distributed system.

Main Responsibilities

  •  take the ownership of and maintain Galera Cluster packages on Linux (.RPM and .DEB) and BSD
  • maintain the automatic package building pipeline and extend it to cover additional platforms and testing scenarios

 

Desired Skills & Requirements

 

  • knowledge of …
[Read more]
DDL Failures in MariaDB Galera Cluster

A MariaDB support customer recently asked me what would happen if a Data Definition Language (DDL) statement failed to complete on one or more nodes in MariaDB Galera Cluster. In this blog post, I will demonstrate what would happen. The demonstration below was performed on a 2-node cluster running MariaDB 10.1, but other Galera Cluster distributions should work similarly. Schema ... Read More

7 Galera Cluster presentations in Percona Live Santa Clara 18-21.4. Meet us there!

Once again Galera Cluster is a popular topic at Percona Live 2016. There are 7 Galera Cluster presentations in Percona Live Santa Clara 18-21.4. Codership’s co-founder and Galera developer Seppo Jaakola talks about Schema Upgrades in Galera Cluster, 20 April 01:00 PM – 01:50 PM @ Ballroom A.  The number includes many Percona XtraDB Cluster presentations, which is based on Codership’s Galera Cluster.

 

Codership will also have a booth at the conference. Meet the developers and experts of Galera Cluster and visit our booth 507!

 

Tuesday 19 April

Orchestrating Percona XtraDB Cluster with Kubernetes (Raghavendra Prabhu)  3:50 PM – 04:40 PM @ Ballroom D

Percona XtraDB Cluster Reference Architecture 2016 (Jay …

[Read more]
Codership Galera Cluster Webinar USA – Migrating from Master-Slave MySQL Replication to Multi-Master Galera Cluster-April 12th

AGENDA:

In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.

Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.

DATE AND TIME:  Tue, Apr 12, 2016 10:00 AM – 11:00 AM PDT (Pacific time)

PRESENTERS: Philip Stoev, Sakari Keskitalo Codership

[Read more]
Codership Galera Cluster Webinar EMEA – Migrating from Master-Slave MySQL Replication to Multi-Master Galera Cluster-April 12th

AGENDA:

In this webinar, we will discuss the practical aspects of migrating a database setup based on traditional asynchronous replication to multi-master Galera Cluster. We will discuss the benefits Galera provides and how traditional replication settings, architecture and practices can be converted to Galera Cluster. We will show the steps that are needed to perform the migration with limited or no downtime, and will demonstrate the procedure in practice using a live database with an actual workload.

Galera Cluster is trusted by thousands of users. Galera Cluster powers Percona XtraDB Cluster and MariaDB Enterprise Cluster. This is a webinar presented by Codership, the developers and experts of Galera Cluster.

DATE AND TIME:  Tue, Apr 12, 2016 11:00 AM -12:00 PM EEST (Eastern Europe time)

PRESENTERS: Philip Stoev, Sakari Keskitalo Codership

[Read more]
Fixing inconsistency on MySQL Slave of Galera Cluster

This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync

Syncing Inconsistent MySQL Slaves

 

Checksum is a standard practice among DBAs to verify the data consistency across replicated nodes. In this post we’re going to review the syncing options for an inconsistent MySQL slave of Galera cluster node.

Here we’re assuming a setup of regular replication to a MySQL instance from one of the Galera cluster nodes.

In the usual MySQL replication setup, standard practice involves the usage of the pt-table-checksum tool to identify the discrepancies and usage of pt-table-sync to bring them in sync. The checksum tool, pt-table-checksum, can run across Galera cluster node to verify the data consistency and confirm if the MySQL slave is consistent with a chosen primary node.

What happens if this Galera cluster’s regular MySQL slave sees data inconsistency on it? Will pt-table-sync work there? The answer to this depends…
pt-table-sync when used with –sync-to-master …

[Read more]
Clarification on “Call me Maybe: MariaDB Galera Cluster”

Recently Aphyr (Kyle Kingsbury) published https://aphyr.com/posts/327-call-me-maybe-mariadb-galera-cluster

The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to conclusion may get the wrong impression and we’re left with more questions than ever.

So, let me state what is the real conclusion of this article:
“Galera cluster does not support SNAPSHOT ISOLATION LEVEL, in contract to what was stated in the documentation”.
Following that conclusion is using Galera cluster may result in “corrupted” data.

I do not quite like the usage of the word “corrupted” here. For me, the more correct word be to use is “inconsistent”.

So with this clarification, the …

[Read more]
Useful queries on MySQL information_schema

MySQL information_schema comes with useful information about the database instance, status, … etc. which is needed for daily DBA work.
There are some simple queries on the information_schema that I use on my daily basis in which I’m writing this post for my reference and maybe a good reference for someone else too …

Finding tables without Primary or Unique Keys:

PKs are so important, especially, for InnoDB tables as MySQL uses PKs as a clustered index and having no PKs might lead to severe performance problems.

Also having no PKs is one of the main causes of slave lagging problems mainly when using RBR (Row-Based Replication), e.g. if a delete statement on the master will delete 1 million rows on a table without PK, a full table scan will take place. This “might” not be a problem on the master but on the slave 1 million full table scan will take place – because changes to the individual rows are being …

[Read more]
Showing entries 1 to 10 of 40
10 Older Entries »