Re: Sinister variable caching problem with rand()

On Sat, May 15, 2010 at 9:48 PM, Anthony Esposito
<[email protected]> 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