… the write load of all the MySQL instances. The original idea was to configure them with raid-10 + LVM, making sure to… correctly. We got decent tpcc performance, nearly 37k NoTPM using 5.6.11 and xfs. Then, since ZFS on Linux is… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Comment: State of the art: Galera - synchronous replication for InnoDB
April 23, 2013 By 15 Comments
…/o on it that I have seen when running mysql 5.1 or mariadb 5.5 on the same hardware in a master/slave…-14 seconds. This is all on centos 6.4, adaptec raid controller with six 300G SAS drives in a raid10 for…=100000 MariaDB-Galera-server-5.5.29-1.x86_64 mysql-5.1.67-1.el6_3.x86_64 MariaDB-server-5.5.30-1.x86…
Post: Recovering Linux software RAID, RAID5 Array
August 27, 2011 By 2 Comments
Dealing with MySQL you might need to deal with RAID recovery every so often. Sometimes because of client lacking the … 26 13:51:11 2011 Raid Level : raid5 Used Dev Size : -1 Raid Devices : 6 Total Devices : 5 Persistence : Superblock is persistent Update… /dev/md2 mdadm –verbose –create /dev/md2 –chunk=64 –level=5 –raid-devices=6 /dev/sda3 /dev/sdb3 /dev/sdc3 /dev/sdd3…
Post: Setting up XFS on Hardware RAID -- the simple edition
December 16, 2011 By 9 Comments
… point mysql‘s tmpdir elsewhere) Everything else for MySQL (/mnt/data or similar): (sym-link /var/lib/mysql into here when you setup mysql… sectors fit in a RAID stripe. 65536 / 512 = 128 sectors per stripe. Get start boundary of our mysql partition from fdisk: 27344896… gave above: RAID 1+0: is a set of mirrored drives, so the number here is num drives / 2. RAID 5: is striped…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 18 Comments
… with HDD RAID storage – technology we have been using for many years – when there’s striping like in RAID0, 5, 6 or any variation of them (5+0, 1+0, 1+0+0 etc.). While IO inside the RAID is perfectly… misalignment on the file system, you can see how RAID ends up doing 5 IO operations – two to D4 and one on…
Post: Is there room for more MySQL IO Optimization?
January 3, 2013 By 11 Comments
… cached — system files, binary log, FRM files, MySQL MyISAM system tables etc. Starting MySQL 5.5 MySQL uses asynchronous IO which should allow it to… Read_Ahead which is not available in MySQL 5.5 (different version is added back in MySQL 5.6) so I tried that as well… of workloads indeed work better with O_DIRECT mode. The RAID controller also can make significant difference here as O_DIRECT…
Post: Aligning IO on a hard disk RAID – the Benchmarks
June 9, 2011 By 13 Comments
… … # Disk Schedulers And Queue Size ############################# sda | [deadline] 128 # RAID Controller ############################################ Controller | LSI Logic MegaRAID SAS Model | …Percona Server 5.0.92-87 with the following my.cnf configuration: [mysqld] datadir=/data/mysql socket=/…
Post: Looking for RAID Controller without Battery Learning problems ?
January 5, 2012 By 11 Comments
… its impact to MySQL Performance. Here are couple … Enabled ——————————————————– Controller Version Information ——————————————————– BIOS : 5.2-0 (18252) Firmware : 5.2-… device name : RAID10-A RAID level : 10 Status of logical …
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
…[1]; $AMI_ID= $fields[2]; $PUBDNS = $fields[3]; $STATUS = $fields[5]; $START = $fields[10]; print “$SecGroup|$IPAdd|$Instance_ID|$AMI_ID… by doing: root@hamysql:~# apt-get install mysql-server-5.1 The package install MySQL has an automatic startup script controlled by init… but Pacemaker will not manager MySQL, just the host running it. I’ll also skip the raid configuration of multiple EBS volumes…
Comment: Disaster: LVM Performance in Snapshot Mode
February 6, 2009 By 55 Comments
…” RAID 10 16000 88 178 167 97 2777 1630 9’31” RAID 5 16000 88 232 124 99 330 1359 10’28” RAID 5, LVM… some overhead, but really can be neglected. Even RAID 5 has better performance compared to RAID 10 (see sequential output block)!!! iozone gives… finally chose RAID 5 + LVM for MySQL server. I chose RAID 5 instead of RAID 10 since I didn’t see much gain from RAID 10 in…
