Re: maximum size of mysql server-id field

2005-05-27 Thread Eric Bergen
It's 32 bit. I'm not sure if it's signed or not but chances are you don't need more than 2 billion ids :) Richard Lynch wrote: On Wed, May 25, 2005 11:59 pm, David said: Does anyone know what the range for server-id can be? Is it a 16 bit number? 32 bit? I can't seem to find it in the do

Re: maximum size of mysql server-id field

2005-05-26 Thread Richard Lynch
On Wed, May 25, 2005 11:59 pm, David said: > Does anyone know what the range for server-id can be? > > Is it a 16 bit number? 32 bit? > > I can't seem to find it in the documentation or via google. I did dogpile.com for "my.cnf format server-id" and found: http://mysqld.active-venture.com/Replica

maximum size of mysql server-id field

2005-05-26 Thread David
Does anyone know what the range for server-id can be? Is it a 16 bit number? 32 bit? I can't seem to find it in the documentation or via google. I guess most people just do "server-id = 1" and "server-id = 2" but for large setups, that becomes difficult to manage and there are better ways of tyi