[MCOL-467] replication setup issues when adding modules in combined setup Created: 2016-12-15  Updated: 2023-10-26  Resolved: 2017-01-23

Status: Closed
Project: MariaDB ColumnStore
Component/s: ?
Affects Version/s: 1.0.6
Fix Version/s: 1.0.7

Type: Bug Priority: Major
Reporter: David Thompson (Inactive) Assignee: David Hill (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

Centos7 root rpm install with ssh keys on remote servers.

Issue Links:
Relates
relates to MCOL-475 Error in script /usr/local/mariadb/co... Closed
relates to MCOL-481 Add prompt to disable/enable mysql re... Closed
Sprint: 2016-25, 2017-01, 2017-2

 Description   

Started with a single node combined server install using internal storage. Ran procedures to add a new module. This works correctly however the maria server replication is not setup.

We can do this manually with ma enableMySQLReplication, however this fails with an error if i use ssh keys. It worked using the root password.

So 2 issues:

  • addmodule should add replication for a combined node add.
  • enableMYSQLREplication fails with ssh keys configured.

We should also check the same for adding a UM in a non combined setup.

 Comments   
Comment by David Thompson (Inactive) [ 2016-12-15 ]

In debug.log:
Dec 13 15:48:17 centos ProcessMonitor[171490]: 17.518241 |0|0|0| E 18 CAL0000: runMasterDist: Failure rsync to module: pm2
Dec 13 15:48:17 centos ProcessManager[171611]: 17.518447 |0|0|0| E 17 CAL0000: line: 10166 setMySQLReplication: ERROR: Error getting MySQL Replication Master Information

in /tmp/masterdist log:
rsync -vopgr --exclude=mysql/ --exclude=test/ --exclude=infinidb_vtable/ --exclude=infinidb_querystats/ --exclude=calpontsys/ --include=/ --include=/* --exclude=* /usr/local/mariadb/columnstore/mysql/db/ @172.21.21.3:/usr/local/mariadb/columnstore/mysql/db/

Testing this manually it requests a password for some reason. If i change the rsync command to add root before at sign it works. So there is some logic issue in the username not being injected correctly.

Comment by Ben Thompson (Inactive) [ 2017-01-10 ]

The enableMysqlReplication appears to be fixed by MCOL-475

Comment by Ben Thompson (Inactive) [ 2017-01-10 ]

The addmodule should be tested again after the introduction of MCOL-481 fix that changes the behavior for enabling replication by default.

Comment by Ben Thompson (Inactive) [ 2017-01-12 ]

Please refer to the linked issues.

Comment by David Hill (Inactive) [ 2017-01-23 ]

did addmodule and mysql rep was working
did both the disable and enable with ssh setup, both worked

Generated at Thu Feb 08 02:21:18 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.