[OSM-dev] MySQL backup

[Andreas Brauchli]

On Mon, 2007-01-15 at 15:52 +0000, Nick Hill wrote:
> Hello Andreas
> 
> What sort of overhead does LVM introduce to I/O?
i can't tell you that i've barely used it, maybe someone else can answer
that for me.

> 
> We take backup snapshots for the database every Friday and Tuesday. The database 
> is off-line for around 4-6 minutes while this is done.
with the lvm process it would just be read-only, not completely offline
- although 4-6min isn't that bad

> 
> We could automate a process whereby the backup is copied to another machine then 
> a planet.osm made from it.
> 
> Steve, does the generation of planet files generally go smoothly, what is the 
> exact process you use to make planet dumps? Do you think it'll be a good idea to 
> automate the process on cron?