Next Unique Number - Generation

2011-07-21 Thread Vikram A
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

Re: Next Unique Number - Generation

2011-07-21 Thread Vikram A
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 HA on cloud

2011-07-21 Thread Yogesh Kore
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

Re: MySQL HA on cloud

2011-07-21 Thread Rob Wultsch
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,

RE: Next Unique Number - Generation

2011-07-21 Thread Daevid Vincent
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`

MySQL refusing to accept passwords

2011-07-21 Thread Tim Thorburn
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