Programmer Group

1. The way of separating read from write in MySQL There are several ways for mysql to achieve read-write separation: The program modifies mysql operation, communicates with database directly, realizes load balance in a simple and quick way with separation of reading and writing and random way, and di ...

Installation and initialization of mariadb yum install mariadb-server.x86_64 -y systemctl status mariadb systemctl start mariadb systemctl enable mariadb mysql netstat -antlupe | grep mysql See mysql port vim /etc/my.cnf //Add skip networking = 1 skip network for security systemctl restart mariadb Restart service mysql ...

I. ZABBIX server installation Environment: linux 7.3 host ip: 172.25.17.11 1. Prepare the installation package: Install all: [root@server11 mnt]# yum install * -y 2. Install the database and open the service to set the database password: [root@server11 mnt]# yum install mariadb-server -y [root@server11 mnt]# systemctl ...

The database organizes, stores and manages data according to the data structure. It is a warehouse built on the computer storage device. Simply speaking, it can be regarded as an electronic file cabinet itself - the place where electronic files are stored. Users can add, intercept, update and delete data in files.1. Install and deploy http://w ...

1. Install the main program and server of MariaDB database [root@fudanwuxi ~]# yum install mariadb mariadb-server.x86_64 [root@fudanwuxi ~]# systemctl restart mariadb.service [root@fudanwuxi ~]# systemctl enable mariadb.service Created symlink from /etc/systemd/system/multi-user.target.wants/mariadb.service to /usr/ ...

Implementation of vsftpd virtual user based on MYSQL authentication 1. Install packages and package groups 2. FTP server realizes PAM configuration 3. Prepare ftp related tables in the database 4. Modify vsftpd configuration file and call PAM ﹣ MSYQL module 5. Virtual users mapping to system users 6. Implement different ...

Recently, I have learned a lot of new knowledge. Thank you for your excellent teacher's detailed explanation. This blog records what I think. Want to learn more about functional testing in the Spring Boot project?This article takes you to learn more about using the Docker container in testing. This article focuses on applying some best practice ...

The introduction of Nginx dynamic and static separationNginx has a strong static processing ability, but its dynamic processing ability is not enough. Therefore, the dynamic static separation technology is often used in enterprisesDynamic and static separation for PHP Static page to Nginx Dynamic page to PHP-FPM module or Apache processingIn ...

Quartz has different memory and database modes In memory mode, task information is saved in memory, and it will be lost during shutdown. It needs to be re executed manually. In database mode, task information is saved in database, and the focus is to support cluster RAMJobStore in memory mode and database mode JobStoreTX, RAMJobStore is suita ...

Implement multiple instances based on yum source This experiment implements three examples, using port 330633073308 respectively 1. Install MariaDB server, yum #yum install mariadb-server 2. Create a directory for each instance #mkdir  /data/mysql/{3306,3307,3308}/{etc,data,socket,log,bin,pid} -pv 3. Permission to modify ...