Replication breakage when Heartbeat Failover occurs

2009-08-12 Thread Imran Chaudhry
I want to fix a replication issue with a 2-node cluster (one active, one passive) that is using Heartbeat for failover. The nodes are in Master-Master configuration (that is, each is the slave and master of the other). I have several other hosts that are replication slaves from the active node.

Re: Replication breakage when Heartbeat Failover occurs

2009-08-12 Thread Walter Heck - OlinData.com
Hi Imran, Have a look at MySQL MMM for Multi-Master Replication failover. The project is currently in refurbishment when ti comes to having a home, but you can start by looking at : http://mysql-mmm.org for information. This project is made for exactly what you want to achieve: Having multiple

Re: Replication - connecting a slave to a master on the same host via a port or socket

2009-08-12 Thread Johan De Meersman
You can easily get around that behaviour by specifying 127.0.0.1, though :-) On Tue, Aug 11, 2009 at 8:56 PM, Gavin Towey gto...@ffn.com wrote: Andrew, Yes it's true, because when you specify localhost, you're using the local socket file. The port only has meaning for TCP connections.

MySQL and Relevance

2009-08-12 Thread Steffan A. Cline
Anyone know of a way to do a query within MySQL kind of like a relevance but without the Full Text index? I am searching on country, region and city. Now, that's easy enough but what if I need to sort by full match down to partial and no matches but always get something like always a found set