LAMP yum installation - Centos 7
Centos 7 yum install LAMP
Author: Yan Tao
E-mail: coderyantao@qq.com
Note: the experimental environment is virtual machine, selinux and firewalld have been shut down
Official Apache 2.4 documentation https://httpd.apache.org/docs/2.4/
#View port
[root@localhost ~]# firewall-cmd --query-port=80/tcp
no
...
Posted by Linjon on Sun, 21 Jun 2020 03:01:40 -0700
[programming basics] Python configuration file reading library ConfigParser summary
The Python ConfigParser tutorial shows you how to use ConfigParser to use configuration files in Python.
Article catalog
1 Introduction
1.1 Python ConfigParser reading files
1.2 sections in Python configparser
1.3 Python ConfigParser reading data from strings
1.4 Python ConfigParser reading data fro ...
Posted by turboprop on Sun, 21 Jun 2020 02:23:45 -0700
Packaging and deployment of SpringBoot and Mysql application Docker
This paper implements a simple springboot+mysql application (ip count based on user access and stored in mysql database), builds a docker image for the application, implements the deployment of docker container and the docking with mysql container
Docker installation
You can install docker desktop f ...
Posted by friedemann_bach on Sun, 21 Jun 2020 00:02:11 -0700
Mysql automatically creates and deletes partition tables
Sometimes we need to save a lot of data, which is time-sensitive, such as some logs. After a period of time, the existence of these data is not significant, and in addition to taking up a lot of hard disk space, it may make data queries slow.This data needs to be cleaned up regularly.We can cope with ...
Posted by timtom3 on Sat, 20 Jun 2020 17:56:03 -0700
How to add fields to mysql large tables without stopping
Adding fields to a table of ten million or more levels in MySQL has always been a headache. In this case, how to deal with it? This paper uses three common scenarios to illustrate the case.
1. Environmental preparation
Database version: 5.7.25-28 (Percona branch)
Server configuration: three centos 7 virtual machines with 2CPU 2G memory
Database ...
Posted by romilbm on Fri, 19 Jun 2020 23:20:57 -0700
mysql master and slave of Liunx service management
Introduction of master and slave
What is master-slave?
MySQL master-slave replication is one of its most important functions. Master-slave replication refers to that one server acts as the master database server and another or more servers act as the slave database server, and the data in the master ...
Posted by grimz on Fri, 19 Jun 2020 05:48:13 -0700
A more cultural sql statement 1 every day
SELECT pf1001.attrId, attrCode, attrName,
(case pf1001.scopeType
when '04' THEN CONCAT('product-',(select productName from pf1003 where productId= pf1001.scopeId))
WHEN '03' THEN CONCAT('Product line-',(select productLineName from pf1004 where productLineId= pf1001.scopeId))
WHEN '02' THEN CONCAT( ...
Posted by philwhite on Thu, 18 Jun 2020 03:29:30 -0700
A quick tutorial of building server project based on Hunt Framework 3.2.0
Hunt Framework is a full stack Web framework developed in D language, similar to Laravel / SpringBoot / Django, etc., which enables D language developers to create projects quickly. The built-in super multi business specifications are convenient for developers to use out of the box, and convenient for managers to review project code more easily ...
Posted by jesse_james on Thu, 18 Jun 2020 02:11:58 -0700
Finish MySQL (all) 2 in half a day
Finish MySQL in half a day (all)
Finish MySQL (all) 1 in half a day
The blogger uses MySQL version 8.0, and the storage engine is InnoDB. We don't explain InnoDB in detail here. If necessary, we recommend you to know This article Blog (or Baidu) https://www.jianshu.com/p/519fd7747137
3A. Add, delete, ...
Posted by pella.d on Wed, 17 Jun 2020 23:46:05 -0700
Spring boot implements read-write separation (based on Mybatis, mysql)
Recently, the task is relatively light, and I have free time to learn learning technology, so I come to study how to realize the separation of reading and writing. Here we use blog to record the process. On the one hand, it can be viewed in the future, and on the other hand, it can also be shared with you (most of the information on the Interne ...
Posted by ctoshack on Tue, 16 Jun 2020 23:22:11 -0700