Displaying 4 results from an estimated 4 matches for "master_log_pos".
2015 Nov 12
1
MariaDB 10.X Master-Slave Replication
...en 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
be swept off to.
Bilbo Baggins.
http://vanis...
2015 Mar 12
3
mysql replication - problems
...TIFIED
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 connecting from
the slave to the master:
mys...
2015 Mar 12
0
mysql replication - problems
...E 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 connecting from
>...
2015 Mar 12
3
mysql replication - problems
...k 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 prob...