Programming VIP

Zabbix deployment Experimental environment: 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 ...

Mariadb changes the root password By default, the password of the newly installed mariadb is empty. You can log in to the database by directly entering mysql in the shell terminal. If it is the first time you have just installed it, use the MySQL? Secure? Installation command to initialize it. # mysql_secure_installation NO ...

LNMP Basics What is LNMP One of the mainstream enterprise website platforms 50: Linux operating system N:Nginx website service software M:MySQL.MariaDB database P: Website development language (PHP.Perl.Python) Difference between static website and dynamic website Static web page: (1) Static w ...

Note: the key to using regular expressions is REGEXP 1. Query records that start with a specific character or string The character "^" matches the text at the beginning of a specific character or string #In the fruits table, query the records whose f ﹣ name field begins with the letter b MariaDB [vincen]> selec ...

Mariadb user and rights management Permission category Library level Table level Field level Management category Program class Management category: CREATE TEMPORARY TABLES Create temporary table CREATE USER Create user FILE SUPER SHOW DATABASES RELOAD SHUTDOWN REPLACTION SLAVE REPLACTION CLIENT LOCK TABLES PRECESS Progra ...

Preface: There is a Federated storage engine in MySQL. Data tables using this engine do not store any data locally, but all data are stored on remote servers. 1. See if Federated storage engine is supported MariaDB [(none)]> show engines; | FEDERATED | YES | FederatedX pluggable storage engine ...

catalog Displaying logs in database through log analyzer Environmental preparation Prepare server: Log server: Database server: Test whether the log server and database are connected: websrv server: Displaying logs in database through log analyzer Environmental ...

I have a database of account numbers and card numbers. I match these files with files to update all card numbers to this account, so I only use the account. I created a view that links the table to the account / card database to return the Table ID and the associated account, and now I need to update those records whose ID matches the accou ...

Download: Xtrabackup https://www.percona.com/downloads/XtraBackup/Percona-XtraBackup-2.4.8/binary/redhat/7/x86_64/Percona-XtraBackup-2.4.8-r97330f7-el7-x86_64-bundle.tar Unzip, install yum tar -xvf Percona-XtraBackup-2.4.8-r97330f7-el7-x86_64-bundle.tar yum install percona-xtrabackup-24-2.4.8-1.el7.x86_64.rpm Full backup innobackupex –user=r ...

Binary deployment is relatively simple. You can go to mysql official website without installing dependent environment download MySQL binary package. Or through the link of my network disk download , there are auto deployment scripts in the network disk link. Note: the latest MySQL version 8.0 is completely consistent with the deployment proces ...