Programming VIP

1. Create test case library tables Welcome to the MariaDB monitor. Commands end with ; or \g.Your MariaDB connection id is 11Server version: 10.2.26-MariaDB-log MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> ...

Environmental Science: 192.168.205.37: as MHA server 192.168.205.47: as Master server 192.168.205.57: as Slave1 server192.168.205.67: as Slave2 server Edition: OS: centos 7 1810 with mini install mariadb-server 5.5.60mha4mysql-manager-0.56-0.el6.noarch.rpm mha4mysql-node-0.56-0.el6.noarch.rpm Purpose: MHA uses a program written in perl scrip ...

Environmental Science: 192.168.205.17: as master server 192.168.205.27: as slave server 192.168.205.37: as slave server Edition: OS: centos 7 1810 with mini install mariadb-5.5.60 Purpose: By default, the replication function of MySQL is asynchronous. Asynchronous replication can provide the best performance. The main library sends the ...

Deployment steps 1. Installing docker yum install -y docker systemctl enable docker systemctl start docker 2. Look at the docker image. There is nothing in the container at this time. docker images 3. Download docker image docker pull mariadb docker pull wordpress docker pull phpmyadmin/phpmyadmin ...

1.zabbix-server (ubuntu1804) 1) Necessary packages zabbix-server-mysql zabbix-frontend-php 2) Start-up services State Recv-Q Send-Q Local Address:Port Peer Address:Port ...

Table Content MariaDB [company]> SELECT * FROM employee_info; +-----+-------+------+--------+---------+--------+ | id | name | age | salary | address | sex | +-----+-------+------+--------+---------+--------+ | 001 | Alex | 30 | 13000 | NULL | male | | 002 | Jack | 27 | 8500 | NULL | male | | 003 | Cathy | 23 | ...

   MySQL was originally developed by Michael Widenius, but soon after Mr. Michael sold MySQL to SUN for $1 billion, SUN was acquired by Oracle. Mr. Michael, fearing that MySQL would be closed-source in the future, built a new project named after his daughter Maria. —— MariaDB, MariaDB's default storage engine is Maria, not ...

Xtrabackup description and installationXtrabackup description and installationFull backup and recovery of XtrabackupFull and incremental backup and recovery of XtrabackupIV. Partial Completeness, Increment and Recovery of XtrabackupXtrabackup description and installation1. Introduction and description of XtrabackupPercona XtraBackup is the only ...

Server host preparation Jumpserver (management side) 192.168.1.25 docker-ce jumpserver/jms_all:1.4.8 mirror backend-db (managed back-end service) 192.168.1.26 MariaDB mariadb-server redis backend (Managed backend Service) 192.168.1.27 1.jumpserver management configuration 1. Configure the yum source of dock [root@localhost ~]# wget -O /etc/y ...

Introduction to Log AnalyrThe Log Analyzer tool provides an easy-to-use, powerful front-end for searching, viewing and analyzing network activity data, including system logs, event logs and many other log sources. Since it only presents data to our users, the data itself needs to be collected by another program, such as syslogd, rsyslog (now th ...