May 26, 2012

Post: Percona Server version 10

…, Today we are pleased to announce the release 10 of Percona Server with XtraDB storage engine. Since the previous release 9.1… SE Name at mysql start Bug #550867:5.1.45+xtradb-10 compilation fails on Ubuntu Karmic Bug #547230:Add new columns… LaunchPAD. Please report any bugs found on Bugs in Percona XtraDB server. For general questions use our Pecona-discussions group, and…

Post: Shard-Query EC2 images available

…-demo-64bit x86_64 Percona Server 5.5.11 with XtraDB. Requires m1.large or larger. ami-f65ea19f shard-query-infobright… ‘ontime_fact’G *************************** 1. row *************************** Name: ontime_fact Engine: InnoDB Version: 10 Row_format: Compact Rows: 6697533 Avg_row_length: 241 Data…

Post: Percona testing: Quick test clusters with kewpie!

xtradb-cluster 20120113-125552 INFO clientbindir: /percona-xtradb-cluster/client 20120113-125552 INFO testdir: /percona-xtradb-cluster/kewpie 20120113-125552 INFO server_version…. mysql> select * from t1; +—-+ | a  | +—-+ |  1 | |  4 | |  7 | | 10 | | 13 | +—-+ 5 rows in set (0.00 sec) mysql…

Post: xtrabackup-1.2

… next version 1.2 of XtraBackup software is released. The list of changes in this version includes: Changelog: XtraBackup supports now XtraDB 10 tar4ibd supports variable page size and fast_checksum of XtraDB Supported 32bit platform…

Post: Percona Server 5.1.52-12.3

Percona Server version 5.1.52-12.3 is now available for download. … to update the current Percona release candidate to the latest version of MySQL 5.1. The release also includes the HandlerSocket… 5.0. (Yasufumi Kinoyasu) Bug #643463 – Shutting down XtraDB could take up to 10 seconds, even when there was no actual work…

Post: High-Performance Click Analysis with MySQL

… server, InnoDB is usually your best bet. (Actually, XtraDB might be very interesting for you, but I… doing here starts to look like a hillbilly version of Infobright, which I’ll talk about later. … drives with much less memory, or even with 10-15x fewer servers. Clever application design, and a…

Post: Disaster: MySQL 5.5 Flushing

…-tables workload, with 20 tables, 10,000,000 rows each. Total database size ~58GB. MySQL version: 5.5.16 Initial benchmark, which…_in_group = 2 In my benchmark I measure results each 10 sec, and when we graph it, it looks like: Basically… whish I could say you should use Percona Server with XtraDB. If we were using SSD as storage, then I would…

Post: State of the art: Galera - synchronous replication for InnoDB

… by yourself MySQL/Galera Release 0.7pre. In current version propagation is done by mysqldump from one of nodes … list, Yves put recently, http://www.mysqlperformanceblog.com/2009/10/16/finding-your-mysql-high-availability-solution-%e2%80… for next releases and looking to make integration with XtraDB….

Post: Pretending to fix broken group commit

… to break this serialization – in XtraDB release3 (will be announced soon, you can take current version for testing from Launchpad) we introduce… load). I tested it on Dell PowerEdge R900 with RAID 10 in WriteThrough mode to emulate absence of BBU. With BBU…