mysql/MariaDB learning 2.3 mysql common functions
Environmental Science:
CentOS 7,mysql5.7
Summary description:
This article mainly describes how to use mysql common functions, such as string correlation function, date format function, calculation function, etc
Steps:
1. Mathematical function
Functions for mathematical calculation:
-- ABS(X):Return X Absolute value
sele ...
Posted by AL-Kateb on Mon, 06 Jan 2020 01:03:01 -0800
Snapshot backup using Linux LVM
1. Overview of LVM
The full name of LVM, Logical Volume Manager, is a flexible management mechanism for disk partitions provided by Linux.To understand LVM, you first need to start with a problem that Linux users often encounter, which is, "How should I properly evaluate the size of different partitions to appropriately allocate hard disk ...
Posted by jabbaonthedais on Sun, 05 Jan 2020 17:59:44 -0800
CentOS 6.8 configure MySQL to replicate in SSL encryption mode
CentOS 6.8 configure MySQL to replicate in SSL encryption mode
The master-slave replication of MySQL uses plaintext transmission by default, which is not secure. You can configure the master-slave replication to use SSL encryption connection.
Configuration on Master
1. Generate key
mysql_ssl_rsa_setup --uid=mysql
2. Copy ...
Posted by gloveny on Sun, 05 Jan 2020 11:20:12 -0800
Another dubbo multi network card problem
background
Another inaccessible event
Analysis
First of all, refer to this kind of questions Troubleshooting: foreign consumer XXX access service YYY from registry zzz use Dubbo version 2.5.3, please check register access list (whitelist / blacklist)
It's not the same thing to find out~
It can be seen from the error reporting above that ...
Posted by creet0n on Sat, 04 Jan 2020 19:47:22 -0800
Kubernetes/6.Pod Resource Management
1. Labels
Labels are "key value" types of data that can be specified directly at the time of resource creation or added on demand at any time, and then checked for matching by the tag selector to complete resource selection.
You need to be aware of:
An object can have more than one tag, and the same tag can be added to more than one ...
Posted by PHP Novice on Sat, 04 Jan 2020 09:35:40 -0800
MySQL database whole database backup script
MySQL database whole database backup script
Author: old farmer (Liu Qihua)
QQ: 46715422
Email: 46715422@qq.com
Wechat: 46715422
Test operating system environment: CentOS 6/7, Debian 8/9, FreeBSD 11/12
Test MySQL version: 5.7.23
User name and password: mysql
The database we need to back up this time: test
Script required for backup: bac ...
Posted by ViN86 on Fri, 03 Jan 2020 21:39:36 -0800
Docker Containers - Mirror Management, Port Mapping, Container Interconnection
Layer of docker image
_Each instruction in the Dockerfile creates a new mirror layer;_Mirror layers will be cached and reused;_When the instructions of the Dockerfile are modified, the copied file changes, or the variables specified when the image is built are different, the corresponding mirror layer cache will fail;_When the mirror cache of ...
Posted by nadeemshafi9 on Fri, 03 Jan 2020 20:18:01 -0800
CPU hot add of KVM virtualization technology
1, CPU hot add of KVM virtualization technology
1. Precautions
a. KVM virtualization can't reduce the CPU online, and CPU hot add technology is suitable for the scenario that can't be shut down, but the CPU performance is seriously insufficient
b. The technology of CPU hot add requires higher version of host and virtual mach ...
Posted by dujed on Wed, 01 Jan 2020 11:53:39 -0800
Setting up a docker environment under CentOS7.4
Docker uses timeline as version number after version 1.13, which is divided into community version CE and enterprise version EE.
The community version is free for individual developers and small groups. The enterprise version will provide additional charging services, such as infrastructure, containers, plug-ins, etc. that ...
Posted by DimeDropper on Wed, 01 Jan 2020 01:48:09 -0800
Linux basic learning - Docker learning notes
Docker installation
1 Official website The access speed is very slow, Help document
2 domestic Chinese website,Help document
[root@qdlinux ~]# yum remove docker \
docker-client \
docker-client-latest \
docker-common \
docker-latest \
docker-latest-logrotat ...
Posted by mzfp2 on Tue, 31 Dec 2019 06:51:52 -0800