Cacti和Zabbix所需Mysql安装配置

zlzyp

　　注：此篇文章的部分内容摘抄自公司同事编写的技术文档，在此对他致以衷心的谢意！
　　Cacti、Nagios、Zabbix都是生产环境常用的监控软件，为了整合资源便于管理一般都将这三种监控软件整合到一台服务器中，下面是工作中总结的适合Cacti、Zabbix、Nagios的编译参数和基本配置方法，希望对大家有帮助。

　　1. mysql编译和安装配置(mysql-5.1.58)

• ./configure \
  
• --prefix=/usr/local/mysql-5.1.58 \
  
• --enable-assembler \
  
• --with-libwrap=/usr/lib/ \
  
• --with-charset=utf8 \
  
• --with-extra-charsets=gb2312,gbk,big5,latin1,utf8 \
  
• --with-mysqld-user=mysql \
  
• --without-debug \
  
• --with-big-tables \
  
• --enable-thread-safe-client \
  
• --with-client-ldflags=-all-static \
  
• --with-plugins=myisam,myisammrg,innodb_plugin
  
• 
  
• make && make install
  
• 
  
• cd /usr/local; ln -s mysql-5.1.58 mysql
  
• 
  
• cd /src/mysql-5.1.58; /bin/cp -pfr support-files /usr/local/mysql/
  groupadd mysql; useradd mysql -g mysql
  
• mkdir -p /data/mysql/{data,ibdata,log}
  
• chown -R mysql:mysql /data/mysql
  
• 
  

　　2. mysql配置文件

• [client]
  
• port            = 3306
  
• socket          = /tmp/mysql.sock
  
• 
  
• [mysqld]
  
• port            = 3306
  
• socket          = /tmp/mysql.sock
  
• character-set-server=utf8
  
• init_connect='set names utf8'
  
• skip-name-resolve
  
• basedir = /usr/local/mysql
  
• datadir = /data/mysql/data
  
• back_log = 50
  
• max_connections = 600
  
• max_connect_errors = 10
  
• skip-external-locking
  
• max_heap_table_size = 64M
  
• sort_buffer_size = 8M
  
• join_buffer_size = 8M
  
• thread_cache_size = 8
  
• thread_concurrency = 8
  
• query_cache_size = 64M
  
• query_cache_limit = 2M
  
• ft_min_word_len = 4
  
• default-storage-engine = InnoDB
  
• thread_stack = 192K
  
• transaction_isolation = REPEATABLE-READ
  
• tmp_table_size = 64M
  
• long_query_time = 5
  
• log-error  
  
• slow_query_log
  
• server-id = 1
  
• key_buffer_size = 32M
  
• read_buffer_size = 8M
  
• read_rnd_buffer_size = 16M
  
• bulk_insert_buffer_size = 64M
  
• myisam_sort_buffer_size = 128M
  
• myisam_max_sort_file_size = 10G
  
• myisam_repair_threads = 1
  
• myisam_recover
  
• ignore-builtin-innodb
  
• plugin-load=innodb=ha_innodb_plugin.so
  
• plugin_dir=/usr/local/mysql/lib/mysql/plugin
  
• innodb_file_format=barracuda
  
• innodb_additional_mem_pool_size = 20M
  
• innodb_buffer_pool_size = 1G
  
• innodb_data_file_path = ibdata1:20M:autoextend
  
• innodb_file_per_table = 1
  
• innodb_data_home_dir = /data/mysql/ibdata
  
• innodb_file_io_threads = 4
  
• innodb_thread_concurrency = 16
  
• innodb_flush_log_at_trx_commit = 0
  
• innodb_log_buffer_size = 8M
  
• innodb_log_file_size = 1024M
  
• innodb_log_files_in_group = 2
  
• innodb_log_group_home_dir = /data/mysql/ibdata
  
• innodb_max_dirty_pages_pct = 90
  
• innodb_flush_method=O_DSYNC
  
• innodb_lock_wait_timeout = 120
  
• innodb_open_files = 300
  
• 
  
• [mysqldump]
  
• quick
  
• max_allowed_packet = 32M
  
• 
  
• [mysql]
  
• no-auto-rehash
  
• 
  
• [myisamchk]
  
• key_buffer_size = 512M
  
• sort_buffer_size = 512M
  
• read_buffer = 8M
  
• write_buffer = 8M
  
• 
  
• [mysqlhotcopy]
  
• interactive-timeout
  
• record_buffer = 16773120
  
• 
  
• [mysqld_safe]
  
• open-files-limit = 8192
  

　　3. 初始化系统库配置启动脚本

• cd /usr/local/mysql; bin/mysql_install_db --user=mysql
  
• 
  
• /bin/cp -rf /usr/local/mysql/share/mysql/mysql.server /etc/init.d/mysqld
  
• chmod +x /etc/init.d/mysqld
  
• chkconfig --add mysqld
  
• chkconfig mysqld on
  
• service mysqld start
  

　　4. 设置环境变量

• echo "export MYSQL_HOME=/usr/local/mysql " >> /etc/profile;
  
• echo "export PATH=$PATH:$MYSQL_HOME/bin" >> /etc/profile;
  
• echo "export LD_LIBRARY_PATH=/lib:/usr/lib:/usr/lib64:/usr/local/lib:$MYSQL_HOME/lib/mysql" >> /etc/profile
  
• source /etc/profile
  

　　5. 设置mysql的root密码

• /usr/local/mysql/bin/mysqladmin -u root password 'q1w2e3r4'
  
• /usr/local/mysql/bin/mysqladmin -u root -h 127.0.0.1 password 'q1w2e3r4'