Linux: shell script automatically inserts data from. csv file into MySQL database

Specific scenario Ubuntu 16.04 system, follow the previous article, unzip the compressed file, and then store the unzip file csv in MySQL database. The file to be operated is in / home/myftp/upload/backupcopy, and the file content First look at the specific contents of the document Take 2019-01-13.tar.gz compresse ...

Posted on Sat, 02 Nov 2019 06:42:04 -0400 by cptn_future

You need to be proficient in a monitoring - prometheus server related content

Overview of files and directories in prometheus directory [root@aliyun-hk-yabo-prod-jiranew prometheus210]# ll total 117924 drwxr-xr-x 2 3434 3434 4096 May 25 21:54 console_libraries drwxr-xr-x 2 3434 3434 4096 May 25 21:54 consoles drwxr-xr-x 21 root root 4096 Jul 8 03:00 data -rw-r--r-- 1 3434 3434 11357 May 25 21:54 ...

Posted on Fri, 01 Nov 2019 21:46:14 -0400 by trevprellie

Kepler cloud platform: 9 examples to analyze how to install dependencies

This article introduces how to install dependency on Kepler cloud platform. What is Kplcloud? kplcloud is a lightweight PaaS platform based on Kubernetes. It manages the application through a visual interface, reduces the degree of application containerization, and reduces the time cost of application containerization. Kplcloud has been servin ...

Posted on Fri, 01 Nov 2019 20:12:27 -0400 by noon

Scrapy crawler - get user data

Initialization After installing scratch, execute "scratch startproject myspider" Next, you will see the myspider folder. The directory structure is as follows: scrapy.cfg myspider items.py pipelines.py settings.py __init__.py spiders __init__.py ...

Posted on Fri, 01 Nov 2019 16:42:37 -0400 by John_wilson

High availability based on mysql and solve its stickiness

High availability based on mysql Based on the previous experiment, this experiment added the resource group of the last time. Shut down the apache service. Server (since the disk is shared, only one server needs to load resources): pcs stonith delete apache_group ##Delete resource group ...

Posted on Fri, 01 Nov 2019 11:48:19 -0400 by Simbachips

Management of SQL session in mybatis

Instead of combining spring with mybatis, use mybatis directly Firstly, we introduce the dependency of mybatis, druid pool and mysql driver. <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.9</version> </dependency&g ...

Posted on Fri, 01 Nov 2019 07:02:13 -0400 by Crowly

Check whether the ID card number is correct through SQL

According to the provided ID card number information, verify whether the ID card number conforms to the second generation ID card specification, and the area code can be downloaded online.   The database is DB2, but the 18th digit verification algorithm of general ID number can be found from the Internet through visua ...

Posted on Fri, 01 Nov 2019 04:29:56 -0400 by hoodlumpr

Django installation startup and deployment (apache)

Environmental Science: ubuntu18.04 LTS  Python 3.6.8 DB:Mysql Install python3 first sudo apt-get install python3.6 If it's not pip3, you can install pip3 first, otherwise the following pip3 will be replaced by pip sudo apt install python3-pip Install Django sudo pip3 install Django You can ...

Posted on Thu, 31 Oct 2019 17:59:01 -0400 by mgrphp

seafile onlyoffice building multi person collaborative online document editing

Run seafile and onlyoffice Install docker compose # for CentOS yum install docker-compose -y # for Ubuntu apt-get install docker-compose -y Edit docker-compose.yml version: '2.0' services: db: image: mariadb:10.1 container_name: seafile-mysql environment: - MYSQL_ROOT_PASSWORD ...

Posted on Thu, 31 Oct 2019 07:56:07 -0400 by loftystew

JDBC encapsulation tool class and fuzzy query and row level lock

package JDBC.utils; /** * JDBC Tool class. Simplified JDBC programming * @author Max_Hu * */ import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; public class DBUtil { //The construction methods of tool classes are all private. //Because the ...

Posted on Thu, 31 Oct 2019 02:51:24 -0400 by hbuchel