start: Job failed to start

Edited!
Hi

Mirror setup, using "Installing A Web, Email & MySQL Database Cluster On Debian 6.0 With ISPConfig 3"

Seems to be a known issue due to change in MYSQL-version. //Edit wrote php-version before, should be mysql-version)
I read the threads
http://www.howtoforge.com/forums/showthread.php?t=63205&highlight=start:+Job+failed+start
http://www.howtoforge.com/forums/showthread.php?t=63198&highlight=start:+Job+failed+start
http://www.howtoforge.com/forums/showthread.php?t=62473&highlight=start:+Job+failed+start&page=4

Understand I have to somehow invoke:
CHANGE MASTER TO MASTER_HOST='master', MASTER_USER='slave_user00', MASTER_PASSWORD='some_password' (...)

Sorry to be a newbie, but where is this supposed to be entered.
>MySql IS actually running but I could not login with "mysql -u root -p"
>On the other hand "mysql -h localhost -u root -p" did work.
(it can't be a sql-command. And also, Is this sulotion forever, will it stick even after a restart.) it obviously is, my mistake.

>now I have commented out
>#master-host = 172.17.2.182
>#master-user = slaveuser
>#master-password = password
>#master-connect-retry = 60

>Suddenly after several mysql restarts it is possible to login with "mysql -u root -p" so i did
>"mysql> CHANGE MASTER TO MASTER_HOST='slaveIP-address', MASTER_USER='slaveuser', MASTER_PASSWORD='mystrongpassword' "

Now I am not sure how to proceed from here. I
Can't find out what to do. Start over from beginning with a new install following the same "howto", will produce same problem, or?

//millpark10

 

[solved]

Hi
Some instructions in the perfect server setup referred to is not applicable due to change in mysql-version!

This worked for me:
Server1
The change in /etc/mysql/my.cnf comment out:
#bind-address = 127.0.0.1
For server 1 add lines:
server-id = 1
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 1
log_bin = /var/log/mysql/mysql-bin.log
Change from 100M to 500M:
max_binlog_size = 500M

server 2:
The change in /etc/mysql/my.cnf comment out:
#bind-address = 127.0.0.1
For server 2 add lines:
server-id = 2
replicate-same-server-id = 0
auto-increment-increment = 2
auto-increment-offset = 2
log_bin = /var/log/mysql/mysql-bin.log
Change from 100M to 500M:
max_binlog_size = 500M

Following
The additions in /etc/mysql/my.cnf:
master-host = 172.17.2.182
master-user = slaveuser
master-password = password
master-connect-retry = 60
will not work in 5.5.34 (the version I have)

Instead these shall be invoked as mysql-command,
login to mysql
mysql -u root –p
mysql> CHANGE MASTER TO MASTER_HOST='172.17.2.181', MASTER_USER='slave_user', MASTER_PASSWORD='mystrongpassword';
mysql> FLUSH PRIVILEGES;
mysql> quit;

This was a bit confusing before I understood it and got it to work. In the process to find out how to do this the problems and errors in previous post showed up. I also managed to destroy the mysql installation (changed privileges etc).
I completely removed it an reinstalled it, then followed my revised setup as above.

To remove mysql completely from your system:
sudo apt-get remove --purge mysql-server mysql-client mysql-common
sudo apt-get autoremove
sudo apt-get autoclean

Long post and maybe not completely understandable, sorry for that. I'm obviously a newbie trying to follow descriptions.

//millpark10