There is a new version of this tutorial available for Debian 8 (Jessie).

Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3 - Page 5

This tutorial exists for these OS versions

On this page

  1. 5 Configure Replication In ISPConfig
  2. 6 Additional Notes
  3. 7 Links

5 Configure Replication In ISPConfig

Log into ISPConfig on the master server with a webbrowser:

http://192.168.0.105:8080

Click on System > Server Services > server2.example.tld:

Select "server1.example.tld" in the "is mirror of" field and click on Save.

Then open System > Server Config and enable the checkbox "Connect Linux userid to webid" on the "Web" tab:

 

6 Additional Notes

When you want to activate a firewall on the master or slave server, ensure that you open port 3306 for MySQL on both servers.

 

7 Links

Share this page:

Suggested articles

13 Comment(s)

Add comment

Comments

By: Anonymous
Reply  

Easy to understand written toutorial - but I miss some points you mentioned in the introduction:

 

This tutorial describes the installation of a clustered web, email, database and DNS server to be used for redundancy,  high availability and load balancing on Debian 6 with the ISPConfig 3...

 

What I miss are postfix (queue) redundancy, amavis (temp + quarantine)redundancy as well as handling logfiles (if complete logfiles to be archived for some month -> Vorratsdatenspeicherung). Just copying /vmail from server 1 to server 2 isn't redundancy, the loss of mails is possible.

How to switch between services (or servers) if one goes down or isn't reachable and how is load balancing solved?

just my 2 cents
Alois

By: nitesh
Reply  

Hello,

 I also read that tutorial and this is too good. But i just want to ask if my master server goes down then how can  i run services on server 2 so my webistes will not go down.

 Please update on this.

By:
Reply  

 Hello, What user and password i need to ISPConfig control panel login ?

By:
Reply  

The default ISPConfig login is:

Username: admin
Password: admin

By:
Reply  

How IspConfig 3 manage the load balancing apache clusters sessions?

By: qqkk
Reply  

Then open System > Server Config and enable the checkbox "Connect Linux userid to webid" on the "Web" tab:

this config for server1 or server2??

By:
Reply  

I've done on both servers and works correctly

By: Shelby99
Reply  

Hi

I can't login on default admin admin account. Every time i try on both servers i get this error:

ERROR

Username or Password wrong.1

Password lost?
 

 Anybody know what to do?

By: Ariel
Reply  

Same incident here.

 I've used these queries to the DB:

 mysql> select username, passwort, md5('admin')  from sys_user\G

*************************** 1. row ***************************

    username: admin

    passwort: 21232f297a57a5a743894a0e4a801fc3

md5('admin'): 21232f297a57a5a743894a0e4a801fc3

1 row in set (0.00 sec)

So, the password for 'admin' user is 'admin' but the interface does not allow me to log on.

By:
Reply  

Get the password again:

Code:
grep -i db_password /usr/local/ispconfig/interface/lib/config.inc.php
Set the password:
Code:
mysql -u root -p
mysql> update mysql.user set password=PASSWORD("<PASSWORD>") where User='ispconfig';
mysql> flush privileges;
mysql> quit

By: Anonymous
Reply  

Hello! First of thank your very much for this nice tut. I also solved the problem regarding to the login problem for the ISPconfig web interface. 

Only one thing I left: The configuration at the end "Connect Linux userid to webid". Do I have to set this configuration for both servers?

 Thank you, mic.

By: berry
Reply  

hello, thank you very much unbelievable

By:
Reply  

Same question: How IspConfig 3 manage the load balancing and HA?