Database Administrator

Installation and configuration of Percona XtraDB Cluster Percona XtraDB Cluster is a high availability and scalability solution for MySQL users based on Percona Server. It includes the Write Set REPlication patch and uses the Galera 2.0 library,

Conversion of RR isolation level to RC isolation level in MySQL First understand the difference between RR (REPEATABLE-READ) and RC (READ-COMMITTED. The RR isolation level adds a gap lock, which avoids Phantom reads and prevents repeated reads, so

Modify Oracle RAC Database Name Briefly record some methods for modifying the name of Oracle RAC. 1. Close an instance [Oracle @ rac11g2 ~] $ Sqlplus/as sysdba SQL> shutdown immediate; 2. Back up the spfile File SQL> create pfile =

Principles and experiments of Oracle foreign key index creation In the project, we require that all tables with a primary-child relationship use foreign key constraints to ensure the correct relationship between the primary and child tables. We do

ORA-28000 the account is locked error Simulation The error message is as follows:OCI-Call Error SQL code 28000, the account is lockedSQL>! Oerr ora 28000.28000,000 00, "the account is locked"// * Cause: The user has entered wrong password

Use Toad for remote Oracle 12C data connection 1. Install Oracle12c on the local machine. If you want to install a database on the local machine, select to install data. If you only need to connect remotely, skip this step without installing a

Postgres-X2 deployment steps Sort 2015 elephant will, everyone is very concerned about PostgreSQL cluster, at present, developers have turned to Postgres-X2, recently according to their own and colleagues deploy xl process to deploy a Postgres-X2.

MySQL and MariaDB traditional master-slave cluster configuration The most basic cluster mode for MySQL and MariaDB is the master-slave mode, which is also the most widely used cluster mode for many small and medium-sized enterprises. This cluster is

SpringBoot unofficial tutorials | Article 4: Integrating JPA and springbootjpa in SpringBoot Reprinted please indicate the source:Http://blog.csdn.net/forezp/article/details/70545038This article is from Fang zhipeng's blog JPA stands for Java

Toad for oracle garbled characters in Chinese, toadoracle Toad for oracle garbled characters in Chinese Chinese characters are displayed normally when data is stored in the database, and garbled characters are displayed on the toad for oracle

Create users and permission settings in Oracle, create permissions in oracleOracle user creation and permission settings Permission: Create session Create table Unlimited tablespace Connect Resource Dba Example: # Sqlplus/nolog SQL> conn/as

SQL Server complex SQL logic implementation, SQL Server SQL Logic I. Problems For example, if you already have data in tables a and B, how can you convert it to Table c through SQL statements? Table a is a table that has the same UserName and

In oracle, what happens when a value in date time format is inserted into a field in varchar2 format ?, Oraclevarchar2   -- Create Table test1 Create table TEST1(ID VARCHAR2 (40) default sys_guid (),TDATE VARCHAR2 (200))Tablespace APP_TX_DATAPctfree

MySQL (7) ----------- MySQL thread pool summary (1), mysql Thread Pool Thread pool is a core function of Mysql5.6. For server applications, high concurrency requests are always a topic that cannot be bypassed, whether it is web Application Service

Database review 7 -- recovery, database review 7Database review CH14 recovery 13.1 recovery concept Database SystemRestoreIt refers to the behavior that restores the database from an inconsistent state after a certain "failure" to a normal

In fact, for non-professional database operators, such as software developers, some of the basic knowledge about database indexing are largely unknown, or do not know why. I think the main cause of this situation is the industry. Many companies have

Yesterday, someone asked the QQ group how to design the database structure in an infinitely layered tree structure with a large data volume of more than 10 thousand records. In fact, this is a common issue. The general practice is to have a pid

I have briefly introduced how to emulate Java in SQL? The implementation scheme that replaces the parameter location, in programming and development, we will implement some strange simple and complex ideas with our own programming concepts, every

OpenStack Trove will change the database management mode from five aspects (1) As a database-as-a-service framework for OpenStack, Trove lays the foundation for automated configuration and management of several major SQL databases and NoSQL

This article is from DBAnotes. Original article title: DRBD and Pacemaker If someone asks you if a PC server can reach 99.99% high availability, what should you do? Maybe no machine can "Make sure" to achieve this availability. Of course, there may