Im trying to make sure I grasp how the database runs now with a Master ISPC Web Server, a Mail Server, a DB server, NS1 server and NS2 server. During the install, all servers per the documentation were installed with MariaDB. It was instructed to create 'root'@'ip' and 'root'@'fqdn' for every server on the Master Web Server database and grant all the permissions. Now after all of the servers are built, Im seeing ispcsrv2@ip, ispcsrv2@fqdn, ispcsrv3@ip, ispcsrv3@fqdn, ispcsrv4@ip, ispcsrv4@fqdn, ispcsrv5@ip, and ispcsrv5@fqdn with their privileges set to "usage". So are all of the databases replicating to the Master? Is there any database redundancy going on? Or does each database contain it's own information. Can someone explain because it almost seems like a hub and spoke database design where I still have a single point of failure if the Master WebServer database goes down? I did the multiserver setup this time because I want to make sure that all of the eggs are not in the same basket in case something crashes but Im not sure how the database structure is on whether I have redundancy or if I should be scheduling mysql dumps every so often if they are not redundant. Thanks.
each server has its own database and fetches updates from the master-db as ispcsrvX. The root-account is for ispconfig-updates only.
Yes, they are redundant in a way that the slave server will keep working when the master or another slave goes down. But you will have to do backups of each database as each slave node has only the data that it needs and the master contains all data, so while you have redundancy in the way that servers are not affected by outages of another servers, you still have to backup each database to be able to restore a node in case of a fatal system error.
