Programmer Think

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 ...

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 ...

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 ...

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 ~] ...

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 ...

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 ...

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}] ...

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 ...

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 ...

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 ...