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
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
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
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