Multi instance implementation of mysql database under Linux
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 ...
Posted by coco777 on Wed, 18 Dec 2019 08:55:32 -0800
Using nfs to realize remote backup and recovery of database
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 ...
Posted by alfieshooter on Mon, 16 Dec 2019 11:50:16 -0800
The realization of master-slave cascade of mysql
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 ...
Posted by suprsnipes on Sat, 14 Dec 2019 11:16:05 -0800
MySQL Architecture - mmm deployment instance
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 ...
Posted by EODC on Sat, 14 Dec 2019 09:48:21 -0800
MySQL query and delete duplicate records
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 ...
Posted by s4salman on Tue, 10 Dec 2019 16:00:02 -0800
Configure lnmp environment using yum (CentOS7.6)
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 ...
Posted by ozzythaman on Sun, 08 Dec 2019 01:58:32 -0800
Python practice [6] [database operation | file reading and writing]
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 ...
Posted by ericwright17 on Fri, 06 Dec 2019 06:45:52 -0800
MySQL - mmm high availability (practice!)
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 ...
Posted by jozard on Tue, 03 Dec 2019 07:33:34 -0800
Build Linux:LAMP Environment
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 ...
Posted by bulgin on Sat, 23 Nov 2019 00:46:29 -0800
Mairadb source compilation and installation
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 ...
Posted by Martin18 on Mon, 18 Nov 2019 08:09:33 -0800