[Cialug] mysql replication

[Dave J. Hala Jr.]

On mysql 4.x you need to add a line like the following in the my.cnf on
the master and slave for each db you want to replicate.

replicate-do-db=dbdname

I'm guessing that it applies no matter table type you are using.

You'll also need a replication username, password and that account will
have to have replication privileges.


:) Dave



On Wed, 2006-11-15 at 10:26, Dave Weis wrote:
> Has anyone gotten it working? I think I have it set up correctly but the 
> master shows:
> mysql> show master status;
> +------------------+----------+--------------+------------------+
> | File             | Position | Binlog_Do_DB | Binlog_Ignore_DB |
> +------------------+----------+--------------+------------------+
> | mysql-bin.000002 |   203328 |              |                  |
> +------------------+----------+--------------+------------------+
> but all of the examples I've seen show something in the Binlog_Do_DB 
> column. I have the following lines in the my.cnf
> log-bin = mysql-bin
> server-id = 1
> innodb_data_home_dir = /var/lib/mysql/
> innodb_data_file_path = ibdata1:2000M:autoextend
> innodb_log_group_home_dir = /var/lib/mysql/
> innodb_log_arch_dir = /var/lib/mysql/
> innodb_buffer_pool_size = 768M
> innodb_additional_mem_pool_size = 128M
> innodb_log_file_size = 512M
> innodb_log_buffer_size = 256M
> innodb_flush_log_at_trx_commit = 1
> sync_binlog = 1
> innodb_safe_binlog = 1
> 
> The files are innodb format.
> 
> Thanks
> dvae
-- 

Open Source Information Systems, Inc. (OSIS)
Dave J. Hala Jr., President <dave at osis.us>
641.485.1606 www.osis.us
Save a life: Adopt a shelter animal!