solr enterprise search application server

catalog 1. Introduction to Solr 2. Inverted index 3. Introduction to Lucene API 4. solr installation Chinese word segmentation tool - IK analyzer 5. Connect mysql Import product data from mysql Query test 6. Practice 1. Introduction to Solr In fact, we use almost all of them, such as Taobao, J ...

Posted on Fri, 05 Jun 2020 03:38:21 -0400 by BillyMako

JEECG containerization deployment

There is a Dockerfile in the JEECG code. The basic idea is to take CentOS as the basic image, in which nginx, jdk, MySQL and redis are installed. The compiled front-end files are copied to the designated directory of nginx, the back-end jar files are placed in the root directory, and the configuration f ...

Posted on Thu, 04 Jun 2020 15:18:49 -0400 by nonaguy

xtrabackup backup and recovery data script

This script is used to back up and restore MySQL databases. Summarize the two pits of xtrabackup backup: 1. In the process of data recovery, if there is an error in the middle of the process, the data will be destroyed and it is difficult to recover later. 2. In the recovery process, if the versio ...

Posted on Thu, 04 Jun 2020 10:50:08 -0400 by juschillin

Beginner's understanding of Java design pattern

The structural pattern of Java design pattern 1. Adapter mode Adapter mode of class 1.1 1.2 adapter mode for objects 1.3 adapter mode of interface 2. Decoration mode 3. Agent mode 4. Appearance mode 5. Bridge mode 6. Combination mode 7. Enjoy yuan mode 1. Adapter mode Convert the interface of ...

Posted on Thu, 04 Jun 2020 08:41:25 -0400 by meandrew

MySQL: case when usage

When doing data analysis, we need to find data from the database and analyze it. Accurate data query results are conducive to concise and effective analysis in the later stage. During this period, case when in mysql is used to record the usage of case when. The CASE statement is a multi branch statement structure. The statement first looks up t ...

Posted on Wed, 03 Jun 2020 11:20:30 -0400 by DamienRoche

Consumer cluster deployment-01

#####Reference article( https://blog.51cto.com/412166174/1975822) About consumer Consul includes multiple components, but as a whole, it provides service discovery and service configuration tools for your infrastructure. It provides the following key features:Service discovery: the client of Consul can provide a service, such as api or mysql. ...

Posted on Wed, 03 Jun 2020 11:02:10 -0400 by dancahill

Configure GTID dual master for MySQL 5.7

Environmental planning 192.168.31.178 Master/Slave 192.168.31.179 Master/Slave 192.168.31.178 configuration gtid-mode=ON enforce_gtid_consistency=on log-slave-updates=true master-info-repository=TABLE relay-log-info-repository=TABLE relay_log = /data/mysql/relay.log relay_log_index = /data/mysql/relay_log.index report-port = 3306 sync-m ...

Posted on Tue, 02 Jun 2020 11:05:08 -0400 by root

Are MySQL Join statements inefficient?

We often hear Join join queries that avoid using MySQL because of poor performance. Is this the case?Let's try it out. 1. Environment MySQL: 5.7.30 Storage Engine: InnoDB Index type: default optimized B+tree   2. Prepare 2.1 Table preparation and data preparation We plan to create five tables and insert 10W pieces of data into them, ...

Posted on Tue, 02 Jun 2020 07:53:10 -0400 by hanpedro

Oracle learning - view, sequence, synonym, index

1. View 1.1 what is a view View is a mapping of virtual table and entity table. When to use views In development, there are some table structures that do not want too many people to contact, so entity tables are mapped to a view. (simplified table structure) In the project process, programmers mainly focus on the performance of coding and ...

Posted on Mon, 01 Jun 2020 11:55:47 -0400 by ldtiw

flowable-6.5.0 running official demo

1. Download flowable-6.5.0 from the official website: https://flowable.com/open-source/downloads/ After downloading and unzipping, open the directory wars 2. Find a clean tomcat8 In the war file directory flowable-admin.war  flowable-idm.war  flowable-modeler.war  flowable-rest.war  flowable-task.war A total of 5 war packages are placed in ...

Posted on Mon, 01 Jun 2020 11:10:09 -0400 by krelian