I have a few sites on web11 that are going VERY slow. One in particular fails to load at all from several locations. From my understanding, the database server is in Waco, but the web server is still in Florida.
Took awhile, but finally figured out my problem is the same as yours.
To clarify for the other users…MySql Database is on one server, while the actual website that uses it is on another server.
When they’re in the same data center, they can communicate rapidly…
But what they did is move the MySql server to Waco, while the actual website is still in Fla…NOW you have a tremendous slowdown while they talk to each other.
It’s like our husbands have traveled ahead of us and we’re wives who are waiting for him to send for us, so we can be one happy family again…and that is taking days if not weeks. Meanwhile our sites are FUBAR.
Now the migration was actually like producing a clone of the server in Waco…while the original server was in Fla…
To solve MY problem, I had the bright idea to use the actual IP of the original MySql server in Fla, where my website still is.
Unfortunately, that server has already been killed…so now I’m forced to wait until my website server rejoins the MySql server.
I’d say there was some very poor planning for this migration…
If the MySql Servers were still in the same cluster as the Websites, we could temporarily hard code the IP in the connection string until both servers were in the same place…z
My sites have also been dragging for more than a week. I just don’t understand how this could have happened. Was this the actual plan? Please update us on when we can expect this to be resolved.
Sites are not down on web11, but the server is again syncing to TX datacenter. We’ve had some other behind the scene issues to come up that we are resolving as well.
I have tickets out on this. More than one because I was left hanging, either put on hold or else marked as resolved. It started out because of a time-stamp discrepancy: