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 wrote:
> I can think of several ways to accomplish this (or close to it)
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` AUTO_INCREMENT=1
: 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 086 India T: (9122)
66505900 F: (9122) 22040826 Url:www.exactuscorp.com