Analysis of gh-ost Principle

Author's Profile: Yang Qilong, a 7-year veteran of DBA, is currently working in Hangzhou Youzan Technology DBA. He is mainly responsible for database architecture design and operation and maintenance platform development. He is good at database performance tuning and fault diagnosis. I. Introduction Last article (gh-ost online ddl change tool ...

Posted on Wed, 18 Sep 2019 02:51:33 -0700 by spiffy577

SpringBoot Integrated Redis Cache

About Redis Cache Why use caching? Enhance the efficiency of accessing duplicate access data. Three uses of Redis Database, Cache, Message Middleware Redis scenario (for data that is accessed repeatedly) Page caching (static data such as pictures, CSS, html etc.) - hot spot data Latest List Ranking List Counter session storage Use Sugge ...

Posted on Tue, 17 Sep 2019 18:48:30 -0700 by denniston

[SpringBoot - Web development (using Thymeleaf template engine)]

[Text can only describe fragment information, specific details reference code] https://github.com/HCJ-shadow/SpringBootPlus Introducing POM dependencies <properties> <java.version>1.8</java.version> <thymeleaf.version>3.0.11.RELEASE</thymeleaf.version> <thymeleaf-layout-dialect.version& ...

Posted on Mon, 16 Sep 2019 02:42:04 -0700 by Kurt

vsftp virtual user based on mysql, the use of iptables

vsftp creates virtual users based on mysql 1. First install the environment yum groupinstall -y "Development Tools" "Server PlatformDevelopment" yum install -y pam-devel mariadb-devel mariadb-server vsftpd lftp ftp //Download the latest pam-mysql http://pam-mysql.sourceforge.net/ //Compile and install pam-mysql tar xf pam_mysql-0.7RC1.tar.gz ...

Posted on Sun, 15 Sep 2019 21:22:02 -0700 by nou

Extend mybatis and general mapper to support geometry type fields of mysql

Because the storage, query and calculation of geographic location information are needed in the project, it is decided to use the geometry type field of mysql (version 5.7) database to save geolocation coordinates and Virtual Generated Column to save geohash value for easy query. You need to understand how geometry is used and its advantages.Si ...

Posted on Sun, 15 Sep 2019 02:48:15 -0700 by therainmaker53

Dictionary dict in python

Definition of Dictionary With key-value storage, it has very fast lookup speed. Dictionary keys are generally unique, and values can be of any data type. A dictionary is an unordered collection of data. Usually the order of output is different from ...

Posted on Thu, 12 Sep 2019 02:37:18 -0700 by cesar110

python crawls stories to Mysql and uses Django framework to do a search rendering interface [django search rendering stage]

Environment: pycharm 3.6 MySQL Django HTML JS 1. Creating a virtual environment: python-m venv bxwx001 2. CMD enters the Scripts directory and enters the instruction: activate to activate the virtual environment 3. Download the package needed by the ...

Posted on Wed, 11 Sep 2019 22:47:54 -0700 by SuprSpy79

mall deployment in Linux environment (based on Docker container)

SpringBoot e-commerce project mall (20k+star) address: https://github.com/macrozheng/mall abstract This paper mainly illustrates mall deployment in Linux environment in the form of graphics and text. It involves installing Mysql, Redis, Nginx, RabbitMQ, Elastic search, Mongodb and SpringBook application deployment in Docker container based on ...

Posted on Tue, 10 Sep 2019 19:23:23 -0700 by triponline

99%SQL optimization encountered in your work, here are all solutions for you

-- Example table CREATE TABLE `employees` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(24) NOT NULL DEFAULT '' COMMENT 'Full name', `age` int(20) NOT NULL DEFAULT '0' COMMENT 'Age', `position` varchar(20) NOT NULL DEFAULT '' COMMENT 'position', `hire_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMEST ...

Posted on Mon, 09 Sep 2019 18:08:40 -0700 by Monkey-Moejo

Strings and lists in Python

Character string 1. Definition of strings: a = 'westos' b = "what's" c = """ //User Management System 1.Adding users 2.delete user Three.show user .... """ print(a) print(b) print(c) [29] 2. Characters of strings: s = 'hel ...

Posted on Mon, 09 Sep 2019 05:01:10 -0700 by __greg