Database Administrator

About Replication in redis I. Introduction Redis's replication mechanism allows slave to transmit copies from the master over the network to complete data backup. It has the following features: Asynchronous replication One master, multiple slaves

Using Redis as a time series database: Reasons and Methods Since the emergence of Redis, it has been used in the storage and analysis of time series data to a certain extent. Redis was initially implemented as a buffer for logging. With the

Upgrade to MySQL 5.7 to solve the partition problem. Preface Some friends often ask, How is MySQL partition? Can I use it? Are there many bugs? I don't know why MySQL partitions have such an impression on the general public. However, in the

MyCAT Log Analysis MyCAT logs cannot be obtained for running information about MyCAT. For example, if MyCAT adopts read/write splitting, how does MyCAT execute a query statement, and which node each shard is distributed. The default value is the

Practices for restoring data using MySQL binlog A few days ago, I worked overtime until. On the way back, a friend called and said that the development and maintenance staff of their company were updating the online system versions, accidentally

Verification of the MyCAT Character Set The default Character Set of MyCAT is UTF8. The following describes how to check the log to verify the effect of different MySQL client character sets and server character sets on MyCAT. There are three main

ORA-14400: The inserted partition keyword is not mapped to any partition Problem description: When kettle is used to extract data from the original Library to the standard library, an error is reported during the extraction process: ORA-14400:

Basic MySQL Tutorial: About varchar (N) PrefaceWhat does varchar (N) N mean and how many Chinese characters can it store? This is a common question. Today I was asked by another developer to write an article about this question. 2. Theoretical

MySQL-related statements (add, delete, modify, and query) (SQLyog software implementation) MySQL-related statements (add, delete, modify, and query) (SQLyog software implementation) -- Create an employee table: empCreate table emp (Empno INT, --

Innodb Storage engine backup tool-Xtrabackup Xtrabackup is a tool used to back up InnoDB data. It supports online Hot Backup (data read/write is not affected during Backup) and is a good alternative to InnoDB Hotbackup. Xtrabackup has two main tools:

Access Oracle through the DB2 Federation 1. View OS and DB versionsOS version:C: \ Users \ Administrator> verMicrosoft Windows [version 6.1.7601]Oracle version:SQL> select * from v $ version where rownum = 1;BANNER------------------------------------

Detailed installation process of source code in the latest version of MySQL 5.7.10 Detailed installation process of source code in the latest version of MySQL 5.7.10 1 ,:Package: http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.10.tar.gz You

MySQL Master/Slave Database Configuration Guide and error handling MySQL master-slave replication Configuration 1. Requirements 1.1 System Platform consistency 1.2 consistent database versions 2. Modify the my. cnf file. The master server and slave

Install MySQL in CentOS 7 The mysql-sever file for mysql installation does not appear to be in the yum source of CentOS 7. You need to download it from the official website. # Wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

Oracle adump file goes viral The Oracle adump file is too long, causing the oracle database to crash and re-build the adump directory. The error is: no space left on device, df-TH space is still available, but the directory cannot be created, the

Manually generate an AWR report Sometimes the AWR report cannot be graphically generated for installing EM in the database. In this case, you need to manually generate an AWR report. Oracle provides an SQL statement to manually generate an AWR

How to install Redis in Linux Redis overview and Comparison Memcached is a high-performance distributed memory object Cache System for dynamic Web applications to reduce database load. It caches data and objects in the memory to reduce the number of

Oracle Installation of Automatic Installation Software Package for the first time 1. install required software packages automatically in Oracle Configure the yum repository in advance Define the package.txt package list file: Take the official

Oracle Database rman backup plan and recovery 1. Prerequisites for completely restoring rman: Historical backup of datafile, controlfile, and spfile, plus full archivelog and complete redolog. 2. rman backup script: A. RMAN level 0 BACKUP

SQLite performance optimization instance sharing, sqlite performance optimization instance The first cache database to be found in iOS development was SQLite, which was also used as the backbone in the future. In the past, SQLite was not used to