Shulou(Shulou.com)06/01 Report--

This article mainly introduces what are the differences between the master and slave of the deployment of the mysql5.5+ version and the previous version of mysql5.5, the contents of the article are carefully selected and edited by the author, with a certain pertinence, and is of great significance to everyone's reference, let's work with the author to understand the differences between the master and slave of the deployment of the mysql5.5+ version and the previous version of mysql5.5.

Most of them are similar.

It is mainly that the parameters starting with master are no longer supported after 5.5,

Master-host,master-user,master-password,master-port et al.

If configured, the database will report an error and cannot start

The master configuration remains the same, but still

Server-id=1

Log-bin=log

Binlog-do-db=database / / databases to be synchronized

Binlog-ignore-db=mysql / / ignored database

. (omit part)

Change from configuration to (note the following comments, all of which have been abandoned):

Server-id=2

# master-host=192.168.124.51

# master-user= AffairLog

# master-password= password

# master-port=3306

# master-connect-retry=60

Replicate-do-db=database / / synchronized database

Replicate-ignore-db=mysql / / ignored database

The second is that you can't use the slave start or start slave command directly, because it will report an error.

How to use the version after 5.5: start slave; stop slave

We need to use change master to

That is:

Mysql > change master to

> master_host='192.168.124.51'

> master_user='username'

> master_password='password'

> master_log_file='bin-log.000001'

> master_log_pos=120

And then start slave

If the database port does not use the default 3306, you need to execute the following statement: "

Change master to master_host='116.121.1.10',master_port=1223,master_user='newback',master_password='cctv@12315#$',master_log_file='mysql-bin.000001',master_log_pos=120

[actual command to remove outer double quotes, port number and master_log_pos without quotation marks] everything else remains the same.

After reading the above about the master and slave differences between the deployment of the mysql5.5+ version and the previous version of mysql5.5, many readers must have some understanding. If you need to get more industry knowledge and information, you can continue to follow our industry information column.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.