Programmer Think

I preface In enterprise applications, mature businesses usually have a large amount of data A single MySQL cannot meet the actual needs in terms of security, high availability and high concurrency Configure multiple master-slave database servers to realize read-write separation. II Principle of master-slave replication 1.mysql replicat ...

Purpose: to present the data to users by converting it into word pictures Tools: openoffice +java code + database, of which openoffice has windows version and Linux version. The download address of openoffice is: link: https://pan.baidu.com/s/1Y5Ra3TfNCcvVX1bF-29hjw Password: 44ms The installation and startup of openoffice is not described: ...

Brief description of MyBatis (reference from: What is mybatis_ Baidu knows (baidu.com)) MyBatis was originally an open source project ibatis of apache. In 2010, the project was migrated from apache software foundation to google code and renamed MyBatis. Moved to Github in November 2013. MyBatis is an excellent persistence layer framework tha ...

1. Spring5 transactions What is a transaction? Transaction is the most basic unit of database operation. Logically, it is a set of operations. Either all succeed. If one fails, all fail. Four characteristics of transactions: Atomicity, consistency, isolation, persistence. A case we often encounter is the problem of bank transfer. ...

MySQL (crazy God's notes) 1. Initial database 1.1 why learn databases? 1. Job requirements 2. In today's world, in the era of big data, those who get the database get the world. 3. Forced demand: save data 4. Database is the core existence of all software systems: DBA 1.2 what is a database? DataBase (DB, DataBase) Concept: dat ...

1, MySQL create data table CREATE TABLE table_name (column_name column_type); 1. Create a library and set the character set encoding to utf8 create database 'Library name' default character set = 'utf8'; 2. Create the table and set the character set encoding to utf8 create table 'Table name'(id int(6),name char(10)) default character set = ...

Analysis of data distribution strategy of greenplusGreenplus is an MPP database, which is composed of a master and multiple segments (a standby master can also be configured optionally). Its data will be distributed on different segments according to the set distribution strategy.In version 6, gp provides three strategies: random distribution, ...

preface In a normal production environment, we sometimes encounter host disk and other hardware failures that cause the host OS system to fail to start, or the OS system itself fails to repair. At this time, there is no other way except to reinstall the OS system, but how to join the original RAC cluster after reinstallation 👇👇 The followin ...

There may be many recovery methods for MySQL drop table. The following one is based on full backup, replication, and then sql_thread stops at a specified location to recover. Let's simulate recovery environmental information MySQL version information: Server version: 8.0.27 MySQL Community Server - GPL os: [root@test28 ~]# cat /etc/redh ...

database The database is similar to a folder with many excel tables, but the database is a software specially used to manage data, so the efficiency is much higher than that of Excel or text storage Database management system consists of a collection of interrelated data and a set of programs to access these data. This data set is often c ...