Posted by ivan25 on May 22, 2010 at 11:56am
Amazon is providing MySQL hosting through RDS.
It comes with very interesting features (Automated Backups, DB snapshots, multi AZ deployments) out of the box.
Is it an interesting alternative to setting up your own MySQL on EBS as it may require less administration and can scale easily ?
Comments
No
There's no way to bundle/script this, and there's limited control over the RDS configuration. We wouldn't me adding much PANTHEON magic, even if we could set it up to roll out.
However, if you have the skill to set up an RDS instance (this requires the use of Amazon's command-line tools) it's pretty trivial to install your Drupal on it. It behaves just like any other remote DB host. The ability to scale-up your database instance with only a few minutes of downtime is pretty attractive. :)
https://pantheon.io | http://www.chapterthree.com | https://www.outlandishjosh.com
hi
This is a interesting way for backups ... at the moment i have a problem doing my snapshot and i cant restore my database whe a instance go down but ... i can do it i think i hope:)
http://developer.amazonwebservices.com/connect/entry!default.jspa?categoryID=112&externalID=1663&printable=true
Martinhal, are you trying RDS
Martinhal, are you trying RDS or just setting up EBS + MySQL ?
I need to find time to test RDS. Data persistency on EC2 is somehow scary :)
Im looking for the best
Im looking for the best option i was trying RDS too .ivan25 i think the first i have success i will use !! :) but is cheapest the mysql + ebs because i havent a rds instance running .in that case i have a volume .i have a mercury running on a EBS and another volume for mysql snapshots ... im working in it ! :)
@Josh, Amazon just rolled out
@Josh, Amazon just rolled out the RDS Web admin. Makes it a little easier to handle than only through the command line.
RDS is a service
RDS is a very particular Amazon-only service, can't be "packaged" and in all likelyhood won't ever be a part of PANTHEON.
However, migrating your own setup to use an RDS database is trivial if you know what you are doing. Just dump the database, load on RDS, and update your settings.php. Anyone who's ever set up Drupal by hand can do this. It doesn't need to be a part of this project.
https://pantheon.io | http://www.chapterthree.com | https://www.outlandishjosh.com
How to switch off local MySQL
@joshk, those using RDS should also be able to avoid any overhead from the Pantheon's local MySQL and perhaps related services that are not needed. Could you suggest what should be turned off and how? Thanks.
---
Tomáš J. Fülöpp
http://twitter.com/vacilandois
re: How to switch off local MySQL
The short answer is to turn off mysql but running "/etc/init.d/mysql stop" or "service mysql stop". I would also reconfigure memcached to use RDS (if that's even possible) or turn it off too with "/etc/init.d/memcahced stop".
The long answer is that BCFG2 will check these processes when it's run and start them if they are not running. This behavior can be changed in /var/lib/bcfg2/Rules by changing "On" to "Off" for those 2 services (the name of the file in /var/lib/bcfg2/Rules depends on the version of Mercury you're using).
However, running /usr/local/bin/update_mercury.sh will overwrite that file which any updates from our launchpad site. So, we probably need to add a variable or 2 to /etc/mercury/server_tuneables that tells BCFG2 if the services should be on or off...
We'll figure out a long-term solution and post it here but you have some short-term solutions above in the meantime.
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com
Thanks for the explanation
Thanks for the explanation Greg.
re: How to switch off local MySQL - updated
Mercury 1.1 (which is in Beta) now support turning Mysql and Memcached off via the /etc/mercury/server_tuneables file.
Greg
--
Greg Coit
Systems Administrator
http://www.chapterthree.com
re: How to switch off local MySQL
Greg, I note, with thanks, that it will be possible to switch off MySQL in /etc/mercury/server_tuneables. I don't see that option in ami-6d3c1619, which is Mercury 1.1, but I guess an older one. I assume I will see the new server_tuneables when you release stable Mercury 1.1 AMI.
You have puzzled me however with this:
Why would I need to switch off memcached if I use RDS? I thought memcached does just the same as Drupal/Pressflow cache would do, but in memory. Looking at my memcached monitor, it is full of data, so I have assumed it is working fine. E.g. right now it says: Hits: 1118438 (90.4%).
(And if there is some brick-wall reason why memcached cannot work with RDS in Mercury, do you - or other members of this group - know how to re-configure Mercury's memcached to play nice with RDS? Thanks!)
---
Tomáš J. Fülöpp
http://twitter.com/vacilandois
RDS is perfect only you have
RDS is perfect only you have to point the database to your rds instance.
ivan25 i think to work with
ivan25 i think to work with RDS you need terminal use for example when you want to run a instance from snapshot you need it. we admin Console maybe not finished.
Anyone tried this?
I'm considering setting up RDS with Mercury. I'd be curious if anyone is using this setup?
If so, how well does it perform? Any setup tips ( on the RDS side ) ?
I've heard that RDS has
I've heard that RDS has horrid performance. What's the real story?