Setting up Mycat environment based on Docker to realize the separation of reading and writing of Mysql database
1. Construction environment
1.1 build Mysql master-slave service
1.1.1 download Mysql image
docker pul ...
Posted on Mon, 02 Mar 2020 23:11:40 -0800 by Nandini
1.Spring configuration data source
1.1 role of data source (connection pool)
Data sources (connection pools) are used to improve program performance
Instantiate the data source in advance and initialize some connection resources
Get from data source when using connection resources
Return the connect ...
Posted on Sun, 01 Mar 2020 03:49:41 -0800 by justin15
Basic use of JdbcTemplate
01 - basic use of jdbctemplate - Overview (understanding)
JdbcTemplate is an object provided in the spring framework, which is a simple encapsulation of the original tedious Jdbc API objects. The spring framework provides us with many operation template classes. For example ...
Posted on Sun, 01 Mar 2020 03:44:47 -0800 by lrdaramis
yum mode installation
1, Install MySQL YUM repository
yum localinstall https://dev.mysql.com/get/mysql57-community-release-el7-8.noarch.rpm
2, Install MySQL 5.7
yum install -y mysql-community-server
3, Start MySQL and enable automatic startup of MySQL
Posted on Sat, 29 Feb 2020 20:16:48 -0800 by cretaceous
MyBatis reverse engineering to generate persistence layer code
Mybatis requires programmers to write their own sql statements. Mybatis officially provides reverse engineering, which can automatically generate the code needed for mybatis execution (mapper.java, mapper.xml, pojo...) for a single table ...
Posted on Fri, 28 Feb 2020 01:30:46 -0800 by yacaph
I haven't written a real combat blog for a long time, because I practiced in the company a few months ago, and the blog update was delayed. Now I can't go back to school because of the epidemic, but I still can't lose my skills. Today, I'd like to write a real combat practice of using scratch to climb dangdang.com.
Create a sketch proj ...
Posted on Fri, 28 Feb 2020 00:34:19 -0800 by cougar23
1. What is sqoop
Apache sqoop (TM) is a tool designed for efficient transferring bulk data between Apache Hadoop and structured datastores such as relational databases
Convert the statement of sqoop to mapreduce task (maptask)
Advantages: data integration across platforms
Posted on Thu, 27 Feb 2020 22:22:51 -0800 by athyzafiris
test.csv and train.csv data preprocessing
Processing of test.csv file
Processing of train.csv file
Spark processes data
Upload files to HDFS
Launch Spark Shell
Prediction of repeat customers by SVM classifier
Output results to mysql ...
Posted on Wed, 26 Feb 2020 22:30:09 -0800 by artic
Part I: class loading
The loading, connection and initialization of types in java are all completed during the program running:
Loading: finding and loading binary data for a class
Verify: ensure the correctness of the loaded class
Prepare: allocates memory for static variables of th ...
Posted on Wed, 26 Feb 2020 22:06:03 -0800 by jscofield
Complete tutorial: https://jooq.diamondfsd.com/
At present, under the framework of microservice, single service single library operation is more advocated. However, due to some historical burden or other factors, it is necessary to access multiple databases at the same time in the project. This article mainly explains some handling methods for ...
Posted on Wed, 26 Feb 2020 02:44:34 -0800 by Jenling