Re: Next Unique Number - Generation
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 (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=1000; Other server: ALTER TABLE `students` AUTO_INCREMENT=2000; * don't re-invent the wheel and just use UUID() * make the primary key a combination key of a regular auto-increment and NOW() or RAND() or some other unique column of the table itself or something like IP number of the server, etc. * setup a trigger to alter the primary key accordingly prior to insert. Maybe one server is even numbers and the other is odd numbers, or use MOD() or other math to have a pool of servers. http://stackoverflow.com/questions/5416548/mysql-two-column-primary-key-with -auto-increment -Original Message- From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Wednesday, July 20, 2011 11:18 PM To: MY SQL Mailing list Subject: Next Unique Number - Generation Hi there, I need a technical help fro you, I have developed a software for college school. Here we have concept called register number/admission number. These are two unique umber for each student. My application resides Client/server model. These numbers will be generated (some defined format) to each student when they are admitted at first time. This admission process is taken place at different nodes at a time. In this scenario, I am facing difficulty that, the same number is generated at time in two machines. (Logic is newest number will be displayed in the node before admission). How can I stop this logical issue? Can i have solution for this? Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=aim.prab...@gmail.com -- Best Regards, Prabhat Kumar MySQL DBA My Blog: http://adminlinux.blogspot.com My LinkedIn: http://www.linkedin.com/in/profileprabhat
Re: Next Unique Number - Generation
Hi Neil, thank you for your response, The admission number/register number will contain text/symbol(-,/,#). Is it possible to keep this as increment ? From: Neil Martins neil.mart...@exactuscorp.co.in To: Vikram A vikkiatb...@yahoo.in; MY SQL Mailing list 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 086 India T: (9122) 66505900 F: (9122) 22040826 Url:www.exactuscorp.com DISCLAIMER and CONFIDENTIALITY CAUTION This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Unauthorized reading, dissemination, distribution or copying of this communication is prohibited. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you have received this communication in error, please notify us immediately by telephone at (9122) 66505900 or email us at i...@exactuscorp.com and promptly destroy the original communication. Thank you for your cooperation. Please note that any views or opinions presented in this email are solely those of the author and do not necessarily represent those of the company. Communicating through email is not secure and capable of interception, corruption and delays. Anyone communicating with Exactus Corporation Limited by email accepts the risks involved and their consequences. The recipient should check this email and any attachments for the presence of viruses. Exactus accepts no liability for any damage caused by any virus transmitted by this email. - Original Message - From: Vikram A vikkiatb...@yahoo.in To: MY SQL Mailing list mysql@lists.mysql.com Sent: Thursday, July 21, 2011 11:48 AM Subject: Next Unique Number - Generation Hi there, I need a technical help fro you, I have developed a software for college school. Here we have concept called register number/admission number. These are two unique umber for each student. My application resides Client/server model. These numbers will be generated (some defined format) to each student when they are admitted at first time. This admission process is taken place at different nodes at a time. In this scenario, I am facing difficulty that, the same number is generated at time in two machines. (Logic is newest number will be displayed in the node before admission). How can I stop this logical issue? Can i have solution for this? Thank you in advance.
RE: Next Unique Number - Generation
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=1000; Other server: ALTER TABLE `students` AUTO_INCREMENT=2000; * don't re-invent the wheel and just use UUID() * make the primary key a combination key of a regular auto-increment and NOW() or RAND() or some other unique column of the table itself or something like IP number of the server, etc. * setup a trigger to alter the primary key accordingly prior to insert. Maybe one server is even numbers and the other is odd numbers, or use MOD() or other math to have a pool of servers. http://stackoverflow.com/questions/5416548/mysql-two-column-primary-key-with -auto-increment -Original Message- From: Vikram A [mailto:vikkiatb...@yahoo.in] Sent: Wednesday, July 20, 2011 11:18 PM To: MY SQL Mailing list Subject: Next Unique Number - Generation Hi there, I need a technical help fro you, I have developed a software for college school. Here we have concept called register number/admission number. These are two unique umber for each student. My application resides Client/server model. These numbers will be generated (some defined format) to each student when they are admitted at first time. This admission process is taken place at different nodes at a time. In this scenario, I am facing difficulty that, the same number is generated at time in two machines. (Logic is newest number will be displayed in the node before admission). How can I stop this logical issue? Can i have solution for this? Thank you in advance. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
