I have checked multiple how-to guides, but I'm stomped at installation steps and general architecture. My aim is to have Domain/Email in HA/load balanced mode with DNS being external (separate server service). So far what I understand: 1) Install 1x server, it creates its own DB - dbispconfig 2) Install 2x server with "expert" option when asked "Shall this server server join an existing ISPConfig multiserver setup" answer "Y". So the question is : Is the server number 2x installing its local database and linking itself at the same time to the master database (so in reality it runs its own DB and syncs some data to the master) OR are they sharing the same master database? The second question is: during installation when the system asks for the MySQL server in the "interactive" mode, is it expected that MySQL user/database/password is already created or will it create the user/db/password itself? Edgars
Yes. You wrote but perhaps you have not read this https://www.howtoforge.com/tutorial...-the-remote-mysql-users-for-our-slave-servers You should examine the documents available and read the ones that apply to your case: https://www.ispconfig.org/documentation/
@Taleman or others a quick note installing MultiServer. 1) Install first server as normal - > This will install local DB. The crucial part is that during installation when the in "interactive" mode it generates the "root" password. 2) Installing the second server the same happens, it generates local MySQL root password which must be used during install. (this was what I was missing)
Further question @Taleman: I noticed the root install created phpmyadmin database and roundcube database. Can these databases be shared on galera level? Or they must be separate for each slave instance?
Why me? You do not accept answers from anyone but me? Do not use @ nickname references unnecessarily. You seem to know more about the databases these applications use. I have not needed to deal with phpmyadmin or roundcube database. But do these applications work if you have installed them on two hosts and have their databases on a third host?
Well I have read your numerous posts so I figured "Ask the guy who may know or knows someone who knows". I can respect your request about References. Database Host location is not the subject of my question. In your context I can answer myself - Yes the two hosts can place their databases and work on third remote host. My question: Each instance installs its own "local" roundcube / phpmyadmin db. Is it ok to use single remote database for roundcube and phpmyadmin for N hosts via Galera, or there is some special requirement to have them separate?
So I'm missing key details and would like to request any info. Multiserver setup: 1) Can I redirect users to Slave WEB interface and allow to create new users on slave? OR what I see is that slave is a "copy" of master and thus all new users/dns changes must be created only on master server? 2) What about databases like phpmyadmin and roundcube - can I just redirect all slaves to mater phpmyadmin and roundcube DB ?
No. ISPConfig system runs the Panel on one host only, the master host of the setup. If you create two web servers, you can choose on which the website, database and shell and FTP users are created. Is there a reason to do that? It might work, but I am not sure two PHPMyAdmin installs can use same phpmyadmin database, that could mess the database. What does the multiserver install guide say about such setup?
Again thanks for confirming - I suspected as much through experimentation. My reason why I want to put every DB on Galera is: centralization, redundancy, and scalability. Another question - What I see is that roundcube and phpmyadmin do not actually store that much data in database and for that matter also ISPconfig itself. Am I correct in assuming that user mail+files are stored primarily on FileSystem itself? The only thing I should be worried about is ISPconfig DB location as that probably indicates where other DB to be installed for example for User Wordpress.
If you already have verified it, why ask? At least show results of experiments when asking for help. So you have already experimented with this? What were the results? How was the experiment conducted? You should even state what the question is, if you want an answer. Which filesystem? If that is a question, you should elaborate. I do not understand what you mean there.
It may be best if you could draw diagram of your preferred mutilpe server setup, then explain or ask based on that with clarity and simplicity. We do not read minds and do not know what are you truly intend to do or trying to achieve, with what setup's arrangements or using which softwares. To many of us, it is quite a straight forward and clear for multiple server setup based on the ISPConfig documents.
