[GRLUG] Hosting ideas

[Tim Schmidt]

On Fri, Mar 21, 2008 at 10:47 PM, Michael Mol <mikemol at gmail.com> wrote:
> I run a site called Rosetta Code.  It's a fairly active wiki, with
>  around 500 edits per week and around 10,000 page views per week,
>  sometimes more.  Currently, the database weighs in at about 130MiB.
>
>  Combined the database size, my shared hosting account at Bluehost, and
>  my desire to do backups, and you get a problem.  See, this evening I
>  wrote a script that would run mysqldump on the database and save it to
>  my home machine.  Problem is, running mysqldump on that database on
>  that server* causes sites to start spitting HTTP 500 errors, and my
>  account gets suspended for a minute until the CPU utilization sliding
>  window passes.
>
>  * Bluehost has the MySQL server and Apache server on the same box for
>  any given account.
>
>  So I can't exactly automate it without taking down my site (and
>  possibly many others) each time.  I need to find different hosting for
>  Rosetta Code.  Preferably something that won't choke when I pull
>  100+MB of data out of the database every morning over an SSH
>  connection.

You could pipe the mysqldump output through something to throttle
it...  bzip2 comes to mind, but that wouldn't lower your CPU
utilization.  Sure seems like something < 5 lines of perl could get
done though.

--tim