4 ms·
This is possible using the S3 storage engine for MySQL, which is currently in beta. Your database lives on S3, your hosts live in EC2 Xen VMs. As I understand
by nailer 19y ago
This is possible using the S3 storage engine for MySQL, which is currently in beta. Your database lives on S3, your hosts live in EC2 Xen VMs.
As I understand it, if your VM is powered off, you lose cached data your database will then start re-pulling from the storage engine.
You can fetch the storage module from here: http://fallenpegasus.com/code/mysql-awss3/ http://fallenpegasus.com/code/mysql-awss3/
Relevant presentation:
http://fallenpegasus.com/code/mysql-awss3/presentations/ http://fallenpegasus.com/code/mysql-awss3/presentations/
Computerworld article: http://www.computerworld.com/action/article.do?command=viewA.. http://www.computerworld.com/action/article.do?command=viewA....
Have I done it? No. It's something I'm investigating for a startup which may have a need for elastic scalability.
My main concern: you'd need a list of consistent speed between S3 and EC2. Any current users know what this is like?