rhel6.4 安装nodejs和Mysql DB服务
安装好redhat6.4虚拟机后, 安装软件:
# yum install gcc-c++ openssl-devel Loaded plugins: product-id, security, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. Setting up Install Process No package openssl-devel available. Error: Nothing to do
上网查询得知, redhat的yum源是收费的. 因此需要配置本地yum源. 步骤如下:
1) 将安装光盘镜像文件 rhel-server-6.4-x86_64-dvd.iso 上传到RHEL64虚拟机中:
$ scp ./rhel-server-6.4-x86_64-dvd.iso root@vm-ipaddr:~/
2) 在RHEL64虚拟机中挂载 ISO 文件(已将 rhel-server-6.4-x86_64-dvd.iso 移动到 /opt/ 下):
# mount -t iso9660 -o loop /opt/rhel-server-6.4-x86_64-dvd.iso /mnt/repo # df -h
3) 创建rhel-debuginfo.repo
# vi /etc/yum.repos.d/rhel-debuginfo.repo
输入以下内容
[Server] name=Red Hat Enterprise Linux Server baseurl=file:///mnt/repo #本地iso的挂载路径 enabled=1 #可以使用yum gpgcheck=1 #设置检查gpgkey gpgkey=file:///mnt/repo/RPM-GPG-KEY-redhat-release # 配置gpgkey的路径
4) 修改yumRepo.py配置文件
# vi /usr/lib/python2.6/site-packages/yum/yumRepo.py :802 找到802行, 将下面的语句: remote = url + ‘/’ + relative 改为: remote = '/mnt/repo' + '/' + relative
好了, 安装软件试试, 清理缓存:
# yum clean all # yum install gcc-c++ openssl-devel
一切正常.
5) 为方便, 把这些mount写进 /etc/fstab，以便开机就挂载ISO:
/opt/rhel-server-6.4-x86_64-dvd.iso /mnt/repo iso9660 loop 0 0
==============================================================
下面安装nodejs:
1) 升级系统
# yum install gcc-c++ openssl-devel
2) 下载合适的nodejs包:
# wget http://nodejs.org/dist/v0.10.26/node-v0.10.26-linux-x64.tar.gz
3) 编译nodejs
# tar -zxvf node-v0.10.26-linux-x64.tar.gz # cd node-v0.10.26 # ./configure # make && make install
4) 运行 nodejs
# node --version
使用yum安装mysql
1) 系统自动下载和安装Mysql
安装mysql-client:
# yum -y install mysql
安装mysql-server:
# yum -y install mysql mysql-server mysql-devel
# chgrp -R mysql /var/lib/mysql
# chmod -R 770 /var/lib/mysql
2) 服务启动, 更改root密码
# service mysqld start
第一次root登录不用输入密码:
# mysql -u root
更改root密码,例如: abc123456
mysql> SET PASSWORD FOR 'root'@'*' = PASSWORD('abc123456');
3) 在服务清单中添加mysql服务
# chkconfig --add mysqld
4) 更改root密码,例如: abc123456
# mysqladmin -u root password 'abc123456'
5) 可选: 登陆mysql, 然后删除test数据库
# mysql -u root -pabc123456
mysql> DROP DATABASE test;
删除匿名帐户
mysql> DELETE FROM mysql.user WHERE user = '';
重载权限
mysql> FLUSH PRIVILEGES;
添加mysql用户, 例如：car/abc789
mysql> GRANT ALL PRIVILEGES ON your_db_name.* TO 'car'@'%' IDENTIFIED BY 'abc789';
6) 要机器启动之后,自动启动mysqld:
# chkconfig --levels 345 mysqld on
7) 如要其他机器能访问，在mysql.user中添加一个Host为'%'的user,然后flush priviledges;
mysql> update mysql.user set host='%' where user='car';
mysql> FLUSH PRIVILEGES;
最后防火墙加一句类似这样的语句即可(开通3306端口):
-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT
8) 给用户赋予binlog权限, 以root登陆db:
mysql>GRANT SUPER, REPLICATION CLIENT, REPLICATION SLAVE ON *.* TO car@'%' IDENTIFIED BY 'abc789';
=============================================================
1. 打开Mysql的binlog:
mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | OFF |
+---------------+-------+
1 row in set (0.00 sec)
在my.cnf文件的[mysqld]下加上一行(windows为mysql.ini)
#vi /etc/my.cnf
[mysqld]
...
#添加这一行就ok了=号后面的路径和名字自己定义吧
log-bin=/var/lib/mysql/mysql-bin-log
# service mysqld restart;
mysql> show variables like 'log_bin';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| log_bin | ON |
+---------------+-------+
1 row in set (0.00 sec)
mysql> show binlog events;
+----------------------+-----+-------------+-----------+-------------+----------------------------------------------------+
| Log_name | Pos | Event_type | Server_id | End_log_pos | Info |
+----------------------+-----+-------------+-----------+-------------+----------------------------------------------------+
| mysql-bin-log.000001 | 4 | Format_desc | 1 | 106 | Server ver: 5.1.66-log, Binlog ver: 4 |
| mysql-bin-log.000001 | 106 | Query | 1 | 207 | use `test`; insert into bigdata values (1,'zhang') |
+----------------------+-----+-------------+-----------+-------------+----------------------------------------------------+
2 rows in set (0.00 sec)
2. 查看当前工作的logfile名及大小： show binary logs /show master logs;
mysql> show binary logs;
+-----------------+-----------+
| Log_name | File_size |
+-----------------+-----------+
| bin-log.000011 | 148329 |
+-----------------+-----------+
mysql> show master logs;
+-----------------+-----------+
| Log_name | File_size |
+-----------------+-----------+
| bin-log.000011 | 148329 |
+-----------------+-----------+
mysql> show binary logs;
ERROR 1381 (HY000): You are not using binary logging ###没有开启binary logs
3. 清除所有binary logs;
1)
mysql> show master logs;
+-----------------+-----------+
| Log_name | File_size |
+-----------------+-----------+
| log-bin.000001 | 259548 |
| log-bin.000002 | 37200 |
| log-bin.000003 | 74219 |
+-----------------+-----------+
3 rows in set (0.00 sec)
mysql> reset master; (在slave上，用reset slave，之前应stop slave，之后再start slave）
Query OK, 0 rows affected (0.00 sec)
mysql> show master logs;
+-----------------+-----------+
| Log_name | File_size |
+-----------------+-----------+
| log-bin.000001 | 98 |
+-----------------+-----------+
1 row in set (0.00 sec)
4. 清除指定部分logs：
mysql>purge binary logs to 'log-bin.000012';
将log-bin.000012之前的binary logs清掉；
mysql>purge binary logs before '2011-05-28 12:05:38';
将指定时间之前的binary logs清掉；
5.查看当前binary log的情况：
mysql>show master status;
6. 查看binary logs的内容：
mysql>show binlog events;
命令行下：
#mysqlbinlog /var/log/mysql/log-bin.000140; 或者
#mysqlbinlog --start-datetime='2011-07-01 00:00:00' --stop-datetime='2010-07-15 00:00:00' /var/log/mysql/log-bin.000020 > ./tmp.log
7. 在my.cnf/my.ini中设定binary logs回滚天数：
expire_logs_days = 7