Details
-
Bug
-
Status: Closed (View Workflow)
-
Trivial
-
Resolution: Won't Fix
-
5.6.1
-
None
Description
We can make the initial user experience slightly better by having all CS aliases sourced automatically upon a fresh install. Thus not requiring the user exit and relogin as root
Tested on Centos 7 in AWS. t2.medium
Installed:
|
MariaDB-columnstore-engine.x86_64 0:10.5.9_6_5.5.2-1.el7_9 |
|
|
Dependency Installed:
|
boost-atomic.x86_64 0:1.53.0-28.el7 boost-chrono.x86_64 0:1.53.0-28.el7 boost-date-time.x86_64 0:1.53.0-28.el7 boost-filesystem.x86_64 0:1.53.0-28.el7 boost-regex.x86_64 0:1.53.0-28.el7 |
boost-system.x86_64 0:1.53.0-28.el7 boost-thread.x86_64 0:1.53.0-28.el7 jemalloc.x86_64 0:3.6.0-1.el7 libicu.x86_64 0:50.2-4.el7_7 python3.x86_64 0:3.6.8-18.el7 |
python3-libs.x86_64 0:3.6.8-18.el7 python3-pip.noarch 0:9.0.3-8.el7 python3-setuptools.noarch 0:39.2.0-10.el7 |
|
|
Complete!
|
[root@ip-172-31-9-10 centos]# |
[root@ip-172-31-9-10 centos]# |
[root@ip-172-31-9-10 centos]# alias |
alias cp='cp -i' |
alias egrep='egrep --color=auto' |
alias fgrep='fgrep --color=auto' |
alias grep='grep --color=auto' |
alias l.='ls -d .* --color=auto' |
alias ll='ls -l --color=auto' |
alias ls='ls --color=auto' |
alias mv='mv -i' |
alias rm='rm -i' |
alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde' |
Notice after you exit and relogin, the aliases are sourced
[root@ip-172-31-9-10 centos]# exit |
exit
|
[centos@ip-172-31-9-10 ~]$ sudo su |
[root@ip-172-31-9-10 centos]# alias |
alias core='cd /var/log/mariadb/columnstore/corefiles' |
alias cp='cp -i' |
alias dbrm='cd /var/lib/columnstore/data1/systemFiles/dbrm' |
alias egrep='egrep --color=auto' |
alias fgrep='fgrep --color=auto' |
alias grep='grep --color=auto' |
alias l.='ls -d .* --color=auto' |
alias ll='ls -l --color=auto' |
alias ls='ls --color=auto' |
alias mcsModule='cat /var/lib/columnstore/local/module' |
alias mcsReadOnly='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/mode-set --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":20, "mode": "readonly"}'\'' -k | jq .' |
alias mcsReadWrite='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/mode-set --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":20, "mode": "readwrite"}'\'' -k | jq .' |
alias mcsShutdown='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/shutdown --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":60}'\'' -k | jq .' |
alias mcsStart='curl -s -X PUT https://127.0.0.1:8640/cmapi/0.4.0/cluster/start --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' --data '\''{"timeout":60}'\'' -k | jq .' |
alias mcsStatus='curl -s https://127.0.0.1:8640/cmapi/0.4.0/cluster/status --header '\''Content-Type:application/json'\'' --header '\''x-api-key:'\'' -k | jq .' |
alias mv='mv -i' |
alias rm='rm -i' |
alias tcrit='tail -f /var/log/mariadb/columnstore/crit.log' |
alias tdebug='tail -f /var/log/mariadb/columnstore/debug.log' |
alias terror='tail -f /var/log/mariadb/columnstore/err.log' |
alias tinfo='tail -f /var/log/mariadb/columnstore/info.log' |
alias twarning='tail -f /var/log/mariadb/columnstore/warning.log' |
alias which='alias | /usr/bin/which --tty-only --read-alias --show-dot --show-tilde' |
Quick path
sudo yum install wget -y
wget https://dlm.mariadb.com/enterprise-release-helpers/mariadb_es_repo_setup
chmod +x mariadb_es_repo_setup
sudo ./mariadb_es_repo_setup --token="xxxxxxxxxxxxxxxxxx" --apply --mariadb-server-version="10.5" --mariadb-maxscale-version=2.5
yum install epel-release -y
yum install python2 python2-PyMySQL python2-pip -y
yum install -y MariaDB-server MariaDB-backup MariaDB-shared MariaDB-client MariaDB-columnstore-engine mariadb-columnstore-cmapi
alias