Hi there! thanks to Florian, I switched my platform to Ubuntu 11.10, which does have more recent packages of pacemaker and resource…_vip (ocf::heartbeat:IPaddr2): Started ubuntu-cluster01 Master/Slave Set: ms_MySQL [p_mysql] Masters: [ ubuntu-cluster01 ] Slaves: [ ubuntu-cluster02 ] Still, the replication…
Comment: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
February 7, 2012 By 102 Comments
Post: Debian / Ubuntu Percona builds
March 9, 2009 By 8 Comments
… ignore that and added scripts to build binaries on our Ubuntu 8.10 box. It’s going to be only 64bit releases…, which I mentioned before (http://www.mysqlperformanceblog.com/2009/02/11/limiting-innodb-data-dictionary/). Speaking of deb binaries I tried…
Post: Clarification on MySQL security vulnerability
June 19, 2012 By 2 Comments
… the security vulnerability in MySQL/MariaDB sql/password.c: 64bit Ubuntu Oneiric (11.10) binaries are vulnerable in Percona Server ONLY on some… newer Ubuntu versions are affected. Oneiric is not a LTS distribution. Most servers using server-market-focused versions, such as 10.04…
Post: SSD, XFS, LVM, fsync, write cache, barrier and lost transactions
March 2, 2009 By 32 Comments
…/6i and HighPoint 2300). The problem was solved by installing Ubuntu 8.10 which is currently running all this system. Originally I… publish some nice benchmarks where InnoDB on SSD outperforms RAID 10, but recently I faced issue which can make previous results… because LVM ignores write barriers (see http://dammit.lt/2008/11/03/xfs-write-barriers/ ), but again with enable write-cache…
Post: Faster Point In Time Recovery with LVM2 Snaphots and Binary Logs
February 23, 2012 By 3 Comments
… was made available to the lvconvert binary. Base installs of Ubuntu 11.04 (Natty) and CentOS 5.7 includes packages with this….00g mysql-data 0.00 mysql-logs sb -wi-ao 10.00g Suppose sometime after the snapshot, I accidentally dropped the…
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…:~$ 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… is to install Heartbeat and Pacemaker on both host, with Ubuntu 10.04, it is very straightforward: root@monitor:~# apt-get install…
Post: Modeling MySQL Capacity by Measuring Resource Consumptions
March 8, 2011 By 1 Comment
… at procfs for MySQL process: root@ubuntu:/var/log/mysql# cat /proc/19018/stat … 12ms 7ms 0 # pages distin 65 11.43M 1 18 6.84 9… # 1us # 10us # # 100us ################################################################ # 1ms ############# # 10ms ###### # 100ms # # 1s # 10s+ We can see this query takes …
Post: A recovery trivia or how to recover from a lost ibdata1 file
June 3, 2011 By 8 Comments
… disk space and good internet connectivity, I fired up an Ubuntu 10.04 EC2 instance, installed MySQL and provided the customer the…: CREATE TABLE `tables` ( `name` varchar(100) DEFAULT NULL, `spaceid` int(11) NOT NULL, PRIMARY KEY (`spaceid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1… “insert into tables (name,spaceid) values (‘$tname’,conv(‘$spaceid’,16,10))” test; done Recovering the tables With all this in place…
Post: FreeBSD tests
June 15, 2006 By 15 Comments
… http://www.mysqlperformanceblog.com/2006/06/13/quick-look-at-ubuntu-606/). Initially I was very pessimistic about FreeBSD, as results…: InnoDB threads FreeBSD 6 Suse 10.0 Suse/ FreeBSD ratio 1 483.22 536.91 1.11 4 852.21 816.27…: –key-buffer-size=500M –max-connections=500 –skip-innodb Suse 10.0: kernel-smp-2.6.13-15.x86_64 NTPL…
Post: Percona Replication Manager, a solution for MySQL high availability with replication using Pacemaker
November 29, 2011 By 102 Comments
…-agents/zipball/master On my Ubuntu Lucid VM, this file goes in…bootstrap-options” \ dc-version=”1.0.11-a15ead49e20f047e129882619ed075a65c1ebdfe” \ cluster-infrastructure=”openais” \ expected-quorum-votes…1322236006″ property $id=”mysql_replication” \ replication_info=”10.2.2.162|mysql-bin.000090|…
