最近学习数据库的笔记 notecase写的的笔记

一般安装好系统以后要做的操作：
1. iptables 关闭, selinux 关闭
2. 搭好yum 源

对于32bit的系统yum源是：
[base]
name=rhel6.1
baseurl=ftp://update:update@10.1.1.1/Server
enabled=1
gpgcheck=0

对于64bit的系统yum源是：
[base]
name=rhel6.1
baseurl=ftp://rhel64:rhel64@10.1.1.1/Server
enabled=1
gpgcheck=0

以后下载东西的地方
3. ftp://cs2:cs2@10.1.1.10
ftp://cs2@10.1.1.10  看笔记

4. chkconfig iptables off ; chkconfig NetworkManager off

5.双系统的启动（先装好64bit的，后再装好32bit的）
 在32bit的系统上添加 64bit grub 菜单
    title xxx
     root (hd0,x)
     kernel /xxxxx ro root=xxxx
   initrd /xxxxxx

6. ntsysv --level 2345


acpid
avahi-daemon
crond
haldaemon
messagebus
network
sshd
rsyslog
sysstat

===========================================
Mysql的版本
mysql 5.1.X
mysql 5.5.X
mysql-cluster-7.2.X

软件包
    1. rpm ->  i386.rpm || x64.rpm  || src.rpm
    2. binary  -> 直接使用  二进制包
    3. source
        \-> ./configure 生成 Makefile <- 软件组件功能，编译规则，安装规则


一、mysql-5.1.36-linux-i686-glibc23.tar.gz

1. 确保系统存在 mysql 用户 (gid=uid=27)
2. 解压到 /usr/src 下
3. 软链接 ln -s  /usr/src/mysql-XXXX     /usr/local/mysql  
4. 生成服务器配置文件  -> /usr/local/mysql/etc/my.cnf
{mkdir /usr/local/mysql/etc/
vim etc/my.cnf}

[mysqld]
port = 3306
socket = /var/run/mysqld/mysql5.socket
pid-file = /var/run/mysqld/mysql5.pid
general-log
general-log-file = /var/log/mysqld/mysql5-access.log
log-error = /var/log/mysqld/mysql5-error.log
user = mysql
datadir = /database

    确保目录存在，属性正确

5. 生成客户端配置 -> /etc/my.cnf   (添加下面两行)
[mysql]
socket=/var/run/mysqld/mysql5.socket

6. 生成启动服务脚本
    （cp） 或者  （ln -s ）/usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqlold

    修改 mysqlold 的权限为 755

basedir=/usr/local/mysql
datadir=/database
pid_file= /var/run/mysqld/mysql5.pid
conf=/usr/local/mysql/etc/my.cnf


7. 创建数据库，并初始化

    mkdir /database
    cd /usr/local/mysql
    ./scripts/mysql_install_db

    验证 -> ls /database/mysql/

8. 启动服务器  /etc/init.d/mysqlold start
9. 登录服务器验证

mysql> select version();
+------------+
| version()  |
+------------+
| 5.1.36-log |
+------------+
1 row in set (0.00 sec)

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)

===============================================

mysql-5.1.36.tar.gz

1. 停止二进制版本, 删除 /usr/local/mysql
2. 解压到/usr/src
3. 编译定制
./configure --prefix=/usr/local/mysql --enable-local-infile --with-charset=gbk --with-extra-charsets=utf8,gb2312 --with-pthread --with-unix-socket-path=/var/run/mysqld/mysql5.socket --with-mysqld-user=mysql --with-debug --with-big-tables --with-plugins=partition,innobase,myisam,myisammrg,heap --with-mysqlmanager

    {服务器引擎 ->
         Available plugins are: partition daemon_example
         ftexample archive blackhole csv example federated
         heap ibmdb2i innobase myisam myisammrg ndbcluster.}

记得执行make & make install

4. 在执行上面后就会生成服务器配置文件  -> /usr/local/mysql/etc/my.cnf
{mkdir /usr/local/mysql/etc/
vim etc/my.cnf}

[mysqld]
port = 3306
socket = /var/run/mysqld/mysql5.socket
pid-file = /var/run/mysqld/mysql5.pid
general-log
general-log-file = /var/log/mysqld/mysql5-access.log
log-error = /var/log/mysqld/mysql5-error.log
user = mysql
datadir = /database

    确保目录存在，属性正确

5. 生成客户端配置 -> /etc/my.cnf (添加下面两行内容)
[mysql]
socket=/var/run/mysqld/mysql5.socket

6. 生成启动服务脚本（复制或者链接脚本文件）
ln -s    /usr/src/mysql-5.1.36/support-files/mysql.server /etc/rc.d/init.d/mysqlnew

    修改 mysqlold <- 755

basedir=/usr/local/mysql
datadir=/database
pid_file= /var/run/mysqld/mysql5.pid
conf=/usr/local/mysql/etc/my.cnf


7. 创建数据库，并初始化

    mkdir /database
    cd /usr/local/mysql
    ./bin/mysql_install_db

    验证 -> ls /database/mysql/

    chown mysql:mysql /database /usr/local/mysql

8. 启动服务器( /etc/init.d/mysqlnew start  )
chown mysql:mysql /var/run/mysqld/ /var/log/mysqld /database/ /usr/local/mysql/ -R

9. 登录服务器验证

mysql> select version();
+------------+
| version()  |
+------------+
| 5.1.36-log |
+------------+
1 row in set (0.00 sec)

mysql> select user();
+----------------+
| user()         |
+----------------+
| root@localhost |
+----------------+
1 row in set (0.00 sec)