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
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.
MySQL HA on cloud
Hi, I have cloud setup where MySQL servers are installed. Replication is applied in between mysql servers. Now I want to implemet HA for MySQL. Can any one help me how can I achieve MySQL failover? I looked DRBD, Linux Heartbeat, but I am not able to confirm which should I go for or is there anything else by which I can achieve my goal? Thank You. Regards, Yogesh
Re: MySQL HA on cloud
On Thu, Jul 21, 2011 at 6:20 AM, Yogesh Kore yogeshk...@gmail.com wrote: Hi, I have cloud setup where MySQL servers are installed. Replication is applied in between mysql servers. Now I want to implemet HA for MySQL. Can any one help me how can I achieve MySQL failover? I looked DRBD, Linux Heartbeat, but I am not able to confirm which should I go for or is there anything else by which I can achieve my goal? Thank You. Regards, Yogesh Getting automatic failover right is near impossible and it is very easy to destroy your data. I strongly suggest not attempting this project. -- Rob Wultsch wult...@gmail.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
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
MySQL refusing to accept passwords
Hello, For those keeping score, this will be the second time in the past few months I've come upon this problem. To recap, this is happening on a development laptop running Win7 64-bit Ultimate and MySQL 5.5.13. This morning, all was working well. This evening, I launched MySQL Workbench 5.2.34 CE to work on a table. When I attempt to access the server from within Workbench, I'm now prompted with a window asking for my password. Of course, my password is not accepted when I enter it - I'm presented with error #2000. Just to confirm, mysql --version returns: mysql Ver 14.14 Distrib 5.5.13, for Win64 (x86) This is not an upgrade, after my last mishap, I once again formatted the laptop with a fresh install of Windows 7 Ultimate 64-bit as well as MySQL 5.5.13. I've begun digging through bugs.mysql.com, but I'm not seeing any standing out. I should point out that this problem also breaks any sites running on this dev laptop as all passwords are no longer accepted. Any thoughts on what may be causing this? It seems to be happening every month or so at this point. Thanks in advance, -Tim Thorburn