sqlgrey-users

[Sqlgrey-users] Distributed DBs

[Ray B. <rj_...@rj...>]

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.

Regards
Ray Booysen

Re: [Sqlgrey-users] Distributed DBs

[Who K. <qui...@me...>]

My setup runs a single sqlgrey mysql database on the system where my 
primary mx resides.

My secondary and tertiary mx use the same mysql database connecting 
remotely.

Works fine for me.

Ray Booysen wrote:

> 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.
>
> Regards
> Ray Booysen
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users

Re: [Sqlgrey-users] Distributed DBs

[Josh E. <jo...@en...>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Ray Booysen wrote:
> 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.

I have multiple Postfix machines with sqlgrey connecting over TCP to
a single MySQL machine; works great.

J
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (FreeBSD)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCuGE8V/+PyAj2L+IRAk1TAJ9GxLu01z9E7d3ZPp/y9ji/8bMP6QCgrsQy
XNbDHNEDcjtmBzWf+zZpnng=
=Nn2n
-----END PGP SIGNATURE-----

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.