1. Unzip the file and enter the unzipped folder
tar xvf haproxy-1.9.8.tar.gz cd haproxy-1.9.8
2. Compile and install haproxy, compile parameters
make ARCH=x86_64 TARGET=linux2628 USE_PCRE=1 USE_OPENSSL=1 USE_ZLIB=1 USE_SYSTEMD=1 USE_CPU_AFFINITY=1 PREFIX=/usr/local/haproxy make install PREFIX=/usr/local/h ...
Added by double-f on Mon, 10 Jun 2019 20:38:52 +0300
SETNX is an instruction in Redis, called "Set If Not Exist", which sets value to key only when it does not exist, otherwise no operation is performed. SETNX can also be used to implement locks in Redis.
Before introducing how to use SETNX to implement locks, let's consider the following question:
Suppose we now ha ...
Added by Snorkel on Mon, 10 Jun 2019 04:47:19 +0300
DDL, DML statements
DDL (Data Definition Language) data definition language is to create, delete and modify the internal objects of the database; DML (Data manipulation language) is a data manipulation language, which operates on the data in the table.
Create a database - CREATE
Display the currently created database
mysql> SHOW DATA ...
MySQL triggers, like stored procedures, are a program embedded in MySQL.Triggers are actions triggered by time, including INSERT, UODATE, and DELETE statements.If triggers are defined, they trigger actions when the database executes these statements. A trigger is a named database object related to a table that is activated when a specifi ...
Added by simjay on Fri, 07 Jun 2019 20:45:46 +0300
SELECT..FOR UPDATE has been extended in MySQL version 8.0 to implement new clauses NOWAIT and SKIP LOCKED ( WL#3597 and WL #8919 ).This is a simple try and see how it works.Finally, similar functionality in AliSQL is described below
Like the literal meaning of the new syntax, NOWAIT means that an error is returned directly when a lock cann ...
Linux install MySQL.
1. Installation Files
mysql website I can't find how to download it.So, I upload to Baidu cloud for everyone Free Download.
1. Upload Files
Use linux The sz and rz commands of can be uploaded, or can be uploaded using the filezila tool. After uploading, see the following file:
Added by ReDucTor on Thu, 06 Jun 2019 19:49:59 +0300
First go to the official website https://www.zabbix.com/documentation/3.2/manual/installation/install_from_packages/repository_installation
Here you install some trusted certificates, or components, based on your own system.
In order to be able to use it quickly, I did not go into it.
After the installation is completed,
Now you a ...
Added by sstoveld on Thu, 06 Jun 2019 00:20:47 +0300
Distributed MySql Deployment Scheme
mysql master-slave backup
MyCat Middleware Build
haproxy load agent
keepalived for single point failure
mycat-eye monitoring web
Overall structure of experimental environment
1. Start mysql master-slave backup
2. Scheduling and routing using ...
Added by iman121 on Tue, 04 Jun 2019 06:05:31 +0300
What is FTWL
FTWRL is short for FLUSH TABLES WITH READ LOCK (FTWRL). This command is mainly used to ensure backup consistency. In order to achieve this goal, it needs to close all table objects, so this command is very lethal and easy to cause hang when executing the command. If it is executed in the main library, the business cannot access it ...
Added by raouleduke on Sun, 02 Jun 2019 01:47:07 +0300