Re: Connecting from PHP to MySQL on another Server
| From: | Jon Farmer | Date: | Thu, 17 Jan 2002 12:50:10 +0000 |
| Subject: | Re: Connecting from PHP to MySQL on another Server | ||
| References: | 1 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-15929@lists.php.net to get a copy of this message | ||
> 1. What is the difference between working with PHP and MySQL on a local
> server and working with PHP and MySQL when MySQL is on a remote server
None in terms of functionality.
> 2. What is the protocol used to connect to MySQL on a local server and
> what is the protocol used to connect to a remote MySQL server?
On the local machine a client (PHP is a client) can connect through unix
sockets or TCP (3306). On a remote machine its TCP only. Unix sockets access
is faster than TCP.
> 3. Is there a difference in performance between connecting from PHP to
> MySQL on a remote server or PHP to MSSQL Server?
See above answer. Also you have any TCP/IP overhead to add on.
Regards
Jon
--
Jon Farmer
Systems Programmer, Entanet www.enta.net
Tel 01952 428969 Mob 07763 620378
PGP Key available, send email with subject: Send PGP Key