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
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
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
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