Displaying 3 results from an estimated 3 matches for "master_ssl_cert".
2015 Mar 12
3
mysql replication - problems
...onnect the slave to the
master:
mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
MASTER_USER='jf_slave', MASTER_PASSWORD='secret',
MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=34697, MASTER_SSL=1,
MASTER_SSL_CA = '/etc/pki/CA/certs/ca.crt', MASTER_SSL_CERT =
'/etc/pki/tls/certs/mysql.crt', MASTER_SSL_KEY =
'/etc/pki/tls/private/mysql.key';
And when I start up the slave I see that there's a problem connecting from
the slave to the master:
mysql> show slave status \G
*************************** 1. row **************************...
2015 Mar 12
0
mysql replication - problems
...master:
>
> mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
> MASTER_USER='jf_slave', MASTER_PASSWORD='secret',
> MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=34697, MASTER_SSL=1,
> MASTER_SSL_CA = '/etc/pki/CA/certs/ca.crt', MASTER_SSL_CERT =
> '/etc/pki/tls/certs/mysql.crt', MASTER_SSL_KEY =
> '/etc/pki/tls/private/mysql.key';
>
> And when I start up the slave I see that there's a problem connecting from
> the slave to the master:
>
> mysql> show slave status \G
> ***********************...
2015 Mar 12
3
mysql replication - problems
...t; mysql> CHANGE MASTER TO MASTER_HOST='web2.somewhere.com',
> > MASTER_USER='jf_slave', MASTER_PASSWORD='secret',
> > MASTER_LOG_FILE='mysql-bin.000002', MASTER_LOG_POS=34697, MASTER_SSL=1,
> > MASTER_SSL_CA = '/etc/pki/CA/certs/ca.crt', MASTER_SSL_CERT =
> > '/etc/pki/tls/certs/mysql.crt', MASTER_SSL_KEY =
> > '/etc/pki/tls/private/mysql.key';
> >
> > And when I start up the slave I see that there's a problem connecting
> from
> > the slave to the master:
> >
> > mysql> show slav...