[MCOL-528] Local query would not work if user chose not to enable schema sync Created: 2017-01-20  Updated: 2017-12-01  Resolved: 2017-01-22

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

Type: New Feature Priority: Minor
Reporter: Daniel Lee (Inactive) Assignee: Ben Thompson (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Sprint: 2017-2

 Description   

Build tested: 1.0.7-1

For 1.0.7-1, we added a prompt in postConfigure to allow user to enable or disable schema sync. If the user chose not to enable schema sync and enable local query in the next prompt, local query will not work since it requires schema sync enabled. We need to do one of the following:

1) Prompt for local query first, if the answer is yes, then turn on schema sync without prompt the user. This would be the preferred method

2) If the user answered n to schema sync, and y to local query, we still enable schema sync, overriding the user's answer (n to the schema sync question)


===== Setup System Module Type Configuration =====
==> pm1:
==> pm1: There are 2 options when configuring the System Module Type: separate and combined
==> pm1:
==> pm1: 'separate' - User and Performance functionality on separate servers.
==> pm1:
==> pm1: 'combined' - User and Performance functionality on the same server
==> pm1: Select the type of System Module Install [1=separate, 2=combined] (2) > 1
==> pm1:
==> pm1: NOTE: The MariaDB ColumnStore Schema Sync feature will replicate all of the
==> pm1: schemas and InnoDB tables across the User Module nodes. This feature can be enabled
==> pm1: or disabled, for example, if you wish to configure your own replication post installation.
==> pm1: MariaDB ColumnStore Schema Sync feature, do you want to enable? [y,n] > n
==> pm1: Seperate Server Installation will be performed.
==> pm1:
==> pm1: NOTE: Local Query Feature allows the ability to query data from a single Performance
==> pm1: Module. Check MariaDB ColumnStore Admin Guide for additional information.
==> pm1: Enable Local Query feature? [y,n] > y
==> pm1:
==> pm1: NOTE: Local Query Feature is enabled



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

Reviewed and merged

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

DEVELOPER TEST FROM BUILD

when local query feature is answered as no, the prompt to schema sync occurrs

NOTE: Local Query Feature allows the ability to query data from a single Performance
Module. Check MariaDB ColumnStore Admin Guide for additional information.

Enable Local Query feature? [y,n] >

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] >

------------------------------------------------------------------------------------------------------------------

Why local query is answered yes, schema sync is not prompted. its default to on.

NOTE: Local Query Feature allows the ability to query data from a single Performance
Module. Check MariaDB ColumnStore Admin Guide for additional information.

Enable Local Query feature? [y,n] > y

NOTE: Amazon AWS CLI Tools are installed and allow MariaDB ColumnStore to create Instances and ABS Volumes

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

Build verified: 1.0.7-0

mcsadmin> getsoft
getsoftwareinfo Sun Jan 22 17:06:08 2017

Name : mariadb-columnstore-platform
Version : 1.0.7
Release : 1
Architecture: x86_64
Install Date: Sun 22 Jan 2017 12:21:18 PM CST
Group : Applications/Databases
Size : 10013744
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

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