database and web servers
Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database and web servers
On Thursday 21 March 2002 11:28 am, Klym wrote: Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? You can certainly do this. When you connect to a MySQL database, you generally specify _where_ this database is. That said, network bandwidth may become a significant concern. And no, it isn't a good idea for security. A database should be protected by a firewall that only the web server can get through. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: database and web servers
As long as you've got a fat pipe on both ends speed could be ok. But, then again, you never know. Some backhoe in Nebraska could cut your sweb server off from your database. Of course you'll want it to be secure as well. MySQL 4 has support for SSL. I suppose you could setup an ssh port redirection vpn-like system to use with MySQL 3.23 or such. But, it all depends on your needs, your site's traffic, etc. Experiment. :) - Gabriel Klym wrote: Is it possible to have your web server and your MySQL server running at different geographic locations? I'm wondering if I can run my own MySQL server here at home on Linux and have my web site use PHP to connect to it and extract data. Is that a bad idea for security and speed? thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php