New features interpretation | 8.0 new DML statement (TABLE & VALUES)

Author: Yang Taotao Senior database expert, specializing in MySQL for more than ten years. Good at mysql, PostgreSQL, MongoDB and other open-source database related backup and recovery, SQL tuning, monitoring operation and maintenance, high availability architecture design, etc. At present, he is working in aikesheng, providing MySQL related ...

Added by akop on Wed, 25 Mar 2020 11:15:53 +0200

Learn ECs from scratch - Docker+Tomcat+Nginx+MySQL

brief introduction For the enterprise application architecture, it is certainly not limited to one server. According to my imagination: at least one server that deploys the back-end interface; one server that deploys the front-end page; one server that acts as a proxy; one server that loads the database, etc., which does not include load balanc ...

Added by M.O.S. Studios on Tue, 24 Mar 2020 12:43:14 +0200

Spring Cloud Micro Service Architecture From Getting Started to Getting Used - Calling Feign Between Services

One of the most important functions of micro-services is the call between services, which depend on each other.For example, e-commerce systems have order services and inventory services.When we buy a product, we need to generate orders and reduce inventory.Here we're going to use inter-service Feign calls. Feign is a lightweight framework for H ...

Added by no_one on Sun, 22 Mar 2020 06:05:11 +0200

BoneCP Connection Pool Reconnection Mechanism Analysis

1. Background BoneCP used by friend company Mysql connection pool, the application accesses Mysql as domain name, which is configured as follows:   jdbc:mysql://order.mysql.xx.cn:3306/order?useUnicode=true&characterEncoding=UTF-8&allowMultiQueries=true All middleware access is through th ...

Added by navtheace on Sun, 15 Mar 2020 04:17:09 +0200

Construction of microservice parent project

1. Steps of building parent project based on IDEA New maven project 2. Name of aggregation parent project Maven selected version Character encoding settings Annotation effective activation Java version selection 8 File Type filtering 2.pom file description 1.pom Document conten ...

Added by pha3dr0n on Sat, 14 Mar 2020 16:44:16 +0200

Mybatis generator automatically generates code and integrates swaggerui

Introduce dependency: <!-- MyBatis generator --> <dependency> <groupId>org.mybatis.generator</groupId> <artifactId>mybatis-generator-core</artifactId> <version>1.3.7</version> </dependency> <!--Mysql Database driven--> <depend ...

Added by JamesyBHOY on Sat, 14 Mar 2020 16:25:58 +0200

Common functions of MySQL data processing

The built-in functions of MySQL can be roughly divided into the following categories: 1. Processing text functions of text data (such as splicing, case conversion, etc.); 2. A numerical function (such as an algebraic operation) that processes numerical data; 3. Date time class function; 4. System ...

Added by tecate1 on Fri, 13 Mar 2020 16:48:45 +0200

brew installs mysql on Mac OS

I am trying to set up MySQL on Mac OS 10.6 using Homebrew through brew install mysql 5.1.52. All went well, and MySQL install dB was also successful. However, when I try to connect to the server using the following methods: /usr/local/Cellar/mysql/5.1.52/bin/mysqladmin -u root password 'mypass' I get: /usr/local/Cellar/mysql/5.1.52/ ...

Added by freakuency on Fri, 13 Mar 2020 08:04:52 +0200

Saltstack automatic operation and maintenance tools - preliminary environment deployment

Saltstack automatic operation and maintenance tools - preliminary environment deployment Document reference: 1.1 GitHub address;           https://github.com/ansible/ansible           https://github.com/saltstack/salt  1.2. Record the execution to mysql;        https://docs.saltstack.com/en/latest/ref/returners/all/       1, Comparison betwee ...

Added by imstupid on Fri, 13 Mar 2020 06:38:18 +0200

Analysis of distributed DBLE LOAD DATA function implementation

Author: Lu Lu Those who love technology and are willing to share are mainly engaged in the research of database related technology. Source: original contribution *Aikesheng is produced by the open source community. The original content cannot be used without authorization. Please contact the editor for reprint and indicate the source. 1. o ...

Added by Superian on Thu, 12 Mar 2020 11:42:09 +0200