OurSQL Episode 168: Autofailover, part 1

This week we discuss setting up Percona Replication Manager. Ear Candy is playing with Unicode to make seasonal pictures and At the Movies is about systems performance with lots of MySQL examples.

Events
DB Hangops - every other Wednesay at noon Pacific time

FOSDEM 2014 - Sat February 1 - Sun February 2 in Brussels, Belgium.
Upcoming MySQL events

The call for papers for OSCon 2014 is open until Thursday, January 30th

Training
SkySQL Trainings
Tungsten University trainings
Oracle's MySQL Trainings
Percona Trainings

Percona Replication Manager
First announcement of Percona Replication Manager

corosync
Pacemaker

corosync.conf configuration file
sample corosync configuration file
Example of using corosync-objctl to verify nodes are communicating with each other

/etc/corosync/service.d/pacemaker sample:

service {
      name: pacemaker
      ver: 1
}

Starting Pacemaker

Percona pacemaker agents on github - for downloading, or have the proper version of resource-agents

The master/slave clone set for pacemaker.

Setting up virtual IP addresses

"crm configure show" output

testing failover

quorum with 2 hosts, and disabling stonith.
stonith

Ear Candy
In this week's ear candy, we're going to play a little with Unicode character encoding (special thanks to Kolbe Kegel) and some MySQL functions to manipulate them.
emoji

use my_db
create function emoji (e char(10)) returns char(12) deterministic return concat(hex(convert(convert(unhex(lpad(e,8,'0')) using utf32) using utf8mb4)),'2020');
select emoji();

lpad
unhex
convert

xxd
symbola font for Linux machines

Make emoji work in Linux

Ubuntu:
sudo apt-get install ttf-ancient-fonts

Fedora:
sudo yum install gdouros-symbola-fonts

mysql -u username -p -eNB "select emoji('1F384')" my_db | xxd -r -ps

full charset for emoji

If you want to check your output, you can see what happens.

At the movies
This week in At the Movies, we feature Brendan Gregg of Joyent, also the primary author of Dtrace, talking about "The New Systems Performance - Enterprise and the Cloud". You can see the video or just look at the slides (PDF).

Feedback
Facebook group
Google+ page
e-mail: podcast at technocation.org
voicemail using phone/Skype: +1-617-674-2369
twitter: @oursqlcast
or Tweet about @oursqlcast