Programming VIP

MySQL sub database and table can be realized through the middleware Mycat. This paper briefly introduces several partition strategies of Mycat, mode, range and hash, and tests and verifies them respectively 1. MySQL implements database and table splitting based on Mycat 1.1 principle of warehouse and table division Data sharding can be div ...

1, jdk installation Download jdk: Official address: https://www.oracle.com/java/technologies/javase-downloads.html Unzip the downloaded package: #Use command: tar -zxvf jdk-8u291-linux-x64.tar.gz #To facilitate management after decompression: mv jdk-8u291-linux-x64/ /usr/core/jdk #I like to use core as a common (core) and immovable dire ...

Master-slave database Install docker Please refer to my other article: https://blog.csdn.net/m0_46435741/article/details/121502952 Create a new instance of the main mysql container Create a container with mysql version 5.7. Mount data volume: Mount the configuration file to the host Directory: / mydata / MySQL master / conf Mount the log ...

1. The database data is damaged due to misoperation of drop statement. Please write down the recovery idea and actual general steps? #The recovery of all data depends on backup. If there is no backup, it cannot be recovered In case of recovery after misoperation, the incremental recovery method shall be used for recovery. The specific steps ...

The last two articles talked about two ways to divide databases and tables. These two ways can be summarized into one type, which are to divide data in the form of configuration. In this article, we continue to explain a new way to slice data. In addition to the form of configuration, sharding JDBC also supports self-defined rules through code. ...

DML language DML (Data Manipulation Language) refers to the Data Manipulation Language, which is used to update the records of tables in the database. As the name suggests, data is manipulated, so it is for table records, not for table structures. insert statement To realize data insertion, you need to provide table name, column name and va ...

1, Installation 1. Download mysql Official website: https://dev.mysql.com/downloads/mysql/ , I use the latest version 8.0.19. The version format is zip, as shown in the figure below 2. Unzip to the specified path, as shown in the following figure 3. In order to facilitate operation, add the Path of bin folder under this directory to the ...

thank Thank you, Mr. Zhou Yang ❤️❤️ Station b video address Uninstall previous version View the installed MySQL RPM - qa|grep - I MySQL Uninstall mysql-community-server-5.6.36-2 one by one using Yum remove el7. x86_ sixty-four Installation of MySQL for Linux Download MySQL installation package wget https://dev.mysql.com/get/mysql57-comm ...

0. General MySQL basic notes, review and useEnvironment construction: detailed installation steps of MySQL database nameexplaincommandDDL (data definition language)Define and manage data objects, such as databases, data tables, etccreate,drop,alterDML (data operation language)Used to manipulate data contained in database objectsinsert,update, ...

Introduction - learn node The purpose of JS is to help you open the black box of the server. Only by understanding the server can we better cooperate with the server developers in collaborative development 1.1 review and reflection 1. Why can javaScript be executed in the browser? 2. Why can javaScript operate DOM and BOM 3. javaScript ...