Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 30 of 116 Next 30 Older Entries

Displaying posts with tag: galera (reset)

My talks about MySQL, Galera and LXC (and friends) [UPDATE]
+0 Vote Up -0Vote Down

Im giving some talks this year:

MySQL Hochverfügbar mit Galera

Location: FrOSCon

About: Learn about Galera and deploy it using LXC and Ansible

LBaaS-Loadbalancer as a Service

Place: GUUG Frühjahrsgespräche

Topic: It is a workshop ( together with Jan Walzer and Jörg Jungermann). We are going to show how to use LXC to provide slim loadbalancers.

Medley der Containertechniken

Place: GUUG Frühjahrsgespräche

Topic: Learn about all the basic techniques vanilla based Container technology uses/shares (Namespaces, Cgroups und Chroot). Have a look at some of them (LXC, Libvrit, systemd-nspawn and Docker)

MySQL Replikation: Von den Anfängen in die Zukunft

Place: DOAG 2014

Topic: Learn about the past and the future of MySQL

  [Read more...]
Munin graphing of MySQL
+0 Vote Up -0Vote Down

While there are many graphing tools out there and we’ve used Munin for a while now.

The MySQL plugin for Munin had fallen out of date and the show engine innodb status output changed in 5.5 making some bits of the plugin simply not work any more. Also the show global status has some extra variables so there was a need to create new graphs.

All of these are now in the 2.1.8+ development releases of Munin.

Here are samples of the new/updated graphs.

Tables

  [Read more...]
ClusterControl Module for Puppet
+0 Vote Up -0Vote Down
July 7, 2014 By Severalnines

If you are automating your infrastructure using Puppet, then this blog is for you. We are glad to announce the availability of a Puppet module for ClusterControl. For those using Chef, we already published Chef cookbooks for Galera Cluster and ClusterControl some time back.  

 

 

ClusterControl on Puppet Forge

 

The ClusterControl module initial release is available on Puppet Forge, installing the

  [Read more...]
2xHipster (Docker and Galera) doesn't mean its good.
+0 Vote Up -0Vote Down

Ahoi,

There had been already a couple of blogposts about Docker and Galera in the MySQL community. I've got to confess I love both. But on the other hand I don't think this is a good combination at all. Having a look at the blogpost doing galera with docker Im still not confessed. Im going to tell some points why I think so.

I assume Galera is already well know in the MySQL community :)

Docker is not just another technique to virtualize

Docker is more than just being another way to virtualize. And this may be one of the biggest points I miss with the other blogposts.

What is the purpose of Docker?

With Docker you build applicationcontainers. So you have a container just running one application. The overhead of containers compared to hypervisor technologies like KVM, VMWare etc. is



  [Read more...]
How to Deploy Percona XtraDB Cluster without Internet Connection
+0 Vote Up -0Vote Down
May 23, 2014 By Severalnines

If you need to deploy a database cluster behind your corporate firewall, on servers with no internet access, then this blog is for you. Most of the installation tutorials out there require servers to have an internet connection, and that would not work very well with companies under strict policies and compliance guidelines. 


Our online Galera Configurator supports deployment without Internet connection for Percona XtraDB Cluster. You would need to prepare a minimum of four hosts (three DB nodes and one management node), generate a Deployment

  [Read more...]
Archival and Analytics - Importing MySQL data into Hadoop Cluster using Sqoop
+1 Vote Up -0Vote Down
May 16, 2014 By Severalnines

We won’t bore you with buzzwords like volume, velocity and variety. This post is for MySQL users who want to get their hands dirty with Hadoop, so roll up your sleeves and prepare for work. Why would you ever want to move MySQL data into Hadoop? One good reason is archival and analytics. You might not want to delete old data, but rather move it into Hadoop and make it available for further analysis at a later stage. 

 

In this post, we are going to deploy a Hadoop Cluster and export data in bulk from a Galera Cluster using Apache Sqoop. Sqoop is a well-proven approach for bulk data loading from a relational

  [Read more...]
Doing a rolling upgrade of Percona XtraDB Cluster from 5.5 to 5.6
+0 Vote Up -0Vote Down

Overview

Percona XtraDB Cluster 5.6 has been GA for several months now and people are thinking more and more about moving from 5.5 to 5.6. Most people don’t want to upgrade all at once, but would prefer a rolling upgrade to avoid downtime and ensure 5.6 is behaving in a stable fashion before putting all of production on it. The official guide to a rolling upgrade can be found in the PXC 5.6 manual. This blog post will attempt to summarize the basic process.

However, there are a few caveats to trying to do a rolling 5.6 upgrade from 5.5:

  • If you mix Galera 2 and Galera 3 nodes, you must set
  •   [Read more...]
    Slides from PLMCE 2014 breakout session
    +0 Vote Up -0Vote Down

    As many of you already know, PLMCE is an annual MySQL
    community conference and Expo organized by Percona in the month of April
    (usually). It is a great conference, not only to meet new and eminent people in
    MySQL and related database fields, but also to attend interesting talks, and
    also to give some.

    This year I spoke about synchronous replication at a higher level. The talk was
    titled “ACIDic Clusters: Review of current relational databases with synchronous replication”. Having previously given talks with boring titles (but





      [Read more...]
    innodb_flush_logs_on_trx_commit and Galera Cluster
    +0 Vote Up -0Vote Down

    We deploy Galera Cluster (in MariaDB) for some clients, and innodb_flush_logs_on_trx_commit is one of the settings we’ve been playing with. The options according to the manual:

    • =0 don’t write or flush at commit, write and flush once per second
    • =1 write and flush at trx commit
    • =2 write log, but only flush once per second

    The flush (fsync) refers to the mechanism the filesystem uses to try and guarantee that written data is actually on the physical medium/device and not just in a buffer (of course cached RAID controllers, SANs and other devices use some different logic there, but it’s definitely written beyond the OS space).

    In a non-cluster setup, you’d always want it to be =1 in order to be ACID compliant and that’s also InnoDB’s default. So far so good. For cluster setups,

      [Read more...]
    Effective way to check the network connection performance, when using replication geographically distributed
    +1 Vote Up -0Vote Down
    Why this article

    The more I have to interact with customers asking about MySQL/Galera, the most I have to answer over and over to the same question about what kind of network conditions Galera can manage efficiently.

    One of the most frequent myths I have to cover at the start of any conversation that involve the network is PING.

    Most of the customers use PING to validate the generic network conditions, and as direct consequence they apply that approach also when in need to have information on more complex and heavy use like in the Galera replication.

    To have a better understanding why I consider the use of PING, not wrong but inefficient, let us review some basic networking concepts.

     

    Frame

    At the beginning stay the physical layer, but I am

      [Read more...]
    Clustering SugarCRM with MySQL Galera for High Availability and Performance
    +1 Vote Up -0Vote Down
    March 20, 2014 By Severalnines

    SugarCRM is the leader in open source CRM systems, and has been adopted by some of the largest firms, including IBM. The CRM software includes all sales, marketing and support tools out of the box, and can also be extended to integrate social media sources. For those depending on SugarCRM, especially when deploying in cloud environments with lower SLAs, having a high availability architecture can make a lot of sense. 

    In this blog post, we will show you how to cluster SugarCRM Community Edition

      [Read more...]
    Talks first half of this year
    +0 Vote Up -0Vote Down

    Hi,
    I would like to give you an overview regarding all my talks till june.

    • MySQL@Ceph (Ceph Day Frankfurt ./. 27.02.2014)
      Yes you missed that already :)
    • MySQL: PerformanceSchema (DOAG SIG - MySQL ./. 27.03.2014)
    • Galera Cluster für MySQL (DOAG SIG - MySQL ./. 27.03.2014)
    • Docker++ ./. Containervirtualisierung von Applikationen mit Merhwert (Linuxtag ./. 08.05.2014)
    • Docker: Not even a Hypervisor (Containers for OpenStack) (Linuxtag ./. 09.05.2014
    • Docker: LXC Applikationskontainer für jedermann (SLAC ./. 13.05.2014)

    There is also a training



      [Read more...]
    How to use the ClusterControl REST API to automate your Database Cluster
    +0 Vote Up -0Vote Down
    March 11, 2014 By Severalnines

    For ops folks with multiple environments and instances to manage, a fully programmable infrastructure is the basis for automation. ClusterControl exposes all functionality through a REST API. The web UI also interacts with the REST API to retrieve monitoring data (cluster load, alarms, backup status, etc.) or to send management commands (add/remove nodes, run backups, upgrade a cluster, add/remove load balancer, etc.). The API is written in PHP and runs under Apache. The diagram below illustrates the architecture of ClusterControl.

    Figure: ClusterControl

      [Read more...]
    Resources for HA Database Clusters: New ClusterControl Release, Galera Migration Webinar & Blog Resources
    +0 Vote Up -0Vote Down
    March 6, 2014 By Severalnines

     

    Check Out Our Latest Resources for MySQL, MariaDB & MongoDB Clusters

     

    Here is a summary of resources & tools that we’ve made available to you in the past weeks. If you have any questions on these, feel free to contact us!

     

    ClusterControl 1.2.5 released

    We are pleased to announce the release of ClusterControl 1.2.5, which now supports MySQL 5.6 and Global Transaction IDs to enable cross-datacenter and cloud replication over high latency networks. Galera users are now able to assign nodes to their

      [Read more...]
    How to Set Up Asynchronous Replication from Galera Cluster to Standalone MySQL server with GTID
    +1 Vote Up -0Vote Down
    March 3, 2014 By Severalnines

    Hybrid replication, i.e. combining Galera and asynchronous MySQL replication in the same setup, became much easier with MySQL 5.6 and GTID. Although it was fairly straightforward to replicate from a standalone MySQL server to a Galera Cluster, doing it the other way round (Galera → standalone MySQL) was a bit more challenging. At least until MySQL 5.6 and GTID. 

    There are a few good reasons to attach an asynchronous slave to a Galera Cluster. For one, long-running reporting/OLAP type queries on a Galera node might slow down an entire cluster, if the reporting load is so intensive that the node has to

      [Read more...]
    Before every release: A glimpse into Percona XtraDB Cluster CI testing
    +0 Vote Up -0Vote Down

    I spoke last month at linux.conf.au 2014 in Perth, Australia, and one of my sessions focused on the “Continuous Integration (CI) testing of Percona XtraDB Cluster (PXC)” at the Developer,Testing, Release and CI miniconf.

    Here is the video of the presentation:

    Here is the presentation itself:

    Percona XtraDB Cluster before every release: Glimpse into CI testing from Raghavendra Prabhu

    Below is a rough transcript of the talk:

    This talk covered the continuous integration

      [Read more...]
    Auto increments in Galera
    +0 Vote Up -0Vote Down

    Lets start by considering a scenario where records are being inserted in a single auto-increment table via different nodes of a multi-master cluster. One issue that might arise is ‘collision’ of generated auto-increment values on different nodes, which is precisely the subject of this article.

    As the cluster is multi-master, it allows writes on all master nodes. As a result of which a table might get same auto-incremented values on different nodes on INSERTs. This issue is discovered only after the writeset is replicated and that’s a problem!

    Galera cluster suffers with the similar problem.

    Lets try to emulate this on a 2-node Galera cluster :

    1) On node #1:
    
    MariaDB [test]> CREATE TABLE t1(c1 INT AUTO_INCREMENT PRIMARY KEY, c2 INT)ENGINE=InnoDB;
    Query OK, 0 rows affected (0.07 sec)
    
    MariaDB [test]> START TRANSACTION;
    Query OK, 0
      [Read more...]
    How to Deploy Galera Cluster for MySQL using Docker Containers
    +0 Vote Up -0Vote Down
    February 18, 2014 By Severalnines

    Virtual Machines are great, and very useful when trying out new software. However, they might be an unnecessarily heavyweight solution when testing clusters, especially if these consist of multiple nodes running exactly the same software. Each VM runs a full-blown OS image. On the other hand, Linux Containers (LXC) are an efficient alternative to OS-level virtualization and can run multiple isolated systems on a single host. Docker is a wrapper around LXC, it automates the deployment of applications inside containers. 

    A notable advantage if you run with Docker + LXC is you can run many containers on a single host.

      [Read more...]
    MariaDB Galera Cluster 5.5.35 Now Available
    +0 Vote Up -0Vote Down

    The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.35. This is a Stable release.

    See the Release Notes and Changelog for detailed information on this release and the Galera page in the MariaDB Knowledge Base for general information about MariaDB Galera Cluster.

    Download MariaDB Galera Cluster 5.5.35

    Release Notes

      [Read more...]
    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster
    +0 Vote Up -0Vote Down
    February 13, 2014 By Severalnines

     

    Galera is slowly but surely establishing itself as a credible replacement for traditional MySQL master-slave architectures. 

    The benefits are clear - a true multi-master InnoDB setup with built-in fail-over, potentially across data centers. 

    But how do you migrate? Does the schema or application change? What are the limitations? Can migration be done online, without service interruption? What are the potential risks, and how to address those?

     

    Webinar: Migrating to MySQL, MariaDB Galera and/or Percona XtraDB Cluster

     

    Tuesday, March

      [Read more...]
    Follow up on FOSDEM
    +0 Vote Up -0Vote Down

    After my presentation at FOSDEM I got a few questions regarding our Galera implementation and why we did things the way we want. First of all, the slides: Spil Games @ FOSDEM: Galera Replicator IRL from spil-engineering Second of all, the questions I got: Q: Why first copy all the data to a new MySQL […]

    The post Follow up on FOSDEM appeared first on Spil Games Engineering.

    Announcing Partnership with Percona
    +2 Vote Up -1Vote Down
    February 4, 2014 By Severalnines

    Great news for Percona customers! We are thrilled to announce our partnership with Percona. Effective immediately, Percona customers will be able to enjoy the advanced automation, monitoring and cluster management capabilities of ClusterControl. Percona will be bundling, with its Cluster support contracts, Percona ClusterControl - a privately branded version of ClusterControl Community. Together we're providing support for the full stack, from Percona XtraDB Cluster to management tools, giving customers one number to call. 

    For anyone who has deployed, managed or

      [Read more...]
    How to Cluster Liferay with MySQL Galera and Ceph for High Availability and Performance
    +1 Vote Up -1Vote Down
    February 3, 2014 By Severalnines

    Liferay is an open-source content management system written in Java. It is used by a number of high traffic sites, as this survey suggests. 

    Clustering Liferay and other components such as the database and the file system is a good way to handle the performance requirements of a high traffic site. The latest Liferay version has introduced features that simplify clustering, such as built-in support for Ehcache clustering, Lucene replication, read/write splitting capabilities for database (in case if you run on

      [Read more...]
    MaxScale for the rest of us - Part 1
    +4 Vote Up -0Vote Down


    MaxScale for the rest of us - Part 1

    SkySQL released MaxScale as Open Source on github a few weeks ago. For some instructions on how to install and configure it, Ivan Zoratti has written a blog about that, and Mark Riddoch has written about why we need MaxScale here, but what I will try in a series of blogs is to describe what MaxScale is, in terms of what you can do with it, and to put it into context, so that you have an idea why you would want to install it in the first place. I will also show how to configure and manage MaxScale. This first post is a quick introduction to MaxScale.

    So what is



      [Read more...]
    Benchmarking Galera Cluster
    +4 Vote Up -0Vote Down
    What is it about?

    I used to do some benchmarkstuff and blogged about it on my blog written in German. Im going to do testings and benchmarkings again:)

    We are going to have a look into ‘benchmarking’ a 3-node Galera Cluster. The application (sysbench) is on a separate node accessing one node of the cluster. This would be the case in a i.e. VIP setup.

    Setup

    3 Galera Nodes

    • Virtual machines (OpenStack) provided by teuto.net
    • VCPU: 4
    • RAM: 4GB
    • OS: Centos 6.4-x86_64
    • MySQL-server-5.6.14wsrep25.1-1.rhel6.x86_64
    • galera-25.3.2-1.rhel6.x86_64

    Separate sysbench node

    • Same specs as the Galera nodes
    • sysbench 0.5
    • oltp test on 5 tables 1000000 rows each (ca. 1.2GB)
    • A run took 60
      [Read more...]
    MariaDB Enterprise 1.0 is Here
    +1 Vote Up -0Vote Down

    I know it was officially announced Monday, but I just wanted to take a moment and let everyone know MariaDB Enterprise 1.0 is now available, in case you missed the previous article.

    What does MariaDB Enterprise consist of?

    “MariaDB Enterprise is composed of several components including MariaDB Manager, which is a set of management tools and an API with which you can easily provision, monitor, and manage a highly available MariaDB Galera Cluster for multi-master, synchronous replication. Galera is a powerful technology that can eliminate single points of failure for your database infrastructure, but it is relatively new and can be a challenge to configure for administrators who aren’t familiar with it.”

      [Read more...]
    Webinar Replay & Slides: Repair & Recovery for Your MySQL, MariaDB & MongoDB / TokuMX Clusters
    +0 Vote Up -0Vote Down
    January 23, 2014 By Severalnines

     

    Thanks to everyone who attended this week’s webinar; if you missed the sessions or would like to watch the webinar again and browse through the slides, they are now available online.

     

    Special thanks to Seppo Jaakola from Codership, the creators of Galera Cluster, for walking us through the various scenarios of Galera recovery. 

     

    Webinar topics discussed: 

    • Redundancy models for Galera, NDB and MongoDB / TokuMX
    • Failover & Recovery (Automatic vs Manual)
      [Read more...]
    Galera Phrases
    +1 Vote Up -0Vote Down

    I confess I am a Galera fanboy. This post is going to present two slogans about Galera reminding you about Galera “limitations”. This is for the sake of user experience:)

    Galera Phrases:

    • One Cluster
    • Replication
    One Cluster

    Think about Galera as One Cluster. As every transaction is committed virtually synchronously, the slowest node determines the (DML) speed of the cluster. This is true regarding the network too.

    Replication
    • Galera is still some kind of replication. So keep in mind to provide PK as for (ROW based) Replication. There is a Featurerequest of mine to have a PK option to enforce creating of Tables with a PK. Please vote for it:)

    • With traditional MySQL Replication the slave might lag. This is not hurting the

      [Read more...]
    Active-active Alfresco cluster with MySQL Galera and GlusterFS
    +1 Vote Up -0Vote Down
    January 20, 2014 By Severalnines

    Alfresco is a popular collaboration tool available on the open-source market. It is Java based, and has a content repository, web application framework and web content management system. For critical large-scale implementations that require 24*7 uptime, a multi-node cluster would be appropriate. Since Alfresco depends on external components such as the database and the filesystem, clustering the Alfresco instances only would not be enough.

    In this post, we are going to show you how to deploy an active-active Alfresco cluster with MySQL Galera Cluster (database), GlusterFS (filesystem) and HAproxy with Keepalived (load balancer)

      [Read more...]
    Upcoming Webinar: What’s new in Percona XtraDB Cluster 5.6
    +1 Vote Up -0Vote Down

    I’ve been blogging a lot about some of the new things you can expect with 

      [Read more...]
    Showing entries 1 to 30 of 116 Next 30 Older Entries

    Planet MySQL © 1995, 2014, 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.