mysql remote connection is very slow

Virtual private server discussion and vps hosting solutions. Review VPS hosting providers and offer advice on virtual web hosting solutions.
Post Reply
harrington
Newbie
Posts: 2
Joined: Thu Nov 09, 2017 8:30 pm

Fri Nov 17, 2017 7:53 pm

Hello, 

I have a VPS Server with WHM for administration, 
a user to whom I gave a hosting account, I connect their own desktop system in windows, with a mysql database created in our vps server, the remote connection is satisfactory, but It is very slow. What do you recommend to improve the speed of this connection or what other solution alternatives recommend me to implement. 

Regards,


derrick
Newbie
Posts: 2
Joined: Sat Sep 30, 2017 9:09 am

Fri Nov 17, 2017 8:03 pm

Hello,

I am a developer and whenever I am consulted I recommend not using a remote connection via internet to a database from a desktop application, in any case it is more optimal to use web services, the direct connection is through sockets and the base data is needed to be very stable, the remote being latency is not very good and makes the database client has microcuts with reconnection processes that makes everything very slow.
RackService
Newbie
Posts: 1
Joined: Sat Nov 18, 2017 4:35 am

Sat Nov 18, 2017 4:37 am

From which location to which location are you connecting? This may not be related to the server but to the network speeds between those two services.
ronnel
Junior Member
Posts: 13
Joined: Sat Sep 29, 2018 1:10 am

Fri Oct 05, 2018 2:43 pm

In this case, you should check your internet connection speed. And if it is possible, try to download or export your database, then do all your operations, then update it online. Or work on the database on the web server online. But if you are sure, you have a good internet speed, and that you are not working in a period when the server his highly solicited, then you can proceed.
User avatar
raffm
Newbie
Posts: 5
Joined: Mon Sep 03, 2018 4:54 pm

Mon Oct 08, 2018 3:36 pm

Not sure how much RAM do you have on the server, as the server resources including ram, storage, bandwidth, are the important factors that affect load website load speed and various connection speed. So, make sure you have sufficient server resources for the tasks you're performing. Also, a client control panel, for example, VPSrobots, would be a better choice for the small-sized servers, as the web-based WHM you installed on your server actually consumes around 1-1.5G RAM on your server.
Post Reply
  • Information
  • Who is online

    Users browsing this forum: No registered users and 1 guest