Showing entries 1 to 10 of 38
10 Older Entries »
Displaying posts with tag: Galera cluster (reset)
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]
MMUG13: Practical MySQL Optimisation y Galera Cluster presentations

English: Madrid MySQL Users Group will be holding their next meeting on 17th June at 18:00h at EIE Spain in Madrid. Dimitri Vanoverbeke and Stéphane Combaudon from Percona will be offering two presentations for us: Practical MySQL optimisations Galera Cluster – introduction and where it fits in the MySQL eco-system I think this is an excellent moment … Continue reading MMUG13: Practical MySQL Optimisation y Galera Cluster presentations

Severalnines News & Tools: New DevOps Guide Webinar, Load Balancing for MySQL Replay and More..

February 4, 2015 By Severalnines Check Out Our Latest Technical Resources for MySQL, MariaDB & MongoDB Clusters

 

Like every month, we have created new content and tools for you; here is a summary of what we’ve published. Please do check it out and let us know if you have any comments or feedback.

 

New Live Technical Webinars

 

A DevOps Guide to Database Infrastructure Automation for eCommerce

Tuesday, February 17th

 

Infrastructure automation isn’t easy, but it’s not rocket science either, says Riaan Nolan. Automation is a worthwhile investment for retailers serious about eCommerce, but deciding on which …

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