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,

Description of InnoDB tablespace, segments, and zones 1. The tablespace is the highest level of the logic structure of the InnoDB Storage engine. All data is stored in the tablespace. By default, the InnoDB Storage engine has only one tablespace

Detailed analysis of high-availability Redis service architecture construction Memory-based Redis should be the most commonly used key-value database in various web development businesses. We often use it to store user login states (Session storage)

How to install Redis using yum in CentOS 1. Because the official CentOS yum source does not contain Redis, We need to install a third-party yum source. Here we use the epel repository of Fedora. Yum install epel-release You will be prompted to

Redis Cluster in Redis Cluster1. Linux System Configuration 1.1. vm. overcommit_memory settings The overcommit_memory file specifies the kernel's memory allocation policy. The value can be 0, 1, or 2. 0 indicates that the kernel will check whether

13 Tuesday course 2018.01.15 mysql user management, common SQL statements, mysql database backup and recovery, 13.4 mysql user management By default, mysql has a root user, but the root directory permission is too high, which is dangerous.

PostgreSQL uses dblink to implement cross-database query. postgresqldblink A recent SQL statement involves joint queries between tables in different databases. At the beginning, I learned how to write SQL statements, but failed to execute them. I

10 things you should know about NoSQL Databases Since the 1/4 century, relational databases (RDBMS) have been the mainstream database models. But now non-relational databases, "Cloud" or "NoSQL" databases, are gaining an increasing share as an

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

MySQL5.6 backup and recovery command, mysql5.6 backup and recoveryBackup Mysqldump-P 3010-h 130.51.2.24-uroot-proot zplatdb> backup. SQL Restore Recover to my local machine, because I have not set a password for this machine, the password is

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

MongoDB query, index and aggregation, MongoDB, and index aggregation Initialize the mongodb Database > Use dengswitched to db deng> db. createCollection ("jingdong") # No parameter {"OK": 1}> show collectionsjingdongsystem. indexes> userdoc1 =

7. oracle learning starter Series 7-network management and configuration, 7. oracle Network Management Chapter 7 of oracle learning starter Series Network Management and Configuration In the previous article, we learned about models and users,

Convert data in Excel into SQL statements and convert data into SQL statementsIf the excel table contains three columns of data: A, B, and C, and you want to import the data to the users table of the database, the corresponding fields are name, sex,

MySql Performance Tuning (5) demonstration of using a proper lock mechanism for table locks, mysql Tuning MySql locks take the following forms: 1. Table-level locks; low overhead, fast locking; no deadlock; large lock granularity, the highest

MySql Performance Tuning (4) Quick table structure modification and mysql Tuning 1. Modify the varchar type To meet your needs, change varchar (6) To varchar (8). A better method is not to use altertable modify, but to use the following

ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES) solution to the problem, 28000 denied ERROR 1045 (28000): Access denied for user 'root' @ 'localhost' (using password: YES) the ERROR code indicates that Access

In Oracle databases, this initialization parameter file is divided into two types: Text parameter files and server parameter files. Their content is the same, but the representation is different. The server parameter files are saved in binary format.

The statement for creating a user with Complete Oracle Database User management and data import and export is as follows: CREATE USER IDENTIFIED BY DEFAULT TABLESPACE TEMPORARY TABLESPACE

OOP concepts in Oracle:Object Type, variable array, nested table, object table, and object view. Object Type: Advantages: 1) it is easier to interact with object applications written in Java and C ++. 2) easy to obtain. An object type request can