Mysqlmaster/slave test process

1. test environment: gt; Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223gt; gt; slave: Virtual Machine, CentOS (4.0) + mys

1. test environment: gt; Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223gt; gt; slave: Virtual Machine, CentOS (4.0) + mys

Homepage → Database Technology

Background:

Read News

Mysql master/slave test process

[Date:] Source: Linux community Author: Linux editor [Font:]

1. test environment:

> Master: physical machine, Debian (testing) + mysql5.0 + ip: 192.168.40.223

> Slave: Virtual Machine, CentOS (4.0) + mysql5.0 + ip: 192.168.40.225

2. Modify the Master (192.168.40.223)

1). Modify/etc/mysql/my. cnf

Make the following changes in [mysqld]

> Change bind-address from 127.0.0.1 to 192.168.40.223.

> Add: server-id = 1

> Add: log-bin

> Add: binlog-do-db = test

> Add: binlog-ignore-db = mysql

2). Create a copy data account:

> Grant replication slave on *. * to 'slave _ Server' @ 192.168.40.225 identified by 'vobile ';

3) Restart mysql

>/Etc/init. d/mysql restart

3. Modify Slave (192.168.40.225)

1). Modify/etc/my. cnf

In [mysqld], make the following changes:

> Add: server-id = 2

> Add: master-host = 192.168.40.223

> Add: master-user = slave_server

> Add: master_password = vobile

> Master-port = 3306

2) Restart mysql

>/Etc/init. d/mysqld restart

4. Data Import

1) Export the test database in master (192.168.40.223): mysqldump-uroot test> test. SQL

2). Import test. SQL to the slave database:

> Mysql-uroot-e 'create database test ;'

> Mysql-uroot test <test. SQL

5. Enable slave

1). Input start slave in mysql on slave (192.168.40.255;

2). view the slave status (192.168.40.225 mysql): show slave status \ G;

> In the status values, Slave_IO_Running and Slave_ SQL _Running are set to Yes.

3). view the master status (192.168.40.223 mysql): show master status;

6. Detection results

1) In the master database, test has a table human with only three records, and three records are recorded in the same database and table in slave;

2) Insert a record in the master;

3). Add the same record to the corresponding slave.

0

Configure the Oracle Data Source in Struts in Linux

Oracle Account Management

MySQL tutorial

Image Information

View All comments in this article (0)

Comments

Latest Information

Popular this week

Introduction to Linux community-advertisement service-website map-help Info-contact us
The articles published on this site (LinuxIDC) do not mean that they agree with the statement or description. They only provide more information and do not constitute any suggestions.


Copyright©2006-2011 Linux community All rights reserved Zhejiang ICP backup No. 06018118