Ask HN: how to push to a live site?
So I've read a fair amount of books and links on the internet describing how to scale stuff. Something I haven't come across are general strategies on pushing to a live CRUD site without taking it down. Can anyone point me to resources that I've missed, or perhaps just tell me?
15 comments
[ 2.9 ms ] story [ 36.4 ms ] threadSVN also has some documentation on their site, and I imagine git would have something similar.
- Scalable Internet Architectures (Developer's Library) by Theo Schlossnagle
http://philip.greenspun.com/seia/
... and a whole buncha links on google with "scaling", although "scaling mysql" seems especially popular
I imagine there are similar solutions for other languages.
Worst case scenario, you can roll your own. A very basic trick is to use symbolic links on your server - deploy the site to a new folder, and simply point the symbolic link to the new folder when you're done.
Capistrano is great. I've used it to great success deploying Django(Python) apps to complex environments.
A long time ago I worked (in a very small testing capacity) at a very large video/streaming media serving company.
As I recall, the scripted procedure was to tag a release in CVS, and a script would pull that down into a new directory and swing the symlink.
This site had a very mature and infrequently changing billing system code path, which I believe was not modified in this process. If this doesn't describe your workload you would probably have to change this to support concurrent execution of multiple versions for people who have a session established
Approach 2)
Using any mainstream hardware load balancer (or presumably a similarly featureful free/open software LB), configure it to point at N+1 machines in a cluster. Administratively remove machines from the new session pool one at a time (virtual machines can make this flexible and easy to roll back). Once the established sessions have expired or been forced out, upgrade the software and roll them back in.
One neat aspect of this approach is if you have an "oh shit" hockey stick scaling issue, you can watch it happen on one machine before deploying it to every machine in your cluster. Also good for A/B testing, as mentioned in recent articles here.
If you're smart you can orchestrate db changes non-destructively. If less smart use capistrano.
This is fine if you are paid by the hour.
The smarter way is to make changes that span codebase versions. You want to normalize a table so entities can have more than one address? Build an addresses table crosswalked to entity id and let the new code use it. Once you're happy with it you can drop some columns, but if you need to roll back, you haven't thrown anything away.
To me the difference is like that between hiring a hooker and charming a cheerleader. Either way you should make backups. ymmv.
Although maybe what you are saying is that you can make 'dumb' sql changes which break compatibility with past code vs 'smart' sql changes and code changes which are backwards compatible?
We wrote a little custom code (we call it "bake") for deploying Cappuccino applications:
"bake": http://github.com/280north/cappuccino/tree/master/Tools/bake...
sample "bakefile": http://github.com/280north/cappuccino/tree/master/Tools/bake...
It pulls your code from git (but could easily do local files, scp, rsync, svn, etc), runs an optional build command (like "ant"), copies source paths to destination paths in a deployment directory, gzips the deployment directory, scp's the code to your server(s), ungzips it, and does a little magic...
Each version is placed in it's entirety in a uniquely named (unix timestamp) subdirectory. We could just redirect from "/" to "/1221268756/" (for example) but that's incredibly ugly, so we use the little known HTML <base> tag to trick it. The index.html file in "/" is identical to the one in "/1221268756/" except it has a <base> tag which tells the app all URLs are relative to "/1221268756/" instead of the default containing directory ("/").
And it actually seems to work really well. The big advantage of this is you can set your cache expire date arbitrarily far in the future, and your entire app will be cached until you change index.html to point to a new <base>. 280 Slides, which is ~2.6MB uncompressed, loads on my computer in about 1.5 seconds if it's cached. The only problem with this approach is when you deploy, all clients will have to re-download every resource, even ones that don't change. A more granular system would be ideal, but significantly more complex.
I looked at Capistrano briefly but decided against it for some reason I can't remember. Perhaps that would have been better, but c'est la vie...