Programmer Think

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 = ...

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 ...

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 ...

Words 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 ...

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 ...

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. ...

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 ...

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 Close Firewall [root@bogon ~]# systemctl stop firewalld.service About zabbix and related service software ...

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 ...

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` ...