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

Added by NickG21 on Thu, 02 Dec 2021 04:43:45 +0200