Master/slave mysql ssl

Discussion in 'Installation/Configuration' started by pititis, Apr 5, 2012.

  1. pititis

    pititis Member

    Hello,

    I have enabled ssl and certificates for my master server(mysql), also I have added an user to mysql:

    Code:
    
CREATE USER 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'192.168.0.106' IDENTIFIED BY 'myrootpassword' [B]REQUIRE SSL[/B] WITH GRANT OPTION MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;
    After this, in the slave I want to join the master server running the install script. Here is my question, need I enable ssl and generate the certificates in the slave too?
     
    pititis, Apr 5, 2012
    #1
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    I dont think so as the slave connects to the master and not the master to the slave.
     
    till, Apr 5, 2012
    #2

Share This Page