… been working for a customer benchmarking insert performance on Amazon EC2, and I have some interesting results that I wanted to… software RAID 10. Now let’s come to the MySQL configuration. MySQL Configuration I used Percona Server 5.5.22-55 for…, so that was all about the configuration of the EC2 instance and MySQL. Now as far as the benchmark itself is concerned…
Comment: How to calculate a good InnoDB log file size
April 24, 2012 By 33 Comments
What if the calculation above shows that I should have an innodb log file size of 1-2 MB? I’m running Percona server on an ec2 small instance with the XFS filesystem for the mysql data directory.
Comment: Announcement of Percona XtraDB Cluster 5.5.20 GA release
April 15, 2012 By 10 Comments
… some idea on what throughput increase we can expect considering EC2 and EBS constraints. Our company is working on adding NoSQL… is now exclusively based on Percona’s MySQL server. The more we can extract from MySQL without relegating to the extremely limiting…
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
…=’Contains all avaialble data from 1988 to 2010′; mysql> use ontime1; Database changed mysql> show table status like ‘ontime_fact’G *************************** 1… set up the hosts file: sudo su – # cat hosts.internal | ~ec2-user/tools/mkhosts >> /etc/hosts # ping shard20 PING shard20 (10… my.cnf [client] port=3306 socket=/tmp/mysql-inno.sock [mysqld] socket=/tmp/mysql-inno.sock default-storage-engine=INNODB innodb-buffer…
Post: High availability for MySQL on Amazon EC2 - Part 6 - Publishing server location
February 16, 2011 By Leave a Comment
… posts of this series, we now have an HA MySQL service running on EC2. We now need to find a way to… to the HA MySQL service. Normally, in an HA setup, this is achieved using virtual IP addresses but EC2 does not support…) that publishes the IP address of a newly created MySQL server. MYSQL_IP=`ec2-describe-instances -K $PK -C $CERT $NEW_INSTANCE_ID…
Post: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… are no single point of failure. In an environment like EC2, where a node can disappear almost without notice, one would… main issue we faced is that IPs are dynamic in EC2 so when an instance restarts, it gets a new IP… the hostname like: [NDBD DEFAULT] NoOfReplicas=2 Datadir=/var/lib/mysql-cluster/ DataMemory=1G IndexMemory=100M [NDB_MGMD] Id=1 Hostname…
Post: Product to try: MySQL/MariaDB-Galera 0.8
June 13, 2011 By 34 Comments
… to add support for Percona XtraBackup to propagate nodes. Why MySQL/MariaDB + Galera 0.8 is interesting? It allows to solve… provides a HA solution for MySQL setups in the Cloud. E.g. with current state of MySQL EC2 setups suffer from lacking a… three node cluster is much more complex than an average MySQL master-slave setup. Potential performance penalty: Although to have performance…
Post: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see… the general usage of AWS as you get on normal EC2 servers with EBS. I benchmarked the largest available RDS instance…
Post: Should we give a MySQL Query Cache a second chance ?
April 10, 2011 By 63 Comments
… is appealing to improve performance for MySQL Applications ? Make it Lockless Can we re-implement MySQL Query Cache so it is lockless… memory amount might be limited especially in constrained environments as EC2. We could implement API which would allow one to use… make it cool again. The question is whenever anyone from “MySQL Market Players” – Oracle, MariaDB, Drizzle, Percona Server, will allocate resources…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… compatibility between version and so you can run MySQL 5.0 database with MySQL 5.1 with no problems in most cases…, such as DECIMAL field got whole another meaning in MySQL 5.0 MySQL generally supports legacy storage format for a while, even… quickly. This especially makes sense for cloud environments as Amazon EC2 where it is easy and inexpensive to temporary get extra…
