Comments on Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3

I can't get the MySQL sync to work.
After scp command and MySQL config edit it fails start on server2. Is there something missing from this tutorial?

The tutorial is complete and works on the servers that I installed. If you need help with your setup, please make a post in the forum which includes the detailed error messages etc.

I'm having big-time trouble with Slave_IO_Running: No Why is this happening? The Slave_SQL_Running is Yes.... Help cause I'm stuck

...I have the same problem with the mysql sync, after stopping mysql service and editing /etc/mysql/my.cnf there is no way to restart MySQL again.

 Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!

Works like a charm with older Mysql.

Trying to do it with Mysql5.5+ (from dotnet) and I get the same error as above.

The following options are removed in MySQL 5.5. If you attempt to start mysqld with any of these options in MySQL 5.5, the server aborts with an unknown variable error.

–master-host
–master-user
–master-password
–master-port

What way to work around?

Example for Server One in this guide:

mysql -u root -p

CHANGE MASTER TO MASTER_HOST=’192.168.0.106?,

MASTER_USER=’slaveuser’,

MASTER_PASSWORD=’slave_user_password’,

MASTER_CONNECT_RETRY=’60’;

 Where you have the command: ssh-copy-id -i $HOME/.ssh/id_dsa.pub [email protected]

Right below that section in the next block is code you obviously copied out of your xterm window.

 All the IP's are different, not hugely so but for anyone walking through this the first time and clueless about what they are doing and what is really going on and just following verbatim.  Small problem I thought you might care to know about and possibly address. I had to verify if I was reading your How-To or notes of my own in one of my wiki's and I don't think it was there before but hard to say, worked for me each time none the less.

hths 

On server 2:

Log into the MySQL shell as root user..

You should use : 

/etc/init.d/mysql start (again)

Then you have an error like that:

ERROR 29 (HY000): File '/var/lib/mysql/master.info' not found (Errcode: 13 or similar. You should use chmod 777 /var/lib/mysql/master.info .

Then the error dissapear. If you are more serious , you should give the correct priveligies to mysql.

Hi guys

im new to this , is there a setup like this that works with ubuntu 12.04 lts.

i will be thankfull for life.

I had problems following this set of instructions organising the base setup and MYSQL config. As I see it it only sets up replication one way. 

 I followed the following instructions to setup master-master and then carried on : 

 https://www.howtoforge.com/mysql5_master_master_replication_debian_etch

For those using unison between differing OS releases. You can update unison by adding a repository to the older OS to bring both versions in sync.

Now for two questions:

1) unison fails to sync two folder. Something about not having permission. I looked in the destination folder and there are a number of hidden unison files there that I can't remove even as root. Will have to keep digging to find an answer for that

2) I don't use * in the IP field (eith v4 or v6). is this a prerequisite for multiserver setups? Or can we somehow link the IPs from the various servers to specific accounts?

Unison sync sorted, turns out I needed to learn about the immutable attribute. Lesson learned...

One thing I've noticed is that website quota usage isn't displayed anymore. The page is just empty. Is this a known bug or due to the master being Ubuntu 10.04 LTS and the slave being 14.04 LTS?

Thanks for this tut.

But the MYSQL database does not sync the users I create with the websites. Everything else is working.

(c0aps1 is not showing up in the backup server's database)

anything? Thanks!

I cannot find "Connect Linux userid to webid" in ISPconfig version 3.0.5.4p8.

The option is there in that version in the same place: System > Server config on the web tab.

This part is necesarry ? Because I found create master to master replication using both server in master and slave , and not have copy mysql data directory ?? 

Now we have to sync the two mysql servers. We do this by copying over the mysql data directory from the master to the slave and also the debian configuration file that contains the debian-sys-maint user. This can be done as we stopped mysql before on both servers.

On server 1:

scp -pr /var/lib/mysql/* [email protected]:/var/lib/mysql/scp -pr /etc/mysql/[email protected]:/etc/mysql/debian.cnf

This part is necesarry ? Because I found create master to master replication using both server in master and slave , and not have copy mysql data directory ?? 

Now we have to sync the two mysql servers. We do this by copying over the mysql data directory from the master to the slave and also the debian configuration file that contains the debian-sys-maint user. This can be done as we stopped mysql before on both servers.

On server 1:

scp -pr /var/lib/mysql/* [email protected]:/var/lib/mysql/scp -pr /etc/mysql/[email protected]:/etc/mysql/debian.cnf

This part is necesarry ? Because I found create master to master replication using both server in master and slave , and not have copy mysql data directory ?? 

Now we have to sync the two mysql servers. We do this by copying over the mysql data directory from the master to the slave and also the debian configuration file that contains the debian-sys-maint user. This can be done as we stopped mysql before on both servers.

On server 1:

scp -pr /var/lib/mysql/* [email protected]:/var/lib/mysql/scp -pr /etc/mysql/[email protected]:/etc/mysql/debian.cnf

This part is necesarry ? Because I found create master to master replication using both server in master and slave , and not have copy mysql data directory ?? 

Now we have to sync the two mysql servers. We do this by copying over the mysql data directory from the master to the slave and also the debian configuration file that contains the debian-sys-maint user. This can be done as we stopped mysql before on both servers.

On server 1:

scp -pr /var/lib/mysql/* [email protected]:/var/lib/mysql/scp -pr /etc/mysql/[email protected]:/etc/mysql/debian.cnf