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