ソースコンパイル

• Oracle

プロプラエタリ

• MySQL

(5.6)
参考 : http://d.hatena.ne.jp/yk5656/20140729/1407026787

yum -y install wget cmake gcc gcc-c++ ncurses-devel perl

mkdir /usr/local/mysql

cd /usr/local/src/
wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.19.tar.gz/from/http://cdn.mysql.com/ -O mysql.tar.gz
tar xvfz mysql.tar.gz
cd mysql-5.6.19

--rm -rf CMakeCache.txt
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci

make
make install

groupadd mysql
useradd -g mysql -d /usr/local/mysql mysql
chown -R mysql:mysql /usr/local/mysql

mkdir /var/lib/mysql

/usr/local/mysql/scripts/mysql_install_db --user=mysql --datadir=/var/lib/mysql -basedir=/usr/local/mysql
chown -R mysql:mysql /var/lib/mysql/*

vim /etc/my.cnf

[client]
socket=/var/lib/mysql/mysql.sock

su - mysql

vim .bash_profile
export PATH=/usr/local/mysql/bin:$PATH

. .bash_profile

--起動
/usr/local/mysql/bin/mysqld --pid-file=/var/lib/mysql/mysqld.pid --datadir=/var/lib/mysql &

--接続確認(パスワード設定前)
/usr/local/mysql/bin/mysql -u root -h localhost

--パスワード設定
set password for 'root'@'localhost' = password('Aaa!1234');
flush privileges;

--接続確認
/usr/local/mysql/bin/mysql -u root -h localhost -p'Aaa!1234'

--停止
/usr/local/mysql/bin/mysqladmin -u root -h localhost -p'Aaa!1234' shutdown

--自動起動スクリプト作成

vim /var/lib/mysql/mysqlstart
#!/bin/sh
/usr/local/mysql/bin/mysqld --pid-file=/var/lib/mysql/mysqld.pid --datadir=/var/lib/mysql &

vim /var/lib/mysql/mysqlstop
#!/bin/sh
/usr/local/mysql/bin/mysqladmin -u root -h localhost -p'Aaa!1234' shutdown > /dev/null

chmod +x /var/lib/mysql/mysqlstart
chmod +x /var/lib/mysql/mysqlstop

exit

vim /usr/lib/systemd/system/mysqld.service

[Unit]
Description=MySQL Server
After=network.target

[Service]
Type=forking
ExecStart=/var/lib/mysql/mysqlstart
ExecStop=/var/lib/mysql/mysqlstop
User=mysql

[Install]
WantedBy=multi-user.target

--サービスでの起動と停止
systemctl daemon-reload

systemctl start mysqld
systemctl status mysqld
systemctl enable mysqld
systemctl stop mysqld

• PostgreSQL

参考 : https://qiita.com/shadowhat/items/0225dfc4347aa6d260f3

(9.6)

--OS標準のPostgreSQLのアンインストール

rpm -e qt-postgresql-4.8.5-13.el7.x86_64
rpm -e qt5-qtbase-postgresql-5.6.1-10.el7.x86_64
rpm -e postgresql-devel-9.2.18-1.el7.x86_64
rpm -e qt3-PostgreSQL-3.3.8b-51.el7.x86_64
rpm -e postgresql-libs-9.2.18-1.el7.x86_64

--ユーザーと作業ディレクトリの作成

mkdir /usr/local/pgsql
useradd postgres
echo postgres | passwd --stdin postgres
chown postgres:postgres /usr/local/pgsql

--インストール作業

yum install -y gcc
yum install -y zlib-devel

cd /usr/local/src
wget https://ftp.postgresql.org/pub/source/v9.6.3/postgresql-9.6.3.tar.gz
tar xvzf postgresql-9.6.3.tar.gz
chown -R postgres:postgres postgresql-9.6.3
su postgres
cd postgresql-9.6.3
./configure --without-readline
make
make install

--環境変数を設定

vim ~/.bashrc

export PATH="$PATH":/usr/local/pgsql/bin
export POSTGRES_HOME=/usr/local/pgsql
export PGLIB=$POSTGRES_HOME/lib
export PGDATA=$POSTGRES_HOME/data
export MANPATH="$MANPATH":$POSTGRES_HOME/man
export LD_LIBRARY_PATH="$LD_LIBRARY_PATH":"$PGLIB"

source ~/.bashrc

mkdir $PGDATA

--DBを初期化

initdb --encoding=UTF-8 --no-locale

--Listenアドレスの設定

vim /usr/local/pgsql/data/postgresql.conf

#listen_addresses = 'localhost'
↓
listen_addresses = '*'

--ListenIP範囲の設定
vim $PGDATA/pg_hba.conf

host all all 0.0.0.0/0 trust

--起動
pg_ctl status
pg_ctl -w start
pg_ctl status
pg_ctl -w stop
pg_ctl status

• SQL Server

プロプラエタリ