An initial version of Waffle Grid Cream – Version 0.5 release is now available.
We have elected to create one AMI for now, that is ready to be configured as either a MySQL Server, a memcached server, or as in the following example both. For this first version, we have also not configured MySQL or memcache, but rather provide a virgin Waffle Grid ready server for developers to experiment and benchmark with.
Future releases will include custom AMI’s and the automated ability to register new memcached servers with the Waffle Grid enabled MySQL server.
We assume you have created an EC2 account and are using one of the many tools available to launch images.
The AMI you want to launch is ami-0575936c. This is an Ubunut Intrepid 8.10 32bit small instance, and includes MySQL 5.4.0 beta and Memcache 1.4.0 RC1.
$ ssh -i [key] ubuntu@ec2-[hostname] $ ps -ef | grep -e "mysql" - "memcached" $ memcached -m 1024 -p 11211 -u nobody -l 127.0.0.1 -d $ memstat -s localhost $ sudo /etc/init.d/mysql start
$ mysql -uroot -e "SELECT VERSION" $ mysql -uroot -e "SHOW ENGINE INNODB STATUS\G"
The Innodb Status shows a new section.
--------- MEMCACHED --------- Memcached puts 0 Memcached hits 0 Memcached misses 0 Memcached Prefix: 3576
$ mysql -uroot -e "SELECT COUNT(*) FROM sakila.actor" $ mysql -uroot -e "SHOW ENGINE INNODB STATUS\G" $ memcached -s localhost
Verification will show the change of information in the INNODB STATUS output.
--------- MEMCACHED --------- Memcached puts 4 Memcached hits 0 Memcached misses 4 Memcached Prefix: 3576 Memcached Miss Total Lat 103 (us) Memcached Miss Recent Lat 103 (us) Memcached Set Total Lat 760 (us) Memcached Set Recent Lat 760 (us)
You can also confirm stats in memcached.
$memstat -s localhost Listing 1 Server Server: localhost (11211) pid: 3453 uptime: 575 time: 1245013741 version: 1.4.0-rc1 pointer_size: 32 rusage_user: 0.0 rusage_system: 0.0 curr_items: 5 total_items: 5 bytes: 82265 curr_connections: 6 total_connections: 9 connection_structures: 7 cmd_get: 4 cmd_set: 5 get_hits: 0 get_misses: 4 evictions: 0 bytes_read: 82265 bytes_written: 82265 limit_maxbytes: 1073741824 threads: 5