In the two iterations of the latest project, the database needs to be updated according to the changes of business requirements, and two iterations are updated in different ways.
The first is to use python's MySQLdb module to update with native sql statements
1 import MySQLdb
2 #host name
3 HOST = '127.0.0.1'
4 #User name
5 USER = ...
Posted by Qnuts on Mon, 10 Jun 2019 01:53:56 +0200
This article mainly introduces the concepts and methods of master-slave replication, master-slave replication and semi-synchronous replication of mariadb.
Reference resources http://www.jb51.net/article/97786.htm
The time of master and slave servers should be synchronized, and the database version should be consistent in order to avoid a ...
Posted by chenggn on Sun, 09 Jun 2019 21:08:36 +0200
From Congo: https://www.cnblogs.com/ZKPython/p/10992326.html
First, to install nginx and MySQL on the server, the website file is recommended at / usr/local/www, environment Python 3.6+mysql 5.7. Ali cloud's server can have a configured public image, otherwise install the environment on its own.
Name of this project: loginOrRegister
For X ...
Posted by stlewis on Sat, 08 Jun 2019 19:04:24 +0200
In Java Web-JDBC-1-not just the connection, we did the CURD operation, but we wrote it many times and thought about how to optimize it. Does that happen every time? This can only be regarded as an operator, an operator without thought.
Today, optimize on the basis of last time.
First look at the Java Web architecture:
First, the fi ...
Posted by new2code on Fri, 07 Jun 2019 22:31:32 +0200
zabbix Foundation and Advancement (1) - zabbix Component Deployment
zabbix is a well-known distributed monitoring system.Supports the collection of zabbixagent data through the proxy server zabbix proxy, then saves the collection in the local database and sends it to the zabbix server for uniform storage and display.
Zabbix services w ...
Posted by LiveFree on Fri, 07 Jun 2019 20:06:17 +0200
There are four isolation levels for database transactions:
Read Uncommitted: Allow dirty reading, that is, it is possible to read data in other sessions that have not submitted transaction modifications.
Read Committed: Only submitted data can be read, which is the default level for most databases such as Oracle.
Repeated Read: Repeated Read. ...
Posted by AZDoc on Fri, 07 Jun 2019 00:14:02 +0200
Create a database
create database database name [other options];
Create database tables
create table Table Name(Column Statement);
## Taking the creation of students table as an example, the table will store such contents as student number (id), name (name), sex (age), contact telephone (tel):
create table students
id int ...
Posted by Mikester on Thu, 06 Jun 2019 21:53:47 +0200
Compile and install the zabbix-server side of the deployment in the CentOs 7.0 environment
First you need to close selinux
[root@bogon ~]# sed -i 's/SELINUX=.*/SELINUX=disabled/' /etc/selinux/config
[root@bogon ~]# setenforce 0
[root@bogon ~]# systemctl stop firewalld.service
About zabbix and related service software ...
Posted by fatal on Thu, 06 Jun 2019 18:12:44 +0200
Lao Zhang Mei is not only a fan of Jin Yong, but also a fan of the Three Kingdoms. I like to watch the fighting between Zhuge Liang of Shu State and Sima Yi of Wei State. The use of all kinds of magic tricks is classic. In view of the management of MySQL database, Mr. Zhang also has many ingenious ideas, which will be introduced to you one by o ...
Posted by suavebum on Thu, 06 Jun 2019 00:44:12 +0200
Database int, what is the length after the char field
First come to the conclusion:The length of the int field has nothing to do with the length of the data you store, but with the display.The length of the char field is related to the length of the data you store
int field length
Start with int and look at the table below
CREATE TABLE `test10` ...
Posted by bulrush on Tue, 04 Jun 2019 18:33:17 +0200