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

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 …

  [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 …
  [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 …

  [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 …

  [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.

…  [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 …
  [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 …

  [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 …

  [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 …

  [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 …
  [Read more...]
10 Newer Entries Showing entries 31 to 40 of 47 7 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.