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 ...
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.
1) Default transaction:
Posted by ramblix on Sat, 15 Jun 2019 18:46:04 +0200
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
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
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
(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
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;
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
Posted by ultrasound0000 on Tue, 11 Jun 2019 20:41:15 +0200
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
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