MySQL ODBC Connector - maximum size of mysql server-id field

Author

maximum size of mysql server-id field

David

2005-05-26, 3:23 am

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 =3D 1" and "server-id =3D 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/mysql? unsub...sie.nctu.edu.tw

Richard Lynch

2005-05-26, 3:23 am

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/Re...on_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/mysql? unsub...sie.nctu.edu.tw

Eric Bergen

2005-05-27, 1:23 pm

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:
>
>
>
>I did dogpile.com for "my.cnf format server-id" and found:
>
>http://mysqld.active-venture.com/Re...on_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/mysql? unsub...sie.nctu.edu.tw

Sponsored Links