Redshift spinup/shutdown script about sqlalchemy-redshift HOT 6 CLOSED

No technical blockers, the current test script was just an MVP to get running quick

from sqlalchemy-redshift.

let's have a chat about this on IRC. We need a very locked down AWS that can only create/delete redshift instances, then it should be just some boto magic.

from sqlalchemy-redshift.

I'm logged into freenode and on #sqlalchemy and will plan to be so for the rest of the day.

from sqlalchemy-redshift.

@jklukas I've started work on bigcrunch (it stops redshift, get it?)

https://github.com/graingert/bigcrunch/blob/master/bigcrunch/__main__.py

It's a heroku service, and at the moment it supports spinning up the service, adding a test session, and removing tests sessions when they are done.

Currently I've tested that creating a test session when the database server still exists.

Not implemented is shutting down the server on an hourly job when there are no unexpired sessions.

from sqlalchemy-redshift.

Just a note that Bigcrunch seems to be doing its job. I was just looking at AWS billing, and we've only used $3.50 worth of Redshift so far this month. 👍

from sqlalchemy-redshift.

woop woop, it's a bit glitchy and there's some really obvious error handling I need to insert. But I'm happy restarting the build if you are!

from sqlalchemy-redshift.