[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