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