If you have recently attended some Yves Trudeau , you may have heard about Percona Replication Manager ( PRM), a new high availability tool for .events or if you have checked some slides from
Percona & 2012
(a slightly modify rebroadcast of Florian's post )
If you are interested byavailability solution with , Florian Haas from and myself myself will be co-presenting next Tuesday a tutorial on the topic. It is never too late to register!
For the ones who are already registered, here's advance information which you will find useful.
As our tutorial is going to be highly interactive, every attendee will have the opportunity to follow along withand …
…, , Kenny Gryp, Yves Trudeau, Espen Braekken, and industry giants such as 's Mike DelNegro and 's Daniel Austin. No fluff, no sales pitches.
An evening panel on cloud and virtualization, featuring people who've built large systems in and out of the cloud. We'll have Peter Zaitsev, OmniTI ; author of Scalable Internet Architectures), Robert Uhrmacher ( of ideeli , Inc …(
You can also the whole branch from here:
On my Ubuntu Lucid VM, this file goes in /usr/lib/ocf/resource.d/heartbeat/ directory.
To use this agent, you'll need aconfiguration. As a starting point, I'll discuss the configuration I use during my tests. node testvirtbox1 \ attributes IP="10.2.2.160" node …
In a month, the 24th of October, Johan Andersson ( severalnines.com ) and I will be giving a full day tutorial on NDB cluster which will include both presentations and hands-on. Be ready for a fast ramp-up on NDB! Among items covered:
- NDB for sharding
- Other access methods
If entity_210 …
Johan Andersson and Yves Trudeau will run NDB Cluster Tutorial which is full day in depth tutorial focused on NDB Cluster/ MySQL Cluster technology which is
rapidly gaining popularity for building high performance and highly available systems with MySQL. Initially designed for Telecom Applications MySQL Cluster have been slowly adapting features making it more and more useful for broad set of applications. If you're looking to get started with this new technology this is …
NDB cluster is a very interesting solution in term of high availability since there are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would think that it is a good fit.
It is indeed a good fit but reality is a bit trickier. The main issue we faced is that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP. What the problem with a new IP? Just change the IP in the cluster config and perform an rolling …
A few day ago, a customer came to Percona needing to recover data. Basically, while doing a transfer from one SAN to another, something went wrong and they lost the ibdata1 file, where all the table meta-data is stored. Fortunately, they were running with innodb_file_per_table so the data itself was available. What they could provide us was:
all the tables ibd files (Nearly 200 of them, 40 GB of data)
the schema in sql format
No remote access
Their first question was "Is it possible to recover the data?"
This post is the fifth of a series that started here .
From the previous posts of this series, we now have nearly everything setup, only a few pieces are missing. One of the missing pieces is thescript that run on the instance.
First, this script is optional, Pacemaker will accept a noop bash script but since we have the opportunity to run a script on the MySQL host, let's take it. At minimum, let's use mysqladmin to ping the database to see if …