search

compbio-UofT / medsavant

MedSavant is a search engine for genetic variants
22 stars 9 forks source link

Database cannot be run on a separate machine from server #340

Open meatcar opened 10 years ago

meatcar commented 10 years ago

There are multiple issues with running MedSavant Server on one machine, and the database on another. Such a configuration would be needed to scale the database to a multi-node cluster, for handling larger datasets.

The issues are as follows:

  1. Both the DB and the server require access to tmp-dir. The DB requires it for dumping and re-loading tables, the server for it's own purposes. However, the presence of this folder is required on both the server and DB machines. Eliminating this dependency should sufficiently decouple the DB machine from the server machine.
  2. Since we are accessing the DB over the network, and are piggy-backing on the DB user-management system, each user has to have permissions to be accessed over the network from any host, not just localhost. This is done by UPDATE mysql.user SET host = "%" WHERE user = "$USERNAME";.
meatcar commented 9 years ago

Also, inserting data into Infobright Community Edition requires writing to a file that the database can access.