At 12:47 PM -0700 2006-08-02, Jacek Becla wrote:
Keywords: DataAccWG
Attendees: Jeff, Russell, Kem, Sergei, Ani, Maria, Ray, Jacek
mysql on teragrid for DC1
- problems with setup script related to WCSlib/WCSTools,
possible to bypass by removing offending lines
- missing mysqldb python module (I temporarily installed it
in my sandbox)
- apparently there is a pacman script for that already
- catalog ingest service does not allow to configure mysql
socket, and we can't use default sockets because we have
non-standard mysql installation done without root privileges.
I just checked in a version of dbingest that allows one to specify a
socket file.
- socket is used for local connections, outside connections
use host:port. We do want to run catalog ingest service
on the same machine where we run mysql server
I am still puzzled as to why this matters -- unless a firewall
prevents the connection. The dbingest server sends very little data
to the database via its connection. The database reads the actual
data from the data files written by the pipeline. All nodes share a
file system, so the dbingest servers and database servers can run on
any combination of nodes and still ingest data.
(And even if the dbingest and database server run on the same node,
they can still connect using host:port)
Regards,
-- Russell
_______________________________________________
LSST-data mailing list
[email protected]
http://www.lsstmail.org/mailman/listinfo/lsst-data
