Authors: Cheng runke, Qian FenVideo: Qian FenIn the previous article, we demonstrated how to quickly implement MySQL high availability cluster deployment and the verification and unloading method of deploying the cluster. This article will demonstrate how to backup and restore a cluster.The deployment version is RadonDB MySQL Kubernetes 2.1.3.E ...
Posted by bamfon on Mon, 25 Apr 2022 06:06:50 +0300
Study preparation: first create a table (I use the previous table here)
mysql -u root -p
create database school;
use school;
create table class(
id int(10) not null,
name varchar(20) not null,
sex char(2) not null,
cardid varchar(20) not null,
phone varchar(11),
address varchar(50));
desc class;
insert into class values ('1','zhangsan', ...
Posted by omniuni on Mon, 25 Apr 2022 00:29:16 +0300
Memory structure
SQL buffer:
explain
It is used to store SQL statements, execution plans and result sets. The default result set is closedCACHE_POOL_SIZE: the default value is 200. For complex systems with many SQL types and Pkgs, it is recommended to increase this parameter
select * from v$parameter where name = 'CACHE_POOL_SIZE';
--0 ...
Posted by fitzsic on Sat, 23 Apr 2022 10:38:54 +0300
Introduction to Shiro security framework
Shiro security framework actual combat: Based on the separation of front and rear ends, technology selection: springboot 2 X + MySQL + mybatis + Shiro + redis + idea + jdk8, link address: [recent update]
1, ACL and RBAC explanation of permission framework design
1. Concept of permission control
Wh ...
Posted by robs99 on Thu, 21 Apr 2022 01:25:00 +0300
introduce
1. What is pymysql
**pymysql * * is a third-party module (Library) used to operate mysql in Python (that is, a mysql client)
pymysql is a module after Python 3, and MySQL DB is used to operate the database in Python 2
You can also use pymysql to connect to the mysql database in Django
2. Installation of pymysql
Terminal command lin ...
Posted by nitharsanke on Wed, 20 Apr 2022 23:43:17 +0300
This article data analyst must see! Last time I talked about the basics of database and mysql. This time, let's learn some of the most commonly used core query statements in MySQL.
The framed part is the focus of this section
1, Single table query
SELECT Field name FROM Table name WHERE condition [GROUP BY Field name HAVING condition ORDER ...
Posted by Jaspal on Wed, 20 Apr 2022 16:58:51 +0300
As a back-end development, there should be more than a few people who have used mycat. Talk about the problems encountered by the author using mycat! A separate service is required. For the concept that we only have a series of connection addresses, sometimes we don't know when we hang up (because it is deployed by operation and maintenance, an ...
Posted by salmon on Wed, 20 Apr 2022 13:22:14 +0300
database
mysql database
Create table
- data type
+ Integer type int
+ Floating point type double
+ Date type date/timestamp
+ String type char varchar
* variable varchar(n) The maximum length of characters must be given n Use: user name, password, ID number. n= 40 40 Bytes, 20 characters
* Immutable is char ...
Posted by loganbest on Wed, 20 Apr 2022 07:21:11 +0300
1, Database concept and its classification
Database: software for storing data, which is stored in the computer for a long time, and an organized collection of data.
Data table: the table is the basic unit of data storage in the database. The data is stored in different tables according to classification, which can query the data very efficie ...
Posted by angelcool on Tue, 19 Apr 2022 07:57:28 +0300