MySQL Optimized Notes (6) - Stored Procedures and Stored Functions

When a large system is set up, it will be found that many SQL operations overlap, and individual calculations are the same, for example, in a business system, how a single sheet is calculated.When these situations arise, using stored procedures is a great optimization. This series: demo download (1) MySQL Optimized Notes (1) - Basic op ...

Posted by tili on Sun, 16 Jun 2019 19:23:17 +0200

Day21- JDBC transactions (JDBC enhancements)

Thing: Things are a logical set of operations in which the units that make up the set of operations either succeed or fail entirely In short, a set of operations either succeeds or fails; one thing has n components or n components succeed at the same time or n components fail at the same time. mysql transaction 1) Default transaction: ...

Posted by ramblix on Sat, 15 Jun 2019 18:46:04 +0200

Kubernetes Service's "Stateful Service Running Single Instance"

target Create a PV in your environment Create a Deployment for MySQl Exposing MySQL to other pod s in the cluster by DNS name Before the beginning You need a Kubernetes cluster, a kubectl command-line tool that can connect to the cluster. If you don't have a cluster, you can use Minikube To create. We will create a PV (Persistent Volume) for ...

Posted by stringman on Sat, 15 Jun 2019 05:50:34 +0200

sql basic grammar (2) - - query statement (select)

Overview of select statement There are three common functions of keyword select ion in query statements: single-table query, multi-table join query and sub-query. All the following introductions are about manipulating this table create table tml //Main table, two fields, ID (primary key self-increasing) and name (non-empty) ...

Posted by MarcB on Sat, 15 Jun 2019 05:13:11 +0200

Django 1.11.1 + Correct steps for database table operation

Wallpaper. jpg Hello everyone! Yes, I have issued a "pseudo" tutorial. Originally this article was originally called "Django database table operation summary: based on Django 1.11.1", but I changed it because Django has done all that we should do. We don't need to think about dealing with the database itself at all. When I ...

Posted by railanc4309 on Wed, 12 Jun 2019 21:55:36 +0200

Source code analysis of database middleware Sharding-JDBC: Syntax parsing of SQL parsing (1)

(iv) Focus on Wechat Public Number: [Taro Back-end Cabin] Welfare: RocketMQ/MyCAT/Sharing-JDBC All Source Analysis Articles List RocketMQ/MyCAT/Sharing-JDBC Chinese Annotation Source GitHub Address Every message you leave about the source code will be answered carefully. Even if you don't know how to read the source code, you can ask. New so ...

Posted by javauser on Tue, 11 Jun 2019 21:59:50 +0200

Assignment Question 3

3. Implement HA-LAMP combination based on heartbeat v2 crm; Require that wordpress be deployed, and any data in the edited articles can be accessed normally after node switching; Introduce networking: All devices use CentOS 6.8 operating system Two servers are configured with LAMP, IP addresses 192.168.255.128 and 192.168.255.129 V ...

Posted by ultrasound0000 on Tue, 11 Jun 2019 20:41:15 +0200

06.19 Meaning and Installation of MySQL Database (Part I)

Chapter 1 Database Classification 1. Relational database There are many two-dimensional tables in the database, one table, two tables, three tables, one hundred tables and so on. There may be associations between multiple tables. 2. Non-relational databases Includes multiple database services (multi-instance) 3306/3307/3307. Each databas ...

Posted by lepad on Mon, 10 Jun 2019 03:41:52 +0200

Two methods of updating database scripts by python

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

Master-slave replication, master-master replication and semi-synchronous replication of MariaDB

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