mysql主从复制高可用手册.pdf -m6米乐安卓版下载

m6米乐安卓版下载-米乐app官网下载

mysql主从复制高可用手册.pdf

284

15页

6次

2021-08-19

免费下载

mysql

node1 master ip10.10.10.101

node2 slave ip10.10.10.102

via ip(ip) 10.10.10.100

node1node2fire9

rpm -e mysql-devel-4.1.20-1.rhel4.1

rpm -e mysql-bench-4.1.20-1.rhel4.1

rpm -e php-mysql-4.3.9-3.15

rpm -e libdbi-dbd-mysql-0.6.5-10.rhel4.1

rpm -e mod_auth_mysql-2.6.1-2.2

rpm -e mysql-server-4.1.20-1.rhel4.1

rpm -e mysql-python-1.0.0-1.rhel4.1.i386

rpm -e myodbc-2.50.39-21.rhel4.1.i386

rpm -e qt-mysql-3.3.3-9.3.i386

rpm -e mysqlclient10-devel-3.23.58-4.rhel4.1.i386

rpm -e mysqlclient10-3.23.58-4.rhel4.1

rpm -e cyrus-sasl-sql-2.1.19-5.el4.i386

rpm -e perl-dbd-mysql-2.9004-3.1.i386

rpm -e mysql-4.1.20-1.rhel4.1

redhat as 4 update4 32

mysql-5.0.45-linux-i686-icc-glibc23.tar.gz

libnet-1.1.2.1-1.rh.el.um.1.i386.rpm

mysql

fire9 fire9dingh@gmail.com

2007912

release 1.0

heartbeat-pils-2.0.4-1.el4.i386.rpm

heartbeat-stonith-2.0.4-1.el4.i386.rpm

heartbeat-2.0.4-1.el4.i386

perl-5.8.8.tar.gz

dbi-1.59.tar.gz

dbd-mysql-4.005.tar.gz

time-hires-01.20.tar.gz

period-1.20.tar.gz

convert-ber-1.31.tar.gz

mon-0.11.tar.gz

mon-0.99.3-47.tar.gz

mysql

# tar zxvf mysql-5.0.45-linux-i686-icc-glibc23.tar.gz -c /usr/local/

# cd /usr/local/

# mv mysql-5.0.45-linux-i686-icc-glibc23 mysql

# cd mysql

# groupadd mysql

# useradd -g mysql mysql

#passwd mysql

# ./scripts/mysql_install_db --user=mysql

# cp support-files/mysql.server /etc/rc.d/init.d/mysqld

# chmod x /etc/rc.d/init.d/mysqld

# chkconfig --add mysqld

# /etc/rc.d/init.d/mysqld start

my.cnf/etc/

vi /etc/my.cnf

server-id =1 server-id = 2log-bin=mysql-bin

binlog-do-db=fire9;server-id =1 server-id =2

log-bin=mysql-bin replicate-do-db=fire9 fire9

mysql

# mysql

mysql> create database fire9; #

mysql>set password for root@localhost = password (123456); #root

mysql>flush privileges;

mysql>grant replication slave on fire9.* to slave@10.10.10.102 identified by 'password';

# mysqldump -uroot -p fire9 > fire9.sql

# scp fire9.sql root@10.10.10.102:/tmp

of 15

免费下载

mysql

文档被以下合辑收录

墨天轮最受欢迎的技术文档-高可用架构篇（共124篇）

数据库高可用如何实现？这份合辑你或许可以用到！本文为大家整理了墨天轮社区上一些受欢迎的数据库高可用架构实践主题相关文档，包含oracle、postgresql、mysql三类数据库，欢迎大家下载查看🌹

关注

mysql主从复制高可用手册.pdf -m6米乐安卓版下载

文档被以下合辑收录

评论