Actual combat: use xtrabackup to make incremental backups for mysql

Originality: Fat Dog and Flying Bird qq14808540 Production environment architecture: MySQL 5.6, one master and one slave. Periodic incremental backup is implemented on the slave side. The slave is configured as a 2-core 4G and hangs on the SSD data disk. Introduction to xtrabackup There are two tools: xtrabackup: is a tool for hot backup of dat ...

Posted by mounika on Sun, 30 Jun 2019 01:08:48 +0200

PHP_Design Patterns

What is design pattern? Typical solutions to classical scenarios that often occur in software development are called design patterns. How to Learn Design Patterns Typical scenarios - > Typical problems - > Typical solutions polymorphic Used to eliminate logical statements. Polymorphism (ploymorphism) is a biological concept, referring to ...

Posted by sp@rky13 on Thu, 27 Jun 2019 23:03:00 +0200

mysql extension function

Because of its small size, fast speed and low overall cost of ownership, especially with the characteristics of open source, many small and medium-sized websites choose mysql as the website database in order to reduce the overall cost of ownership. The solution of database system using mysql database management system and PHP scripting language ...

Posted by johany on Tue, 25 Jun 2019 00:05:41 +0200

Queries in 05-mysql (Chapter 1)

Prepare data, create data tables Creating Student Information Table students create table students( id int unsigned primary key auto_increment not null, name varchar(20) default '', age tinyint unsigned default 0, height decimal(5,2), gender enum('male','female','Simon?','secrecy'), cls_id int unsigned default 0 ); Create class tables c ...

Posted by _Alex_ on Thu, 20 Jun 2019 22:35:50 +0200

docker and git implementation push-to-deploy

background Recent research into docker-based continuous delivery processes has allowed docker to build host-independent software environments that can push-to-deploy docker containers while pushing code to remote repositories through the git hooks mechanism (triggering a specific script in the $GIT-DIR/hooks directory when a particular event oc ...

Posted by phpBuddy on Thu, 20 Jun 2019 19:38:44 +0200

CentOS 7.3 Compile and Install MariaDB 10.2.6

1. Delete the default database configuration file for CentOS 7.3 [root@localhost ~]# find -H /etc/ | grep my.c /etc/pki/tls/certs/make-dummy-cert /etc/pki/tls/certs/renew-dummy-cert /etc/my.cnf.d /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf [root@localhost ~]# rm -rf /etc/my.cnf /etc/my.cnf.d/ [root@localhost ~] ...

Posted by mr_badger on Thu, 20 Jun 2019 00:35:02 +0200

MySQL 5.7------------------------------- Installation based on entOS6 binary package

1. Background   * MySQL is a relational database management system developed by Swedish MySQL AB and currently owned by Oracle.MySQL is one of the most popular relational database management systems. In the application of WEB, MySQL is the best RDBMS (Relational Database Management System) application software.   * MySQL is ...

Posted by Barnacles on Wed, 19 Jun 2019 18:54:57 +0200

MySQL's headache-provoking Alert Case Analysis

MySQL Analysis of Abrted Alert Logactual combatPart1: Write at the topIn the error log of MySQL, we often see some kinds of borted connection errors, this article will make a preliminary analysis of such errors, and understand the basic ideas and methods of investigation after a problem arises. It's important to master this method, not to have ...

Posted by Johannes80 on Tue, 18 Jun 2019 23:39:39 +0200

mysql multi-source replication in detail

You should know that the biggest feature of mysql is master-slave replication compared with other databases, but the version before 5.7 only supports one master-slave replication at most. For some statistical classes, it needs to cross-database. This is a troublesome thing. In the past, only database middleware (mycat, etc.) can do this kind of ...

Posted by steelerman99 on Mon, 17 Jun 2019 02:14:29 +0200

Nodejs Learning Notes (6) - - Mysql Connection

install Mysql installationhttp://ftp.ntu.edu.tw/MySQL/Downloads/MySQLInstaller/Version: mysql-installer-community-5.7.17.0.msiVisual Interface Tool: MySQL-Front_V5.4.4.153_SetupInstallation tutorial: http://jingyan.baidu.com/article/363872ec2e27076e4ba16fc3.htmlAbout passwords: admin/admin root/adminhttp://www.jb51.net/article/71888.htmhttp://b ...

Posted by BizBoy on Sun, 16 Jun 2019 23:57:16 +0200