Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 76 10 Older Entries

Displaying posts with tag: Blog (reset)

Announcing Galera Cluster 5.5.42 and 5.6.25 with Galera 3.12
+0 Vote Up -0Vote Down

Codership is pleased to announce the release of Galera Cluster 5.5.42 and 5.6.25 with Galera Replication library 3.12, implementing wsrep API version 25.

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com, while previous releases remain available on LaunchPad. The …

  [Read more...]
Can’t Be Any Faster Than That: A Real-Life Experiment with Latency in a Geo-distributed Environment
+1 Vote Up -0Vote Down

Introduction

A question frequently asked is how much latency does Galera have in geo-distributed environments. After all, snail mail can also be used for database replication, but the latency will not be acceptable.

Let’s see how Galera performs.

A Two-Datacenter Setup

We start by creating a two-node cluster using a pair of Amazon EC2 regions that are as far apart Internet-wise as it gets – Sydney and São Paulo. The underwater cable maps do not show a direct link between Australia and South …

  [Read more...]
Geo-Distributed Database Clusters with Galera
+0 Vote Up -0Vote Down

Introduction

With Galera you can construct database clusters where each node is located in a different physical or even geographical location. In this blog post we will show some of the benefits from having such a geo-distributed cluster and the specific Galera features that enable practical replication across WAN links.

Benefits From Geo-Distribution

Geo-distribution allows database to break out from the single data center, which opens a whole new approach to redundancy and performance.

Increased Redundancy

Having database nodes in various geographic locations increases redundancy considerably, so that …

  [Read more...]
Node Can Not Join the Cluster? How to Debug Issues with SST.
+0 Vote Up -0Vote Down

Galera Cluster has the ability to add new nodes to the cluster by handling internally the transfer of the entire dataset to the new node. The same procedure, called State Snapshot Transfer (SST), applies to nodes that are rejoining the cluster after being down for a longer period of time.

A lot of operations happen during SST and there are various things that could go wrong. This article describes how to configure our server optimally for SST and how to debug any issues that arise.

The Basics

Let’s first consider all the items that play a role in the preparation and configuration of SST.

Selecting …

  [Read more...]
Debugging Transaction Conflicts in Galera Cluster
+0 Vote Up -0Vote Down

If you are using Galera Cluster in multi-master mode, you will most likely run into transaction conflicts if two clients attempt to modify the same row at the same time. Such conflicts are reported a deadlock errors to the application.

Legacy applications are frequently unable to handle transaction conflicts properly and may not provide sufficient information to debug the source of the problem.

If the wsrep_log_conflicts option is set, Galera can output all the information about transaction conflicts that is available to it to the error log. As it is a dynamic option, you can enable it while the server is running, collect some …

  [Read more...]
Codership Webinar – Galera Cluster The Backbone of Highly Available OpenStack Database Storage – June 23rd 2015
+0 Vote Up -0Vote Down

Relational databases are ubiquitous in OpenStack: practically every OpenStack service stores its critical metadata in a database, and the MySQL family of databases is the de-facto standard for OpenStack relational data storage. The need for high availability for these relational datastores is obvious. Galera is the default multi-master strongly-consistent replication facility for highly-available relational data in OpenStack. In this webinar, we are joined by independent OpenStack expert Florian Haas to illustrate the ins and outs of Galera for OpenStack.

 

Speaker …

  [Read more...]
Fast Galera Cluster Deployments in the Cloud Using Juju
+0 Vote Up -0Vote Down

Introduction

The Galera Cluster Juju Charm was recently released, and it is now possible to start scalable Galera Clusters using the Juju deployment framework on the public or private cloud (OpenStack, Amazon, Azure and bare metal are all supported). All the logic required to fire up Galera is encapsulated in the Charm, which is a small package of scripts and configuration files that is automatically downloaded and added to your environment.

Installing and Configuring Juju

The Juju client is available for Ubuntu, OSX and Windows. Installing it is a matter of adding its dedicated package repository:

  [Read more...]
Getting started Galera with Docker, part 1
+0 Vote Up -0Vote Down

by Erkan Yanar

Docker is an open platform for developers and sysadmins to build, ship, and run distributed applications. Consisting of Docker Engine, a portable, lightweight runtime and packaging tool, and Docker Hub, a cloud service for sharing applications and automating workflows, Docker enables apps to be quickly assembled from components and eliminates the friction between development, QA, and production environments. As a result, IT can ship faster and run the same app, unchanged, on laptops, data center VMs, and any cloud.

This is the first of a series of blog posts about using Galera with Docker. In this post, we are going to …

  [Read more...]
Latest Galera Cluster version supports also now MySQL 5.5. New Galera Replication Library 3.10 !
+0 Vote Up -0Vote Down

Coderhsip is pleased to announce that latest release of Galera Cluster for MySQL now supports MySQL 5.5

 

Downloads both MySQL 5.5 and 5.6 can be found from galeracluser.com/downloads.  We are also releasing Galera now 3.10, wsrep API version 25.

This and future releases will be available from Galera Cluster Downloads, while previous releases remain available on LaunchPad. The source repositories  and …

  [Read more...]
New Galera Cluster version is now released! It includes patched MySQL server 5.6.21 and Galera replication provider 3.9
+0 Vote Up -0Vote Down

Coderhsip is pleased to announce a new release of Galera Cluster for MySQL consisting of MySQL-wsrep 5.6.21 and Galera 3.9, wsrep API version 25.

 

This release incorporates all changes up to MySQL 5.6.21 and numerous fixes  and enhancements specific to Galera replication.

 

Galera Cluster is now available as targeted packages and package repositories for a number of Linux distributions, including Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download …

  [Read more...]
Showing entries 1 to 10 of 76 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.