[Cialug] mysql replication

[Dave Weis]

On Wed, 15 Nov 2006, Dave J. Hala Jr. wrote:
> 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.

It looks like if they are blank it does all of the databases. I put in to 
ignore the mysql database itself and that does show up. I want it to copy 
everything so I didn't know if it would show % or something.

Everything seems to be going now. It doesn't restart itself very clean 
after unplanned restarts of either end...

> 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
>

-- 
Dave Weis
djweis at internetsolver.com
http://www.internetsolver.com/