zabbix主备

yaomint

　　\cp -rf /usr/share/doc/mysql-server-5.0.77/my-large.cnf /etc/my.cnf
mysql_install_db --user=mysql
/etc/init.d/mysqld start

mysqladmin -u root password 'pass123'
mysql -uroot -ppass123 -h127.0.0.1 -e "create database zabbix character set utf8;"
mysql -uroot -ppass123 -h127.0.0.1 -e "grant all on zabbix.* to zabbix@localhost identified by 'zabbixpwd';"
mysql -uroot -ppass123 -h127.0.0.1 -e "show databases;"

mysql -uzabbix -pzabbixpwd zabbix < dbinit/schema/mysql.sql
mysql -uzabbix -pzabbixpwd zabbix < dbinit/data/data.sql
mysql -uzabbix -pzabbixpwd zabbix < dbinit/data/images_mysql.sql


按照提示，修改 php.ini 中时区设置：
date.timezone = Asia/Shanghai
service httpd restart
依次单击下一步，在环境检测时会看到几个fail,再次修改 php.ini,根据提示设置相应参数：
post_max_size = 32M
max_execution_time = 600
max_input_time = 600
memory_limit = 256M
upload_max_filesize = 16M


删除空用户
delete from mysql.user where User='';

设置用户权限
grant 权限列表 on 数据库名.表名 to 用户名@来源地址 [identified by '密码']
grant replication slave on *.* to 'backup'@'192.168.1.101' identified by '123456';
grant all on auth.* to admin@'192.168.168.%' identified by '123456';
grant all on *.* to root@'192.168.0.%' identified by '123456';
grant select on zabbix.* to zabbixdba@&quot;%&quot; identified by '12345678901!';
flush privileges;

查看用户权限
select user,host from mysql.user;
show grants for 用户名@域名或ip
show grants;
show grants for admin@'%.benet.com';
show grants for cacti@'192.168.0.%';

撤销用户权限
revoke 权限列表 on 数据库名.表名 from 用户名@域名或ip
revoke all on *.* from admin@'192.168.168.%';


MYSQL主从配置
1,主数据库对复制进行授权
grant replication slave on *.* to 'backup'@'192.168.168.%' identified by '123456';
flush privileges;

2,备份主数据库
flush tables with read lock;
tar cf mysql.tar /var/lib/mysql
show master status;
unlock tables;
或
mysqldump -uroot -p123456 --quick cacti | gzip > cacti.sql.gz

3,将主数据库的备份恢复到从数据库
tar xf mysql.tar /var/lib/
或
create database cacti;
mysql -ucactiuser -p123456 cacti < cacti.sql
stop slave;
reset slave;
change master to master_host='172.16.16.252',master_user='backup',master_password='123456',master_log_file='mysql-bin.000003',master_log_pos=98;
start slave;