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
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
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
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
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,
cls_id int unsigned default 0
Create class tables
Posted by _Alex_ on Thu, 20 Jun 2019 22:35:50 +0200
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
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 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
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