Tag:Main library

  • MySQL learning notes (28): copying


    This article was updated on May 4, 2020, using MySQL 5.7 and operating system deepin 15.4. catalog Startup options Management and maintenance Replication refers to transferring DDL and DML operations of the master database to the slave database through binary logs, and then the slave database redoes these logs, so as to keep the data […]

  • Common interview questions for Linux job


    linuxOperation and maintenance engineers are often asked a variety of questions during the interview. Next, I will sort out the interview questions according to my own experience for your reference. Take out the document aaa.txt Lines 4 to 7 of [[email protected] ~]# cat aaa.txt 1.aaa2.bbbbbbb3.ccccccccccccc4.dddddddddddddddddddddd5.eeeeeeeeeeeeeeeeee6.ffffffffffffffffffffffffffffffffff7.gggggggggggggggggggggg8.hhhhhhhhhhhhhhhhhhhhhhhhhhhhhhh9.iiiiiiiiiiiiiiiiiiii10.jjjjjjjjjjjjjjjjjjjjjjjjjj11.kkk12.llllllllll [[email protected] ~]# sed -n ‘4,7p’ aaa.txt4.dddddddddddddddddddddd5.eeeeeeeeeeeeeeeeee6.ffffffffffffffffffffffffffffffffff7.gggggggggggggggggggggg Find the file ending […]

  • Technology sharing | MySQL show processlist time is negative


    Author: Gao PengAt the end of the article, there is his book “deep understanding of MySQL master-slave principle 32 lectures”, in-depth and thorough understanding of MySQL master-slave, gtid related technical knowledge. 1、 Source of the problem This is a question a friend asked me. The question is as follows: in MTS, the worker thread sees […]

  • Design of query function for master-slave architecture of database cluster


    According to any IP or domain name, it is a very common and essential function in DBA operation and maintenance to find the cluster architecture, whether it is the master database or the slave database. The implementation of the function described in this paper has been applied to an Internet company. At present, it runs […]

  • Several replication methods of MySQL master slave replication


    catalog Asynchronous replication Multithreaded replication Enhanced semi synchronous replication Asynchronous replication MySQL replication is asynchronous by defaultMaster slave replication requires at least two MySQL services, which can be distributed on different servers or on the same server. MySQL master-slave asynchronous replication is the most common replication scenario. The integrity of the data depends on whether […]

  • Great! Send you 6 MySQL essential tips!


    Author: Lao ZhangOriginal text: http://blog.51cto.com/sumongo… Today I’d like to share with you an article about the use of MySQL DBA essential tools. It can help us manage our database conveniently and make our work more efficient. This tool is from percona, an important branch of MySQL,It’s called percona toolkit,It is a set of commands. Today, […]

  • Four master slave replication architectures commonly used in MySQL


    catalog One master multi slave replication architecture Multi level replication architecture Dual master replication architecture Multi source replication architecture How to optimize the master-slave delay problem? The four common architectures replicated areOne master multi slave replication architecture、Multi level replication architecture、Dual master replication architectureandMulti source replication architecture。 One master multi slave replication architecture In the scenario […]

  • Master slave replication of MySQL “solutions for existing data in master database” and “several replication modes”


    Master slave replication architecture of MySQL At present, MySQL supports two types of replication: 1. Traditional way:The bin log based on the master database copies the log events and event locations to the slave database, and then the slave database is applied to achieve the purpose of master-slave synchronization. 2. Gtid mode (recommended for MySQL […]

  • Duplicate copies the database and creates a physical standby (SPFILE + different instance names + different paths)


    The procedure is similar to duplicate copying the database and creating a physical standby, except that the database does not need to be restarted. Objective: to create a standby without restarting the source database 1 the setting environment is as follows: Primary database IP SID orcl Standby database IP SID orcl_standby Set prompts […]

  • Oracle RAC and DG


    RAC RAC: real application clustersrac RAC: real application clustersrac Single node database: one to one correspondence between data files and sample files When an instance is damaged, the database is corrupted RAC architecture database: data files corresponding to multiple instances The most fundamental intention of Rac is instance level fault tolerance, not data-based Instances are […]

  • Master slave synchronization of MySQL database


    Next: MySQL database introduction backup database Installation environment description System environment: [[email protected]~]# cat /etc/redhat-release CentOS release 6.5 (Final) [[email protected]~]# uname -r 2.6.32-431.el6.x86_64 Database: Because it is a simulation environment, the master-slave database is on the same server, and the server IP address is The main library uses port 3306 The slave library uses port […]

  • Technology sharing | slave_ relay_ log_ Some extensions of info table cognition


    Author: Hu Chengqing slave_ relay_ log_ The info table looks like this: mysql> select * from mysql.slave_relay_log_info\G *************************** 1. row *************************** Number_of_lines: 7 Relay_log_name: ./mysql-relay.000015 Relay_log_pos: 621 Master_log_name: mysql-bin.000001 Master_log_pos: 2407 Sql_delay: 0 Number_of_workers: 16 Id: 1 Channel_name: slave_ relay_ log_ The info table stores the working location of the slave SQL thread. When starting […]