Ispconfig Multiserver setup Nginx Web Server MySql & load balancer

Hi,
I am setting up Ispconfig Multiserver setup with Nginx Web Server , MySql, Load balancer & application server on VPS, each VPS has Punlic IP

I am going to follow the tutorial https://www.howtoforge.com/tutorial/ispconfig-multiserver-setup-debian-ubuntu/

Before going further, I have some questions on the Prelimiary notes which are given as under;

host FQDN IP
panel panel.example.com 10.0.64.12
web01 web01.example.com 10.0.64.13
mx1 mx1.example.com 10.0.64.14
mx2 mx2.example.com 10.0.64.15
ns1 ns1.example.com 10.0.64.16
ns2 ns2.example.com 10.0.64.17
webmail webmail.example.com 10.0.64.18

Q1. Can I combine Panel & Web01 as one server & install Ngnix instead of apache2?
Q2. Can I have only one mx1 - mail Server? In this case, I should avoid mirroring steps mentioned for setup MX2 Server
Q3. Can I avoid ns1, ns2 servers as I can use Web hosting provider name servers?
Q4. What steps should I follow to add MySql in addition to adding host & hostname.
Q5. Can I follow steps given to install Load Balancer on MySql VPS =
wget -O - https://get.ispconfig.org | sh -s -- --no-mail --no-dns -- use MySql=system (so it should have both MySql & Load Balancer) ?
Q6. Application server: I just need Node js and npm packages to run my application, can I add Ngnix web server on this

Please advice

Thanks & regards,
Abin

 

Q1. Sure.

 

Thank you all of you
I will go ahead with the installation
Regarding my Q4, I can not see steps to to be followed to build a seperate Database server in the tutorial

Q5, yes load balancer steps are not there, I meant was to do steps required for load balancer installation ( there are guides on the internet about Load balancer installation

Thanks and regards

 

Hi,
Further to my last post, First I am installting Control Panel & Web01 on one VPS Server & have followed the instructions as per the tutorial
Apart from Server 1 = (control panel+Webserver)
Server 2 = Database
I have user this command to create Database Server
wget -O - https://get.ispconfig.org | sh -s -- --use-nginx --no-dns --no-mail --interactive
My Main Server is showing server 2 now

My question now " Is this the correct way to set up DATABASE Server

Thanks

 

The manual and tutorial (the older ones) should have examples on how to build database servers but you should note that each server still need to have their own database.

There are tutorials for high availability and/or redundancy that you can refer to with note that you may have server(s) or hardware(s) or software(s) to manage them from within or outside ISPConfig to achieve that.

 

you don't actually state anywhere what you want to load balance.

if it's database servers, you can't install the load balancer on the mysql vps, it would need to be between the webservers/appservers and the database servers.
you'd also need to make it master-master replication, or install something like the mysql-nd drivers on every server that connects to these databases, and configure every database connector for read-write splitting, and have standard master-slave mysql replication.

 

Thank you!
Your reply has cleared my doubts
Regards