cnf

MySQL online backup and recovery tools --> XtraBackup 1 Overview of Xtrabackup principles Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to

A Linux job needs to compile a MySQL by itself, but there is already a MySQL on my system. Compile another one. The most troublesome thing is not to compile, but to make the two coexist. A Linux job needs to compile a MySQL by itself, but there is

Detailed steps for implementing mysql hot backup in linux (mysql master-slave replication) bitsCN.com Role of the master and slave: 1. it can be used as a backup method. 2. read/write splitting to relieve the pressure on a database MySQL

The default encoding settings of the MySQL server. The following uses mysql5 under MacPorts as an example to describe the setting method. The default encoding settings of the MySQL server. The following uses mysql5 under MacPorts as an example to

Set MySql data synchronization mysql to provide the database replication function after version 3.23.15. This feature enables synchronization between two databases, master-slave mode, and mutual backup mode. the settings of the database

A slight change in the settings of the mysql character set (for Chinese garbled characters, mysql character set needs to be set) does not cause a headache due to character set problems, but also makes a mistake. it is better to save the time and

Mysql versions later than 3.23.15 provide the database replication function. This feature allows you to synchronize two databases, master-slave mode, and mutual backup mode. The settings of the database synchronization replication function are

This article describes how to query logs and slow query logs in MySQL. It also describes how to use the Mysqldumpslow log analysis tool that comes with MySQL. For more information, see I. query logs Query all the queries in MySQL by using "-- log [=

Share The CentOS installation process of the latest MySQL version 5.6.13 source code in CentOS. BitsCN.com Two months ago, the company withdrew the test server for the DBA and used a group of databases for development. some of the small functions

1. etcmy. cnf is rarely configured by default. You can cpusrsharemysqlmy-large.cnfetcmy.cnf.2. Open the my. cnf file and add the following parameters: [c 1,/etc/my. cnf is rarely configured by default. You can cp/usr/share/mysql/my-large.cnf/etc/my.

This afternoon, I copied the data from mysql. After all the servers are configured, I found that the following errors were reported. CopyCode The Code is as follows: last_io_error: Fatal error: the slave I/O thread stops because master and slave

1. Compile and install MySQL5.5 # yuminstall-ycmakegccgcc-c ++ makecmakencursesncurses-devel # groupaddmysql # useradd-gmysql & n .. 1. Compile and install MySQL5.5 # yuminstall-ycmakegccgcc-c ++ makecmakencursesncurses-devel # groupaddmysql #

Install mysql5.6 and centos7mysql5.6 on CentOS7 There will always be some minor problems during MySQL installation, resulting in slow installation progress. add your own actual operations to Baidu search, summarize the installation methods, and make

Upgrade MySQL5.1 to 5.5.36 and centosmysql5.1 in CentOS Record the process of upgrading MySQL5.1 to 5.5.36 in the CentOS 6.4 environment. I hope you can have a reference. 1. For the sake of security, the original data must be backed up first. 2.

MySQL-group-replication configuration steps (recommended), groupreplication MySQL-Group-Replication is a new feature developed by the mysql-5.7.17 version; it achieves strong consistency between master-slave, However, for the moment, the performance

In Soundbreak, we play live audio and video continuously 24 hours a day, so we cannot make a convincing test of the new replication feature of MySQL. Through tests, we found that this feature can be used to maintain data synchronization with the

Backup recovery policy: 1. regularly perform mysql backup and consider the recovery time that the system can afford. 2. Make sure that mysql opens log-bin. With binarylog, mysql can perform full recovery, time point-based recovery, or location-based

MySQL master-slave synchronization is a mature architecture with the following advantages: ① the query can be performed on the slave server (that is, the READ function we often call) to reduce the pressure on the master server; ② back up data from

I. Introduction I have been using Linux for a long time. I have never studied Linux since I have no hard tasks or systems. Recently, I have to use MySQL in Linux for my work. I thought I had experience using SQLServer in Windows and thought it would

Configure multiple mysql versions in centos Environment Scenario: You need to upgrade the original version of MySQL to a later version of mysql. Solution: to reduce the impact of mysql upgrades on the business, you can configure a later version of