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.

 

Till Brehm

About Till Brehm

Over 20 years experience as Software Developer and Linux System Administrator. Till Brehm is the founder and lead developer of the ISPConfig Hosting Control Panel software (since 2000) and he founded HowtoForge in 2005 as a place to share Linux knowledge with other Linux enthusiasts.

Share this page:

Suggested articles

13 Comment(s)

Add comment

Comments

By: Anonymous

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 redundancyhigh 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

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:

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

By:

The default ISPConfig login is:

Username: admin
Password: admin

By:

How IspConfig 3 manage the load balancing apache clusters sessions?

By: qqkk

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:

I've done on both servers and works correctly

By: Shelby99

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

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:

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

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

hello, thank you very much unbelievable

By:

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