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

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` AUTO_INCREMENT=1

Re: MySQL HA on cloud

2011-07-21 Thread Rob Wultsch
On Thu, Jul 21, 2011 at 6:20 AM, Yogesh Kore 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

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 any