Hi!
I am new to DbForge and have purchased the annual subscription. Currently I connect to the Mysql server from a PHP TUNNEL but I notice that the connection and results are very slow. I would like to know what is the best and fastest connection that I can have with the server to have more speed.
Thank you all!
What is the best way to connect (The fastest)
Re: What is the best way to connect (The fastest)
hi,
of course, using PHP as a proxy is the worst type of connection you can choose ;)
every request goes to the webserver, the webserver talks to the PHP-daemon, and the
PHP process finally talks to MySQL and everything has to go back the same way, bad, very bad ;)
the PHP tunnel is something you should use when there is no other option left.
the best option, of course, is a direct connection, without anything between.
but because of safety, MySQL never should be open to the outside world.
so the logical solution is, to connect via SSH directly to your server and from there to 127.0.0.1 to your MySQL, this connection is as fast as using a direct connection, you won´t notice any difference ;)
cheers,
micha
of course, using PHP as a proxy is the worst type of connection you can choose ;)
every request goes to the webserver, the webserver talks to the PHP-daemon, and the
PHP process finally talks to MySQL and everything has to go back the same way, bad, very bad ;)
the PHP tunnel is something you should use when there is no other option left.
the best option, of course, is a direct connection, without anything between.
but because of safety, MySQL never should be open to the outside world.
so the logical solution is, to connect via SSH directly to your server and from there to 127.0.0.1 to your MySQL, this connection is as fast as using a direct connection, you won´t notice any difference ;)
cheers,
micha
Re: What is the best way to connect (The fastest)
Thank you very much Micha for your answer!
I'm already setting up an SSH connection!
I'm already setting up an SSH connection!