Database Administrator

Solve the socket error when XtraBackup is backed up When XtraBackup is used for the uat database created by the company today, an error is reported. Sort the solution and make a note: Server

MySQL semi-synchronous Replication MySQL supports semi-synchronous replication as a plug-in starting from MySQL5.5. How can we understand semi-sync? First, let's look at the concept of Asynchronization and full synchronization. Asynchronous

ORA-00054: resource busy and acquire with NOWAIT specified ORA-00054: resource busy and acquire with NOWAIT specifiedIf you do not use NOWAIT or other items, the default value is to WAIT (WAIT) for other transactions to commit before returning

Eight years of experience using NoSQL Mike Bowers, an Enterprise Data architect at Jesus Christ's late Saints Church (LDS), introduced eight years of experience using NoSQL databases at the recent Enterprise Data World Conference (EDW. He talked

Redis High Availability Redis Sentinel1. Redis master-slave configuration 1.1. Set master-slave Replication Master 10.24.6.5: 6379    1.2. Cancel master-slave Replication    1.3. Delete all data Flushdb: Delete the database.Flushall: delete all  2.

Differences between translate and replace Today, the nesting of replace and translate in the Oracle database is a bit confused, so I went online and looked at it, and it suddenly became clear: The problems encountered today are as follows: Replace

Problems caused by table sys. dual being cleared A few days ago, I received a report from the application staff saying that the application could not connect to the database and reported the ORA error. This is an Oracle 9.2.0.8 RAC database (it has

Install MySQL + Security optimization with apt-get on Ubuntu 0. Description The advantage of using apt-get for installation is that you don't have to solve the dependency problem between software by yourself. Basically, after apt is executed, the

Install MySQL on Redhat Linux On Linux, Mysql usually has three installation methods:Rpm InstallationGeneral Binary Package InstallationSource code installation packageThis article first introduces the RPM installation method. Here we will mainly

Install MySQL 5.7.9 through source code compilation Install CentOS 6.3Configure yum:[Root @ bkjia ~] # Cd/etc/yum. repos. d/[Root @ bkjia yum. repos. d] # mkdir[Root @ bkjia yum. repos. d] # lsA CentOS-Base.repo CentOS-Debuginfo.repo

Solution to MongoDB connection failure exceeding 1000 on CentOS6 Problem description: When the production environment finds that the CPU is running at full capacity, the number of connections to MongoDB cannot exceed 1000. Solution: 1. Check mongodb

Description of PostgreSQL lock query and killing Process Query the locks in the table. Select a. locktype, a. database, a. pid, a. mode, a. relation, B. relname From pg_locks Join pg_class B on a. relation = B. oid Where upper (B. relname) = 'table _

Oracle 12c In-Memory Oracle introduced the In-Memory and columnar compression option In 12c, which greatly improves query performance. Here, we can see how much performance can be improved in the same query through a comparison. 1. allocate Memory

Oracle 12c In-Memory in Tablespaces As mentioned In the previous article, you can enable In-Memory at the table level. In fact, you can also enable Tablespaces at Tablespaces level, in-Memory is also enabled for all tables stored In Tablespaces. Let'

Detailed description of redis self-starting configuration and redis STARTUP configuration I. Overview 1.1 Principles How does redis auto-start work? After the Linux system is started, a program will scan files under a specific directory and execute

Comparison between MySQL and Oracle: Function 3: mysqloracle Function No. Category ORACLE MYSQL Note 1 Numeric Functions Round (1.23456, 4) Round (1.23456, 4) Same:ORACLE: select round (1.23456

Yesterday, I shared two articles on the cursor: A Case Study on the Performance of the cursor script, and a case study on the performance of the cursor script, the cursor is briefly described in the article. Today, I found a blog article about

However, for those who have been using MySQL for a long time and are familiar with the MySQL ecosystem, changing MySQL is not so urgent. After all, it is not until the end of the day. However, it is time to come. Before Gentoo portage, the MySQL 5.5

This article describes the basic configuration and installation of Mirror for SQL Server 2008. Preparations 1. The Principal, Mirror, and Witness instances are installed in the same version. Currently, they are in SQL Server 2008 SP1. 2. you need to

A "virtual" server composed of two or more physical independent servers is called a cluster server. A MicroSoft service called MicroSoft cluster service (MSC) manages cluster servers. An SQL Server cluster is a virtual Server composed of two or more