[OSM-dev] Data corruption :) II

[Andy Allan]

On Mon, Nov 24, 2008 at 11:29 AM, Stefan de Konink <stefan at konink.de> wrote:

> Are you saying you are not more pissing people off with bad data than with
> fixing all constraint problems; and adding a foreign key constraints?
>
> A maintaince window is very typical. So one way or the other. It would be
> good to start thinking about multiple api servers, (maybe take
> ROMA/HandlerOSM/etc. to compensate for your downtime), and for now leaving
> the others readonly while the read-write version is secured.
>
> I don't really see a problem in this.

That's because you don't understand the current situation. Care to
enlighten everyone with how you are going to add constraints to MyISAM
tables?

I know that you've implemented the API in a different language on a
different db, but that's got very little relevance when talking about
how to operate the current db with the current rails code. Maybe you
should start your thought process with "they are probably doing things
in a particular way for good reasons", and then if you are interested
in finding out what those reasons are, go ahead and ask, read the
code, and find out more.

Cheers,
Andy