Displaying 4 results from an estimated 4 matches for "master_log_file".
2015 Mar 12
3
mysql replication - problems
..._slave'@'ops.somewhere.com' IDENTIFIED
BY 'secret' REQUIRE SSL;
Then back on the slave I used this command to connect 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 co...
2015 Mar 12
0
mysql replication - problems
...; IDENTIFIED
> BY 'secret' REQUIRE SSL;
>
> Then back on the slave I used this command to connect 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...
2015 Nov 12
1
MariaDB 10.X Master-Slave Replication
...Does anybody know if those directives have been removed on that version?
Setting up them with the following mysql commands inside works.
mysql> slave stop;
mysql> CHANGE MASTER TO MASTER_HOST='*192.168.122.2*',
MASTER_USER='*slave_user*', MASTER_PASSWORD='*qwerty*',
MASTER_LOG_FILE='*mysql-bin.000003*', MASTER_LOG_POS=*11128001*;
mysql> slave start;
mysql> show slave status\G;
Cheers,
Roberto Nebot
--
It's a dangerous business, Frodo, going out your door. You step onto the
road, and if you don't keep your feet, there's no knowing where you might
b...
2015 Mar 12
3
mysql replication - problems
...9; REQUIRE SSL;
> >
> > Then back on the slave I used this command to connect 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...