Hey folks, I have been aware of the software for many years, I think we may have even used it years ago . . . but we are using aa Panel right now. We like aa Panel because of the overall ease of use, and it gives us fairly good visibility into what's going on with a box. We have multiple, fairly large web servers (48 cores 256 GB RAM), all running VERY heavy and active WordPress sites. These things are under a massive load all of the time. They are anywhere from 30k uniques a day for each site, to 3k, with a few hundred of these sites. New content is added literally all the time. We are running very heavy on PHP and MySQL and REALLY feel we ned to split this up. 1. Does the multi-server system allow for designating one or two servers as MySQL servers? If so, would this be fairly automated? For example, could we install WordPress on a web server and have the database automatically go to the MySQL server? 2. In the multi-server system, does this allow for migrating sites from one server to another? 3. I 100% do not mind paying for support. In the multi-server system, can this system be "tuned" with both PHP and MySQL settings to work better in our environment? 4. It looks like there is paid support available? Would that support be able to help us migrate from aa Panel as well? 5. What are the recommended add-ons for doing this "right"? Thanks so much.
You can deploy dedicated DB servers in a multiserver setup that only host the databases for the websites. Not yet. Just contact the support and see what they can do for you. Again you should check in with the support and ask, but i think they can a least provide some help with that. What do you mean by this?
1. Does the multi-server system allow for designating one or two servers as MySQL servers? If so, would this be fairly automated? For example, could we install WordPress on a web server and have the database automatically go to the MySQL server? as pyte already stated. yes. you can.. but i don't recommend it. when i first started using ispconfig, i did this, a couple of webservers, each using a separate, centralised, much larger centralised db server. i found that even with very good/fast links between the webservers and db servers, that extra little bit of latency was very noticeable. the way wordpress seems to work, it can make a lot of identical db queries, and it seems to make each one sequentially, not send them all off and sort out the response, just send one, get a response, send the next one.. i found it wordpress sites were much, much faster when the database was kept on the webserver host. obviously, when using a separate db server, a lot of this extra latency with db queries can be minimised with db object caching on the webserver, along with full page caching. but this can also be done with the db on the webserver itself. 3. yes, php and mysql can be tuned. you could even work your way through all the wordpress / plugin code to streamline/optimize every mysql query. it won't always help. visitor behaviour changes over time, some sites might run promotions / special offers, rapidly changing traffic patterns from day to day.. you can optimize mysql for what you see occuring on it today, those same settings can be suboptimal for what happens tomorrow. chasing a perfectly tuned system is an endless race.
I have these machines on the same underlying hypervisors and cannot confirm this. The loading times are nothing out of the ordinary. However we mostly host a few hundred small websites with not that much traffic.
