Showing entries 1 to 10 of 109
10 Older Entries »
Displaying posts with tag: Blog (reset)
Announcing Galera Cluster 5.7.18, 5.6.36 and 5.5.55 with Galera 3.21. Improvements to IPv6 Support, Bug Fixes and Changes to Repositories Structure

Codership is pleased to announce a new release of Galera Cluster for MySQL
consisting of MySQL-wsrep 5.7.18, 5.6.36, 5.5.55 and Galera 3.21, wsrep API
version 25.

Changes to Repositories Structure

With the new release the repository structure is changed to allow for
existence of all of the wsrep-patched mysql versions currently supported:
5.5 through 5.7.

Thus the repository layout requires from the user to adjust his or her
repository configuration to accomodate those changes. In order to have the
MySQL-wsrep and Galera library installed, one would need to add the following
repositories:

1. Galera-3 repository for galera library:
e.g. http://releases.galeracluster.com/galera-3/DIST/

Here DIST is Linux distribution (ubuntu, centos, …).

The latest version of Galera for FreeBSD is available in FreeBSD Ports

[Read more]
China Mobile & Intel Deploy Galera for 1000-Node OpenStack Cloud

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

39% of OpenStack users run Galera Cluster in production for OpenStack components according to recent survey

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.

READ THE FULL REPORT (page 47)

Codership is hiring! We are looking for Quality Assurance Engineer

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

  • 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 …
[Read more]
New MySQL 5.7 Features for your Galera Cluster: Spatial Indexes, JSON Support and more

Introduction

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.

JSON support

If you have previously considered using another …

[Read more]
Galera Cluster Packages and Support for FreeBSD are Now Available From Codership

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 .

Binary Packages

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.

Preparation

[Read more]
Announcing Galera Cluster 5.7.17 GA, 5.6.35 and 5.5.54 with Galera 3.20

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.

This and future releases will be available from http://www.galeracluster.com.
The source repositories and bug tracking are located at http://www.github.com/codership.

New features and notable fixes in the Galera replication library since last binary release by …

[Read more]
Taking Full Advantage of Galera Multi-Master Replication-Galera Cluster Resources Updated

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.

In 2016 Galera Cluster surged past one million downloads – setting up for a great year in 2017

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]
To SST or Not To SST?

Introduction

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.

Basic Principles

State transfers in Galera are governed by the following basic principles:

  1. 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.
  2. The joiner …
[Read more]
Showing entries 1 to 10 of 109
10 Older Entries »