手机版
你好,游客 登录 注册 搜索
背景:
阅读新闻

MySQL完整安装和主从双机配置

[日期:2013-10-08] 来源:Linux社区  作者:Linux [字体: ]

MySQL完整安装和主从双机配置

示例主机:192.168.0.1  示例备机:192.168.0.2
 
################### mysql 完整安装 ###################

groupadd  mysql
useradd -g mysql mysql
mv /root/mysql-5.0.51b.tar.gz /usr/local/src
tar -zxvf mysql-5.0.51b.tar.gz
cd mysql-5.0.51b
./configure –with-charset=latin1 –with-extra-charsets=all –enable-assembler –with-mysqld-ldflags=-all-static –with-mysqld-user=mysql –prefix=/usr/local/mysql-5.0.51b –localstatedir=/data/mysql5051_db
make
make install
ln -s /usr/local/mysql-5.0.51b /usr/local/mysql
mkdir -p /data/mysql5051_db/dbdata
mkdir -p /data/mysql5051_db/innodb
mkdir -p /data/mysql5051_db/binlog
chown -R mysql:mysql  /data/mysql5051_db
chmod -R 775 /data/mysql5051_db
cd /usr/local/src/mysql-5.0.51b
vim ./scripts/mysql_install_db中的ldata=/data/mysql5051_db/dbdata
cp ./support-files/my-small.cnf /etc/my.cnf
/usr/local/mysql-5.0.51b/bin/mysql_install_db –basedir=/usr/local/mysql-5.0.51b –ldata=/data/mysql5051_db/dbdata –user=mysql
vim /etc/my.cnf
bind-address    = 192.168.0.8
datadir    = /data/mysql5051_db/dbdata/
pid-file    = /data/mysql5051_db/my.pid
log-slow-queries=/data/mysql5051_db/dbdata/slowquery.sql
log-bin  = /data/mysql5051_db/binlog/sortrepl.log
################innodb####################
# Uncomment the following if you are using InnoDB tables
innodb_data_home_dir = /data/mysql5051_db/innodb/
innodb_data_file_path = ibdata1:1000M;ibdata2:1000M:autoextend:max:800M
innodb_log_group_home_dir = /data/mysql5051_db/innodb/
innodb_log_arch_dir = /data/mysql5051_db/innodb/
# You can set .._buffer_pool_size up to 50 – 80 %
# of RAM but beware of setting memory usage too high
innodb_buffer_pool_size = 600M
innodb_additional_mem_pool_size = 20M
# Set .._log_file_size to 25 % of buffer pool size
innodb_log_files_in_group = 4
innodb_log_file_size = 400M
innodb_log_buffer_size = 160M
innodb_flush_log_at_trx_commit = 0
innodb_thread_concurrency = 8
#innodb_flush_method = O_DSYNC
innodb_lock_wait_timeout = 50
################innodb####################
#启动服务
# /usr/local/mysql/bin/mysqld_safe -umysql &
# /usr/local/mysql-5.0.51b/bin/mysql
#关闭服务
# /usr/local/mysql/bin/mysqladmin shutdown
################### mysql 完整安装完成 ###################

更多详情见请继续阅读下一页的精彩内容http://www.linuxidc.com/Linux/2013-10/91116p2.htm

推荐阅读:

Ubuntu下Nginx做负载实现高性能WEB服务器5---MySQL主主同步 http://www.linuxidc.com/Linux/2012-06/61687p5.htm

生产环境MySQL主主同步主键冲突处理 http://www.linuxidc.com/Linux/2013-07/86890.htm

MySQL主从失败 错误Got fatal error 1236 http://www.linuxidc.com/Linux/2012-02/54729.htm

MySQL主从复制,单台服务器上实施 http://www.linuxidc.com/Linux/2013-03/81913.htm

linux
相关资讯       MySQL安装  MySQL主从配置 
本文评论   查看全部评论 (0)
表情: 表情 姓名: 字数

       

评论声明
  • 尊重网上道德,遵守中华人民共和国的各项有关法律法规
  • 承担一切因您的行为而直接或间接导致的民事或刑事法律责任
  • 本站管理人员有权保留或删除其管辖留言中的任意内容
  • 本站有权在网站内转载或引用您的评论
  • 参与本评论即表明您已经阅读并接受上述条款