: Does remote mysql work directly to users? Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql

Posted in: #Mysql

Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql data would be transfer directly to the users, but apparently it does not. My bandwith graph spike to 50Mbps extra from the MySql server keep repeatably hitting my server, I assume that the MySql server first transfer back to main site then transfer data to users. Why does it do this or am I just doing it wrong? Is this how remote MySql work? Any help is greatly appreciated. Thanks.

10.01% popularity Vote Up Vote Down

: How to read Google Analytics events data? My question is about Android application button press tracking, but I believe there is no big difference with button press on the web page, so I ask

@Nimeshi995

Posted in: #Android #EventTracking #GoogleAnalytics

1 Comments

: Minimize downtime moving from godaddy to route 53 I have an A record in GoDaddy pointing to my web server. I want to move this now to Route 53. The last time I did this it took almost

@Nimeshi995

Posted in: #Dns #Godaddy #Route53

1 Comments

: 301 redirected an entire website 4.5 months ago; still showing up in Google search results? Consolidated two websites on December 9, 2013; a site wide page-to-page 301 redirect was implemented

@Nimeshi995

Posted in: #301Redirect #GoogleSearch #GoogleSearchConsole #Redirects #Seo

5 Comments

: Htaccess redirect to public folder caught in authentication I have an .htaccess file at the root of my server which has auth on it. I have a redirect statement that upon entering example.myserver.com

@Nimeshi995

Posted in: #Htaccess

1 Comments

Login to post a comment!

1 Comments

Sorted by latest first Latest Oldest Best

@Murray432

The frontend of your website depends on the mysql server to function. The user doesn't connect to the mysql server directly, your webserver connects to the database to get the database data the user requests. Think of the webserver as the static middleman between the end-user and dynamic data. The user connects to the webserver, then the webserver connects to the database. The webserver then relays the information back to the end user.

If the end-user connected to the database directly you'd likely have a major security issue.

10% popularity Vote Up Vote Down

Feed

: Does remote mysql work directly to users? Recently I started moving my MySql to a remote server to offload the load and bandwith. I thought that when a users connect to the site, the MySql

More posts by @Nimeshi995

: How to read Google Analytics events data? My question is about Android application button press tracking, but I believe there is no big difference with button press on the web page, so I ask

: Minimize downtime moving from godaddy to route 53 I have an A record in GoDaddy pointing to my web server. I want to move this now to Route 53. The last time I did this it took almost

: 301 redirected an entire website 4.5 months ago; still showing up in Google search results? Consolidated two websites on December 9, 2013; a site wide page-to-page 301 redirect was implemented

: Htaccess redirect to public folder caught in authentication I have an .htaccess file at the root of my server which has auth on it. I have a redirect statement that upon entering example.myserver.com

Login to post a comment!

1 Comments

Back to top | Use Dark Theme