[OSM-talk] Database Maintenance

Lester Caine lester at lsces.co.uk
Mon Jul 30 12:53:37 BST 2007


Tom Hughes wrote:
>> Of cause what would help would be proper replication to multiple sites. If 
>> implemented properly this would also allow structural changes to be made via 
>> the replication process.
> 
> Please do explain how. I did actually consider this and decided that
> there wasn't any way to use MySQL replication to do it more easily.
> 
> My understanding is that MySQL replicates schema changes, so you just
> wind up with all the slaves and the master all trying to make the same
> schema change at the same time...

The problem here is that MySQL is simply not designed to handle these sorts of 
sizes of databases. Perhaps in the future it may be able to cope, and that is 
why MySQL have poached Jim Starkey away from Interbase/Firebird - to actually 
make it work.

I would be looking to replicating to alternate database engines - Postgres if 
you must, or Firebird. With the right API it should not matter which engine is 
actually serving up the data.

The main point here is that - YES OSM is strapped for hardware - but there are 
many people around who have spare capacity who could mirror if that was 
brought into the equation.

-- 
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php




More information about the talk mailing list