db mysql

1. keepAlived + Mysql uses KeepAlived to implement high-availability MYSQL_HA cluster environment. MYSQL is a master-master synchronous replication relationship to ensure data consistency on the MYSQL server. KeepAlived is used to provide virtual IP

The restoration process of the MYSQL backup database includes two sources of information-backup files and binary logs. backup files can be restored to the status when backup is executed, while binary logs can be restored to the status when a fault

MYSQL Tutorial: regular backup of the backup database can greatly reduce the loss caused by database crashes. There are two ways to back up data in MySQL. one is to use the mysqldump program, and the other is to use the mysqlhotcopy, cp, tar, cpio,

This is a creation in Article, where the information may have evolved or changed. # using go to package a convenient ORM recently in the go to write a Web development framework, see some ORM, most of the need to join their own SQL, for me this used

The master-slave replication structure of MySQL is different from the master-slave replication structure. In the master-master replication structure, any changes to the data inventory on one of the two servers will be synchronized to the other, so

The following articles in the classic version of MySQL two-way replication technology mainly refer to the MySQL two-way replication technology, including preparing for the server and setting the actual operation steps of the synchronization server,

The following articles mainly describe the MySQL two-way replication technology, including preparing for the server and setting the actual operation steps for the synchronization server. The following is an introduction to the MySQL two-way

MySQL master/Master synchronization Configuration Server Name IP System MySQL Odd.example.com 192.168.1.116 Rhel-5.8 5.5.16 Even.example.com 192.168.1.115 Rhel-5.8 5.5.16 Assume that the

MySQL master configuration small Note: There are four machines: A (10.1.10.28), B (10.1.10.29), C (10.1.10.30), D (10.1.10.31). After the configuration result: A-c is mainly from, B is a slave,d for C slave. 0) Preparation workAfter installing

First, the concept:① Database Synchronization (master-slave Synchronous---Primary database writes to write data from server)② database Synchronization (primary primary Sync---Two database servers write data to each other) Second, for examplePrimary

Reference: http://blog.csdn.net/mr__fang/article/details/8692480http://www.2cto.com/database/201201/116756.htmlhttp:// blog.csdn.net/gzq_qiang/article/details/6988975http://blog.csdn.net/shiqidide/article/details/7254035 Software:

first, the principle of MySQL master and slave1. Replication ThreadMySQL's Replication is an asynchronous copy process (mysql5.1.7 above is divided into asynchronous and semi-synchronous modes), copied from one MySQL instace (what we call Master) to

MySQL cluster, MySQL master-slave architecture, MySQL load balancerMySQL Master-Slave synchronizationPrinciple:Replication ThreadsMySQL Replication is an asynchronous copy process, copied from one MySQL instace (we call Master) to another MySQL

MySQL Master Sync configuration Server name Ip System Mysql Odd.example.com 192.168.1.116 rhel-5.8 5.5.16 Even.example.com 192.168.1.115 rhel-5.8 5.5.16 Suppose the

MySQL master-Slave synchronization backup steps under Windows 2003 System A: Master serverIP Address: 192.168.1.124B: From the serverIP Address: 192.168.1.125Prerequisite: Please keep the data of two databases the same before setting the

(i) Install the same version of MARIADB. Here I use Yum to install1) Master:RPM--import Http://yum.mariadb.org/RPM-GPG-KEY-MariaDBEcho ' # MariaDB 10.0 CentOS repository list-created 2014-03-15 UTC#

Previously, it was downloaded in MSI format to install MySQL, it is now found that the MSI format can not find, either the zip version, or the use of installer.Try to use installer, feel very bad use, the following is the use of the zip version.1,

Usually for a brand new MySQL server, there is no data for us to test and use. In this respect, MySQL provides us with some sample databases that we can base on for basic operations, stress testing, and so on. This article describes the installation

Article Source: http://icesquare.com/wordpress/mysql-starting-mysql-error-the-server-quit-without-updating-pid-file/Start MySQL today met this problem, online search, the results of various changes to files, delete files are purely pit Dad, the

Troubleshoot FAQs1. Inconsistent data:SHOW SLAVE STATUS \G;Last_Errno: 1062Last_Error: Error ‘Duplicate entry ‘xxxn-66-77‘ for key1‘ on query. Default database: ‘guild‘. Query: ‘insert into pynpcrecord setMapCode = ‘xxxn‘, UpdateTime = ‘2015-08-07 00