MySQL Read-Write Separation Reality

1. MySQL Read-Write Separation Concept The principle of MYSQL read-write separation is to let Master database handle transactional add, delete, modify, update operations (create, insert, update, delete) and Slave database handle query operations (select). MySQL read-write separation is based on MySQL master-slave replication, which can guarant ...

Posted by fareedreg on Mon, 08 Jun 2020 10:08:09 -0700

Implement LNMP architecture, deploy WordPress and configure NGINX virtual host

1. Compile and install LNMP and wordpress 1.1 install PHP, php mysql, mysql, PHP FPM [root@c1 ~]# yum install php php-mysql ngnix mariadb-server php-fpm -y 1.2 compile and install nginx 1.2.1 installation dependency package [root@c1 nginx]# yum install gcc pcre-devel openssl-devel zlib-devel -y 1.2.2 creating nginx users [root@c1 ~]# useradd ...

Posted by murali on Mon, 01 Jun 2020 07:59:42 -0700

Three ways to check the normal running time of MySQL/MariaDB database on Linux - Zhihu

Each service has its own command to check the uptime of the service. But you can also use other commands for this. Source: https://linux.cn/article-12263-1.html By Magesh Maruthamuthu Translator: geekpi We all know the purpose of using the uptime command in Linux. It is used for checking Linux system uptime And the time s ...

Posted by kevinritt on Fri, 29 May 2020 17:56:15 -0700

Log mysql operations

Now I want to compare the differences before and after php web page execution, but I still can't find better software Add, delete, and change the kind that is recorded. Then MySQL 5 is discovered by browsing the official documentation.1 has one Common Query Log .So try: #cd /Applications/XAMPP/xamppfiles/bin cd /Appl ...

Posted by Goofan on Fri, 15 May 2020 09:17:40 -0700

mariadb Source Installation

Dead work Because MariaDB's binary package mirroring source is at a foreign address, the package is downloaded in advance to the local physical machine and uploaded to the virtual machine/usr/local/src directory for installation using the lrzsz tool. The physical address is (click to download directly to the ph ...

Posted by abo28 on Sun, 10 May 2020 09:09:17 -0700

Alibaba cloud CentOS 7.4 configures Nginx, PHP and Mariadb

CentOS 7.4 basic environment configuration Add third party source yum There are two common third-party sources: EPEL and IUS. You can see the latest installation methods at https://ius.io/GettingStarted/ Automatic installation curl -L https://setup.ius.io | sh Manual installation (if automatic installation is used, this will be omitted) ...

Posted by n1tr0b on Sun, 03 May 2020 02:57:00 -0700

MySQL installation tutorial of Docker series

MySQL installation tutorial of Docker series With the previous basic tutorial Common command operation manual of Docker series After that, this blog records a mysql installation tutorial mysql image query command docker search mysql Several key parameters are explained as follows: INDEX docker.io is the official website of docker NAME the NA ...

Posted by Chetan on Tue, 21 Apr 2020 08:48:24 -0700

Binary installation MySQL 5.7

Binary deployment is relatively simple, so you can go to MySQL official website to download the MySQL binary package without installing the dependent environment. Or download through the link of my network disk, which contains the script for automatic deployment. Note: the latest MySQL version 8.0 is completely consistent with the deployment p ...

Posted by BZero on Tue, 14 Apr 2020 10:07:00 -0700

linux MySQL installation strategy

1.https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz Download the installation package. The previous MySQL installation failed because of the selected version. It is recommended to select [Linux generic] Decompression: tar zxvf mysql-5.7.21-linux-glibc2.12-x86_64.tar.gz //Put the ...

Posted by nariman on Mon, 13 Apr 2020 10:35:50 -0700

Install mysql in RPM mode

System environment Centos-7 mysql version mysql-5.7.17 1. Download and unzip rpm package [root@VM_42_245_centos ~]# tar xf mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar [root@VM_42_245_centos ~]# ls mysql-5.7.17-1.el7.x86_64.rpm-bundle.tar mysql-community-client-5.7.17-1.el7.x86_64.rpm mysql-community-common-5.7.17-1.el7.x86_64.rpm ...

Posted by Wo0tHigh on Sat, 04 Apr 2020 21:41:32 -0700