Galera Cluster is the most used high availability solution for OpenStack components and datastore for the third year in the row according to recent OpenStack survey. Since last year the deployments of all Galera Cluster have increased 5 points. 39% of the OpenStack users report that they use Galera Cluster in production. The number includes MariaDB Galera Cluster, Galera Cluster for MySQL and Percona XtraDB Cluster. MariaDB Galera Cluster ranks now number one database solution before MariaDB, MySQL and MongoDB.
10 Older Entries »
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.
- 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 …
Now that Galera Cluster 5.7 GA has been released, let’s take a look at some features in MySQL 5.7 that improve Galera performance or allow new workloads and applications to be Galera-enabled.
Spatial indexes come to InnoDB and Galera
Previously, only MyISAM tables could have indexes on spatial columns. Starting with 5.7, it is now possible to use spatial indexes with InnoDB tables as well. This way applications in the areas of GIS, geo-location, mapping, etc. can take advantage of Galera replication for their spatial data.
CREATE TABLE geometry_table ( geometry_column GEOMETRY NOT NULL, SPATIAL INDEX(geometry_column) ) ENGINE=InnoDB;
It is also possible to migrate existing spatial data stored in MyISAM or replicated using traditional asynchronous replication to InnoDB and Galera.
If you have previously considered using another …[Read more]
Galera Cluster on FreeBSD
Galera Cluster for MySQL already runs on FreeBSD in large organizations that handle mission-critical and security-sensitive data. With Galera 3.20, we are now providing compilation fixes, ports scripts and binary packages for FreeBSD.
If you are a FreeBSD user, please give those scripts and packages a try! We welcome all feedback at info [&] galeracluster.com .
You can find Galera Cluster binary packages for FreeBSD in our package repository.
Using the Galera Cluster Ports
Until Galera Cluster is made part of the official ports
repository, it is possible to compile Galera and MySQL-wsrep
using the ports scripts that we
maintain in our dedicated repository on GitHub.
Codership is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.7.17 GA, 5.6.34, 5.5.54 and Galera 3.20, wsrep API version 25.
This is our GA release in the 5.7 series. Galera Cluster for MySQL 5.7 contains enhancements in multiple key areas, including security, performance and monitoring.
We will continue to provide Galera Cluster 5.5 and 5.6, allowing customers to take advantage of synchronous, multi-master replication without having to upgrade to the latest major MySQL version.
New features and notable fixes in the Galera replication library since last binary release by …[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.
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 …[Read more]
If a node leaves the cluster and subsequently rejoins, Galera will internally make sure that the node is brought up to speed with the rest of the cluster. It is important for DBAs that this process completes quickly, so ideally SST is avoided altogether and IST is used. However, when looking at the log, SST is still mentioned even if IST is ultimately chosen, which may cause confusion.
In this article, we will describe the entire process of getting a restarted node back to speed with the rest of the cluster and explain the logic behind the various log messages.
State transfers in Galera are governed by the following basic principles:
- The cluster will pick a donor node using an algorithm that favors IST and attempts to avoid any transfers over a wide-area network. A specific donor can be explicitly chosen using the wsrep_sst_donor variable.
- The joiner …
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
* 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
DATE AND TIME FOR …[Read more]
Galera 3.19 comes with improvements to better handle the situation where the entire cluster needs to be restarted. In previous blog post, we already discussed one such feature: Safe-to-Bootstrap.
In this post, we will discuss gcache recovery, which allows for the cluster to be restarted quickly after it was shut down, thus reducing the overall duration of planned or unplanned downtime.
The Gcache and Whole-Cluster Restarts
In previous versions of Galera, When a node starts up, its Gcache is wiped clean. This means that this node can not serve as an IST donor to other nodes that are also starting up at the same time. This is especially important when the entire cluster is being restarted. When the second node starts, it hopes to quickly rejoin the cluster via IST from the first node:
10 Older Entries »