Read-write separation with mycat: master-slave replication based on MySQL

Based on MySQL master-slave replication, this paper uses mycat to realize read-write separation. The role of mycat in applications can be seen in the following figure: mycat allows programmers to only care about business code writing, without worrying about load balancing of back-end database cluster, separation of reading and writing, data ...

Posted by Corin on Mon, 01 Jul 2019 00:21:11 +0200

Quick Experience Percona XtraDB Cluster(PXC)

Percona XtraDB Cluster (PXC) cluster is based on Galera 2.x library, a common multi-master synchronization replication plug-in for transactional applications. It is mainly used to solve the problem of strong consistency, keep the data synchronized between nodes in real time and achieve multi-node read and write simultaneously.It improves the r ...

Posted by steveonly20 on Sun, 30 Jun 2019 19:32:01 +0200

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