I am sure this is a synaptic disconnect, but I can't seem to get my head around this one.
I have remote Zopes (call them "A", "B", "C" ) and a database server ("D"). I also have a bunch of mysql databases. All of the machines run mysql. All the Zope instances share the same Data.fs connected via Zeo. The two cases of interet are how to access a local database, that is, one the same machine as the running Zope, and, how to access a remote mysql database. ZMYSQLDA provides a static binding to connections. MYSQL grants access privileges based on source IP address. So, here are my questions: 1. When I open a database connection with the connection string -u dbroot -h localhost -passwd mypassword what machine is accessed? I'm presuming localhost is always the local machine. Is that correct? 2. How do I open a remote database connection so it works transparently across multiple instances of Zope? The Zope code, shared across instances, uses a single connection with a connection string like -u dbroot -h 192.168.0.3 -passwd somepassword Presumably each of the remote machines (and the database server if it runs Zope) needs an entry in the grant table. And all the database connections need to share the same password. Right? 3. Since queries are bound to their connection, there appears to be no easy way to manage connections in a simple way programmatically. Any help/comments much appreciated. _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )