[MCOL-3686] Improve installation procedure and reduce SQL limitations Created: 2019-12-23  Updated: 2020-05-08  Due: 2020-02-13  Resolved: 2020-05-08

Status: Closed
Project: MariaDB ColumnStore
Component/s: N/A
Affects Version/s: None
Fix Version/s: 1.4.4

Type: Task Priority: Critical
Reporter: Sergei Golubchik Assignee: David Hall (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Relates
Sub-Tasks:
Key
 Summary
 Type
 Status
 Assignee
MCOL-3707 Run columnstore-post-install on combi... Sub-Task Closed Daniel Lee  
MCOL-3708 RPM/DEB removal should run mcsadmin s... Sub-Task Closed Daniel Lee  
MCOL-3709 Package purge should remove /var/lib/... Sub-Task Closed Patrick LeBlanc  
MCOL-3718 Use MariaDB system instead of mysql-C... Sub-Task Closed Daniel Lee  
MCOL-128 ALTER TABLE conversion to columnstore... Sub-Task Closed susil.behera  
MCOL-3349 CTAS (Create Table as Select) Sub-Task Closed susil.behera  
MCOL-3720 AUTO_INCREMENT should pass but warn Sub-Task Closed Andrew Hutchings  
MCOL-3721 COLLATE used in DDL and ORDER BY shou... Sub-Task Closed Daniel Lee  
MCOL-3852 CLONE - ALTER TABLE conversion to col... Sub-Task Closed Daniel Lee  
MCOL-3862 CLONE - COLLATE used in DDL and ORDER... Sub-Task Closed Daniel Lee  
Sprint: 2020-1, 2020-2, 2020-4, 2020-5, 2020-6, 2020-7

 Description   

unconditional part of post-install and postConfigure should be run automatically by package manager

uninstallation should shutdown the "system" and stop all columnstore processes

purge should delete all data

should use systemd/sysv as the mariadb server

ideally should work like a normal plugin

ideally shouldn't ssh into other hosts for cluster management

From the meeting in Frankfurt:

  • ALTER TABLE ENGINE=COLUMNSTORE
  • CREATE TABLE AS SELECT
  • COLLATION should not result in an error, a warning should be added
  • remove auto_increment implementation for ColumnStore
    • Test SEQUENCES to replace this

 Comments   
Comment by Andrew Hutchings (Inactive) [ 2020-01-03 ]

Created sub-tasks for the things that can be dealt with in 1.4. To some extent systemd is already used (columnstore-post-install installs the service currently and after postConfigure it can be used). The rest is part of a bigger project for 1.5 which will be linked to this when the tasks are created.

Comment by Ralf Gebhardt [ 2020-01-10 ]

The list in this task has been defined in Frankfurt to be the minimum needed to change the maturity of the storage engine to stable

Comment by Ralf Gebhardt [ 2020-03-03 ]

Hi julien.fritsch,

can this task really be closed? The requirements from Frankfurt are covered, but the task is listing other topics serg wants to get addressed at some point.

/Ralf

Comment by David Hall (Inactive) [ 2020-05-08 ]

All subtasks are done

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