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 …
The latest from the MySQL community
Ideas, releases, practical guides, and perspectives from the people building with MySQL.
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 protect …
[Read more]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]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 …
Learn how to set up and use Percona's clustercheck script in a MySQL Galera Cluster.
The post Percona’s Clustercheck Script for MySQL Galera appeared first on Datavail.
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
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]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]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]This blog post explores the syncing options for an inconsistent MySQL slave of Galera cluster node using pt-table-sync
The post Fixing inconsistency on MySQL Slave of Galera Cluster first appeared on Change Is Inevitable.