Programmer Think

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ...

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 ~] ...

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 ...

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 ...