[MCOL-41] Need to remove Aria as the default engine setting in my.cnf Created: 2016-05-06 Updated: 2016-05-18 Resolved: 2016-05-18 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | None |
| Fix Version/s: | 1.0.0 |
| Type: | Bug | Priority: | Minor |
| Reporter: | Daniel Lee (Inactive) | Assignee: | Daniel Lee (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Sprint: | MCOL Sprint 1 - Priority 1 |
| Description |
|
Currently, columnStore sets the following in the my.cnf file: default-storage-engine=Aria We need to set it to InfiniDB, or whatever the new name maybe for columnStore. |
| Comments |
| Comment by Dipti Joshi (Inactive) [ 2016-05-06 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Whenever user wants to create columnstore table - they should specify columnstore as the engine=, or if user prefers it to be their default storage engine - they should set "default-storage-engine” in there own my.cnf to columnstore. The out of box my.cnf's the default storage engine setting should not be changed from what MariaDB Server's default storage engine is. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Dipti Joshi (Inactive) [ 2016-05-06 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
We should remove default-storage-engine=Aria line from my.cnf, so that server defaults are used | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by David Hill (Inactive) [ 2016-05-06 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
this didn't work in InfiniDB, you couldn't set the default engine=infinidb. Also Hall requested that we make aria the default.... | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Vladislav Vaintroub [ 2016-05-07 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
setting Aria default would finally give Aria a good production test. It was never default in MariaDB. either MyISAM (up and including 5.3) or XtraDB were. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by David Hill (Inactive) [ 2016-05-09 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
The change to be made here is to REMOVE the default engine setting all together, which will make it match what InfiniDB and MariaDB both do. | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by David Hill (Inactive) [ 2016-05-09 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
changes made, need qa review and testing | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Daniel Lee (Inactive) [ 2016-05-18 ] | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Build verified: InfiniDB> getcalpontsoft Name : infinidb-platform Relocations: (not relocatable) Aris no longer the default engine. It matches with MariaDB now. Server version: 10.1.10-MariaDB InfiniDB 5.0.0 Copyright (c) 2000, 2016, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> show engines;
-------------------
------------------- |