Re: replication planning, concepts

2002-02-11 Thread James Montebello
Think of the binary log as just a long binary data stream, which simply happens to be in a series of files. Each slave has a position in that binary stream, which is expressed as a filename and file position. Each slave has (potentially) a different position in the stream, and therefore a

replication planning, concepts

2002-02-11 Thread Mark M. Ito
MySQL folks, I am planning on using MySQL replication to mirror a database at various far-flung locations. I'm anticipating that there might be a handful of slaves, but they will only come on every few months. In that scenario, the last slave will have a lot of catching up to do if all slaves

replication planning, concepts

2002-02-07 Thread Mark M. Ito
MySQL folks, I am planning on using MySQL replication to mirror a database at various far-flung locations. I'm anticipating that there might be a handful of slaves, but they will only come on every few months. In that scenario, the last slave will have a lot of catching up to do if all slaves

Re: replication planning, concepts

2002-02-07 Thread James Montebello
Think of the binary log as just a long binary data stream, which simply happens to be in a series of files. Each slave has a position in that binary stream, which is expressed as a filename and file position. Each slave has (potentially) a different position in the stream, and therefore a