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

I Forgot

Member
Registered
Joined
Apr 19, 2016
Messages
15
Points
0
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

Well-known member
Registered
Joined
Apr 3, 2015
Messages
1,027
Points
83
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

Member
Registered
Joined
Apr 23, 2016
Messages
16
Points
0
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

Member
Registered
Joined
Mar 10, 2016
Messages
17
Points
0
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

Member
Registered
Joined
Apr 19, 2016
Messages
15
Points
0
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.

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.

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?
 
Older Threads
Newer Threads
Recommended Threads

Latest Hosting OffersNew Reviews

Sponsors

Tag Cloud

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top