MYSQL二进制安装+XFS - 数据库编程

1. 准备分区
yum install xfsprogs
[root@ycdatadbsupport yum.repos.d]# mkfs.xfs -f -i attr=2 -l lazy-count=1,sectsize=4096 -b size=4096 -d sectsize=4096 -L data /dev/sdb
meta-data=/dev/sdb isize=256 agcount=4, agsize=1966080 blks
= sectsz=4096 attr=2
data = bsize=4096 blocks=7864320, imaxpct=25
= sunit=0 swidth=0 blks
naming =version 2 bsize=4096 ascii-ci=0
log =internal log bsize=4096 blocks=3840, version=2
= sectsz=4096 sunit=1 blks, lazy-count=1
realtime =none extsz=4096 blocks=0, rtextents=0
[root@ycdatadbsupport yum.repos.d]# mkdir /data
[root@ycdatadbsupport yum.repos.d]# mount -o rw,noatime,nodiratime,noikeep,nobarrier,allocsize=100M,attr2,largeio,inode64,swalloc /dev/sdb /data
[root@ycdatadbsupport yum.repos.d]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup-lv_root
36G 4.0G 30G 12% /
tmpfs 2.0G 264K 2.0G 1% /dev/shm
/dev/sda1 485M 59M 401M 13% /boot
/dev/sr0 3.5G 3.5G 0 100% /media/OL6.3 x86_64 Disc 1 20120626
/dev/sr0 3.5G 3.5G 0 100% /mnt
/dev/sdb 30G 33M 30G 1% /data
[root@ycdatadbsupport yum.repos.d]# vi /etc/fstab




#
# /etc/fstab
# Created by anaconda on Fri May 23 22:30:35 2014
#
# Accessible filesystems, by reference, are maintained under '/dev/disk'
# See man pages fstab(5), findfs(8), mount(8) and/or blkid(8) for more info
#
/dev/mapper/VolGroup-lv_root / ext4 defaults 1 1
UUID=181e768c-89a3-4e65-b576-4f9ae746f642 /boot ext4 defaults 1 2
/dev/mapper/VolGroup-lv_swap swap swap defaults 0 0
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/sd




b /data xfs rw,noatime,nodiratime,noikeep,nobarrier,allocsize=100M,attr2,largeio,inode64,swalloc 0 0


2. 准备目录：
[root@ycdatadbsupport yum.repos.d]# mkdir -p /data/mysql/mysql_3306/data
[root@ycdatadbsupport yum.repos.d]# mkdir -p /data/mysql/mysql_3306/tmp
[root@ycdatadbsupport yum.repos.d]# mkdir -p /data/mysql/mysql_3306/logs
[root@ycdatadbsupport yum.repos.d]# chown -R root:mysql /data
[root@ycdatadbsupport yum.repos.d]# chown -R mysql:mysql /data
[root@ycdatadbsupport yum.repos.d]# chmod -R 775 /data


3. 解压MYSQL软件
tar -xzvf mysql-5.5.37-linux2.6-x86_64.tar.gz


4. 做好软链接
[root@ycdatadbsupport opt]# ln -s /opt/mysql-5.5.37-linux2.6-x86_64 /usr/local/mysql


5. 准备初始化文件：
vi /etc/my.cnf


6. 初始化DB
[root@ycdatadbsupport mysql5]# scripts/mysql_install_db --defaults-file=/etc/my.cnf --user=mysql
Installing MySQL system tables...
140612 13:51:56 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
OK
Filling help tables...
140612 13:51:56 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --log_slow_queries is not set
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 MySQL root USER !
To do so, start the server, then issue the following commands:


/usr/local/mysql5//bin/mysqladmin -u root password 'new-password'
/usr/local/mysql5//bin/mysqladmin -u root -h ycdatadbsupport.localdomain password 'new-password'
MYSQL二进制安装+XFS(一)
