[MCOL-481] Add prompt to disable/enable mysql replication in postConfigure Created: 2016-12-21  Updated: 2023-10-26  Resolved: 2017-01-20

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

Type: Bug Priority: Trivial
Reporter: David Hill (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MCOL-467 replication setup issues when adding ... Closed
Sprint: 2017-01, 2017-2

 Description   

Add prompt to disable/enable mysql replication in postConfigure during install time.

You can already disable and enable via mcsadmin



 Comments   
Comment by David Hill (Inactive) [ 2016-12-21 ]

add to the 1.0.6.1 repo work

commit fb09099a06e95bb27f9084b9964d2b9c86f54049
Author: David Hill <david.hill@mariadb.com>
Date: Wed Dec 21 13:04:52 2016 -0600

MCOL-481 - added mysql replication prompt

oamapps/postConfigure/postConfigure.cpp | 88 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++----------------------------
1 file changed, 60 insertions, 28 deletions

Comment by David Hill (Inactive) [ 2016-12-21 ]

also change in procmgr

commit 270a67828060bcad287569f5164d54ac538df77e
Author: David Hill <david.hill@mariadb.com>
Date: Wed Dec 21 13:09:22 2016 -0600

MCOL-481 - added mysql replication prompt

procmgr/processmanager.cpp | 20 --------------------
1 file changed, 20 deletions

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

pull request done

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

test

1. run postConfigure on multi-node system setup and enter 'y' to enable mysql replication. make sure mysql replication works
2. run postConfigure on multi-node system setup and enter 'n' to enable mysql replication. make sure mysql replication is not working

Comment by Daniel Lee (Inactive) [ 2017-01-17 ]

Build verified: Github source build.

[root@builder mariadb-columnstore-server]# git show
commit 83b0e5c54a644bc31461752cf73f0e1140586d39
Merge: b975814 93c1c7e
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 12 09:27:28 2017 -0600

Merge pull request #26 from mariadb-corporation/MCOL-500

Update README.md

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

updated the NOTE and prompt

NOTE: The MariaDB ColumnStore Schema Sync feature will replicate all of the
schemas and InnoDB tables across the User Module nodes. This feature can be enabled
or disabled, for example, if you wish to configure your own replication post installation.

MariaDB ColumnStore Schema Sync feature, do you want to enable? [y,n] >

Comment by Daniel Lee (Inactive) [ 2017-01-19 ]

Build tested: 1.0.7-1

Name : mariadb-columnstore-platform
Version : 1.0.7
Release : 1
Architecture: x86_64
Install Date: Thu 19 Jan 2017 02:16:14 PM UTC
Group : Applications/Databases
Size : 10001266
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.7-1.src.rpm
Build Date : Wed 18 Jan 2017 10:16:48 PM UTC

For a 2UM combo installation, when prompted with the following question in postConfigure:

MariaDB ColumnStore Schema Sync feature, do you want to enable? [y,n] > y

I answered with an "y" and schema sync was not enabled.

"grep MySQLRep /usr/local/mariadb/columnstore/etc/Columnstore.xml" return n on both nodes.

<MySQLRep>n</MySQLRep>

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

Fixed issue reported by Daniel, also found another issue when doing the full retest. When setup a system with 1 pm, mysqlrep flag got set correctly with potsConfigure change, but was getting cleared by Procmgr because it was a 1 node system. So I removed that logic from ProcMgr

DEVELOP REPO

commit 8f2bfb58de1d201b18d3d3f24a749ef67ee9e369
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 19 15:16:17 2017 -0600

MCOL-481 fix

oamapps/postConfigure/postConfigure.cpp | 47 ++++++++++++++++++-----------------------------
procmgr/processmanager.cpp | 22 +++-------------------

DEVELOP-1.0 REPO

commit ddf6d15bec6ab64a50c681f5293dae2019a4c755
Author: david hill <david.hill@mariadb.com>
Date: Thu Jan 19 15:04:00 2017 -0600

MCOL-481 fix

oamapps/postConfigure/postConfigure.cpp | 47 ++++++++++++++++++-----------------------------
procmgr/processmanager.cpp | 22 +++-------------------

Comment by Daniel Lee (Inactive) [ 2017-01-20 ]

mcsadmin> getsoft
getsoftwareinfo Fri Jan 20 22:49:09 2017

Name : mariadb-columnstore-platform
Version : 1.0.7
Release : 1
Architecture: x86_64
Install Date: Fri 20 Jan 2017 10:46:12 PM UTC
Group : Applications/Databases
Size : 10001348
License : Copyright (c) 2016 MariaDB Corporation Ab., all rights reserved; redistributable under the terms of the GPL, see the file COPYING for details.
Signature : (none)
Source RPM : mariadb-columnstore-platform-1.0.7-1.src.rpm
B

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