Home Database Mysql Tutorial MySQL报错:master and slave have equal MySQL server UUIDs

MySQL报错:master and slave have equal MySQL server UUIDs

Jun 07, 2016 pm 04:08 PM
mysql error

MySQL报错:master and slave have equal MySQL server UUIDs

Linux公社

首页 → 数据库技术

背景:

阅读新闻

MySQL报错:master and slave have equal MySQL server UUIDs

[日期:2015-02-28] 来源:Linux社区  作者:doiido [字体:]

MySQL报错信息如下:

Last_IO_Errno: 1593

Last_IO_Error: Fatal error: The slave I/O thread stops because master and slave have equal MySQL server UUIDs; these UUIDs must be different for replication to work.

查询相关资料发现,这个主要是因为两台服务器是经过复制而在一起的,所以data下面的文件auto.cnf中的UUID也一样,因此要解决这个问题只要修改auto.cnf中的UUID即可

#  vi /main/mysql/data/auto.cnf
[auto]
server-uuid=f4863bcf-1d28-11e4-8657-000c29eec7bf
#随便改动一两个值即可以,或者按照上面的格式重新写一个

--------------------------------------分割线 --------------------------------------

Ubuntu 14.04下安装MySQL

《MySQL权威指南(原书第2版)》清晰中文扫描版 PDF

Ubuntu 14.04 LTS 安装 LNMP Nginx\PHP5 (PHP-FPM)\MySQL

Ubuntu 14.04下搭建MySQL主从服务器

Ubuntu 12.04 LTS 构建高可用分布式 MySQL 集群

Ubuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb

MySQL-5.5.38通用二进制安装

--------------------------------------分割线 --------------------------------------

本文永久更新链接地址:

  • 0
  • Linux下 MySQL 互为主从配置

    MySQL 建立用户数据库方法

    相关资讯       MySQL报错 

  • MySQL启动报错解决一例  (05/25/2014 07:32:10)
  • 首次使用MySQL报错error1045  (01/06/2014 14:30:27)
  • 图片资讯      

    本文评论   查看全部评论 (0)

    评论声明

    最新资讯

    本周热门

    Linux公社简介 - 广告服务 - 网站地图 - 帮助信息 - 联系我们
    本站(LinuxIDC)所刊载文章不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。


    Copyright © 2006-2015 Linux公社 All rights reserved 沪ICP备15008072号-1号

    Statement of this Website
    The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

    Hot AI Tools

    Undresser.AI Undress

    Undresser.AI Undress

    AI-powered app for creating realistic nude photos

    AI Clothes Remover

    AI Clothes Remover

    Online AI tool for removing clothes from photos.

    Undress AI Tool

    Undress AI Tool

    Undress images for free

    Clothoff.io

    Clothoff.io

    AI clothes remover

    Video Face Swap

    Video Face Swap

    Swap faces in any video effortlessly with our completely free AI face swap tool!

    Hot Tools

    Notepad++7.3.1

    Notepad++7.3.1

    Easy-to-use and free code editor

    SublimeText3 Chinese version

    SublimeText3 Chinese version

    Chinese version, very easy to use

    Zend Studio 13.0.1

    Zend Studio 13.0.1

    Powerful PHP integrated development environment

    Dreamweaver CS6

    Dreamweaver CS6

    Visual web development tools

    SublimeText3 Mac version

    SublimeText3 Mac version

    God-level code editing software (SublimeText3)

    Duplicate entry for key 'PRIMARY' - How to solve MySQL error: Duplicate record of primary key Duplicate entry for key 'PRIMARY' - How to solve MySQL error: Duplicate record of primary key Oct 05, 2023 pm 02:49 PM

    How to solve MySQL error: Duplicate primary key records, specific code examples are needed. When using MySQL database, we often encounter the problem of duplicate primary key records. When we insert a new piece of data into the database, if the primary key value of the data is the same as the primary key value of an existing record, a duplicate primary key record error will occur. The prompt for this error is usually "Duplicatetryforkey'PRIMARY'". So, how to solve this problem? This article will provide several solutions

    Cannot add or update a child row: a foreign key constraint fails - How to solve MySQL error: child row has foreign key constraint Cannot add or update a child row: a foreign key constraint fails - How to solve MySQL error: child row has foreign key constraint Oct 05, 2023 am 08:22 AM

    How to solve the MySQL error: The child row has foreign key constraints, specific code examples are needed. When using the MySQL database, we may encounter the error "Cannotaddorupdateachildrow:aforeignkeyconstraintfails". This error usually indicates a foreign key constraint problem when inserting or updating data. This article explains how to solve this problem and provides specific code examples. First, let's deal with

    Table 'table_name' already exists - How to solve MySQL error: table already exists Table 'table_name' already exists - How to solve MySQL error: table already exists Oct 05, 2023 am 09:25 AM

    Table'table_name'alreadyexists-How to solve MySQL error: The table already exists, specific code examples are needed. Introduction: During the development and management process of using MySQL database, you often encounter errors that the table already exists. This error usually occurs when creating a table repeatedly or when importing an existing table structure. This article will introduce how to solve the problem of MySQL error: table already exists, and provide specific code examples. 1. What is MySQL error: Table has been

    Can't connect to local MySQL server through socket 'socket_name' (2) - How to solve the MySQL error: Can't connect to the local MySQL server through socket (2) Can't connect to local MySQL server through socket 'socket_name' (2) - How to solve the MySQL error: Can't connect to the local MySQL server through socket (2) Oct 05, 2023 am 09:18 AM

    Can'tconnecttolocalMySQLserverthroughsocket'socket_name'(2)-How to solve MySQL error: Unable to connect to the local MySQL server through socket (2), specific code examples are needed When developing and managing MySQL databases, sometimes we encounter some problems, One of the common problems is the inability to connect to the local MySQL server via socket. when we taste

    Data too long for column 'column_name' - How to solve MySQL error: data exceeds field length Data too long for column 'column_name' - How to solve MySQL error: data exceeds field length Oct 05, 2023 am 08:29 AM

    How to solve MySQL error: The data exceeds the field length, specific code examples are needed. During the development process of using MySQL database, we often encounter the problem that the data exceeds the field length. When we insert or update data, if the length of the data exceeds the defined length of the field, MySQL will report an error and prevent the data insertion or update operation. The common prompt message for this kind of error is: Datatoolongforcolumn'column_name'. it tells us a certain field

    Duplicate entry 'value' for key 'unique_key_constraint' - How to solve MySQL error: Duplicate records in unique key constraints Duplicate entry 'value' for key 'unique_key_constraint' - How to solve MySQL error: Duplicate records in unique key constraints Oct 05, 2023 am 09:57 AM

    How to solve the MySQL error: Duplicate records in unique key constraints, specific code examples are needed. When using the MySQL database, we often encounter an error, that is, the error: "Duplicateentry'value'forkey'unique_key_constraint'". This error is usually caused by a unique key constraint being violated when inserting or updating data, resulting in duplicate records in the database. Unique key constraints can ensure that a certain field in the database

    Unknown column 'column_name' in 'table_name' - How to solve MySQL error: unknown column name in table Unknown column 'column_name' in 'table_name' - How to solve MySQL error: unknown column name in table Oct 05, 2023 pm 02:18 PM

    Unknowncolumn'column_name'in'table_name'-How to solve MySQL error: Unknown column name in table, specific code example is needed. When using MySQL database, sometimes you will encounter such error message: Unknowncolumn'column_name'in'table_name'(table Unknown column name in ). This error is usually caused by the specified column name not existing in the table. In this article

    Unknown column type 'column_type' in column 'column_name' - How to solve MySQL error: Unknown column type in column Unknown column type 'column_type' in column 'column_name' - How to solve MySQL error: Unknown column type in column Oct 05, 2023 pm 02:28 PM

    Title: How to solve MySQL error: Unknown column type in column, specific code example is required Introduction: Database plays an important role in the application development process, and MySQL, as one of the commonly used relational database management systems, is widely used In various web applications and enterprise-level systems. However, in the process of using MySQL to create tables, you sometimes encounter error messages. One of the common errors is "Unknowncolumntype'column_type'in

    See all articles