As i get ready to take to production mode, I now want to have the MySQL Server and database on another machine for redundant purposes. (in case the server with the website crashes, i have my backup server [which i backup the website onto on a daily basis] ready and pointed to the server with the MySQL database on it to jump in at a moments notice)
Windows Firewall is turned off on all appliances.
The issue im having is that website as a whole is just slower to load down the line when the database is on the remote server.
So to generalize:
main webserver and mysql operating out of the same physical box = good!
main webserver on one physical box, mysql on another physical box= slow
backup webserver virtual machine (vmware) windows server 2016) on one virtual machine and using the msql on the main webserver physical box = slow
backup webserver virtual machine (vmware) windows server 2016) on one virtual machine, mysql on another physical box= slow
backup webserver and mysql operating out of the same vmware windows 2016 virtual machine server = good!
as long as the MySQL is on the same server as the one the website is hosted on, no problems. Otherwise, the site is slow. Works fine, but its slow.
A database should not be on a remote server but rather from the local server to optimize server queries.The issue im having is that website as a whole is just slower to load down the line when the database is on the remote server.
The most generated errors being found on Opencart forum originates from contributed programming. The increased post counters are caused by redundancies of the same solutions that were already provided prior.
Opencart.com Administrator / Quality Assurance Analyst / Programmer
Keep in mind that a mirrored DB (or anything kept in synch with the primary) will be in just as bad of shape as the primary if there is a hack or code problem, or even possibly if there is only a HW problem. You still need to take regular off-line backups of your DB.
Users browsing this forum: No registered users and 34 guests