I have setup five servers following this tutorial: " Installing A Multiserver Setup With Dedicated Web, Email, DNS And MySQL Database Servers On Debian 6.0 With ISPConfig" Everything works as described. The only problem is when I want to create a DNS a web site or a database, I have to select the server manually. (please look at the bellow picture). I would like to know if there is a plugin or an add on that does it automatically ? My last question is about the load balance... How does ISPCONFIG load balances traffic if a web site is manually installed in one server out of 3 web servers for example ? Is there a feature like Haproxy in ISPCONFIG ?
You set the default server on the limits tab of the client. As admin, you have the option to use all servers off course.
Hello Till, thank you for your time and reply... I followed the ISPCONFIG tutorial on "Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3 " I used ubuntu 12.04 instead of Debian 6.0... Debian 6.0 was unstable for me and I had a lot of issues with dependencies.. And I replaced mysql replication with percona xtradb cluster following this tutorial... "http://redcrackle.com/blog/how-set-percona-xtradb-cluster-ubuntu". I have 4 servers... A B C D. A is the master server. After I install percona xtradb, it works really great.. One database or table created in server A is replicated automatically on server B C D and so forth.. Then I followed the ISPCONFIG tutorial and configured unisson and other requirements. When I installed ISPCONFIG on server A, dbispconfig is replicated on all servers nodes (mysql cluster nodes) The problem problem is when I install ISPCONFIG on server B C and D to join the master, it can't create the dbispconfig that already exists from server A installation. I tried to change the dbispconfig name calling them dbispconfig1 for server A and dbispconfig2 for server B etc... But no luck.. Is there a way to install ISPCONFIG without creating a new database so it can just use the existing dbispconfig database replicated by percona ? Thanks
The dbispconfig database may not be included in your percona db replication. Each node needs its own ispconfig database, the system would not know which records have been written to the config files if new records would appear in a slave database trough mysql replication before ispconfig processed the transaction for them. And you would also get a bunch of security issues by sharing one database between all nodes.
Hello Till, I got it work by running the following mysql command on the master server: CREATE USER 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword'; GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword' WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ; It's working ok.... But there is a limitation with Unison... I am not too familiar with it... Can I sync more than two server in Unison file /root/.unison/default.prf ? So it can look like this ..... [...........] # Roots of the synchronization root = /var root = ssh://192.168.0.106//var/ root = ss://192.168.0.107//var/ root =ss://192.168.0.108//var/ root =ss://192.168.0.109//var/ # Paths to synchronize path = www path = vmail OR [...........] # Roots of the synchronization root = /var root = ssh://192.168.0.106, 192.168.0.107,192.168.0.108,192.168.0.109//var/ # Paths to synchronize path = www path = vmail Thanks
I fear that unison supports just 2 servers. If you need more servers you shoud take a look at csync2: http://oss.linbit.com/csync2/
Thanks Till, for some reasons, Unison looks really simple to setup... I just read over their website that it can be setup using various typologies.. star typology or mesh.. I am going to keep digging into unison and see if I can do... here is the link.. http://www.cis.upenn.edu/~bcpierce/unison/download/releases/stable/unison-manual.html#usingmultiple
