> -----Original Message----- > From: Tobias Asplund [mailto:[EMAIL PROTECTED] > Sent: Monday, December 22, 2003 11:21 AM > To: Jeff McKeon > Cc: [EMAIL PROTECTED] > Subject: Re: Replication Question > > > 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. >
So I have to do something on the master then to add this second slave on the same system as the first slave? I'm not sure how to set up a separate logfile/data for the second slave... Is this done on the master or slave? > > > Is replication System dependant or database dependant? > Neither, it's server instance dependant > You mean mysql "server" as in the software correct? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]