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.
DB Hangops - every other Wednesay at noon Pacific time
The call for papers for OSCon 2014 is open until Thursday, January 30th
Percona Replication Manager
First announcement of Percona Replication Manager
The master/slave clone set for pacemaker.
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.
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');
sudo apt-get install ttf-ancient-fonts
sudo yum install gdouros-symbola-fonts
mysql -u username -p -eNB "select emoji('1F384')" my_db | xxd -r -ps
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).