[MariaDB]: Installation from Linux tar ball

August 11, 2015 · by · in MariaDB

You can download mariadb package from https://downloads.mariadb.org/ and copy to your linux box

[ root @ vm-16af-8253 : /mariadb ] ll -lhtr
total 296M
-rw-r–r– 1 sm70768 mongod 296M Aug 11 01:38 mariadb-10.0.21-linux-x86_64.tar.gz
[ root @ myhostname : /mariadb ]
[ root @ myhostname : /mariadb ]
[ root @ myhostname : /mariadb ]
[ root @ myhostname : /mariadb ]
[ root @ myhostname : /mariadb ] groupadd mysql
[ root @ myhostname : /mariadb ] useradd -g mysql mysql
[ root @ myhostname : /mariadb ] cd /usr/local
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ] tar -zxvpf /mariadb/mariadb-10.0.21-linux-x86_64.tar.gz
mariadb-10.0.21-linux-x86_64/README
mariadb-10.0.21-linux-x86_64/CREDITS
mariadb-10.0.21-linux-x86_64/COPYING
mariadb-10.0.21-linux-x86_64/COPYING.LESSER
mariadb-10.0.21-linux-x86_64/EXCEPTIONS-CLIENT

———–blah blah blah —————-

mariadb-10.0.21-linux-x86_64/man/man1/mysql_client_test_embedded.1
mariadb-10.0.21-linux-x86_64/man/man8/mysqld.8
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ] ln -s mariadb-10.0.21-linux-x86_64 mysql
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ]
[ root @ myhostname : /usr/local ] ll -lhtr
total 44K
drwxr-xr-x 2 root root 4.0K Jun 28 2011 src
drwxr-xr-x 2 root root 4.0K Jun 28 2011 sbin
drwxr-xr-x 2 root root 4.0K Jun 28 2011 libexec
drwxr-xr-x 2 root root 4.0K Jun 28 2011 lib64
drwxr-xr-x 2 root root 4.0K Jun 28 2011 lib
drwxr-xr-x 2 root root 4.0K Jun 28 2011 include
drwxr-xr-x 2 root root 4.0K Jun 28 2011 games
drwxr-xr-x 2 root root 4.0K Jun 28 2011 etc
drwxr-xr-x 5 root root 4.0K Mar 25 20:02 share
drwxr-xr-x 2 root root 4.0K Jul 27 11:17 bin
drwxr-xr-x 12 root root 4.0K Aug 11 01:39 mariadb-10.0.21-linux-x86_64
lrwxrwxrwx 1 root root 28 Aug 11 01:40 mysql -> mariadb-10.0.21-linux-x86_64
[ root @ myhostname : /usr/local ] cd mysql
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] cat /etc/my.cnf
[mysqld]

port = 3306
datadir = /mariadb/mysql/data

[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] mkdir /mariadb/mysql
[ root @ myhostname : /usr/local/mysql ] mkdir /mariadb/mysql/data
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] ./scripts/mysql_install_db –user=mysql
Installing MariaDB/MySQL system tables in ‘/mariadb/mysql/data’ …
150811 1:45:03 [Note] ./bin/mysqld (mysqld 10.0.21-MariaDB) starting as process 18348 …
150811 1:45:04 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150811 1:45:04 [Note] InnoDB: The InnoDB memory heap is disabled
150811 1:45:04 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150811 1:45:04 [Note] InnoDB: Memory barrier is not used
150811 1:45:04 [Note] InnoDB: Compressed tables use zlib 1.2.3
150811 1:45:04 [Note] InnoDB: Using Linux native AIO
150811 1:45:04 [Note] InnoDB: Using CPU crc32 instructions
150811 1:45:04 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150811 1:45:04 [Note] InnoDB: Completed initialization of buffer pool
150811 1:45:04 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
150811 1:45:04 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
150811 1:45:04 [Note] InnoDB: Database physically writes the file full: wait…
150811 1:45:04 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
150811 1:45:04 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
150811 1:45:04 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
150811 1:45:04 [Warning] InnoDB: New log files created, LSN=45781
150811 1:45:04 [Note] InnoDB: Doublewrite buffer not found: creating new
150811 1:45:04 [Note] InnoDB: Doublewrite buffer created
150811 1:45:04 [Note] InnoDB: 128 rollback segment(s) are active.
150811 1:45:04 [Warning] InnoDB: Creating foreign key constraint system tables.
150811 1:45:04 [Note] InnoDB: Foreign key constraint system tables created
150811 1:45:04 [Note] InnoDB: Creating tablespace and datafile system tables.
150811 1:45:04 [Note] InnoDB: Tablespace and datafile system tables created.
150811 1:45:04 [Note] InnoDB: Waiting for purge to start
150811 1:45:04 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 0
150811 1:45:05 [Note] InnoDB: FTS optimize thread exiting.
150811 1:45:05 [Note] InnoDB: Starting shutdown…
150811 1:45:06 [Note] InnoDB: Shutdown completed; log sequence number 1616697
OK
Filling help tables…
150811 1:45:06 [Note] ./bin/mysqld (mysqld 10.0.21-MariaDB) starting as process 18375 …
150811 1:45:06 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150811 1:45:06 [Note] InnoDB: The InnoDB memory heap is disabled
150811 1:45:06 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150811 1:45:06 [Note] InnoDB: Memory barrier is not used
150811 1:45:06 [Note] InnoDB: Compressed tables use zlib 1.2.3
150811 1:45:06 [Note] InnoDB: Using Linux native AIO
150811 1:45:06 [Note] InnoDB: Using CPU crc32 instructions
150811 1:45:06 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150811 1:45:06 [Note] InnoDB: Completed initialization of buffer pool
150811 1:45:06 [Note] InnoDB: Highest supported file format is Barracuda.
150811 1:45:06 [Note] InnoDB: 128 rollback segment(s) are active.
150811 1:45:06 [Note] InnoDB: Waiting for purge to start
150811 1:45:06 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 1616697
150811 1:45:07 [Note] InnoDB: FTS optimize thread exiting.
150811 1:45:07 [Note] InnoDB: Starting shutdown…
150811 1:45:09 [Note] InnoDB: Shutdown completed; log sequence number 1616707
OK

To start mysqld at boot time you have to copy
support-files/mysql.server to the right place for your system

PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
To do so, start the server, then issue the following commands:

‘./bin/mysqladmin’ -u root password ‘new-password’
‘./bin/mysqladmin’ -u root -h myhostname password ‘new-password’

Alternatively you can run:
‘./bin/mysql_secure_installation’

which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.

See the MariaDB Knowledgebase at http://mariadb.com/kb or the
MySQL manual for more instructions.

You can start the MariaDB daemon with:
cd ‘.’ ; ./bin/mysqld_safe –datadir=’/mariadb/mysql/data’

You can test the MariaDB daemon with mysql-test-run.pl
cd ‘./mysql-test’ ; perl mysql-test-run.pl

Please report any problems at http://mariadb.org/jira

The latest information about MariaDB is available at http://mariadb.org/.
You can find additional information about the MySQL part at:
http://dev.mysql.com
Support MariaDB development by buying support/new features from MariaDB
Corporation Ab. You can contact us about this at sales@mariadb.com.
Alternatively consider joining our community based development effort:
http://mariadb.com/kb/en/contributing-to-the-mariadb-project/

[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] ll -lhtr /mariadb/mysql/data/
total 109M
drwx—— 2 mysql root 4.0K Aug 11 01:45 test
-rw-rw—- 1 mysql mysql 48M Aug 11 01:45 ib_logfile1
drwx—— 2 mysql root 4.0K Aug 11 01:45 mysql
drwx—— 2 mysql mysql 4.0K Aug 11 01:45 performance_schema
-rw-rw—- 1 mysql mysql 52 Aug 11 01:45 aria_log_control
-rw-rw—- 1 mysql mysql 16K Aug 11 01:45 aria_log.00000001
-rw-rw—- 1 mysql mysql 48M Aug 11 01:45 ib_logfile0
-rw-rw—- 1 mysql mysql 12M Aug 11 01:45 ibdata1
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] ll -lhtr
total 208K
-rw-r–r– 1 rlmadmin 500 89K Aug 5 14:11 README
-rw-r–r– 1 rlmadmin 500 8.5K Aug 5 14:11 INSTALL-BINARY
-rw-r–r– 1 rlmadmin 500 8.1K Aug 5 14:11 EXCEPTIONS-CLIENT
-rw-r–r– 1 rlmadmin 500 1.6K Aug 5 14:11 CREDITS
-rw-r–r– 1 rlmadmin 500 26K Aug 5 14:11 COPYING.LESSER
-rw-r–r– 1 rlmadmin 500 18K Aug 5 14:11 COPYING
drwxr-xr-x 3 root root 4.0K Aug 11 01:39 include
drwxr-xr-x 3 root root 4.0K Aug 11 01:39 lib
drwxr-xr-x 11 root root 4.0K Aug 11 01:39 mysql-test
drwxr-xr-x 28 root root 4.0K Aug 11 01:39 share
drwxr-xr-x 2 root root 4.0K Aug 11 01:39 bin
drwxr-xr-x 2 root root 4.0K Aug 11 01:39 scripts
drwxr-xr-x 3 root root 4.0K Aug 11 01:39 support-files
drwxr-xr-x 3 root root 4.0K Aug 11 01:39 data
drwxr-xr-x 4 root root 4.0K Aug 11 01:39 sql-bench
drwxr-xr-x 4 root root 4.0K Aug 11 01:39 man
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] ./bin/mysqld_safe –user=mysql &
[1] 18628
[ root @ myhostname : /usr/local/mysql ] 150811 01:46:43 mysqld_safe Logging to ‘/mariadb/mysql/data/myhostname.err’.
150811 01:46:43 mysqld_safe Starting mysqld daemon with databases from /mariadb/mysql/data

[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] cat /mariadb/mysql/data/myhostname.err
150811 01:46:43 mysqld_safe Starting mysqld daemon with databases from /mariadb/mysql/data
150811 1:46:43 [Note] /usr/local/mysql/bin/mysqld (mysqld 10.0.21-MariaDB) starting as process 18706 …
150811 1:46:44 [Note] InnoDB: Using mutexes to ref count buffer pool pages
150811 1:46:44 [Note] InnoDB: The InnoDB memory heap is disabled
150811 1:46:44 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
150811 1:46:44 [Note] InnoDB: Memory barrier is not used
150811 1:46:44 [Note] InnoDB: Compressed tables use zlib 1.2.3
150811 1:46:44 [Note] InnoDB: Using Linux native AIO
150811 1:46:44 [Note] InnoDB: Using CPU crc32 instructions
150811 1:46:44 [Note] InnoDB: Initializing buffer pool, size = 128.0M
150811 1:46:44 [Note] InnoDB: Completed initialization of buffer pool
150811 1:46:44 [Note] InnoDB: Highest supported file format is Barracuda.
150811 1:46:44 [Note] InnoDB: 128 rollback segment(s) are active.
150811 1:46:44 [Note] InnoDB: Waiting for purge to start
150811 1:46:44 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.25-73.1 started; log sequence number 1616707
150811 1:46:44 [Note] Plugin ‘FEEDBACK’ is disabled.
150811 1:46:44 [Warning] Failed to create a socket for IPv6 ‘::’: errno: 97.
150811 1:46:44 [Note] Server socket created on IP: ‘0.0.0.0’.
150811 1:46:44 [Note] Event Scheduler: Loaded 0 events
150811 1:46:44 [Note] /usr/local/mysql/bin/mysqld: ready for connections.
Version: ‘10.0.21-MariaDB’ socket: ‘/tmp/mysql.sock’ port: 3306 MariaDB Server
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] ps -ef | grep mysql
root 18628 15314 0 01:46 pts/1 00:00:00 /bin/sh ./bin/mysqld_safe –user=mysql
mysql 18706 18628 0 01:46 pts/1 00:00:00 /usr/local/mysql/bin/mysqld –basedir=/usr/local/mysql –datadir=/mariadb/mysql/data –plugin-dir=/usr/local/mysql/lib/plugin –user=mysql –log-error=/mariadb/mysql/data/myhostname.err –pid-file=myhostname.pid –port=3306
root 18792 15314 0 01:47 pts/1 00:00:00 grep mysql
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ] echo “export PATH=$PATH:/usr/local/mysql/bin/” >> ~/.bashrc ; source ~/.bashrc; env | grep PATH
PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/usr/local/mysql/bin/:/usr/local/mysql/bin/
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]
[ root @ myhostname : /usr/local/mysql ]

[ root @ myhostname : /usr/local/mysql/support-files ] cp mysql.server /etc/init.d/mysql
[ root @ myhostname : /usr/local/mysql/support-files ] chmod +x /etc/init.d/mysql
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ] chkconfig –add mysql
[ root @ myhostname : /usr/local/mysql/support-files ] chkconfig –level 345 mysql on
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ] service mysql restart
Shutting down MySQL..150811 01:54:46 mysqld_safe mysqld from pid file /mariadb/mysql/data/myhostname.pid ended SUCCESS!
Starting MySQL. SUCCESS!
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ] mysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 3
Server version: 10.0.21-MariaDB MariaDB Server

Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others.

Type ‘help;’ or ‘\h’ for help. Type ‘\c’ to clear the current input statement.

MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>
MariaDB [(none)]>

System specks are below.
[ root @ myhostname : /usr/local/mysql/support-files ] cat /etc/redhat-release
Red Hat Enterprise Linux Server release 6.6 (Santiago)
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ] uname -a
Linux myhostname 2.6.32-504.16.2.el6.x86_64 #1 SMP Tue Mar 10 17:01:00 EDT 2015 x86_64 x86_64 x86_64 GNU/Linux
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ] head /proc/cpuinfo
processor : 0
vendor_id : GenuineIntel
cpu family : 6
model : 45
model name : Intel(R) Xeon(R) CPU E5-2670 0 @ 2.60GHz
stepping : 7
microcode : 1808
cpu MHz : 2600.000
cache size : 20480 KB
physical id : 0
[ root @ myhostname : /usr/local/mysql/support-files ]
[ root @ myhostname : /usr/local/mysql/support-files ]

  • Ask Question
    • Tags: