Programmer Group

Catalog 1. Environmental planning 2. binlog is enabled for all Mysql to ensure that the server IDs of all MySQL are different 3. The master database authorizes the master-slave replication user 4. The main database makes the database data fully available, and then pushes the backup file to the slave database 5. Restore backup files from the d ...

Introduction to Join Join is a very important operation in SQL statements. The common Join operations are as follows: mysql officially only provides an inner connection, a left outer connection, and a right outer connection.Other connections can also be made in some ways. Data preparation a. Create two tables create table `person` ( ...

[TOC] MySQL Create Capable Database Architecture Notes Database Monitoring Content to monitor Monitor the availability of a database: instead of just monitoring the existence of a database process, connect to the database over the network and determine if it is available Monitor database performance: QPS TPS, Number of concurrent threads, inn ...

Source code: GitHub point here || GitEE point here 1, Relational data source 1. Dynamic data source The basic functions of dynamic management data source: data source loading, container maintenance, persistent management. 2. Relational database Different manufacturers of relational databases provide different connection methods, driver packag ...

Reason The Hyperf framework is designed to prevent the proxy cache from not updating after the user updates the component, resulting in a startup error. The following hooks have been added. { "scripts": { "post-autoload-dump": [ "init-proxy.sh" ] } } 　　 The init-proxy.sh script executes the PHP bin / h ...

1, SELECT clause /* Basic query: select * from Table name [where condition]; select Field list from table name [where condition]; Extended query, 5 clauses of select statement: (1)where where Condition is used to filter out the qualified records (rows) from the table (2)group by (3)having (4)order by (5)limit These five clauses can appea ...

Spring Boot druid configuration rely on Add druid dependency to Spring Boot project <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>${druid.version}</version> </dependency> To configure spring.datasource.url= spring.datasource.username= spring.datasour ...

Source code for this article: GitHub. Click here || GitEE. Click here 1. Application of Multiple Data Sources 1. Basic Description In relatively complex application services, configuring multiple data sources is a common phenomenon, such as: configuring a master-slave database to write data, and configuring a slave database to read data. This ...

Statistics of the amount of data in a table is a common requirement, but different table designs and different writing methods can lead to large differences in statistical performance. Here is a simple experiment to test (everyone should pay attention to the cache when testing, otherwise the test results will be affected). 1. Preparations In or ...

Development environment: ubuntu-17.10.1-desktop-amd64 Download link: https://www.ubuntu.com/download/desktop 1. Install mysql through apt get sudo apt-get install mysql-server mysql-client Note: my ubuntu-16 version can't be installed, so I can't find the corresponding website, so we can update the software source through ...