… 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: High availability for MySQL on Amazon EC2 – Part 4 - The instance restart script
August 19, 2010 By 6 Comments
… the MySQL EC2 instance if running Make sure the MySQL EC2 instance is stopped Prepare the user-data script for the new MySQL EC2 instance Launch the new MySQL instance Make… Broadcast the new MySQL instance IP to the application servers Kill the MySQL EC2 instance In order to kill the existing MySQL EC2 instance, we…
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: 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 64 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 24 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…
Post: What attendees are saying about Percona Live NYC ?
September 19, 2012 By Leave a Comment
…) Percona engineers. Percona Live goes above and beyond simply a MySQL conference. I can always count on enjoying presentations on surrounding… event and hope to see you there!” Sean Hull, Senior MySQL EC2 & Scalability Lead have written while essay on the topic: “What… foyer, I ran into all sorts of luminaries in the MySQL space. Percona folks like Peter Zaitsev & Vadim Tkachenko, plus other…
Post: Clarification on MySQL security vulnerability
June 19, 2012 By 2 Comments
… XtraDB Cluster binaries, similar to other MySQL variants, are susceptible to the security vulnerability in MySQL/MariaDB sql/password.c: 64bit Ubuntu… Server ONLY on some hardware/virtualization platforms (confirmed on Amazon EC2 but not on HP Cloud). Neither older nor newer Ubuntu… version of Percona Server, Percona XtraDB Cluster, or any common MySQL variant to minimize security vulnerabilities.
