MySQL master-slave replication, separation and resolution
catalogue
1, MySQL master-slave replication
1.1 master slave replication architecture and principle
1.1.1 service performance expansion mode
1.2 MySQL extension
1.2.1 what is read-write separation?
1.2.2 why is read-write separation necessary
1.2.3 when should I separate reading from writing
1.2.4 master slave copy and read / write sepa ...
Added by Isoss on Sun, 05 Dec 2021 19:04:14 +0200
Nacos introduction, download and configuration persistence to Mysql
scene
What is Nacos
Nacos is dedicated to helping you discover, configure, and manage microservices. Nacos provides a set of easy-to-use feature sets to help you quickly realize dynamic service delivery Service configuration, service metadata and flow management. Nacos helps you build, deliver, and manage microservice platforms mor ...
Added by scnov on Sun, 05 Dec 2021 12:59:45 +0200
MySQL variables, process control and cursors
catalogue
1. Variable
1.1 system variables
1.1.1 classification of system variables
1.1.2. View system variables
1.2 user scalar
1.2.1 classification of user variables
1.2.2 session user variables
1.2.3 local variables
1.2.4 comparing session user variables with local variables
2. Define conditions and handlers
...
Added by thepriest on Sun, 05 Dec 2021 05:47:54 +0200
MySQL notes 4 - table creation, addition, deletion and modification
9 establishment, addition, deletion and modification of table
9.1 table creation (table creation)
Syntax format of table creation: (table creation belongs to DDL statement, and DDL includes: create drop alter)
create table Table name(Field name 1 data type, Field name 2 data type, Field name 3 data type);
create table Table name(
Field na ...
Added by sheen.andola on Sun, 05 Dec 2021 02:28:25 +0200
How to solve the problem that getting timestamp from Mysql database is 8 hours earlier than the normal time
This article introduces the relevant knowledge of "how to solve the problem of obtaining timestamp from Mysql database 8 hours earlier than the normal time". In the operation process of actual cases, many people will encounter such difficulties. Next, let Xiaobian lead you to learn how to deal with these situations! I hope you can rea ...
Added by eddy666 on Sat, 04 Dec 2021 21:50:02 +0200
The lottery management system is realized through Mysql+Swing+jsp
catalogue
Function Preview
Back end main content
Login panel
Management panel
Data panel
Menu bar
Panel switching
Operation database
Main form
key technology
verification
Operating system process
Beautify form
Front end part
Registration interface
jsp realizes front-end and back-end interaction
Fu ...
Added by adityamenon90 on Sat, 04 Dec 2021 01:58:50 +0200
Idea Tomcat Mysql connection
Idea—Tomcat
preparation in advance
Install the applicable JDK version of TomcatIn the doc window, test Tomcat to ensure that it can be executed normally. Step 1: New Project (I'm used to creating an Empty Project first, and then creating a Module under the Empty Project. This is not necessary, but a habit. You can directly create a non ...
Added by karan23424 on Fri, 03 Dec 2021 18:43:48 +0200
Raspberry PI (raspberry pie) installation of MariaDB / MySQL database
Introduction: This article mainly explains how to install MariaDB / MySQL database on raspberry PI (raspberry pie) system.
For image download, domain name resolution and time synchronization, please click Alibaba open source mirror station
1, Update system
Update the system you need to install by running the following comman ...
Added by dewed on Fri, 03 Dec 2021 18:26:54 +0200
What is DQL? Its meaning and common command analysis
Write in front: This article is my study record. If there are mistakes, please point them out and correct them immediately DDL, DQL, DML and DCL will be written in four parts, and DQL will be written in this article.
What is DQL?
DQL: data query language, used to query data
First, paste a table, and the following query contents will be us ...
Added by hanhao on Thu, 02 Dec 2021 22:23:28 +0200
MySQL basic syntax statement 1
1, SQL language classification:
1. DDL: database definition language; It is used to establish and delete databases, tables, views, etc.
DDL includes create, alter, drop, etc.
2. DML: database manipulation language: used for adding, deleting, modifying and querying.
  ...
Added by NickG21 on Thu, 02 Dec 2021 04:43:45 +0200