Assign each server a number and prefix/append that number to the unique
ID.
I will suggest you above, append -A for first machine and -B for
second machine.
-Prabhat
On Thu, Jul 21, 2011 at 12:13 PM, Daevid Vincent dae...@daevid.com wrote:
I can think of several ways to accomplish this
mysql@lists.mysql.com
Sent: Thursday, 21 July 2011 12:06 PM
Subject: Re: Next Unique Number - Generation
Hi
in ur database define the 2 numbers as auto increment.
Neil Martins Exactus Corporation Pvt. Limited ISO 9001:2000 certified 1st
floor, Raheja Plaza, LBS Marg, Ghatkopar (West), Mumbai 400
I can think of several ways to accomplish this (or close to it).
* Assign each server a number and prefix/append that number to the unique
ID.
* initialize each table on each server at a different huge number so they
don't ever collide:
ALTER TABLE `students`
