June 19, 2013

Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker

Hi there! thanks to Florian, I switched my platform to Ubuntu 11.10, which does have more recent packages of pacemaker and…_vip (ocf::heartbeat:IPaddr2): Started ubuntu-cluster01 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ ubuntu-cluster01 ] Slaves: [ ubuntu-cluster02 ] Still, the replication…

Post: Debian / Ubuntu Percona builds

… ignore that and added scripts to build binaries on our Ubuntu 8.10 box. It’s going to be only 64bit…, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/). Speaking of deb binaries I tried…

Post: Can't Create Thread: Errno 11 (A Tale of Two Ulimits)

…: SQLSTATE[HY000] [1135] Can’t create a new thread (errno 11); if you are not out of available memory, you can… fresh user session. If you’re running RHEL/CentOS 5, Ubuntu, or versions of Fedora prior to Fedora 9, this solution…

Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs

… was made available to the lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this…

Comment: What's up with HandlerSocket?

FYI, handlersocket is included in Debian unstable as of today, and will be available in Ubuntu 11.04, releasing later this month.

Comment: What's up with HandlerSocket?

FYI, handlersocket is included in Debian unstable as of today, and will be available in Ubuntu 11.04, releasing later this month.

Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances

…:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618 099720109477 available public i386…-1cdf3775 pending yves-key 0 m1.small 2010-06-18T20:11:14+0000 us-east-1c aki-aca44cc5 monitoring-disabled instance….pem ubuntu@ec2-174-129-89-188.compute-1.amazonaws.com ubuntu@domU-12-31-39-07-C8-32:~$ sudo su – ubuntu@domU…

Post: A recovery trivia or how to recover from a lost ibdata1 file

… disk space and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer…: CREATE TABLE `tables` ( `name` varchar(100) DEFAULT NULL, `spaceid` int(11) NOT NULL, PRIMARY KEY (`spaceid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1… 00 |…T….E…….| #00000020 00 00 00 00 00 11 00 00 00 11 80 39 00 00 00 02 |………..9….| #00000030…

Post: Modeling MySQL Capacity by Measuring Resource Consumptions

… can take a look at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat 19018 (mysqld) S… 1.96 469.31 0.99 # Bytes sent 8.77G 11 55.41M 5.15k 3.88k 258.55k 1.46k… disk tbl 21.21k 0 2 0.01 0 0.11 0 # Tmp tbl size 554.04M 0 12.83M 324… 3949s 0 466ms 2ms 12ms 7ms 0 # pages distin 65 11.43M 1 18 6.84 9.83 2.20 7…

Post: Clarification on MySQL security vulnerability

… the security vulnerability in MySQL/MariaDB sql/password.c: 64bit Ubuntu Oneiric (11.10) binaries are vulnerable in Percona Server ONLY on… EC2 but not on HP Cloud). Neither older nor newer Ubuntu versions are affected. Oneiric is not a LTS distribution. Most…