If you have recently attended some Percona Live events or if you have checked some slides from Yves Trudeau , you may have heard about Percona Replication Manager ( PRM), a new high availability tool for MySQL .
Percona Live MySQL Conference & Expo 2012
PRM is an OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication.
entity_546960 …
(a slightly modify rebroadcast of Florian's post )
If you are interested by High availability solution with MySQL, 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 with Florian and …
- High Scalability: What is Network-based Application Virtualization and Why Do You Need It?
- Simone Carletti's Blog: Running Google Chrome OS on Mac OS X with VMWare Fusion
- A Fresh Cup: Double Shot #701
- igvita.com: VMware CloudFoundry: Ruby powered PaaS
- JJinuxLand: PyCon: Python - The Secret Sauce in the Open Cloud
…Peter Zaitsev, Baron Schwartz, Kenny Gryp, Yves Trudeau, Espen Braekken, and industry giants such as AOL's Mike DelNegro and PayPal'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, Theo Schlossnagle ( OmniTI ; author of Scalable Internet Architectures), Robert Uhrmacher ( CTO of ideeli , Inc …
- High Scalability: Strategy: Cache Larger Chunks - Cache Hit Rate is a Bad Indicator
Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
https://github.com/y-trudeau/resource-agents/raw/master/heartbeat/mysql
You can also the whole branch from here:
https://github.com/y-trudeau/resource-agents/zipball/master
On my Ubuntu Lucid VM, this file goes in /usr/lib/ocf/resource.d/heartbeat/ directory.
To use this agent, you'll need a Pacemaker configuration. As a starting point, I'll discuss the configuration I use during my tests. node testvirtbox1 \ attributes IP="10.2.2.160" node …
- MySQL Performance Blog: Debugging MySQL SSL problems
- MySQL Performance Blog: Is your MySQL buffer pool warm? Make it sweat!
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:
- Achitecture
- Installation
- Loading data
- Administration (common procedures)
- Node recovery
- NDB for sharding
- Replication
- Online scaling
- Other access methods
If entity_210 …
- Engine Yard Developer Blog: 5 subtle ways you're using MySQL as a queue, and why it'll bite you
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 …
- High Scalability: Paper: High Performance Scalable Data Stores
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?"
- Pennysmalls: Much faster Rails tests if you use MyISAM
- A Fresh Cup: Double Shot #578
- Rails Envy » Home: RailsLab: Scaling Your Database - Part 2
- oldmoe: 101 Reasons Why PostgreSQL is a better fit for Rails than MySQL
- Simple thoughts - articles: The Internal Storage Mechanism For Globalize for Rails Model Translations
- JJinuxLand: MySQL: Disk Usage Can Never Shrink When Using InnoDB
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 the Pacemaker script that run on the MySQL 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 …
- Nick Sieger: activerecord-jdbc-adapter 1.0.0
- Riding Rails - home: Rails 3.0: Release candidate!
- igvita.com: State of Ruby VMs: Ruby Renaissance
- Scottish Ruby Conference: Brightbox - Gold Sponsors
- DABlog - Home: Training, part 2: Handling mixed levels of student experience in a class
- RailsTips by John Nunemaker: Why I think Mongo is to Databases what Rails was to Frameworks