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 中文
Previous 30 Newer Entries Showing entries 31 to 47

Displaying posts with tag: XtraDB Cluster (reset)

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...]
Percona XtraDB Cluster: Failure Scenarios with only 2 nodes
+1 Vote Up -0Vote Down

During the design period of a new cluster, it is always advised to have at least 3 nodes (this is the case with PXC but it’s also the same with PRM). But why and what are the risks ?

The goal of having more than 2 nodes, in fact an odd number is recommended in that kind of clusters, is to avoid split-brain situation. This can occur when quorum (that can be simplified as “majority vote”) is not honoured. A split-brain is a state in which the nodes lose contact with one another and then both try to take control of shared resources or provide simultaneously the cluster service.
On PRM the problem is obvious, both nodes will try to run the master and slave IPS and will accept writes. But what could happen with Galera replication on PXC ?

Ok first let’s have a look with a standard PXC setup (no special

  [Read more...]
Percona XtraDB Cluster reference architecture with HaProxy
+1 Vote Up -0Vote Down

This post is a step-by-step guide to set up Percona XtraDB Cluster (PXC) in a virtualized test sandbox. I used Amazon EC2 micro instances, but the content here is applicable for any kind of virtualization technology (for example VirtualBox). The goal is to give step by step instructions, so the setup process is understandable and it could serve as a reference architecture.

You will need 4 virtual machines. 3 for PXC and 1 for the client, which will have HaProxy. I used CentOS 6 as the operating system, the instructions are similar for any Linux distribution.

The client node will have HaProxy installed and it will redirect requests to PXC nodes. This approach works well in real-world scenarios too. Running HaProxy on the application servers instead of having them as dedicated entities gives you benefits like you don’t need

  [Read more...]
Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
+2 Vote Up -0Vote Down

I have a customer who is considering Percona XtraDB Cluster (PXC) in a two colo WAN environment.  They wanted me to do a test comparing PXC against semi-synchronous replication to see how they stack up against each other.

Test Environment

The test environment included AWS EC2 nodes in US-East and US-West (Oregon).  The ping RTT latency between these nodes was right around 100ms.

All environments used Percona Server or Percona XtraDB Cluster server 5.5.24.  Innodb durability was disabled for all tests (innodb_flush_log_at_trx_commit=2).  All other settings were the same kept the same unless otherwise noted.

I tested against the following

  [Read more...]
NO Security vulnerability in Percona Server / XtraDB Cluster provided binaries
+0 Vote Up -0Vote Down

Many of you heard of this nasty security vulnerability in MySQL, and as we are getting a lot of inquiries how does it affect Percona Server, I decided to address it in this post.

  • The issue exists in the source code of MySQL 5.5.23 or earlier and MySQL 5.1.62 or earlier. The same is true for Percona Server, as we share the same code base.
  • However binaries provided by Percona do not have this problem, as in our build process we do not use sse-optimized glibc memcmp. This is true for any version of Percona and all tar.gz, RPM and DEB packages. Once again, if you use binary builds, provided by Percona from our official download area, or from our repositories,
  [Read more...]
Announcement of Percona XtraDB Cluster 5.5.24
+1 Vote Up -0Vote Down

I am happy to announce next version Percona XtraDB Cluster 5.5.24, which is mostly jump to the current version of Percona Server.

It includes an important bug fix:

Binaries are available from downloads area or from our repositories.

For this release we provide binaries for Ubuntu 12.04.

If you want to know more how to migrate to XtraDB Cluster, you can check our recent webinar Migrating To Percona XtraDB Cluster.

This is an General Availability release. We did our best to eliminate bugs and problems

  [Read more...]
Migrating to XtraDB Cluster Webinar follow up questions
+1 Vote Up -0Vote Down

Thanks to all who attended my webinar today. The session was recorded and will be available to watch for free soon here.

There were a lot of great questions asked during the session, so I’d like to take this opportunity to try to answer a few of them:

Q: Is there an easy way to leverage the xtrabackup SST and IST in an xtradb cluster to take your full and incremental backups of the cluster’s databases?

Well, if you noticed, all the current SST methods are just commonly used backup tools, and the SST is, in reality, just doing a full backup. So I’m not sure there’s much to leverage with SST.

The straight-forward to way to backup XtraDB Cluster (IMHO) would

  [Read more...]
Webinar – Migrating to Percona XtraDB Cluster
+0 Vote Up -0Vote Down

Whenever I learn about a new technology, I typically want to know the major administrative touch points more than I want to know exhaustive detail about every configuration option.  Give me the gist, show me enough to get started, and give me a link to the manual.

XtraDB cluster (and Galera, the technology on which it is based) has been attracting a lot of interest in the community and we want to start presenting information about both what we know is essential, but also what we suspect will become essential as more and more production experience is logged with these important new technologies.

As such, I put together a baseline talk for getting you into a working knowledge of XtraDB

  [Read more...]
Announcement of Percona XtraDB Cluster 5.5.23
+4 Vote Up -0Vote Down

Our previous GA release of Percona XtraDB Cluster caused a lot of interest and feedback. I am happy to announce next version Percona XtraDB Cluster 5.5.23, which comes with bug fixes and improvements.

List of changes:

  • Fixes merged from upstream (Codership-mysql)
  • Support for MyISAM, now changes to MyISAM tables are replicated to other nodes
  • Improvements to XtraBackup SST methods, better error handling
  • New SST wsrep_sst_method=skip, useful when you start all nodes from the same sources (i.e. backup)
  • Ability to pass list of IP addresses for a new node, it will connect to the first available

Binaries are available from downloads area or from

  [Read more...]
Benchmarks challenges of XtraDB Cluster
+1 Vote Up -0Vote Down

We are running internally a lot of benchmarks on our recently announced Percona XtraDB Cluster, and I am going to publish these results soon.
But before that I wanted to mention that proper benchmark of distributed system comes with a lot of challenges.
I am saying that not to complain, but to make sure, if you are going to benchmark XtraDB Cluster yourself, there is a lot of things to take into account.

And it seems that one component, which was not much important before, now appears as critical peace, which easily can became bottleneck in the benchmarks – this is network.

In case of simple client-server setup, the network is not fully utilized.

  [Read more...]
Testing Percona XtraDB Cluster with Vagrant
+2 Vote Up -0Vote Down

For those wanting to become more familiar with Percona XtraDB Cluster or if you just one to test its capabilities, I have prepared an easy Vagrant setup ready to deploy.

It contains the puppet recipes to install and configure a cluster of 3 nodes and a load balancer (glb) running on the first node.

To be able to test it, these are the prerequisites you need to have on your system:

Then you can find all the necessary files on my

  [Read more...]
Announcement of Percona XtraDB Cluster 5.5.20 GA release
+4 Vote Up -0Vote Down

I am excited to announce the availability of the GA release of our new product Percona XtraDB Cluster.

Percona XtraDB Cluster is a High Availability and Scalability solution for MySQL Users and is based on Percona Server 5.5.20.

With this release we make clustering very easy and affordable for everyone. You can convert your existing MySQL replication setup into a cluster in just a couple minutes.

Tomorrow, 4-April-2012, I will be giving a webinar where I will

  [Read more...]
Diamond Keynote Panel, BOFs, Lightning Talks, and McAfee and AOL Sponsorships
+0 Vote Up -0Vote Down

I’m excited by all of the recent developments surrounding the Percona Live MySQL Conference and Expo! Our own Baron Schwartz will moderate the Diamond Keynote Panel entitled “Future Perfect: The Road Ahead for MySQL” which will feature a panel of MySQL industry leaders, including: Sundar Raghavan, director product management at Amazon; Paul Mikesell, CEO of Clustrix; a representative from HP; and, a representative from McAfee. The Diamond Sponsor Keynote Panel will take place at 9:30 a.m. on Thursday, April 12th and provide insight into the future of MySQL technology, adoption, and the ecosystem landscape. I am also very pleased to

  [Read more...]
BOFs and Lightning Talks Announced for Percona Live MySQL Conference & Expo
+1 Vote Up -0Vote Down

The Percona Live MySQL Conference & Expo is going to be awesome! Great speakers, an A-list of sponsors, countless opportunities to engage with the community, and an enthusiastic crowd of MySQL users ensure this is going to be a great event. The conference features 72 breakout sessions, keynotes by leading industry luminaries, an optional day of 16 tutorial sessions, a bustling exhibit hall, and numerous opportunities to connect with other community members.

I am pleased to announce the conference Birds of a Feather sessions and Lightning Talks.

  [Read more...]
Percona XtraDB Cluster Events
+2 Vote Up -0Vote Down

We are on our way to delivery a production ready release of Percona XtraDB Cluster by the end March-2012.
We will do couple events to cover features and architecture of XtraDB Cluster.

  [Read more...]
Percona XtraDB Cluster 5.5.20 – Beta release
+1 Vote Up -0Vote Down

I am happy to announce the availability of beta release of our new product Percona XtraDB Cluster.

Percona XtraDB Cluster is High Availability and Scalability solution for MySQL Users and the beta release is based on Percona Server 5.5.20 and the recently released Galera 2.0 GA

The main focus in this release:

  • Incremental State Transfer, especially useful for WAN deployments
  • Support of Percona XtraBackup for Snapshot State Transfer. This feature is available in pre-release series for XtraBackup 2.0

Despite Galera 2.0 has status

  [Read more...]
Previous 30 Newer Entries Showing entries 31 to 47

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.