SystemV's

yum install gcc gcc-c++ pcre-devel openssl-devel 

wget http://www.haproxy.org/download/1.5/src/haproxy-1.5.17.tar.gz

tar xvfz haproxy-1.5.17.tar.gz

cd haproxy-1.5.17

make USE_OPENSSL=1 TARGET=linux2628 ARCH=x86_64

make install

cp -a examples/haproxy.init /etc/rc.d/init.d/haproxy

chmod 700 /etc/rc.d/init.d/haproxy 

ln -s /usr/local/sbin/haproxy /usr/sbin/

mkdir -p /etc/haproxy

vi /etc/haproxy/haproxy.cfg

# 서버관련된 사항들. 딱!! 보면 아는 옵션들...;

global

        log 127.0.0.1 local0 

        maxconn 4096

        user nobody

        group nobody

        daemon

        tune.ssl.default-dh-param 2048

# frontend 나 backend 에 지정된 설정이 없으면 defaults 설정을 따름

defaults

        log global

        mode http

        timeout connect 5000ms

        timeout client 50000ms

        timeout server 50000ms

        option dontlognull

        option http-server-close

        option tcplog

        option httplog

        option httpclose

        option forwardfor

        option accept-invalid-http-request

# 상태확인 페이지 설정. http://www.system.co.kr:8888 이런식으로 접근가능

listen admin *:8888

        stats enable

        stats uri /admin

        stats auth admin:password

        stats refresh 5s

# 각 웹서버들 앞단에 위치한 haproxy 자체에 대한 설정

frontend systemv_web_front

        bind 10.0.0.1:80

        bind 10.0.0.1:443 ssl crt /etc/haproxy/www.systemv.co.kr.pem

        reqadd X-Forwarded-Proto:\ https

        default_backend systemv_web_back

# haproxy 뒷단에 있는 real 웹서버들에 대한 설정

backend systemv_web_back

        errorfile 503 /etc/haproxy/index.html

        balance source

        cookie SERVERID insert indirect nocache

        option httpchk HEAD /index.jsp HTTP/1.0

        server web1 10.0.0.10:80 cookie s1 check inter 2000 rise 2 fall 2

        server web2 10.0.0.11:80 cookie s2 check inter 2000 rise 2 fall 2

vi /etc/rsyslog.d/haproxy.conf

$ModLoad imudp

$UDPServerRun 514 

$template Haproxy,"%msg%\n"

local0.=info -/var/log/haproxy/haproxy-info.log;Haproxy

local0.notice -/var/log/haproxy/haproxy-notice.log;Haproxy

local0.* ~ 

vi /etc/logrotate.d/haproxy

/var/log/haproxy/*.log {

    size 1k

    missingok

    rotate 14

    compress

    ifempty

    delaycompress

    sharedscripts

    postrotate

        /bin/kill -HUP `cat /var/run/syslogd.pid 2> /dev/null` 2> /dev/null || true

    endscript

}

MariaDB [(none)]> show global variables like '%pid%';

+---------------+-------------------------------------------+

| Variable_name | Value                                     |

+---------------+-------------------------------------------+

| pid_file      | /app/mariadb/data/localhost.localdomain.pid |

+---------------+-------------------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]>

 --pid-file=file_name

The path name of the file in which the server should write its process ID.

If this option is not given, mysql.server uses a default value of host_name.pid. The PID file 

value passed to mysqld_safe overrides any value specified in the [mysqld_safe] option file group.

Because mysql.server reads the [mysqld] option file group but not the [mysqld_safe] group, 

you can ensure that mysqld_safe gets the same value when invoke using mysql.server as when 

invoked manually by putting the same pid-file setting in both the [mysqld_safe] and [mysqld]

groups.

[mysqld]

pid-file=/app/mariadb/data/mariaDB.pid

[mysqld_safe]

pid-file=/app/mariadb/data/mariaDB.pid

MariaDB [(none)]> show global variables like '%pid%';

+---------------+-------------------------------+

| Variable_name | Value                         |

+---------------+-------------------------------+

| pid_file      | /app/mariadb/data/mariaDB.pid |

+---------------+-------------------------------+

1 row in set (0.00 sec)

MariaDB [(none)]> 

make -j INT

yum install -y gcc gcc-c++ cmake ncurses-devel bison libxml2-devel

tar xvfz mariadb-10.1.13.tar.gz

cd mariadb-10.1.13

cmake \

-DDEFAULT_CHARSET=utf8 \

-DDEFAULT_COLLATION=utf8_general_ci \

-DENABLED_LOCAL_INFILE=1 \

-DCMAKE_INSTALL_PREFIX=/app/mariadb \

-DMYSQL_DATADIR=/app/mariadb/data

-- Looking for include file security/pam_appl.h - not found

-- Looking for strndup

-- Looking for strndup - found

-- Looking for event.h

-- Looking for event.h - not found

-- Configuring done

-- Generating done

-- Build files have been written to: /root/mariadb-10.1.13

[root@localhost mariadb-10.1.13]# 

make

...

......

Scanning dependencies of target udf_example

[100%] Building C object sql/CMakeFiles/udf_example.dir/udf_example.c.o

Linking C shared module udf_example.so

[100%] Built target udf_example

Scanning dependencies of target my_safe_process

[100%] Building CXX object mysql-test/lib/My/SafeProcess/CMakeFiles/my_safe_process.dir/safe_process.cc.o

Linking CXX executable my_safe_process

[100%] Built target my_safe_process

[root@localhost mariadb-10.1.13]# 

make install

...

.....

-- Installing: /app/mariadb/support-files/policy/apparmor

-- Installing: /app/mariadb/support-files/policy/apparmor/usr.sbin.mysqld.local

-- Installing: /app/mariadb/support-files/policy/apparmor/README

-- Installing: /app/mariadb/support-files/policy/apparmor/usr.sbin.mysqld

-- Installing: /app/mariadb/share/pkgconfig/mariadb.pc

-- Installing: /app/mariadb/share/aclocal/mysql.m4

-- Installing: /app/mariadb/support-files/mysql.server

[root@localhost mariadb-10.1.13]# 

useradd -M -s /sbin/nologin mysql

~# /app/mariadb/scripts/mysql_install_db 

~# cd /app/mariadb/scripts ; ./mysql_install_db 

cd /app/mariadb

./scripts/mysql_install_db

...

.....

2016-04-27 23:41:17 139804154201888 [Note] InnoDB: Waiting for purge to start

2016-04-27 23:41:18 139804154201888 [Note] InnoDB:  Percona XtraDB (http://www.percona.com) 5.6.28-76.1 started; log sequence number 1616809

2016-04-27 23:41:18 139803347433216 [Note] InnoDB: Dumping buffer pool(s) not yet started

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 localhost.localdomain 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='./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@localhost mariadb]#

[root@localhost mariadb]# ls -alh ./data/

total 109M

drwxr-xr-x.  5 root root 4.0K Apr 27 23:41 .

drwxr-xr-x. 12 root root 4.0K Apr 27 22:12 ..

-rw-rw----.  1 root root  16K Apr 27 23:41 aria_log.00000001

-rw-rw----.  1 root root   52 Apr 27 23:41 aria_log_control

-rw-rw----.  1 root root  12M Apr 27 23:41 ibdata1

-rw-rw----.  1 root root  48M Apr 27 23:41 ib_logfile0

-rw-rw----.  1 root root  48M Apr 27 23:41 ib_logfile1

drwx------.  2 root root 4.0K Apr 27 23:41 mysql

drwx------.  2 root root 4.0K Apr 27 23:41 performance_schema

drwxr-xr-x.  2 root root 4.0K Apr 27 22:11 test

chown mysql. ./data -R

cp -a support-files/mysql.server /etc/rc.d/init.d/mysqld

[root@localhost mariadb]# /etc/rc.d/init.d/mysqld start

Starting MySQL. SUCCESS! 

[root@localhost mariadb]# /etc/rc.d/init.d/mysqld stop

Shutting down MySQL.. SUCCESS! 

echo "PATH=$PATH:/app/mariadb/bin" >> ~/.bash_profile

[root@localhost bin]# ./mysql_secure_installation

NOTE: RUNNING ALL PARTS OF THIS SCRIPT IS RECOMMENDED FOR ALL MariaDB

      SERVERS IN PRODUCTION USE!  PLEASE READ EACH STEP CAREFULLY!

In order to log into MariaDB to secure it, we'll need the current

password for the root user.  If you've just installed MariaDB, and

you haven't set the root password yet, the password will be blank,

so you should just press enter here.

Enter current password for root (enter for none): 

Setting the root password ensures that nobody can log into the MariaDB

root user without the proper authorisation.

Set root password? [Y/n] 

New password: 

Re-enter new password: 

By default, a MariaDB installation has an anonymous user, allowing anyone

to log into MariaDB without having to have a user account created for

them.  This is intended only for testing, and to make the installation

go a bit smoother.  You should remove them before moving into a

production environment.

Remove anonymous users? [Y/n]

Normally, root should only be allowed to connect from 'localhost'.  This

ensures that someone cannot guess at the root password from the network.

Disallow root login remotely? [Y/n] 

By default, MariaDB comes with a database named 'test' that anyone can

access.  This is also intended only for testing, and should be removed

before moving into a production environment.

Remove test database and access to it? [Y/n] 

Reloading the privilege tables will ensure that all changes made so far

will take effect immediately.

Reload privilege tables now? [Y/n] 

Cleaning up...

All done!  If you've completed all of the above steps, your MariaDB

installation should now be secure.

Thanks for using MariaDB!

[root@localhost bin]# 

yum install scsi-target-utils

/etc/rc.d/init.d/tgtd start

tgtadm --lld iscsi --op new --mode target --tid 1 -T iqn.data.systemv.co.kr:storage.disk1   

tgtadm --lld iscsi --op show --mode target

tgtadm --lld iscsi --op new --mode logicalunit --tid 1 --lun 1 -b /dev/cciss/c0d1p1

tgtadm --lld iscsi --op show --mode target

tgtadm --lld iscsi --op bind --mode target --tid 1 -I ALL

mv /etc/tgt/targets.conf /etc/tgt/targets.conf_ori

tgt-admin --dump > /etc/tgt/targets.conf

yum install iscsi-initiator-utils

/etc/rc.d/init.d/iscsi start

iscsiadm --mode discovery --type sendtargets --portal IP(타켓아이피)

iscsiadm --mode node --targetname iqn.systemv.co.kr:storage.disk1 --portal IP(타켓아이피) --login  

fdisk -l

yum -y install netatalk avahi  dbus nss-mdns

useradd systemv

passwd systemv

mkdir /home/systemv/TM

chown systemv. /home/systemv/TM

- -transall -uamlist uams_randnum.so,uams_dhx.so,uams_dhx2.so -nosavepassword -advertise_ssh

/home/systemv/TM allow:systemv options:usedots,upriv,tm dperm:0775 fperm:0660 cnidscheme:dbd

hosts:      files mdns4_minimal dns mdns mdns4

<?xml version="1.0" standalone='no'?>

<!DOCTYPE service-group SYSTEM "avahi-service.dtd">

<service-group>

<name replace-wildcards="yes">%h</name>

<service>

<type>_afpovertcp._tcp</type>

<port>548</port>

</service>

<service>

<type>_device-info._tcp</type>

<port>0</port>

<txt-record>model=TimeCapsule</txt-record>

</service>

</service-group>

mv /etc/avahi/services/ssh.service /etc/avahi/services/ssh.service.disabled

/etc/rc.d/init.d/messagebus start

/etc/rc.d/init.d/avahi-daemon start

/etc/rc.d/init.d/netatalk start

-A INPUT -p tcp -m state --state NEW -m tcp --dport 548 -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 5353 -j ACCEPT

-A INPUT -p tcp -m state --state NEW -m tcp --dport 5354 -j ACCEPT

-A INPUT -p udp -m udp --dport 548 -j ACCEPT

-A INPUT -p udp -m udp --dport 5353 -j ACCEPT

-A INPUT -p udp -m udp --dport 5354 -j ACCEPT

/etc/rc.d/init.d/messagebus start

/etc/rc.d/init.d/avahi-daemon start

/etc/rc.d/init.d/netatalk start

yum install libtermcap-devel

imp \'sys/패스워드 as sysdba\’

...

......

/bin/sh ./mkinstalldirs /usr/local/share/vim/vim73/keymap

mkdir /usr/local/share/vim/vim73/keymap

chmod 755 /usr/local/share/vim/vim73/keymap

/bin/sh ./installman.sh install /usr/local/share/man/fr/man1 "-fr" /usr/local/share/vim /usr/local/share/vim/vim73 /usr/local/share/vim ../runtime/doc 644 vim vimdiff evim

installing /usr/local/share/man/fr/man1/vim.1