[TriLUG] MySQL Replication

[Ken M]

Have you checked if it is perhaps a firewall issue.  The boxes will need to be able to communicate with each other on the port that MySQL listens on.  Default port for MySQL is typically 3306.  It is also typically closed in most production setups.  When you open the port you should specify the ip addresses allowed to communicate through that port in your rules.

Ken

On Thu, Jan 29, 2015 at 04:06:18PM -0500, Brian McCullough wrote:
> I am in the midst of trying to set up MySQL Replication between two of
> our Joomla machines, and have some questions.
> 
> I have been working my way through the documentation on the MySQL site,
> following the instructions there, and have, as far as I know, done
> everything ( mostly ) correctly.
> 
> However, now that I have started both master and slave, I think that I
> am seeing that the slave is not allowed to connect to the master.
> 
> Because these two machines are neighbors in a ( 10. ) LAN, and their DNS
> names are for their external addresses, I used the LAN IP address when I
> created the user record for the slave on the master.
> 
> However, the master is saying that "IP Address xxx could not be
> resolved: Name or service not known", which I see as the reason why the
> slave is not allowed to connect.  I may be wrong about that cause,
> however.
> 
> I tried adding that IP address to /etc/hosts, but that didn't seem to
> help.
> 
> 
> Any suggestions?
> 
> 
> Thanks,
> Brian
> 
> 
> -- 
> This message was sent to: Ken M. <ken at mack-z.com>
> To unsubscribe, send a blank message to trilug-leave at trilug.org from that address.
> TriLUG mailing list : http://www.trilug.org/mailman/listinfo/trilug
> Unsubscribe or edit options on the web	: http://www.trilug.org/mailman/options/trilug/ken%40mack-z.com
> Welcome to TriLUG: http://trilug.org/welcome