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 remote files.

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 just

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,

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

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