High performance mysql: database read-write separation (MySQL proxy)

Article directory High performance mysql: database read-write separation (MySQL proxy) 1. What is the separation of reading and writing? 2. How to realize the separation of reading and writing of database 3. Implementation of read-write separation High performance mysql: database read-write se ...

Posted on Tue, 10 Mar 2020 04:35:01 -0400 by Yamakazi

Using Docker to build MySQL service

1, Install docker windows and mac can download docker desktop directly to the official website For linux installation method, please refer to https://www.cnblogs.com/myzone/p/9071210.html You can check for a successful installation by entering the following command in the shell: sudo docker versio ...

Posted on Tue, 10 Mar 2020 01:15:42 -0400 by irishred8575

linux--mysql(MHA high availability Architecture)

MHA high availability architecture Note: one master and many slaves = odd Gtid master-slave replication or semi synchronous replication should be done before MHA high availability experiment. This time, gtid master-slave replication is used gtid master slave replication link: https://blog.csdn.net/Apl ...

Posted on Mon, 09 Mar 2020 23:51:21 -0400 by phpdood

Zabbix custom parameter monitoring and awk commands

awk command awk is a language for processing text files and is a powerful text analysis tool.How awk handles text and data: Read in the text line by line, find rows that match a particular pattern, and do so. Output file matches specific fields of rows It's powerful, so it's useful.Here I focus on the following scenarios:Read in the text line ...

Posted on Sun, 08 Mar 2020 12:40:13 -0400 by martin_g

Mybatis from entry to mastery -- parameter transfer

1, Preparations 1.maven dependency <dependencies> <!-- mysql drive --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.18</version> ...

Posted on Sun, 08 Mar 2020 01:38:11 -0500 by Donovan

Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table

I. objectives Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table 2, Development tools and project environment IDE: IntelliJ IDEA 2019.3 SQL: Navicat for MySQL 3, Basic environment configuration Create database: demodb Create data table and insert data DROP TABLE IF EXISTS t_empl ...

Posted on Sat, 07 Mar 2020 11:03:50 -0500 by avatar.alex

Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table

I. objectives Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table 2, Development tools and project environment IDE: IntelliJ IDEA 2019.3 SQL: Navicat for MySQL 3, Basic environment configuration Create database: demodb Create data table and insert data DROP TABLE IF EXISTS t_empl ...

Posted on Sat, 07 Mar 2020 10:53:17 -0500 by patriklko

Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table

I. objectives Spring boot integrates the addition, deletion, modification and query operations of Mybatis on a single table 2, Development tools and project environment IDE: IntelliJ IDEA 2019.3 SQL: Navicat for MySQL 3, Basic environment configuration Create database: demodb Create data table and insert data DROP TABLE IF EXISTS t_empl ...

Posted on Sat, 07 Mar 2020 10:51:42 -0500 by Tatara

Cloud computing - MySql advanced: configure multiple instances of MySql

Case 1: configure MySQL multiple instances 1.1 problem On the host 192.168.4.56, configure the first MySQL instance Instance name mysql1, port 3307 Database directory / data3307, PID file mysql1.pid Error log mysql1.err On the host 192.168.4.56, configure the second MySQL instance Instance name mys ...

Posted on Sat, 07 Mar 2020 10:04:51 -0500 by lurius

Expression of common filter conditions in SQLAlchemy ORM query

When using SQLAlchemy ORM to query data, if the required records are filtered according to the selected conditions, you can refer to the relevant methods described in this article. There's no skill, just familiarity. Use the data source I often use Sample Data . It is recommended to use jupyter noteboo ...

Posted on Sat, 07 Mar 2020 08:28:57 -0500 by ams007