I'm having to install MysqlDb on a webserver that is going to hold the mysql files on a seperate webserver. How do I do this?
I've tried to mount /usr/lib/mysql onto the webserver from the sqlserver, however the mount command keeps timing out, I think because there is a firewall between the sql server and the web server. I'm having a port opened, so that the mount command can connect. Will this solution work? or am I going to run into more trouble?
Is there a way to install mysqldb with the mysql_config file stored on another server?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
That's how the client configured their server. I'm not sure why they have it that way. I should have noticed this before they built their servers. Granted they are virtual servers, so it wouldn't be much of a change, but at this point, it's not a change I think they are willing to make.
For this problem, I'll try to install MySQL on the web server, and install mysqldb that way. Hopefully it works. Thanks.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think what adustman is suggesting is to run the MySQL server on the machine where the files are and then connect to it via a normal database connection.
If your MySQL base directory (where mysql.cnf, the log files, and the databases live) is on an NFS mount, you'll probably experience very poor performance (see http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html), and you may experience data integrity issues when performing administrative operations because file locking generally doesn't work with NFS.
Why is it that you want to run the MySQL server program on a different server than the one where the files live?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I'm having to install MysqlDb on a webserver that is going to hold the mysql files on a seperate webserver. How do I do this?
I've tried to mount /usr/lib/mysql onto the webserver from the sqlserver, however the mount command keeps timing out, I think because there is a firewall between the sql server and the web server. I'm having a port opened, so that the mount command can connect. Will this solution work? or am I going to run into more trouble?
Is there a way to install mysqldb with the mysql_config file stored on another server?
That's how the client configured their server. I'm not sure why they have it that way. I should have noticed this before they built their servers. Granted they are virtual servers, so it wouldn't be much of a change, but at this point, it's not a change I think they are willing to make.
For this problem, I'll try to install MySQL on the web server, and install mysqldb that way. Hopefully it works. Thanks.
This sounds like an extremely bad idea. Why not just use a TCP connection to the database server?
I need the mysql_config file, so How would I get it through a tcp connection?
I think what adustman is suggesting is to run the MySQL server on the machine where the files are and then connect to it via a normal database connection.
If your MySQL base directory (where mysql.cnf, the log files, and the databases live) is on an NFS mount, you'll probably experience very poor performance (see http://dev.mysql.com/doc/refman/5.1/en/multiple-servers.html), and you may experience data integrity issues when performing administrative operations because file locking generally doesn't work with NFS.
Why is it that you want to run the MySQL server program on a different server than the one where the files live?