It is possible to use Mysql sever out of your hosting server?

I Forgot · Apr 19, 2016

As title mentioned, it is possible to use mysql server (databases) from another hosting provider.

I.e, I want to host my php sites in a hosting and connecting to mysql server on another hosting? if yes, how to do?

RDO Servers · Apr 19, 2016

I Forgot said:
As title mentioned, it is possible to use mysql server (databases) from another hosting provider.

I.e, I want to host my php sites in a hosting and connecting to mysql server on another hosting? if yes, how to do?

Possible, yes.
Recommended, no!

Consider the latency between the two hosts. Even a short 50ms latency, can really slow your website down when your loading pages that require multiple database queries!

batamwebhosting · Apr 23, 2016

I Forgot said:
As title mentioned, it is possible to use mysql server (databases) from another hosting provider.

I.e, I want to host my php sites in a hosting and connecting to mysql server on another hosting? if yes, how to do?

why you want to do that? as RDO said it is possible but usually for this kind of things you want it to run locally.... if you use remote sql the load time for your web page will take much more time...

for example if you have 50ms to your remote sql connection that means your adding another 50ms to your load time...

and also you'd run out of bandwith more quickly

praveenk · Jun 22, 2016

I Forgot said:
As title mentioned, it is possible to use mysql server (databases) from another hosting provider.

I.e, I want to host my php sites in a hosting and connecting to mysql server on another hosting? if yes, how to do?

Yes, you can use it but its depend on your hosting provide , if they allow remote mysql connection or not.

In mysql database configuration file simply change mysql server name from localhost to remote mysql server IP address and you are ready to make connection from php files hosted server to remote mysql database server.

Let me know, if you face any issue.

I Forgot · Jun 23, 2016

RDO Servers said:
Possible, yes.
Recommended, no!

Consider the latency between the two hosts. Even a short 50ms latency, can really slow your website down when your loading pages that require multiple database queries!

I will keep this in mind.

batamwebhosting said:
why you want to do that?

I just want to swtich to another host for using mysql server, in the case, the current hosting is downed.

praveenk said:
Yes, you can use it but its depend on your hosting provide , if they allow remote mysql connection or not.

In mysql database configuration file simply change mysql server name from localhost to remote mysql server IP address and you are ready to make connection from php files hosted server to remote mysql database server.

Let me know, if you face any issue.

Could you please share me codes or how to do this in details?

It is possible to use Mysql sever out of your hosting server?

I Forgot

Member

RDO Servers

Well-known member

batamwebhosting

Member

praveenk

Member

I Forgot

Member

Latest posts New threads

Latest posts

New threads

Latest Hosting Offers New Reviews

Latest hosting offers

Popular Contributors - Past 30 Days

Sponsors

Tag Cloud