mysql stored procedures and usage scenarios

1, What is a stored procedure Simply put, it is a set of SQL statements with powerful functions. It can realize some complex logic functions, which is a bit similar to a function of an application. Stored procedures are similar to triggers. They are a set of SQL sets, but stored procedures are called actively, and their functions are more pow ...

Posted by colossus_09 on Sat, 19 Feb 2022 20:14:31 +0100

MHA high availability cluster deployment and failover of database

There are some problems in the traditional master-slave architecture in the previous article (for example, single point of failure, etc.), which will be solved by adding new content in this blog. 1, MHA concept MHA (MasterHigh Availability) is a set of excellent software for failover and master-slave replication in MySQL high availability ...

Posted by twilitegxa on Sat, 19 Feb 2022 18:41:34 +0100

MySQL- 21- MySQL constraints

1. Overview of constraints 1.1 why constraints are needed Data Integrity refers to the Accuracy and Reliability of data. It is proposed to prevent the existence of data that does not comply with the semantic provisions in the database and to prevent invalid operation or error information caused by the input and output of error information. I ...

Posted by itarun on Sat, 19 Feb 2022 14:48:22 +0100

Using File Storage NAS to build Mysql master-slave replication + read-write separation of K8S cluster

This paper introduces how to use alicloud File Storage NAS to replace K8S native NFS system, so as to realize the flexible expansion, high availability and high-performance deployment of the storage system out of the cluster Built structure A master node and multiple slave nodes that asynchronously copy data from the master are composed, that ...

Posted by justspiffy on Sat, 19 Feb 2022 12:31:57 +0100

Occurrence and handling of Mysql deadlock

preface How should we troubleshoot and analyze Mysql deadlock? There is an insert on duplicate deadlock problem on the front line of. Based on this deadlock problem, this paper will share the troubleshooting and analysis process, hoping to be helpful to you. Deadlock Case recovery Table structure: CREATE TABLE `song_rank` ( `id` int(11) NO ...

Posted by robkir on Sat, 19 Feb 2022 05:29:52 +0100

Software testing handout (full version)

Software testing handout Edit java files using Notepad 1. Configure java path 1.1 select the computer icon / right-click to select the properties of the drop-down menu/ 1.2 select the advanced system Settings link 1.3 select the environment variable button in the system properties window 1.4 select the "classpath" path in the s ...

Posted by saandel on Sat, 19 Feb 2022 03:56:46 +0100

Mysql million data import

Mysql million data import 1. Method Import directly from the source sql file (not recommended)Load data infile command for import (recommended)Replace the engine, change the InnoDB engine of the table to MyISAM, and then import the data (not recommended)Import a single SQL statement of imported data into multiple SQL statements (recommended)O ...

Posted by showman on Fri, 18 Feb 2022 22:25:03 +0100

Introduction and comparison of commonly used redis clients

Introduction and comparison of a common redis client Jedis api online web address: http://tool.oschina.net/uploads/apidocs/redis/clients/jedis/Jedis.html Redisson website address: https://redisson.org/ redisson git project address: https://github.com/redisson/redisson Letuce website address: https://lettuce.io/ Letuce git project ad ...

Posted by pdaoust on Fri, 18 Feb 2022 19:48:47 +0100

Mybatis's past and present life

JDBC When it comes to java operating database, JDBC must be inexcusable. Mybatis actually encapsulates JDBC // Register JDBC Driver Class.forName("com.mysql.cj.jdbc.Driver"); // open a connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/spring-shiwu? characterEncoding=utf-8&serverTimezone=UTC", "root", "1234 ...

Posted by nikbone on Fri, 18 Feb 2022 15:59:31 +0100

2021-5-5 101701Hive command

The first chapter uses Hive to start Hadoop cluster Start HDFS HA (check whether the 50070 web page port is started successfully) Each machine starts the zookeeper service zkServer.sh start Start HDFS service sbin/start-dfs.sh Start YARN HA (check whether the 8088 web page port is started successfully) Start YARN sbin/start-yar ...

Posted by mohabitar on Fri, 18 Feb 2022 15:01:55 +0100