[ZODB-Dev] Gadfly with ZEO clients - anyone trying this?

[Chris McDonough]

I don't think Gadfly is a client-server application.  In other words,
it's limited to running on one system.  I'd suggest MySQL, Postgres,
Firebird, or another relational database that does support the
client-server model.

On Wed, 2004-02-25 at 12:45, Ken Wasetis wrote:
> Hi,
> I've built a prototype using Gadfly as storage for some contest data 
> acquired via Formulator forms via ZPT.  I developed this on a test 
> server running a ZEO client and ZEO server.  Everything works fine with 
> just one ZEO client.
> 
> The problems comes when I try to run multiple ZEO clients (which my 
> production environment has), due to the fact that when we add a 
> ZGadflyDA connection, it creates its storage files within 
> $CLIENT_HOME/var/mydatabase.
> 
> Since it creates the database within the filesystem of a ZEO client 
> (client home) rather than the /var folder on the ZEO server, in 
> production, where the ZEO server is on a different machine than the 
> multiple ZEO clients (on multiple different servers), only the ZEO 
> client where the Gadfly database is stored can connect to it and execute 
> queries.
> 
> Has anyone modified the Gadfly DA.py or db.py files to specify a remote 
> storage (ZEO Server) location/var rather than the location zeo client 
> /var folder for storing Gadfly databases?  Or possibly modified 
> App.config to add a SERVER_HOME or modified one of the other _HOME 
> environment variables?
> 
> I'm sort of surprised that I couldn't find any information on people 
> using Gadfly in a ZEO client/server (specifically, with multiple 
> machines) situation.  If you know of a reference, please help me out.
> 
> If I were to continue to use Gadfly, the most likely scenario would 
> involve me creating a ZEO Client instance on the machine running the ZEO 
> Server/ZODB and this instance would have the Gadfly connection defined. 
>   Then, I'd somehow use ODBC to connect to that database from all the 
> ZEO Clients on the other machines.
> 
> If I must go through the process of hacking to create a centralized 
> Gadfly, I will look more strongly at using MySQL or some other database 
> as the centralized database, I think.
> 
> Any help is appreciated,
> 
> -Ken
> 
> 
> 
> _______________________________________________
> For more information about ZODB, see the ZODB Wiki:
> http://www.zope.org/Wikis/ZODB/
> 
> ZODB-Dev mailing list  -  ZODB-Dev at zope.org
> http://mail.zope.org/mailman/listinfo/zodb-dev