On Sat, May 15, 2010 at 9:48 PM, Anthony Esposito <tony.m.espos...@gmail.com> wrote: > The reason I am not using auto_increment is because the databases exist on a > mysql cluster. The auto_increment counts would have to be maintained very > carefully with multiple servers running the same database so I opted to not > worry about it and generate completely unique keys. When a line is added in > one database it is advertised to all others, the linking between lines in > diff tables is easier this way too.
If you haven't already, I suggest picking up a copy of "High Performance MySQL" for suggestions on easier ways to deal with a database cluster. - Perrin
