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
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
Each service has its own command to check the uptime of the service. But you can also use other commands for this.
By Magesh Maruthamuthu
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
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 /Appl ...
Posted by Goofan on Fri, 15 May 2020 09:17:40 -0700
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
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/
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
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 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
Download the installation package.
The previous MySQL installation failed because of the selected version. It is recommended to select [Linux generic]
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
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
Posted by Wo0tHigh on Sat, 04 Apr 2020 21:41:32 -0700