CentOS6.4にMariaDBとか入れてみた

Twitter ツイート Hatena Bookmark ブックマーク

新しいVPSがきたので、早速MariaDB入れてみようと思った僕です。
ついでに普通のLAMP構成っぽいインストールログを残しておくよ。

てかyum installでrpmが入るとかいいね。素敵ですね!

まずはremiリポジトリを用意する

1
2
# yum install http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
# rpm --import http://rpms.famillecollet.com/RPM-GPG-KEY-remi

apacheのインストール

1
# yum install http-devel --enablerepo=remi

memcachedのインストール

1
# yum install memcached --enablerepo=remi

mariaDBのインストール

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
# rpm --import https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
# vim /etc/yum.repos.d/mariadb.repo

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/10.0.3/centos6-x86
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

# yum install MariaDB-devel MariaDB-client MariaDB-server --enablerepo=remi

phpを入れる

1
2
3
4
# yum install php-devel php php-mbstring php-mysqli  php-pecl-memcached php-gd php-mcrypt --enablerepo=remi
# vim /etc/php.ini

++date.timezone = Asia/Tokyo

とりあえずMariaDBでHandlerSocket試す

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
# vim /etc/my.cnf.d/server.d
[mysqld]
plugin-load=handlersocket.so

# /etc/init.d/mysqld restart
mysql -u root
MariaDB [(none)]> SHOW PLUGINS;
+----------------------------+----------+--------------------+------------------+---------+
| Name                       | Status   | Type               | Library          | License |
+----------------------------+----------+--------------------+------------------+---------+
| binlog                     | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| mysql_native_password      | ACTIVE   | AUTHENTICATION     | NULL             | GPL     |
| mysql_old_password         | ACTIVE   | AUTHENTICATION     | NULL             | GPL     |
| MEMORY                     | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| MRG_MyISAM                 | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| MyISAM                     | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| CSV                        | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| ARCHIVE                    | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| FEDERATED                  | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| InnoDB                     | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| INNODB_TRX                 | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_LOCKS               | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_LOCK_WAITS          | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_CMP                 | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_CMP_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_CMPMEM              | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_CMPMEM_RESET        | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_BUFFER_PAGE         | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_BUFFER_PAGE_LRU     | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_BUFFER_POOL_STATS   | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_METRICS             | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_DEFAULT_STOPWORD | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_INSERTED         | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_DELETED          | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_BEING_DELETED    | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_CONFIG           | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_INDEX_CACHE      | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_FT_INDEX_TABLE      | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_TABLES          | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_TABLESTATS      | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_INDEXES         | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_COLUMNS         | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_FIELDS          | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_FOREIGN         | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| INNODB_SYS_FOREIGN_COLS    | ACTIVE   | INFORMATION SCHEMA | NULL             | GPL     |
| PERFORMANCE_SCHEMA         | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| Aria                       | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| BLACKHOLE                  | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| FEEDBACK                   | DISABLED | INFORMATION SCHEMA | NULL             | GPL     |
| partition                  | ACTIVE   | STORAGE ENGINE     | NULL             | GPL     |
| handlersocket              | ACTIVE   | DAEMON             | handlersocket.so | BSD     |
+----------------------------+----------+--------------------+------------------+---------+

一番したにHandlerSocketが入っている事がわかりますね。

comments powered by Disqus
Built with Hugo
テーマ StackJimmy によって設計されています。