Programmer Group

Preparation environment: centos7 install Yum install MariaDB server Plan and implement the directory structure of multiple instances Port: 33063307, 3308 The folder where each instance stores the database / data / MySQL {330633073308} /data/mysql/3306/{etc,soket,log,data,pid,bin} Create the data folder required by mysql u ...

The importance of mysql (mariadb) database backup: Data is one of the most important files in a database. When our database is damaged, many of our programs will be affected, which will affect the normal operation of the company. Now more and more enterprises begin to pay more and more attention to the database, so we are requ ...

Introduction: The master-slave cascade is to reduce the pressure of the master database, which is more conducive to load balancing. If we don't have a cascade server, we can also achieve the effect of master-slave synchronization, but we don't recommend using it. On the one hand, the pressure of the master database is too hig ...

Source of mmm architecture As we all know, MySQL provides Master-Slave replication, and then it can easily realize Master master two-way replication, and build a Slave library for one of the Master nodes. In this way, the MySQL-MMM architecture is based on two-way replication between Master1 and master2, and Master-Slave replication between M ...

Table structure, data as follows: CREATE TABLE `redis_num_mem` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Self increment id', `cluster_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Redis colony id', `type` varchar(10) NOT NULL DEFAULT '' COMMENT 'key type', `number` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'key ...

I. details of installation version Server: MariaDB Server version: 5.5.60-MariaDB MariaDB Server [root@ln-125 ~]# cat /etc/redhat-release CentOS Linux release 7.6.1810 (Core) [root@ln-125 ~]# nginx -v nginx version: nginx/1.14.2 [root@ln-125 ~]# php-fpm -v PHP 5.4.16 (fpm-fcgi) (built: Oct 30 2018 19:32:20) Copyright (c) 1997-2013 The PHP Group ...

1. Review topics of object-oriented, file operation and database operation: The file score.dat holds the names of 100 students and their Python lessons, advanced mathematics and English scores. (1) define the student class, including name, Python class, advanced mathematics and English scores, total score and average score data members, and ...

Advantages and disadvantages of MySQL-MMM: Advantages: high availability, good scalability, automatic failover, for primary and primary synchronization, only one database write operation is provided at the same time to ensure data consistency. Disadvantages: the Monitor node is a single point, which can be combined with Keepalived to achieve ...

Setup of LAMP Environment Install DNS Server Install DNS Service yum install bind -y Configuration of DNS Create Forward Resolution For example, create a forward lookup zone named "lsy.com": Step 1: Create a lookup zone in the main configuration file/etc/named.conf. vim /etc/named.conf listen-on port 53{any ...

Source compilation and installation of Mairadb 1. Install the dependent components required by the environment first [root@node6 ~]# yum -y install bison bison-devel zlib-devel libcurl-devel \ libarchive-devel boost-devel gcc gcc-c++ cmake ncurses-devel gnutlsevel \ libxml2-devel openssl-devel libevent-devel libaio-devel 2. Create required us ...