N26 - 17th Blog Assignment

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

python's SQL Alchemy ORM

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

Repair of Synchronization Anomalies Caused by MySQL Server Abnormal Power Failure

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

CentOS 7 Compile and Install PHP7

Environmental description 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 Tool download 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

Solve the abnormal problem of The server time zone value'

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

Initial knowledge of database connection pool

Foreword: (still in study, various excerpts, follow-up supplements) Basic knowledge Definition: 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

mysql Operations and Maintenance Server Log. (east_sun Reference Document) Catalog mysql Operations and Maintenance Server Log east_sun Reference Document Catalog 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

Use MySQL Password Plug-in to Eliminate Account Weak Password

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

Redis Note 6: Hash of Data Types

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

Query Function Design of Master-Slave Architecture in Database Cluster

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