In Note 1369139.1 Oracle make this statement...

"Due to the easier maintenance when using the RPM installations, Oracle recommends using these if possible, although considerations such as installing into a non-default location will tend to favor using the tar-ball."

Opinion: In an Enterprise environment where separate teams are responsible for OS and database and where an Enterprise Management solution is in place to raise automated alerts on conditions such as filesystems filling, I believe the tar-ball installation can help maintain clear lines of responsibility (e.g. if /mysql filesystem usage breaches a threshold then DBA team will be engaged, if /opt usage breaches a threshold then UNIX team will be engaged. Also, UNIX patching can be done on a separate schedule to MySQL patching, thus helping support teams more easily identify root cause of issues associated with the patches and allowing MySQL patches to be delayed whilst they are tested on other servers without impacting critical OS level patching). Note that you can have the best of both worlds by making the default install location a separate mount point.

The steps shown are based on a tarball installation for Oracle Enterprise Linux 7

Download

TAR

cd /mysql

unzip ${ZIPFILE}

tar xvf ${TARFILE}.tar.gz
ln -s ${TARFILE} mysql-shell
mv README.txt mysql-shell
rm -f ${TARFILE}.tar.gz
rm -f ${TARFILE}.tar.gz.asc
rm -f ${TARFILE}.tar.gz.md5
rm -f ${ZIPFILE}.zip
export PATH=/mysql/mysql-shell/bin:$PATH

Add this to the .bash_profile for the root user

8.0.23 (EL7)

8.0.24 (Generic)

8.0.26 (Generic)

RPM

APT (Ubuntu)

sudo apt update

sudo apt install mysql-shell

YUM (OEL/RHEL)

yum install mysql-shell

mysqlsh

\c root@localhost

\q

Help

\h

session.help()

session.help('getSchemas')

dba.help('getCluster')

Interpreters

\py

\sql

\js

shell.options.setPersist('defaultMode','sql')

Databases

\js

session.getSchemas()

\py

session.getSchemas()

\sql

show databases;

Innodb Cluster

var cluster = dba.getCluster('myCluster');

cluster.status()

cluster.describe()

cluster.options()

dba.checkInstanceConfiguration()

dba.configureLocalInstance()

cluster.addInstance('icadmin@node2:3306')

cluster.switchToMultiPrimaryMode()

cluster.switchToSinglePrimaryMode()

cluster.setPrimaryInstance('node3')

cluster.setupRouterAccount('icadmin', {'update':1})

cluster.listRouters()

dba.upgradeMetadata()

History

\option --persist history.autosave 1

Start mysqlsh

Connect to local database server as root@localhost

Quit

help

methods for 'session' object

help with 'getSchemas' method of 'session' object

help with 'getCluster' method of 'dba' object

invoke Python interpreter

invoke SQL interpreter

invoke javascript interpreter

Set SQL interprester as default

javascript

Show Databases

python

Show Databases

SQL

Show Databases

Define 'cluster' object

Cluster Status

Describe cluster

Cluster options

Check Instance Configuration

Configure Local Instance

Add instance (needs extra options, see InnoDB cluster page)

Multiple R/W Primary mode

One R/W, multiple RO

Set Primary instance

Setup a Router account

List Routers

Upgrade Metadata

Persist shell history between sessions