Cascade replication of database

Environmental Science: 192.168.205.17: as master server 192.168.205.27: as middle server 192.168.205.37: as slave server Edition: OS: centos 7 1810 with mini install mariadb-5.5.60 Purpose: If there may be a master server and a read server in the production environment, and there may be multiple slave servers, but the performance of th ...

Posted by subasi on Mon, 05 Aug 2019 13:13:55 +0200

Build nginx+mysql+loganalyzer+rsyslog log server

We have planned two hosts in advance. They are: server-1: 192.168.1.135 server-2: 192.168.1.136 server-1 is used as a client to collect logs, import them into MySQL database of server-2, and display the front-end web through Log Analyzer. First is the configuration of server-2 Install LNMP  yum install nginx php -php-fpm php-mysql mysql-server ...

Posted by Jassal on Mon, 05 Aug 2019 12:09:40 +0200

The Heart Course of Installing MySQL on CentOS 7

Today, there is a sudden whim to transfer the blog to your own cloud server. Well, it's a good idea, just able to practice. In order to do this, we must first have a database, linux with mysql. Ouch, that's good. Two words don't mention the installation method of yum [root@VM_235_40_centos ~]# yum install mysql Loaded plugins: fastestmirro ...

Posted by Joopy on Fri, 12 Jul 2019 22:09:26 +0200

CentOS 7.3 Compile and Install MariaDB 10.2.6

1. Delete the default database configuration file for CentOS 7.3 [root@localhost ~]# find -H /etc/ | grep my.c /etc/pki/tls/certs/make-dummy-cert /etc/pki/tls/certs/renew-dummy-cert /etc/my.cnf.d /etc/my.cnf.d/mysql-clients.cnf /etc/my.cnf [root@localhost ~]# rm -rf /etc/my.cnf /etc/my.cnf.d/ [root@localhost ~] ...

Posted by mr_badger on Thu, 20 Jun 2019 00:35:02 +0200

Master-slave replication, master-master replication and semi-synchronous replication of MariaDB

This article mainly introduces the concepts and methods of master-slave replication, master-slave replication and semi-synchronous replication of mariadb. Reference resources http://www.jb51.net/article/97786.htm The time of master and slave servers should be synchronized, and the database version should be consistent in order to avoid a ...

Posted by chenggn on Sun, 09 Jun 2019 21:08:36 +0200

11.1 LAMP Architecture Introduction 11.2 MySQL, MariaDB Introduction 11.3/11.4/11.5 MySQL Installation

11.1 Introduction to LAMP architecture11.2 Introduction to MySQL and MariaDB11.3/11.4/11.5 MySQL installationExtend mysql5.5 source compilation installation http://www.aminglinux.com/bbs/thread-1059-1-1.html mysql5.7 binary package installation (large change) http://www.apelearn.com/bbs/thread-10105-1-1.html 11.1 Introduction to ...

Posted by jpraj on Tue, 21 May 2019 20:58:43 +0200

DML for (MariaDB/MySQL): Data Update, Delete

Contents of this article:1.update statement2.delete statement 2.1 Form Delete 2.2 Multi-table Deletion3.truncate table 1.update statement update is used to modify records in a table. # Form update syntax: UPDATE [LOW_PRIORITY] [IGNORE] table_reference [PARTITION (partition_list)] SET col1={expr1|DEFAULT} [,col2={expr2|DEFAULT}] ...

Posted by thomashw on Sun, 19 May 2019 09:27:22 +0200

Ubuntu Linux System MariaDB10.3 Source Compilation Installation Notes

MySQL and Maria Widenius are real relatives and sisters, named after Michael Widenius, the father of MySQL, who was born to his first wife, My Widenius, and Maria Widenius, the daughter of his current wife.After Oracle acquired Sun, MySQL, previously sold to Sun by Monty, was inherited by Oracle.Oracle is the world's largest co ...

Posted by matthiasone on Sun, 19 May 2019 07:52:21 +0200

Ansible Installation of Linux Multi-Instance mariadb

Ansible installs multi-instance MariaDB 10.2.23 Battlestar Configuration Place mariadb binary packages under root home directory [Mon Apr 29 19:52 root@ansible-centos7 ~]# ls -rw-r--r-- 1 root root 456950538 Apr 26 08:16 mariadb-10.2.23-linux-x86_64.tar.gz Create ansible directory under / data directory and roles folder internally [Mon Apr ...

Posted by Joeker on Fri, 17 May 2019 15:02:28 +0200

Saltstack_Use Guide 05_Data System-Pillar

1. Host Planning   Pillar document https://docs.saltstack.com/en/latest/topics/pillar/index.html   Matters needing attention If the master or minion configuration file is modified, the corresponding service must be restarted.   2. Grains VS Pillar   3. Pillar Basic Information 1 Pillar 2 Pillar data is the dynamic as ...

Posted by phpwizard01 on Thu, 16 May 2019 14:30:01 +0200