Master-slave synchronization of mysql database to achieve read-write separation

In order to understand a large number of concurrent visits in large websites, it is far from enough to achieve distributed load balancing in websites. To the data business layer and data access layer, if the traditional data structure is still used, or only one server is used to handle so many database connection operations, th ...

Posted by Mr. Tech on Sun, 12 May 2019 04:31:44 +0200

2. MySQL server multi-instance and test experiment

Multiple instances In production, with the updating of database version or other requirements, it may be necessary to install multiple databases of different versions (or the same version) on one host. (The database here refers to an entire database separated by the database port number, rather than referring to the database in a database, pay ...

Posted by deejay on Sun, 12 May 2019 04:28:22 +0200

linux Installation mysql8.x

MySQL MySQL introduction MySQL was originally an open source relational database management system developed by Swedish company MySQL AB, which was acquired by Sun Microsystems in 2008. In 2009, Oracle acquired Sunrise Microsystems, and MySQL became Oracle's product. MySQL has become the most popular open source database in the past because of ...

Posted by sweetstuff2003 on Sat, 11 May 2019 22:52:05 +0200

Some characteristics of mariadb (<=10.4)

Recently, I read MariaDB's official website to introduce MariaDB's functions and characteristics, and outlined a few places that I feel it necessary to understand: Supporting column-level compression CREATE TABLE `cmp2` ( `id` bigint(20) NOT NULL, `name` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`)); https://mariadb.com/kb/en/library/storag ...

Posted by Crystal Dragon on Sat, 11 May 2019 22:26:21 +0200

Proxy SQL (11) of MySQL Middleware: Chain Rules (flagIN and flagOUT)

Return Proxy SQL Series: http://www.cnblogs.com/f-ck-need-u/p/7586194.html   1. Understanding Chain Rules In the mysql_query_rules table, there are two special fields, "flagIN" and "flagOUT", which are used to define the entry and exit of the rules respectively, so as to realize the chains of rules. The implementation of ch ...

Posted by pob123 on Sat, 11 May 2019 15:33:54 +0200

MySQL Queries (1)

This article includes the following contents Simple query Conditional query: Group query: group by Sort query: order by Reduplication of query results: distinct Limit query volume: limit 0 preparation First, create two tables employee and department: mysql> select * from employee; +----+----------+--------+--------+-- ...

Posted by abigail on Sat, 11 May 2019 10:55:36 +0200

Detailed description of the shell with python to automatically install zabbix monitor

Script environment 1.linux centos 7 system2. The CD-ROM image file has been mounted3. The system can connect to the external network.4. Font links: https://pan.baidu.com/s/1m9WJys5aGuUi-WgBG-zrxw Extraction code: qq6r Experimental steps 1. Upload font files and zabbix scripts to the Linux system / root directory Method 1: Mount Method 2: U ...

Posted by sicKo on Sat, 11 May 2019 10:00:42 +0200

Building wnmp under Windows

The running environment is windows server 2008 64-bit system. Installation directory D:/wnmp Mysql 5.7 Download Address: https://dev.mysql.com/downloads/mysql/5.7.html#downloads (This article chooses 5.7.25 | Microsoft Windows | All | Windows (x86, 64-bit), ZIP Archive) php7.2 Download Address: https://windows.php.net/downloads/releases/php-7. ...

Posted by cyberlew15 on Sat, 11 May 2019 09:05:31 +0200

Toolset Core Tutorial | Part 5: Using Velocity Template Engine to Generate Template Code

Preface I don't know if you have such a feeling. In normal development, there are often many duplicate codes in dao and service classes. Velocity provides template generation tools. Today, I will teach you how to say goodbye to these duplicate codes. Reference items: https://github.com/bigbeef/cppba-codeTemplatePersonal blog: http://www.zhangb ...

Posted by Tonic-_- on Sat, 11 May 2019 04:37:58 +0200

centos installs ZABBIX (server and agent)

Catalog Configuration of server II. Configuring Agents 3. Notes: 1. Ports are not accessible 2. Active and passive modes of ZABBIX 3. Incorrect alarm time 4. Reference: Configuration of server First configure the zabbix server side 1. go zabbix official website Choose install zabbix from package mode, and then select ...

Posted by Chris_78 on Fri, 10 May 2019 22:11:02 +0200