Database Administrator

MySQL binary log recovery data error: @ GLOBAL. GTID_MODE = OFF. When MySQL Recovers Data using binary logs, the following ERROR occurs: ERROR 1781 (HY000) at line 16: @ SESSION. GTID_NEXT cannot be set to UUID: NUMBER when @ GLOBAL. GTID_MODE = OFF.

How to unlock accounts in Oracle databases When creating an Oracle database, SYS logs on to the Oracle database and unlocks it using the SQL * Plus tool as follows. 1. Use the data dictionary dba_users to check the locking status of the Oracle

MySQL 5.5 upgrades the character set from utf8 to utf8mb4Reason for upgrade MySQL supports only three-byte UTF-8 characters by default, and does not support Emoji emoticons (four bytes). If there are four-byte characters, an error is returned. MySQL

Basic MySQL performance testTest reason Why is performance testing required? Simulate a higher load than the current system to identify performance bottlenecks Reproduce online exceptions Test different hardware and software configurations Plan

How to solve the INS-30131 error when installing Oracle You need to learn about SDE configuration. The Oracle Database Installation Error INS-30131 does not solve the problem. However, you have found a preliminary idea and recorded it for your

MySQL semi-synchronous replication practices Semi-synchronous ReplicationMySQL master-slave replication only supports asynchronous replication before MySQL 5.5. That is to say, after the master database executes some transactions, no matter the

MySQL Character Set details Character garbled characters are common and frequently asked questions in the database. In view of the fact that at most my level can only be attributed to non-streaming and so on, I am very worried about misleading

MySQL replication introduction and SetupMySQL Replication MySQL replication is a MySQL Server (slave) that replicates logs from another MySQL Server (master) and then parses the logs and applies them to itself, similar to Data Guard in Oracle. MySQL

Oracle redo log file analysis (insert)Oracle redo log file analysis (insert) 1: record the current scnselect dbms_flashback.get_system_change_number from dual; GET_SYSTEM_CHANGE_NUMBER -------------------- 11595722: Create a table CREATE TABLE team(

Docker practice: mysql Master/Slave backup read/write splitting, dockermysql 1) download the msql Image File docker pull mysql/mysql-server You can also specify the mysql version. docker pull mysql/mysql-server:5.7 View image filesDocker images 2)

Configure using redis in Spring boot -- Annotation form, springredis -- Following the template encoding method in the previous article, we used redisEncoding format configuration (1)Encoding format (2) After in-depth study, we found that the

MySQL stored procedure details mysql stored procedure and mysql stored procedure details /* Create a stored procedure */ /* Specify an ending mark before creating a stored procedure */ DELIMITER $ CREATE PROCEDURE test_pro1() BEGIN SELECT * FROM

Mysql table partitions are partitioned by day, and mysql partitions by day MySQL table partitioning refers to splitting a table into several small tables according to the set conditions. MySQL 5.1 and later versions support table partitioning,

Use some DataSet functions to log on to the website, and use dataset to log on to the website. First, I have to complete registration and store my personal information in the database. Secondly, some objects in this section are stored in some

Solve the problem that the Collections data of MongoVUE is not displayed, Problem description: After using the mongoDB database, the data is successfully added and can be queried using the command line, but the data in the mongoDB vue is not

One of the differences between MySQL and Oracle is the data type mysqloracle Data Type No. ORACLE MYSQL Note 1 NUMBER Int/DECIMAL DECIMAL is a structure such as NUMBER (). INT Is NUMBER (10), which

Comparison between MySQL and Oracle six triggers, mysqloracle Trigger No. Category ORACLE MYSQL Note 1 Different trigger creation statements Create or replace trigger TG_ES_FAC_UNITBefore insert or

-- Get table (worksheet) or column (field) listings from an excel spreadsheet -- set the variable declare @ incluservername sysname = 'tempexcelspreadsheet 'declare @ excelFileUrl nvarchar (1000) = 'd: \ text.xlsx' --/SET -- delete the Link Service (

Package cn.com. spring; import org. springframework. jdbc. core. namedparam. beanPropertySqlParameterSource; import org. springframework. jdbc. core. namedparam. sqlParameterSource; import org. springframework. jdbc. core. simple.

As mentioned in official documents, row-based replication is the safest and most reliable replication method. Therefore, we would rather sacrifice some performance to ensure data security. In the real environment, the master database MySQL 5.6.10