… replicate an RDS instance to an external server (or even EC2). While it is annoying, this post isn’t going to… will just run the following to resume replication: replica> CALL mysql.rds_skip_repl_error; master> DROP DATABASE percona; Note: If you are running an earlier MySQL version and it does not have the rds_skip_repl…
Comment: Death match! EBS versus SSD price, performance, and QoS
February 27, 2011 By 55 Comments
… in progress to make it easier to run MySQL on local storage in EC2? Is Amazon or Rackspace interested in sponsoring such… some downtime but prefer not to lose transactions then run MySQL on EC2 local storage, use XtraBackup to store backups on EBS…
Post: Percona Server with XtraDB Case Study, Behind the Scenes
October 21, 2010 By 13 Comments
… customer, ideeli, had a database that was struggling on standard MySQL and InnoDB. The big win was the upgrade to XtraDB…. Nothing more could be done without fixing these problems inside MySQL and InnoDB at the source code level, or changing the…. However, remember that this database is running on an EC2 server. EC2 has relatively slow virtual CPUs, and given that and the…
Post: Comparing Percona XtraDB Cluster with Semi-Sync replication Cross-WAN
June 14, 2012 By 7 Comments
… against each other. Test Environment The test environment included AWS EC2 nodes in US-East and US-West (Oregon). The ping… may be improvable by some Galera tuning. UPDATE: latency between EC2 nodes, even within the same availability zone seems to average… availability and disaster recovery than semi-synchronous replication in stock MySQL.
Comment: Percona replication manager (PRM) documentation available (beta)
June 8, 2012 By 5 Comments
… stuff! We are looking to implement an HA mysql solution built upon EC2 for one of our customers and I noticed your… you can point me to which hooks pacemaker up with EC2 or Route53? thx. Jeremy
Comment: How to replace a NDB node on EC2
June 9, 2011 By 10 Comments
… the Sun MySQL consultants a few years ago. This comes from a customer that has 100% of its infrastructure on EC2. I… for that. I am not saying that NDB cluster on EC2 performs better or even that it is on par with…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
….com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
….com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance…
Post: InnoDB Flushing: a lot of memory and slow disk
March 31, 2011 By 57 Comments
… that, unfortunately, none of the existing flushing implementations (including both MySQL native adaptive flushing and that in Percona Server) can handle… (these are the periods of zero throughput on the graph). MySQL‘s general recommendation for this case is to increase innodb… systems where I/O capacity may vary a lot, like EC2 systems, or is affected by periodic tasks like backup or…
Post: The perils of InnoDB with Debian and startup scripts
January 28, 2009 By 13 Comments
…? You might want to disable /etc/mysql/debian-start. When you run /etc/init.d/mysql start it runs this script, which… a lot of tables. And they’re running on Amazon EC2 with 8G of RAM and EBS storage, which is slower… index read, thread declared inside InnoDB 500 mysql tables in use 7, locked 0 MySQL thread id 6424, query id 1579718 10…
