[Cialug] mysql replication

[Dave J. Hala Jr.]

No it doesn't, my experience has been that the best way to stop is stop
the slave, then the master.

On Wed, 2006-11-15 at 10:41, Dave Weis wrote:
> 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
> >
-- 

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!