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

Joined
Apr 19, 2016
Messages
15
Best answers
0
Ratings
1
Points
0
#1
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
Joined
Apr 3, 2015
Messages
1,027
Best answers
1
Ratings
419 3
Points
83
#2
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!
 
Joined
Apr 23, 2016
Messages
16
Best answers
0
Ratings
1
Points
0
#3
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
 
Joined
Mar 10, 2016
Messages
17
Best answers
0
Ratings
4
Points
0
#4
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.
 
Joined
Apr 19, 2016
Messages
15
Best answers
0
Ratings
1
Points
0
#5
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
Latest Threads
Replies
0
Views
10
Replies
1
Views
28
Replies
4
Views
76

Latest Hosting OffersNew Reviews

Sponsors

Latest Blog ArticlesMost Viewed Threads

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