Monitoring service deployment environment:
[root@localhost ~]# cat /etc/redhat-release
CentOS Linux release 7.6.1810 (Core)
zabbix version 4.0
First process: Download update yum sourceTip: there are two ways: official source and Tsinghua source. Considering the download speed, I chose ...
Posted on Wed, 19 Feb 2020 06:41:00 -0500 by playaz
Warm tip: if you can't see the picture clearly by using the computer, you can use the mobile phone to open the article and click the picture in the article to enlarge and view the original HD picture.
github of Fayson:
Tip: the code block can be viewed by sliding le ...
Posted on Tue, 18 Feb 2020 03:02:35 -0500 by sharal
1. Understanding views
A view is a virtual table. Unlike a table that contains data, a view contains only queries that retrieve data dynamically when in use.
WHERE customers.cust_id = orders.cust_id
AND orderitems.order_num = ord ...
Posted on Sat, 15 Feb 2020 07:46:21 -0500 by abasel
CentOS 7-2: 192.168.18.147 (monitoring end: deployment and installation zabbix)
CentOS 7-3: 192.168.18.128 (monitored end)
Monitoring end operation:
[root@cacti ~]# systemctl stop firewalld.service #Turn off firewall function
[root@cacti ~]# systemctl disable firewalld.service #Turn on and disable firewall function
Posted on Tue, 11 Feb 2020 04:24:40 -0500 by flycast
1> Installation of mariadb under. Linux
1.Find and mariadb Relevant security subcontracting version
yum search mariadb
2.install mariadb Customer and service packages for
yum install mariadb mariadb-server.x86_64 -y
3.start-up mariadb service
systemctl start mariadb
systemctl enable mariadb
Posted on Fri, 07 Feb 2020 06:26:53 -0500 by samyl
Multi instance configuration of MySQL
In a physical machine, multiple test environments are needed, so multiple instances of building database are needed. Multiple instances means running multiple programs, and there is no influence between instances. Note that the ports you listen to need to be different. That is to say, running many mysql in ...
Posted on Fri, 31 Jan 2020 14:54:36 -0500 by lunarul
Warm Tip: If the picture is not clear when you use the computer to view it, you can use your mobile phone to open the article and click the picture in the text to zoom in to view the original HD image.
Tip: Code block parts can be slid left and righ ...
Posted on Mon, 27 Jan 2020 19:47:53 -0500 by extrovertive
Beginning of this article: https://www.somata.work/2019/Centos7SetupOwncloudCloudStorage.html
Prepare the necessary software and data first. Here I've sorted it out:Baidu Cloud SharingBut it's best to go online and online by yourself.Here's just a shortcut.owncloud: https://www.owncloud.org
Installation of vmware and virtual machines will not ...
Posted on Thu, 09 Jan 2020 14:11:44 -0500 by gazalec
When it comes to virtualization, I'm a lover of Linux container (LXC). But with the rise of Docker technology, I want to show you how to use Mysql with Docker
What is Docker?
In fact, docker is the encapsulation of LXC. It's very interesting to use. Docker uses LXC to virtualize each application. So in the next example, we wi ...
Posted on Tue, 07 Jan 2020 01:00:38 -0500 by CPInteract
1. Connection query is divided into inner connection and outer connection, and outer connection is divided into left connection and right connection.
2. Inner join: use the comparison operator to compare the data of a column on the surface, and list the data rows in these tables that match the join condition ...
Posted on Sun, 05 Jan 2020 19:47:37 -0500 by mjlogan