mysql master > slave

I followed the tutorial at
http://www.howtoforge.com/how-to-se...plication-with-ssl-encryption-on-debian-lenny
pretty much word for word.

Then when I get to the part where I run

Code:

SHOW MASTER STATUS;

I never get anything returned. Have have been trying to set up replication in side a couple of vmware images before I run it on the real production servers. For the life of me I can not figure out what I am doing wrong. I simply get zero rows returned when I run

Also I would rather replicate only one table instead of the whole database. Is that possible, and how would that be accomplished. I had trouble finding any information on how to accomplish replicating only one table in the database.

 

Are there any MySQL errors in your logs?

 

replication

There is nothing in the mysql logs.

I double checked that the slave_user has the correct permissions in the mysql database user table to do replication.

The required entries are in /etc/mysql/my.cnf

Some stuff works as expected, like turning on ssl and certificate locaitons

But I can not get "SHOW MASTER STATUS;" to work.

 

Can you post your /etc/mysql/my.cnf?

 

the my.cnf

The /etc/mysql/my.cnf

Not much was changed, only the ssl certificates and the replication.

 

You need

Code:

server-id               = 1
log_bin                 = /var/log/mysql/mysql-bin.log
expire_logs_days        = 10
max_binlog_size         = 100M
binlog_do_db            = exampledb

in the [mysqld] section, not in [MYSQL_CLUSTER].

 

[mysqld] secontion, replicate only one table?

That was the trick that I needed

I did not realize that sections matter. Most of the time when editing config files it does not really matter where in the file it is as long as the right syntax accompanies it.


Is it possible to only replicate only one table from the database? How would I accomplish replicating only one table, so I can write to the rest.

 

You can do it as follows:

Code:

replicate-do-db = yourdb
replicate-ignore-table=yourdb.table1
replicate-ignore-table=yourdb.table2
...

Add replicate-ignore-table lines for all tables that you don't want to replicate.