On Mon, 22 Dec 2003, Jeff McKeon wrote: > Is it possible to have 2 database on one server replicating from the > same Master server? yes.
> In other words. DB01 is the Master on System01, > System02 has DB01_rep1 and DB01_rep2, each with their own replication > from DB01. Shouldn't be a problem. > I need to do this to have a development copy of DB01 on System02. I > have production software that pulls data > from DB01_rep1 and I need to set up DB01_rep2 to do some development > work. > > When I copy the DB01 snapshot into a new database (DB01_rep2) on > System02 and then log into that database and do a "Show slave status" it > shows me the slave status information that was set up for DB01_rep1. Just make sure that you're not running against the same logfiles/data, so you can have different relay-logs and master.info files. > Is replication System dependant or database dependant? Neither, it's server instance dependant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]