Re: maximum size of mysql server-id field
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 documentation or via google. I did dogpile.com for "my.cnf format server-id" and found: http://mysqld.active-venture.com/Replication_Options.html which claims it's a 32-bit non-negative. "range from 1 to 2^32 - 1" I dunno if they are authoritative or not, mind you... 32-bit that would have been my first guess, fwiw... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: maximum size of mysql server-id field
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/Replication_Options.html which claims it's a 32-bit non-negative. "range from 1 to 2^32 - 1" I dunno if they are authoritative or not, mind you... 32-bit that would have been my first guess, fwiw... -- Like Music? http://l-i-e.com/artists.htm -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
maximum size of mysql server-id field
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 tying a slave server-id to a machine (last few digits of MAC addr, IP addr, etc...) Thanks, David -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]