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

Displaying posts with tag: Blog (reset)

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...]
Galera as central building block for OpenStack high availability
+0 Vote Up -0Vote Down

By Erkan Yanar 02-11-2014

 

OpenStack is likely the most popular open-source cloud computing platform (for IaaS or PaaS). Running OpenStack for yourself or for customers you likely want to run it without losing data and be able to scale while business grows. In this blog we are going to give a short overview to the OpenStack architecture, focusing on the Database(MySQL/MariaDB) part. Then we are going to discuss why Galera is an essential building block to achieve HA of the database and provide scaling even for very big installations.

 

The quite basic setup consists of:

A …

  [Read more...]
Running a Galera Cluster for MySQL on Microsoft Azure
+0 Vote Up -0Vote Down

By Holger Kenn

 

A few weeks ago, I was looking into running a MySQL Galera Cluster for a customer with a large Linux IAAS deployment on Azure.

Why that? There’s ClearDB, a Microsoft Partner that offers MySQL on Azure as SaaS (Software as a service), so you can go to https://www.cleardb.com/store/azure and pick your size. Or, if you want to run it on your own, you can pick a Ubuntu Linux Gallery image and type “apt-get install mysql-server” and that’s it, right? Well, not so fast…

ClearDB is a great offering for most customers …

  [Read more...]
Slides from past conferences
+0 Vote Up -0Vote Down

Here are my slides from past conferences. They were generated from Org Mode and Beamer. You can read more about it here.

You can get more info on the talks on their respective pages(linked).

Talk at FOSDEM 2013:

Feed me more: MySQL Memory …

  [Read more...]
Top Two Signs your MySQL Database is Maxing Out
+0 Vote Up -0Vote Down

One of the main responsibilities of any database administrator is to keep a close eye on how database performance is impacting size and storage. Decisions will have to be made on whether or not to make changes within the database structure or application itself, or to make the changes on the storage and resource side [...] Read More

Showing entries 1 to 10 of 72 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.