View Single Post

   
  #2 (permalink)  
Old 03-28-2008, 04:40 AM
Baron Schwartz
 
Posts: n/a
Default Re: binlog sequence # rollover

Hi,

On Thu, Mar 20, 2008 at 9:41 AM, Sid Lane <jakes.dad@gmail.com> wrote:
> do binlog sequences just rollover back to 0 w/o a resetlogs? will it just
> automatically go back to mysqld.000000 after mysqld.999999? any replication
> implications?
>
> I know it sounds like a stupid question and I'm sure the developers are
> smart enought to have thought of that but we'll be crossing that threshold
> in the next 6-8 weeks and I don't need to find out it's a problem the hard
> way.


I'm not sure what happens. But you can test: shut down a test
installation, create mysqld.999998, edit the mysqld.index file
appropriately, and restart. Then see what happens when you run FLUSH
LOGS a few times.
Reply With Quote