2 messages in com.mysql.lists.mysqlAutomatic server-id generation for sl...
FromSent OnAttachments
Kevin A. Burton28 Feb 2005 09:40 
Alec...@Quantel.Com28 Feb 2005 09:56 
Subject:Automatic server-id generation for slaves?
From:Kevin A. Burton (bur@newsmonster.org)
Date:02/28/2005 09:40:45 AM
List:com.mysql.lists.mysql

Right now one of the only reasons we can't put our entire config for our slaves in CVSup is that the config *requires* the ability to set a server-id for each machine.

Seems like it would be pretty trivial to support a hostname based policy for this. You could simply look at the IP/hostname and set the value from this (though you might need a tracking table).

Policies could include:

- IP based server-id (IPs are 32bit) - parse the hostname for an ID (db4.server.com would yield a server-id of 4) - Adler32/SHA1 truncate the hashcode of the hostname

The first two seem sufficient. This wouldn't be the default of course and would require an explicit config.

Thoughts?

Kevin

--

Use Rojo (RSS/Atom aggregator). Visit http://rojo.com. Ask me for an invite! Also see irc.freenode.net #rojo if you want to chat.

Rojo is Hiring! - http://www.rojonetworks.com/JobsAtRojo.html

If you're interested in RSS, Weblogs, Social Networking, etc... then you should work for Rojo! If you recommend someone and we hire them you'll get a free iPod!