Hi,
I'm trying to accomplish a mysql master-slave cluster.
I'm following this tutorial:
http://www.howtoforge.com/mysql_mast...er_replication
I'm on step 6.
But on "slave" db server I don't see the databases present in "master".
In /var/log/mysql.log (slave) I see:
Quote:
130124 13:12:55 [ERROR] Slave SQL: Error 'Table 'dovecot.alias' doesn't exist' on query. Default database: 'dovecot'. Query: 'INSERT INTO `dovecot`.`aias` (`alias`, `email`) VALUES ('helpdesk@mydomain.com', 'admin@mydomain.com')', Error_code: 1146
130124 13:12:55 [Warning] Slave: Table 'dovecot.alias' doesn't exist Error_code: 1146
130124 13:12:55 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stoppe at log 'ubuntu1-bin.000002' position 107
|
this is my master cnf:
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=3306
user=mysql
old_passwords=1
log-error=/var/log/mysql/mysqld.log
long_query_time=3
log_slow_queries=/var/log/mysql/slow.log
log-bin=ubuntu1-bin
binlog-do-db=dovecot
binlog-do-db=roundcubemail
binlog-ignore-db=mysql
binlog-ignore-db=test
server-id=1
|
and this my slave cnf:
Quote:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
symbolic-links=0
old_passwords=1
server-id = 2
master-host = 10.10.10.1
master-user = replicant
master-password = XXXXXXXXXXX
master-port = 3306
replicate-ignore-db=mysql
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
|
what is my problem?
should I manually create database on slave? I hope not!
