Replication advice

2006-05-18 Thread Alexandre Gonçalves Jacarandá
I've 3 machines that I use with mysql. One is used for BI consulting and other two for operational consulting. Which one is indicated to be an master server ? Is there possible, with 2 nics in machines, use one for replication and other for receive clients consulting ? Thanks. --

Re: Replication advice needed...

2001-08-26 Thread Jeremy Zawodny
On Sun, Aug 26, 2001 at 11:29:31AM +, Greg Cope wrote: > Jeremy Zawodny wrote:> > > On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > > > > > The other solution is rsync. I dont know much about this guy > > > yet, but I have some concerns with using it to copy over large > > >

Re: Replication advice needed...

2001-08-26 Thread Greg Cope
Jeremy Zawodny wrote:> > On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > > > The other solution is rsync. I dont know much about this guy yet, > > but I have some concerns with using it to copy over large remote > > files. For example, if I have a 1.2 gig table that has been hea

Re: Replication advice needed...

2001-08-25 Thread Jeremy Zawodny
On Fri, Aug 24, 2001 at 09:37:43AM -0700, Bryan Coon wrote: > > The other solution is rsync. I dont know much about this guy yet, > but I have some concerns with using it to copy over large remote > files. For example, if I have a 1.2 gig table that has been heavily > modified over a weeks work

Re: Replication advice needed...

2001-08-25 Thread Irmund Thum
> The other solution is rsync.  I dont know much about this guy yet, but I > have some concerns with using it to copy over large remote files.  For > example, if I have a 1.2 gig table that has been heavily modified over a > weeks work, how reliable is the remote file after rsync?  I guess Im jus

Re: Replication advice needed...

2001-08-23 Thread Jeremy Zawodny
On Thu, Aug 23, 2001 at 03:19:17PM -0700, Bryan Coon wrote: > Hi, > > We have a somewhat tricky problem that I need some help with. What > we have is one machine (the master) that we use for database > development, and two dedicated nodes (slaves) on a beowulf cluster > that house the non-dev da

Replication advice needed...

2001-08-23 Thread Bryan Coon
Hi, We have a somewhat tricky problem that I need some help with. What we have is one machine (the master) that we use for database development, and two dedicated nodes (slaves) on a beowulf cluster that house the non-dev databases. What we need is to mirror the master to the slaves, but not ne