Server

MariaDB 설치 (Ubuntu14.04 + MariaDB 10.1)

Author: Thorpe Lee(koangbok@gmail.com), Front&Back-end Developer, posted on 2016-07-30 10:40:49

Print - 프린트하기


1.DESCRIPTION

1.1 Notice

이번에는 Ubunt 14.04에 MariaDB 10.1 버전 설치를 해보도록 하겠습니다. 기본적으로 Ubuntu 14.04버전이 설치되어있어야 하겠지요. 

1.2 Application and Envirment

OS Ubuntu 14.04
MariaDb 10.1

 

1.3.Common

root@shell:~$ apt-get update
root@shell:~$ apt-get upgrade

 

2.INSTALL

2.1 MariaDB설치 

root@shell:~$ sudo apt-get install software-properties-common

[sudo] password for thorpe: ******

Reading package lists... Done
Building dependency tree       
Reading state information... Done
software-properties-common is already the newest version.
software-properties-common set to manually installed.
The following packages were automatically installed and are no longer required:
  libntdb1 python-ntdb
Use 'apt-get autoremove' to remove them.
0 upgraded, 0 newly installed, 0 to remove and 17 not upgraded.

root@shell:~$ sudo apt-key adv --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db

Executing: gpg --ignore-time-conflict --no-options --no-default-keyring \
--homedir /tmp/tmp.c9WOJuF2fA --no-auto-check-trustdb --trust-model always \
--keyring /etc/apt/trusted.gpg --primary-keyring /etc/apt/trusted.gpg --recv-keys --keyserver hkp://keyserver.ubuntu.com:80 0xcbcb082a1bb943db
gpg: requesting key 1BB943DB from hkp server keyserver.ubuntu.com
gpg: key 1BB943DB: public key "MariaDB Package Signing Key " imported
gpg: Total number processed: 1
gpg:               imported: 1

root@shell:~$ sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el] http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu trusty main'

root@shell:~$ sudo apt-get update

Get:1 http://ftp.kaist.ac.kr trusty InRelease [3,234 B]
Ign http://kr.archive.ubuntu.com trusty InRelease                              
Hit http://kr.archive.ubuntu.com trusty-updates InRelease                      
Get:2 http://ftp.kaist.ac.kr trusty/main amd64 Packages [5,557 B]              
Hit http://kr.archive.ubuntu.com trusty-backports InRelease                    
Hit http://kr.archive.ubuntu.com trusty Release.gpg                            
Hit http://kr.archive.ubuntu.com trusty-updates/main Sources                   
Hit http://kr.archive.ubuntu.com trusty-updates/restricted Sources  
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
중간 생략
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Hit http://security.ubuntu.com trusty-security/main Translation-en  
Hit http://security.ubuntu.com trusty-security/multiverse Translation-en  
Hit http://security.ubuntu.com trusty-security/restricted Translation-en 
Ign http://extras.ubuntu.com trusty/main Translation-en_US               
Hit http://security.ubuntu.com trusty-security/universe Translation-en
Ign http://extras.ubuntu.com trusty/main Translation-en
Fetched 20.1 kB in 5s (3,910 B/s)
Reading package lists... Done

root@shell:~$ sudo apt-get install mariadb-server

Reading package lists... Done
Building dependency tree       
Reading state information... Done
The following packages were automatically installed and are no longer required:
  libntdb1 python-ntdb
Use 'apt-get autoremove' to remove them.
The following extra packages will be installed:
  galera-3 gawk libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl
  libjemalloc1 libmariadbclient18 libmysqlclient18 mariadb-client-10.1
  mariadb-client-core-10.1 mariadb-common mariadb-server-10.1
  mariadb-server-core-10.1 mysql-common socat
Suggested packages:
  gawk-doc libmldbm-perl libnet-daemon-perl libplrpc-perl
  libsql-statement-perl libipc-sharedcache-perl libterm-readkey-perl mailx
  mariadb-test tinyca
The following NEW packages will be installed:
  galera-3 gawk libaio1 libdbd-mysql-perl libdbi-perl libhtml-template-perl
  libjemalloc1 libmariadbclient18 libmysqlclient18 mariadb-client-10.1
  mariadb-client-core-10.1 mariadb-common mariadb-server mariadb-server-10.1
  mariadb-server-core-10.1 mysql-common socat
0 upgraded, 17 newly installed, 0 to remove and 17 not upgraded.
Need to get 22.2 MB of archives.
After this operation, 181 MB of additional disk space will be used.
Do you want to continue? [Y/n]  <= Y를 입력한후 설치 진행을 계속해주세요.

 

Get:1 http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu/ trusty/main mysql-common all 10.1.16+maria-1~trusty [8,450 B]
Get:2 http://kr.archive.ubuntu.com/ubuntu/ trusty/main gawk amd64 1:4.0.1+dfsg-2.1ubuntu2 [781 kB]
Get:3 http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu/ trusty/main mariadb-common all 10.1.16+maria-1~trusty [3,212 B]
Get:4 http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu/ trusty/main galera-3 amd64 25.3.15-trusty [6,906 kB]
Get:5 http://kr.archive.ubuntu.com/ubuntu/ trusty/main libaio1 amd64 0.3.109-4 [6,364 B]
Get:6 http://kr.archive.ubuntu.com/ubuntu/ trusty/main libdbi-perl amd64 1.630-1 [879 kB]
Get:7 http://kr.archive.ubuntu.com/ubuntu/ trusty/main libdbd-mysql-perl amd64 4.025-1 [99.3 kB]

 

2016-08-02  8:48:38 140214127265536 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-08-02  8:48:38 140215044454336 [Note] Plugin 'FEEDBACK' is disabled.
 * Starting MariaDB database server mysqld                                                                                                                                                                      [ OK ] 
 * Checking for corrupt, not cleanly closed and upgrade needing tables.
Processing triggers for ureadahead (0.100.0-16) ...
Setting up mariadb-server (10.1.16+maria-1~trusty) ...
Processing triggers for libc-bin (2.19-0ubuntu6.9) ...

 

root@shell:~$ vi //etc/apt/sources.list.d/MariaDB

# MariaDB 10.1 repository list - created 2016-08-01 23:41 UTC
# http://downloads.mariadb.org/mariadb/repositories/
deb [arch=amd64,i386] http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu trusty main
deb-src http://ftp.kaist.ac.kr/mariadb/repo/10.1/ubuntu trusty main

root@shell:~$ /etc/init.d/mysql start

 * Starting MariaDB database server mysqld                                                                                   [ OK ]

root@shell:~$ mysql -u root -p mysql

Enter password: ************

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.
Your MariaDB connection id is 44
Server version: 10.1.16-MariaDB-1~trusty mariadb.org binary distribution

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 [mysql]>

If you see like that, the installation is finished

 

3.REFERENCE and LINKS


3.1 Link

https://downloads.mariadb.org/mariadb/repositories/#mirror=kaist&distro=Ubuntu&distro_release=trusty--ubuntu_trusty&version=10.1

https://mariadb.com/kb/en/mariadb/yum/