Re: [Sqlgrey-users] Distributed DBs

[Lionel B. <lio...@bo...>]

Ray Booysen wrote the following on 21.06.2005 10:05 :

> Hi all
>
> Has anyone done any testing with distributed sqlgrey databases?  What
> I mean is that there are multiple machines running sqlgrey connecting
> to the same MySQL database on a single machine.


This is the configuration used in production by my employer (but with
PostgreSQL). Runs fine with 2 SQLgrey instances.

There is an an harmless race condition when 2 SQLgrey instances want to
create the same entry in connect. I've seen it only once in the logs :
the second SQLgrey instance gets an SQL error for the second INSERT in
the connect table, thinks something is fishy about the database and
reconnects to make sure the database connection is clean. In this case
you get an error message in the logs and a mail (if the admin_mail entry
is properly configured).
I'll clean this in the future and will do it ASAP if this becomes a
problem for someone (too much errors/e-mails).

Lionel.