Seventeenth Blog Assignment
1. Describe the working principle of LVS with graphics.
Function: According to the target IP and target port of the request message, the scheduling is forwarded to a host at the back end, which acts on the fourth layer of the OSI network model.
LVS has four cluster types, namely:
(1) lvs-nat: Multi-target ...
Posted on Sun, 14 Apr 2019 10:15:32 -0700 by nvee
Preface: SQL Alchmey was learned in summer vacation, and did not write a blog in time after learning. This blog mainly introduces SQL Alchemy and its basic operations. After writing this blog, I will be free to do a small project of Fortress Machine. The next blog is about Web Framework and django Foundation~~
Introduction to ORM
Object relatio ...
Posted on Fri, 12 Apr 2019 02:18:31 -0700 by simon_belak
At noon, taking advantage of the meal time to extract teeth, just ready, the boss called, said that there was an unexpected power outage of a db server, simple communication, the machine up first, wait for a look back, found that the problem is not so simple.
The power is off by a master. Look at slave and find that slave has stopped sync ...
Posted on Fri, 12 Apr 2019 00:54:31 -0700 by Ionisis
EnOS 7 X64 4 Core 2G Memory Built in VMware 12
Installed in the environment http://blog.csdn.net/u014595668/article/details/50166277 Compile and install MySQL 5.7.9
Compiler environment: Download libmcrypt 2.5.7,mhash-0.9.9.9 Download,mcrypt-2.6.8 Download PHP Installation kit: php
7 download ...
Posted on Thu, 11 Apr 2019 17:54:31 -0700 by Pedro Sim
I believe that many small partners and I have encountered this kind of problem, when using JDBC to connect to mysql database, the abnormal situation of SQL Exception as shown below occurs!
java.sql.SQLException: The server time zone value '¤¤°ê¼Ð·Ç®É¶¡' is unrecognized or represents more than one time zone. You must configure either the serv ...
Posted on Wed, 10 Apr 2019 10:57:31 -0700 by markkanning
Foreword: (still in study, various excerpts, follow-up supplements)
The database connection pool is responsible for allocating, managing and releasing database connections. It allows applications to reuse an existing database connection rather than re-establish it. It also releases database connections with idle ...
Posted on Tue, 09 Apr 2019 22:30:31 -0700 by redesigner
mysql Operations and Maintenance Server Log. (east_sun Reference Document)
mysql Operations and Maintenance Server Log east_sun Reference Document
Summary of Log Classification
1 Server Log error_log
2 Server Log Slow Query log_slow
2 Server Log Slow Query log_slow
3 Server Log Universal Query Log general_log
Posted on Tue, 09 Apr 2019 22:12:31 -0700 by daphreeek
Since MySQL version 5.6.6, a password plug-in (validate_password) has been provided to check password strength and improve security. After the password plug-in is installed and enabled in the database, when creating user, alter user (version 5.7), grant and set password operations, the password will be verified to conform to the default passwo ...
Posted on Tue, 09 Apr 2019 14:33:31 -0700 by Thauwa
Command Description Syntax
HSET assigns HSET key field value to filed field in key
HGET Gets the filed value in key HGET key field
HMSET sets multiple filed fields value HMSET key field value [field value...]
HMGET Gets the value of all filed fields HMGET key field [field...]
HSETNX does not operate HSETNX key field value unless filed does ...
Posted on Tue, 09 Apr 2019 13:54:30 -0700 by pengu
Finding the cluster structure of the database instance, whether it is a master library or a slave library, according to any IP or domain name, is a common and essential function in DBA operation and maintenance. The function realization described in this paper has been applied in an Internet company. It is running steadily and continuously prov ...
Posted on Mon, 08 Apr 2019 21:12:31 -0700 by Yeodan