[MCOL-3306] non-root install my.sql default location support Created: 2019-05-13  Updated: 2020-08-25  Resolved: 2019-10-07

Status: Closed
Project: MariaDB ColumnStore
Component/s: MariaDB Server
Affects Version/s: None
Fix Version/s: 1.4.0

Type: New Feature Priority: Major
Reporter: David Hill (Inactive) Assignee: Todd Stoffel (Inactive)
Resolution: Fixed Votes: 0
Labels: None


 Description   

Customer request enhancement for non-root install and the default setup for my.cnf

1. MYSQL_HOME is not defined - appears to be much more useful for non-root installs for apps to locate the my.cnf file

2. When a my.cnf file cannot be located, the client tries to use a bogus internal default socket 'db/mysql.sock' file, which does not exist.

3. software support the default /etc/my.cnf



 Comments   
Comment by Andrew Hutchings (Inactive) [ 2019-09-26 ]

toddstoffel In 1.4.0 the columnstore specific settings are stored in /etc/my.cnf.d/columnstore.cnf which is loaded in by my.cnf. Does that fulfil the requirements here?

Comment by David Hill (Inactive) [ 2019-10-07 ]

Support case ID has been corrected

Comment by David Hill (Inactive) [ 2019-10-07 ]

customer feedback

not sure which requirement they are trying to fulfil with that statement.

Steps we took to resolve the issue was to define MYSQL_HOME
$ env | grep MYSQL_HOME
MYSQL_HOME=/home/mysql/mariadb/columnstore/mysql

Add a custom cnf file to /home/mysql/mariadb/columnstore/mysql/my.cnf.d and edit /home/mysql/mariadb/columnstore/mysql/my.cnf to add a line with
!includedir /home/mysql/mariadb/columnstore/mysql/my.cnf.d/
so the files there would be read.

After postConfigure is executed and it and the system startup puts all these files in place,
we have to shut down the system and start it again to get all the changes to be active. Otherwise the mysql schema (and any schemas created after that) uses the previous system default character set latin1 instead of the final desired configuration of utf8.

FYI on the 1.2.5 system we just stood up, there is not a columnstore.cnf in the specified location.
$ pwd
/home/mysql/mariadb/columnstore/mysql/my.cnf.d
$ ls
auth_gssapi.cnf client.cnf enable_encryption.preset mysql-clients.cnf rocksdb.cnf server.cnf tokudb.cnf z-sas.cnf

The last one being our custom file.

Comment by Andrew Hutchings (Inactive) [ 2019-10-07 ]

In that case it will be fixed in 1.4. With 1.4 we load the default /etc/my.cnf and have ColumnStore specific options in /etc/my.cnf.d/columnstore.cnf. A user can add their own options in /etc/my.cnf.d.

Comment by David Hill (Inactive) [ 2019-10-08 ]

Question Is this the location for non-root installs or is non-root install supported in 1.4

/etc/my.cnf.d/columnstore.cnf

Comment by Andrew Hutchings (Inactive) [ 2019-10-08 ]

The former for now, we haven't made a decision on the latter.

Comment by David Hill (Inactive) [ 2019-10-08 ]

Since this is non-root install related,
I dont think it should be closed
until we know how non-root
will be supported in 1.4

Comment by Andrew Hutchings (Inactive) [ 2019-10-09 ]

If non-root goes away it will be replaced by something else. Either way the paths have already changed in 1.4.

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