Programmer Group

MySQL Master-Slave Replication Practice-Log Point-Based Replication Log-point-based replication Establishment of special duplicate accounts on master and slave Libraries MariaDB [employees]> create user 'repl'@'172.%' identified by '123456'; Note that passwords in production must be in accordance with the relevant specifications to ...

Sixteenth Blog Assignment 1. Source code compilation and installation of LNMP architecture environment; Test environment: nginx host IP: 192.168.23.200 php-fpm host IP: 192.168.23.201 mysql host IP: 192.168.23.202 Test procedure (1) Install nginx on the nginx host by source code compilation (install pcre-devel and openssl-devel f ...

    By looking at Mysql, I will find that the table inquiries are very detailed. The following is my summary after reading. It's full of Mysql queries. From the most basic to the difficult. First look at the structure of the database. MariaDB [CargoWarehouse]> show tables; +--------------------------+ | Tables_in_CargoWarehouse | +--- ...

This article is written in CentOS 7. Ensure that SELinux is closed, firewalls are closed, or specified ports are prevented from being opened. Detailed information is as follows #master [root@promote ~]# cat /etc/redhat-release CentOS Linux release 7.6.1810 (Core) [root@promote ~]# [root@promote ~]# ifconfig ens33: flags=4163<UP,BROA ...

Preface System environment [root@lnmp mysql]# cat /etc/redhat-release CentOS Linux release 7.3.1611 (Core) [root@lnmp mysql]# uname -r 3.10.0-514.el7.x86_64 Official Download Address mariadb database php ngixn Install MariaDB 10.3.13 1. Download mariadb binary packageBecause the compilation time of source packages is too long, the binary pa ...

System Platform: CentOS 7 1611WordPress Download AddressphpMyAdmin Download Address (CentOS 7 recommends that you do not install the latest version, otherwise you need to compile the latest php-fpm)httpd (192.168.1.200), php-fpm (192.168.1.201), mariadb (192.168.1.202) are installed on three hosts respectively.And provide WordPress, phpMyAdmin ...

sakila sample database official information and installation instructions Notice if the supported version of the sample database matches your database. In order to test, sometimes a large number of data sets are needed. MySQL Official provides a sample database for testing. The download page is in the Here. Now take the saki ...

I. Environmental preparation CentOS 7 + Apache 2.4.6 + PHP +Mariadb Apache and Mariadb are installed directly by yum, and PHP is installed by binary source code. The previous items here are the same as the snipeit asset management system installed before. Pre-installation preparation 1. System Update # Note Use Centos 7.5 ...

All the paths in this article are followed by an article: CentOS 7 multi-instance of yum installation MariaDB configuration https://blog.csdn.net/u011342720/article/details/83213558 Description: The following port is 3307 instance as main database and 3308 corresponding instance as slave database Master database configuration ...

Introduction to LAMP LAMP: Short for Linux Apache MySQL PHP, which installs Apache, MySQL and PHP on Linux system to form an environment to run PHP scripting language, usually a website. Apache is the most commonly used web service software, while MySQL is a relatively small database software. Both software and PHP can be installed on one mach ...