Programming VIP

1. Download mysql installation package to / usr/local/soft [root@VM_0_9_centos ~]# cd /usr/local/soft[root@VM_0_9_centos soft]# wget http://dev.mysql.com/get/Downloads/MySQL-5.6/mysql-5.6.33-linux-glibc2.5-x86_64.tar.gz 2. Installation dependent environment [root@VM_0_9_centos soft]# yum -y install perl perl-devel autoconf libaio 3. ...

I. httpServlet 1. guide pack //Find the package by searching Maven servlet (class name) to pom.xml import package <dependencies> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysq ...

I. Preface This article will talk about the dynamic allocation of url permission by Spring Security without login permission control. After login, access url permission will be granted according to the login user role. Basic environment spring-boot 2.1.8 mybatis-plus 2.2.0 mysql database maven project For the introduction of Spring Security, ...

centos installation Version Description: centos7, mysql5.7, not centos7, some commands may not be compatible Install MySQL server # Download and install mysql yum. wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm yum -y install mysql57-community-release-el7-10.noarch.rpm # Install MySQL server yum -y install m ...

In the previous article, we talked about the read-write separation based on Mysql8 (there is a link at the end of the article). This time, we talked about the implementation process of the sub database and sub table. conceptual analysis Vertical fragmentation According to the way of business split, it is called vertical split, also known as ver ...

[TOC] I. fsimage and edit files 1. Basic concepts txid: namenode gives a unique id for each operation event (add, delete, and change operation), which is called txid. Generally, txid is automatically increased from 0. For each additional operation, txid is automatically increased by 1. fsimage: It is a mirror file of the metadata of namenode i ...

Server configuration Password free login, configure public key connection Copy the local public key to the server $ ssh-copy-id -i ~/.ssh/id_rsa.pub root@192.168.100.80 Replace aliyum source Replace Centos-7.repo wget http://mirrors.aliyun.com/repo/Centos-7.repo # backups mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo ...

The first method uses a foreach loop $arr = [ [ 'name' => 'testname1', 'age' => 18, ], [ 'name' => 'testname2', 'age' => 19, ], [ 'name' => 'testname3', 'age' => 18, ], ]; $servername = "l ...

Preface: A new sys schema is introduced in MySQL 5.7. Sys is a system library of MySQL. When MySQL 5.7 is installed and initialized with mysqld, sys library will be created automatically. The tables, views, functions and stored procedures in sys libraries can make it easier and faster for us to understand some information of MySQL, such as whic ...

Usually when we refer to database table structure, we are concerned about several attributes:Field name, type, length, whether primary key, whether self-increasing, whether empty, default value, notes.So, what are the properties of using SQL statements to get these attributes under the mainstream databases? MySQL database As the most popular da ...