Programmer Think

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

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

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

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

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

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

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

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

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

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