Database Administrator

PostgresSQL master-slave setup steps Due to work requirements, I recently started to contact various databases and try high-availability solutions for various database products. I am sharing the master-slave configuration of postgresql today. It is

Obtain the value of a specific position in the field in MySQL Obtain the value of a specific position in the query field in MySQL For example, there are two types of data: mysql>  select  *  from  t; + --------------------------+ |  name | + --------

How MySQL achieves transaction isolationReview Among the many storage engines of MySQL, only InnoDB supports transactions. The transaction isolation level mentioned here refers to the transaction isolation level under InnoDB. Read not committed: one

Logrotate implements MySQL slow log Segmentation MySQL slow log? The slow query log of MySQL is a log record provided by MySQL. It is used to record the statements whose response time exceeds the threshold value in MySQL, specifically the SQL

Use MyBatis Based on XML, and use MyBatis for XML 1. Project Structure 2. entity Student package net.hw.bean;/** * Created by howard on 2016/4/25. */public class Student { private int id; private String name; private String branch;

Application of Go in codoy database middleware and go codoy Middleware Author: Liu Yanyun This article mainly focuses on Go's database middleware application. First, we will talk about the application development requirements. For details, we will

Navicat Premium 12.0.18 installation and activation, navicat12.0.18 This article describes how to download, install, activate, and use Navicat Premium 12.0.18. Note: The active files provided by the bloggers support Navicat Premium 12.0.11-12

Detailed description of SQLite3 binding function family usage and precautions; sqlite3 binding Preface The code displayed in this article is actually how to use the parameterization mechanism of Sqlite3 to insert data or update the data. It depends

-- ============================================ -- LOGGING and NOLOGGING on table and index segments -- ============================================ In some cases, you can use the log recording mode for the table segment and index segment, or you

This article will simulate a data warehouse system with user data, product data, and order data. Create a multi-dimensional dataset based on the data structure and process it incrementally. The incremental approach is to consider the growth of data

In the actual production environment, if the concurrency is not large, you can use the pessimistic locking method. This method is very convenient and simple to use. However, if the system concurrency is very large, pessimistic locking will bring

Although many GUI-based MySQL clients exist, such as the famous phpMyAdmin and SQLYog, I have always liked the native MySQL command line client. Indeed, I am not familiar with these command line interfaces (CLI) previously, it took us some time to

The nature of Indexes MySQL officially defines indexes as: indexes are the data structures that help MySQL efficiently obtain data. Extract the sentence trunk to get the essence of the index: Index is the data structure. We know that database query

1. EXPLAIN tbl_name EXPLAIN tbl_name is a synonym for DESCRIBE tbl_name or show columns from tbl_name. 2. EXPLAIN [EXTENDED] SELECT select_options If the keyword "EXPLAIN" is placed before the SELECT statement, MySQL will EXPLAIN how it processes

In today's era of rapid development of information technology, users often encounter the problem of Switching Data in EXCEL files to data in ORACLE databases to achieve real-time data operations, there are not many materials available in this regard.

The Virtual Private Database feature of Oracle is also known as fine-grained access control. It provides row-level security checks for DML statements in data management languages such as SELECT. PL/SQL policy functions are associated with a data

If you use the default Oracle creation method when creating foreign key constraints, you cannot delete the referenced data. This gives us more flexible options in Oracle9i, however, we use the on delete cascade and on delete set null keywords to

Oracle elastic uard is a database-level HA solution. Its primary functions include redundancy, data protection, and fault recovery. When the "transaction consistency" of the production database is used, the physical full backup (or physical COPY) of

BKJIA featured translations] Oracle 11g R2 extends many new feature suites for backup and recovery, including recovery manager RMAN, many of which are extensions for earlier features. BKJIA editing recommendations: New features and application

1.1: added data files Starting from SQL SERVER 2005, the database does not generate NDF data files by default. Generally, a primary data file MDF is enough. However, for some large databases, due to a large amount of information, in addition, some