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

Perfect distributed transaction support for MySQL 5.7 Two Phase Commit Protocol Distributed transactions generally adopt the 2 PC Protocol, which is the full name of Two Phase Commitment Protocol. This Protocol is mainly used to solve the problem of

MySQL Tutorial: Build a MySQL Cluster in Linux Install fuse for mysql-cluster-gpl-7.4.6-linux-glibc2.5-i686.tar.gz (http://pan.baidu.com/s/1c1bjxVa) The system is a Linux virtual machine. 2 virtual machines (ensure that the firewall is disabled,

Use Linux commands to filter out the complete SQL statements in binlog DB: MySQL 5.6.16CentOS: CentOS release 6.3 (Final) How to extract the complete insert statement when an insert statement is input across rows using spaces! Create an empty

Install Redis in Ubuntu 14.04 Let's talk about the simple process of installing Redis in Ubuntu 14.04. 1 go to the redis official website to download the latest stable version: http://redis.io/-> Redis 2.8.19 is the latest stable version. (or use

Common Oracle and SDE maintenance commands-view tablespaces Previously, I reported a data update problem on the site. I thought it was caused by the full table space (the error was written in the previous blog article). Therefore, I remotely checked

Saving Oracle learning database data as files It is often necessary to generate documents from data in Oracle databases. Because you prefer the script method, you need to set the format when using spool, the following is a simple example of how to

MySQL 5.6 parameter extra_port PrefaceAs a MySQL DBA, the Too connector connections error is often encountered during the O & M of MySQL. At this time, it is embarrassing that database maintenance personnel cannot log on to the database for

Redis Design and Implementation Study NotesPreface This book focuses on the implementation of the underlying Redis layer, which is divided into four parts: Data Structure and Object Standalone Database implementation Implementation of

Common Oracle users use the show parameter Method In Oracle, only sys users can use show parameter to view parameter settings. If you want common users, you can also use show parameter, the SELECT permission must be granted to common users in the V _

Fast paging using ROW_NUMBER The method of listing by page in Linq uses Skip () and Take (). However, how do I write paging using SQL scripts? First, we can sort by ROW_NUMBER () OVER and get a view with serial numbers. Then, we can use the

Solution to Oracle11g CRS-0184 [Grid @ rac3 cssd] $ crs_stat-tCRS-0184: Cannot communicate with the CRS daemon. [Grid @ rac3 cssd] $ crsctl check hasCRS-4638: Oracle High Availability Services is online[Grid @ rac3 cssd] $ crsctl check crsCRS-4638:

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:

Comparison of several MySQL environment problems Sometimes there are environmental problems. comparison is a good method. If the comparison is proper, you can avoid repeated problems. You can infer some possible situations or problems based on the

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------------------------------------

When TOAD is connected to DB2, SQL1460N is reported. Tests should be performed between different versions of DB2 over the past few days. DB2 V9.7.4 64bit has been installed before, DB2 V9.7.6 has been installed after the test is uninstalled, the

How to enable MySQL database remote connection Sometimes it is not possible to remotely connect to the MySQL database. You can refer to the following method to solve the problem. 1. log on to the MySQL database of your machine: mysql-uroot-p

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

Oracle 11g system-level trigger to track drop misoperations Preface:The data in a table in the db is always disordered. I guess I 've experienced data synchronization operations such as drop and create, but no one knows where to operate it now,

YII2 database query practices and YII2 database practices This article explores the yii2 framework and provides simple practices for adding, deleting, modifying, and querying, and associated queries and other basic database operations. Database