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 45 Next 15 Older Entries

Displaying posts with tag: XtraDB Cluster (reset)

Semi-Sync replication performance in MySQL 5.7.4 DMR
+2 Vote Up -0Vote Down

I was interested to hear about semi-sync replication improvements in MySQL’s 5.7.4 DMR release and decided to check it out.  I previously blogged about poor semi-sync performance and was pretty disappointed from semi-sync’s performance across WAN distances back then, particularly with many client threads.

The Test

The basic environment of these tests was:

  • AWS EC2 m3.medium instances
  • Master in us-east-1, slave in us-west-1 (~78ms ping RTT)
  • CentOS 6.5
  • innodb_flush_log_at_trx_commit=1
  • sync_binlog=1
  • Semi-sync replication plugin installed and enabled.
  • GTID’s enabled (except on 5.5)
  • sysbench 0.5 update_index.lua test, 60 seconds,
  [Read more...]
MySQL High Availability With Percona XtraDB Cluster (Percona MySQL Training)
+1 Vote Up -0Vote Down

I’ve had the opportunity to train lots of people on Percona XtraDB Cluster (PXC) over the last few years the product has existed.  This has taken the form of phone calls, emails, blog posts, webinars, and consulting engagements. This doesn’t count all the time I’ve spent grilling Codership on how things actually work.  But it has culminated in the PXC tutorial I have given annually at Percona Live MySQL Conference and Expo in Santa Clara, California for the last two years.  

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


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...]
    ClusterControl for Percona XtraDB Cluster Improves Management and Monitoring
    +1 Vote Up -1Vote Down

    ClusterControl for Percona XtraDB Cluster is now available in three different versions thanks to our partnership with Severalnines. ClusterControl will make it simpler to manage and monitor Percona XtraDB Cluster, MySQL Cluster, MySQL Replication, or MySQL Galera.

    I am very excited about our GA release of Percona XtraDB Cluster 5.6 last week. As Vadim described in his blog post announcing the release, we have brought together the benefits of Percona Server 5.6, Percona XtraBackup and Galera 3 to create a drop-in compatible, open source, state-of-the-art high availability MySQL clustering solution. We could not have done it

      [Read more...]
    The use of Iptables ClusterIP target as a load balancer for PXC, PRM, MHA and NDB
    +1 Vote Up -0Vote Down

    Most technologies achieving high-availability for MySQL need a load-balancer to spread the client connections to a valid database host, even the Tungsten special connector can be seen as a sophisticated load-balancer. People often use hardware load balancer or software solution like haproxy. In both cases, in order to avoid having a single point of failure, multiple load balancers must be used. Load balancers have two drawbacks: they increase network latency and/or they add a validation check load on the database servers. The increased network latency is obvious in the case of standalone load balancers where you must first connect to the load balancer which then completes the request by connecting to one of the database servers. Some workloads like reporting/adhoc queries are not affected by a small increase of latency but other workloads like oltp processing

      [Read more...]
    Percona XtraDB Cluster/ Galera with Percona Monitoring Plugins
    +1 Vote Up -0Vote Down

    The Percona Monitoring Plugins (PMP) provide some free tools to make it easier to monitor PXC/Galera nodes.  Monitoring broadly falls into two categories: alerting and historical graphing, and the plugins support Nagios and Cacti, respectively, for those purposes.


    An update to the PMP this summer (thanks to our Remote DBA team for supporting this!) added a Galera-specific host template that includes a variety of Galera-related stats,

      [Read more...]
    2 new features added to Percona XtraDB Cluster (PXC) since 5.5.31
    +1 Vote Up -0Vote Down

    With the last Percona XtraDB Cluster (PXC) release, two major features were added:

    * a new command to bootstrap the cluster was added to the init script
    * SST via Xtrabackup now supports Xtrabackup 2.1 features

    In this post, I want to explain the benefits of these added features and how to use them.

    If you follow the mysqlperformanceblog regularly, you’ve already noticed that there are several ways to start a node and that it’s not always easy to start the node

      [Read more...]
    Changing an async slave of a PXC cluster to a new Master
    +1 Vote Up -0Vote Down
    Async and PXC

    A common question I get about Percona XtraDB Cluster is if you can mix it with asynchronous replication, and the answer is yes!  You can pick any node in your cluster and it can either be either a slave or a master just like any other regular MySQL standalone server (Just be sure to use log-slave-updates in both cases on the node in question!).  Consider this architecture:

    However, there are some caveats to be aware of.  If you slave from a cluster node, there is no built in mechanism to fail that slave over automatically to another master node in your cluster.  You cannot assume that the binary log positions are the same on all nodes in

      [Read more...]
    Percona XtraDB Cluster (PXC) in the real world: Share your use cases!
    +0 Vote Up -0Vote Down

    The aim of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across (and our Percona consultants have assisted) is that of HP Cloud. There is a post about it here by Patrick Galbraith of HP. The post focuses on their deployment of PXC for HP Cloud DNS. The post focuses on the key aspects of

      [Read more...]
    Follow these basics when migrating to Percona XtraDB Cluster for MySQL
    +0 Vote Up -0Vote Down

    Galera/Percona XtraDB Cluster (PXC) for MySQL is a hot thing right now and some users jump right in without enough testing. Consequently, they’re more likely to either suffer failure or issues that prevent them from moving forward. If you are thinking of migrating your workload to Percona XtraDB Cluster, make sure to go through these basics.

    log_slave_updates is REQUIRED

    You need to have log_slave_updates enabled on the cluster node acting as async slave for replicated events from the async master to be applied to the other

      [Read more...]
    Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL now available
    +0 Vote Up -0Vote Down

    Percona is glad to announce the release of Percona XtraDB Cluster 5.5.30-23.7.4 for MySQL on April 17, 2013. Binaries are available from the downloads area or from our software repositories.

    New Features:

    • Percona XtraDB Cluster has implemented initial implementation of weighted quorum. Weight for node can be assigned via pc.weight option in the wsrep_provider_options variable. Accepted values are in the range [0, 255] (inclusive). Quorum is computed using weighted
      [Read more...]
    Keynotes, BOFs, and the Community Networking Reception at Percona Live MySQL Conference and Expo
    +1 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo begins next Monday and runs April 22-25, 2013. Attendees will see great keynotes from leaders in the industry including representatives from Oracle, Amazon Web Services, HP, Continuent, and Percona. They can also participate in thought provoking Birds of a Feather sessions on Tuesday night and the Wednesday night Community Networking Reception will be fun and entertaining with the presentation of the Community Awards and the Lightning Talks.

    If you

      [Read more...]
    Running Percona XtraDB Cluster in a Sandbox on Ubuntu
    +2 Vote Up -0Vote Down
    I wanted to do some experimentation with Percona XtraDB Cluster (Galera) and I didn't want to use virtual machines. I'm already using MySQL Sandbox for many other projects so that's the natural choice.

    I've downloaded the tarball for Percona XtraDB Cluster 5.5.29 and I've extracted it to ~/opt/mysql/5.5.29-pxc.

    Then I've installed 3 nodes:
    make_sandbox 5.5.29-pxc -- --sandbox_port 4551 \
    --sandbox_directory msb_5_5_29-pxc01 

    make_sandbox 5.5.29-pxc -- --sandbox_port 4552 \
    --sandbox_directory msb_5_5_29-pxc02 

    make_sandbox 5.5.29-pxc -- --sandbox_port 4553 \
    --sandbox_directory msb_5_5_29-pxc03 

    But when I try to start a node this error happens:
    130327 14:21:03 [Note] WSREP: wsrep_load(): loading provider library '/home/dvee

      [Read more...]
    Percona MySQL University coming to Toronto this Friday!
    +0 Vote Up -0Vote Down

    Percona CEO Peter Zaitsev leads a track at Percona MySQL University in Raleigh, N.C. on Jan. 29, 2013.

    Percona MySQL University, Toronto is taking place this Friday and I’m very excited about this event because it is a special opportunity to fit a phenomenal number of specific and focused MySQL technical talks all into one day, for free.

    Over the course of the day we will cover some of the hottest topics in the MySQL space. There will be talks covering topics like MySQL 5.6, MySQL in the Cloud and High Availability for MySQL, as well as

      [Read more...]
    Oracle Technical Experts at the Percona Live MySQL Conference and Expo
    +12 Vote Up -0Vote Down

    I’m pleased to announce that Oracle is sending some of their top technical people to speak at the Percona Live MySQL Conference and Expo. The conference takes place April 22-25, 2013 at the Santa Clara Convention Center and Hyatt Santa Clara.

    Tomas Ulin, VP, MySQL Engineering for Oracle, will present an invited keynote talk on “Driving MySQL Innovation” during the Tuesday morning opening keynotes. With the recent release of MySQL 5.6, conference attendees will hear about the latest developments of this

      [Read more...]
    Accessing Percona XtraDB Cluster nodes in parallel from PHP using MySQL asynchronous queries
    +2 Vote Up -0Vote Down

    Accessing Percona XtraDB Cluster nodes in parallel with MySQL asynchronous calls

    This post is followup to Peter’s recent post, “Investigating MySQL Replication Latency in Percona XtraDB Cluster,” in which a question was raised as to whether we can measure latency to all nodes at the same time. It is an interesting question: If we have N nodes, can we send queries to nodes to be executed in parallel?

    To answer it, I decided to try a new asynchronous call to send a

      [Read more...]
    Investigating MySQL Replication Latency in Percona XtraDB Cluster
    +2 Vote Up -0Vote Down

    Investigating MySQL Replication Latency in Percona XtraDB Cluster

    I was curious to check how Percona XtraDB Cluster behaves when it comes to MySQL replication latency — or better yet, call it data propagation latency. It was interesting to see whenever I can get stale data reads from other cluster nodes after write performed to some specific node. To test it I wrote quite a simple script (you can find it in the end of the post) which connects to one node in the cluster, performs an update and then immediately does the read from second node. If the data has been

      [Read more...]
    Announcing Percona XtraDB Cluster 5.5.29-23.7.1
    +3 Vote Up -0Vote Down

    Percona is glad to announce the release of Percona XtraDB Cluster on January 30th, 2013. Binaries are available from downloads area or from our software repositories.

    Bugs fixed:

    • In some cases when node is recovered variable threads_running would become huge. Bug fixed #1040108 (Teemu Ollakka).
    • Variable wsrep_defaults_file would be set up to the value in the last configuration file read. Bug fixed by keeping the value found in the top configuration file. Bug fixed
      [Read more...]
    Percona XtraDB Cluster: SElinux is not always the culprit !
    +2 Vote Up -0Vote Down

    If you are using SElinux, you should know that it’s advised to disable it to avoid issue with PXC. Generally the communication between your nodes doesn’t work properly and a node having SElinux enabled won’t be able to join the cluster.

    So when a node doesn’t join the cluster where it should, my first reflex is to have a look at audit.log. But recently I faced another problem: the node joined the cluster but SST failed (whatever which method was used, discarding skip).

    I checked SElinux and it was of course disabled, then I add some debug information in the SST script but it seemed that the script was never launched. And this time the culprit is called : AppArmor !

    Percona doesn’t provide any AppArmor profile for PXC, but it seems that on this server (Ubuntu TLS), a previous version of MySQL was

      [Read more...]
    Percona XtraDB Cluster (PXC): what about GRA_*.log files ?
    +0 Vote Up -0Vote Down

    How easy is it to identify and debug Percona XtraDB Cluster replication problem ?

    If you are using PXC, you may have already seen in your datadirectory several log files starting with GRA_

    Those files correspond to a replication failure. That means the slave thread was not able to apply one transaction. For each of those file, a corresponding warning or error message is present in the mysql error log file.

    Those error can also be false positive like a bad DDL statement (DROP a table that doesn’t exists for example) and therefore nothing to worry about. However it’s always recommended to understand what’s is happening.

    As the GRA files contain binlog events in ROW format representing the failed transaction this post explains how to proceed.

    The first step to be able to analyze your GRA files is to

      [Read more...]
    A closer look at Percona XtraDB Cluster for MySQL
    +0 Vote Up -0Vote Down

    The Web And PHP Magazine just published an article describing Percona XtraDB Cluster written by Liz van Dijk and Kenny Gryp. It is a pretty high-level introduction to the technology, so definitely give it a read if you’ve been wanting to give it a closer look.

    Go to their website http://www.webandphp.com and download Issue number 9 for free!


    Percona Live London 2012: Percona XtraDB Cluster in a nutshell
    +0 Vote Up -0Vote Down

    On Monday I will deliver with Seppo Jaakola from Codership a tutorial on Percona XtraDB Cluster (Percona Server + Galera).

    Already in London and you don’t know how to consume the hotel’s bandwidth ? If you attend this tutorial, you can download the Virtual Box appliance we will use during the session.

    Two versions are available:

    How to test them:

  • Open the downloaded file with Virtual Box
  • Install all 3 machines
  •   [Read more...]
    Realtime stats to pay attention to in Percona XtraDB Cluster and Galera
    +2 Vote Up -0Vote Down

    I learn more and more about Galera every day.  As I learn more, I try to keep my myq_gadgets toolkit up to date with what I consider is important to keep any eye on on a PXC node.  In that spirit, I just today pushed some changes to the ‘wsrep’ report, and I thought I’d go over some of the status variables and metrics being tracked there with the aim to show folks what they should be watching (at least from my opinion, this is subject to change!).

    First, let’s take a look at the output:

    [root@node3 ~]# myq_status -t 1 wsrep
    Wsrep    Cluster        Node           Queue   Ops     Bytes     Flow        Conflct
        time  name P cnf
      [Read more...]
    Speaking at Percona Live London 2012: Percona XtraDB Cluster in a nutshell
    +2 Vote Up -0Vote Down

    If you are interested by a great and revolutionary HA solution for MySQL or even if you already have some experience with PXC and/or Galera, I invite you to attend the tutorial I will deliver in Percona Live MySQL Conference London 2012 (PLUK2012), December 3rd : Percona XtraDB Cluster in a nutshell.

    Small amount of theory and a lot of exercises and examples to really tame the beast that PXC is !

    A Codership engineer will also be present and happy to help me answering your questions.

    Note to attendees: please bring your

      [Read more...]
    Understanding Multi-node writing conflict metrics in Percona XtraDB Cluster and Galera
    +3 Vote Up -0Vote Down

    I have addressed previously how multi-node writing causes unexpected deadlocks in PXC, at least, it is unexpected unless you know how Galera replication works.  This is a complicated topic and I personally feel like I’m only just starting to wrap my head around it.

    The magic of Galera replication

    The short of it is that Galera replication is not a doing a full 2-phase commit to replicate (where all nodes commit synchronously with the client), but it is instead something Codership calls “virtually synchronous” replication.  This could either be clever marketing or clever engineering, at least at face value.   However, I believe it really is clever engineering

      [Read more...]
    Percona Toolkit version 2.1.6 released
    +3 Vote Up -0Vote Down

    The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.6. This is the sixth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.

    The complete list of changes is on the Launchpad milestone for 2.1.6, but here are some highlights the release:

    • pt-online-schema-change can now handle column renames
    • pt-online-schema-change’s DELETE trigger no longer fails when altering a primary key
    • pt-stalk got a plugin hook interface
    • pt-show-grant support for column-level grants
    • pt-table-checksum will warn if slaves have a differing binlog_format

    Remember that if you need help with Percona Toolkit, we provide flat-fee, unlimited

      [Read more...]
    Percona XtraDB Cluster – installation and setup webinar follow up Q&A
    +2 Vote Up -0Vote Down

    Thanks for all, who attended my webinar, I got many questions and I wanted to take this opportunity to answer them.

    Q: Even ntp has a delay of 0.3-0.4 between servers does that mean a 0.25 as from logs can be an issue ?
    A: My demo vms were running for a few hours before the webinar in my local virtualbox instance, and I tried to show the minimal installation required for XtraDB cluster. Unfortunately enough, I didn’t include NTP, which caused SSTs to fail with the tar stream being from the future. The 0.3 – 0.4 second delay seems too much to me. According to the NTP standard, if the delay between the hosts is greater

      [Read more...]
    Percona Toolkit version 2.1.4 released
    +0 Vote Up -0Vote Down

    The Percona Toolkit team is happy to announce the release of Percona Toolkit version 2.1.4. This is the fifth stable release in the 2.1 series, and primarily a bug-fix release; We suggest that users upgrade to the latest version of the tools.

    The complete list of changes is on the Launchpad milestone for 2.1.4, but here are some highlights the release:

    • pt-table-checksum now works with Percona XtraDB Cluster
    • The “Version Check” feature, explained at length here.
    • –defaults-file is now used when connecting to discovered slaves in pt-table-checksum

    All in all, a solid bug-fix release, with the addition of some new

      [Read more...]
    Percona XtraDB Cluster / Galera Tutorial at Percona Live NY 2012
    +1 Vote Up -0Vote Down

    I’ve mentioned this before, but I’m delivering a tutorial on Percona XtraDB Cluster / Galera at Percona Live NY 2012 right in midtown-Manhattan on October 1st.

    I really want this tutorial to be hands-on, not just a 3 hour lecture, so you can actually see how a cluster operates and interact with it.  So, I have come up with a set of walkthroughs for different features and areas of learning PXC using a common set of Virtual Machines setup with Vagrant and Puppet (which works on Linux, OSX, or Windows).  This sounds complicated, but it basically means we can create a test environment

      [Read more...]
    Avoiding SST when adding new Percona XtraDB Cluster node
    +1 Vote Up -0Vote Down

    Some people want to use a backup to prepare a new Percona XtraDB Cluster node. They want this to avoid State Snapshot Transfer that could slow down the donor (depending of the SST method you are using, the donor can be blocked. I will cover this in a future blog post). As backup are generally performed during non-peak time, the effect should be reduced, and this avoid the need of performing 2 backups: the usual backup and the SST).

    So to be able to use a backup for this purpose, we have 3 prerequisites:

    • use XtraBackup >= 2.0.1
    • the backup needs to be performed with –galera-info (option for innobackupex)
    • have a gcache big enough to store all the changes from the time of the backup until the restore to be able to perform the
      [Read more...]
    Showing entries 1 to 30 of 45 Next 15 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.