Database Administrator

CentOS7 compilation and installation MySQL 5.6.28 and compilation Parameters The source code package version after MySQL 5.5 is compiled and installed using the CMake tool. Therefore, you must install the latest version of MySQL in advance. CMake is

How to adjust GI configuration after renaming a private Nic in Oracle 11gR2 RAC Environment Environment Description: AIX + 11gR2 RAC dual-nodeCause: the two NICs used for private network communication use a gigabit Nic. Now, they need to be replaced

MyCAT global serial number When database/table sharding is implemented, the auto-increment primary key of the database cannot be globally unique. Therefore, MyCat provides global sequence and multiple implementation methods including local

Install Redis in LinuxPrepare to install and run the command: tar zxvf redis-3.0.4.tar.gzEnter the decompressed Folder: cd redis-3.0.4Compile source code: makeIf the following error occurs: [root@localhost redis-3.0.4]# makecd src && make allmake[1]

Use BBED for Oracle 11g Compilation Environment: RHEL 6.4 + Oracle 11.2.0.4 1. Copy the missing file 2. Compile BBED 3. BBED Test Reference 1. Copy the missing file Several related files are missing in 11g, but we can actually copy the related

Oracle 11G R2 uses RMAN to build the DataGuard Environment Environment: Role Machine name Operating System IP Remarks Master Database Db1 CentOS 5.11 x86_64 192.168.2.241 Install Oracle and create a database

MySQL · performance optimization · 5.7.6 InnoDB page flush Optimization In this article, we have introduced in detail the latest Optimization of InnoDB page flush by Oracle MySQL and Community branches. Further improvements have been made in the

MySQL string truncation Functions In work, some fields may need to form a string by a separator as the field value to access the database table. For example, a task pair should store three results in different data tables, in this case, the primary

Oracle Database Resource Management1. Understand Resource Manager terminology Three basic structures of Resource Manager: Resource user group, Resource plan (and auxiliary plan), and Resource plan wizard. The database resource manager can help you

MySQL new features-mysql_config_editor source code analysis Mysql has launched the encryption tool mysql_config_editor since mysql5.6. Previously, we put the account and password in plain text into my. cnf, so that you can log on to the database

SQLite3 simple operationDirectory 1. Create Database Files 2. operate in the sqlite3 prompt Column 3. SQL command format 4. Create a data table 5. Create an index 6. Add a document 7. query data 8. How to change or delete Materials 9 other

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

HBase table data Paging HBase is a key technology in the Hadoop Big Data ecosystem technology circle. It is a columnar database for Distributed Storage of big data. For more details about HBase, friends can search on the Internet, and I will write a

ORA-00600 error caused by cursor_sharing HOST: IBM S85Main hardware: 6 CPU + 8 GB memorySystem: AIX5.2Patch: ML04Database: Oracle 9.2.0.4Middleware: BEA Tuxedo 8.1The system is a new oltp-type financial system. The performance stress test performed

Compile and install PostgreSQL9.4.1 and phpPgAdmin in CentOS 6.6   Preparations before installation # Yum install readline-devel zlib-devel Download, decompress, compile, and install the source code # Wget https://ftp.postgresql.org/pub/source/v9.4.1

Precautions and troubleshooting for connecting a single Oracle 11.2 instance to ASM Notes for accessing ASM from an Oracle 11.2 instance: 1. Oracle users and grid users must have the same group, and the ASM Disk group must be consistent with this

MySQL configuration file my. cnf added log parameter file Error MySQL configuration file my. cnf added log parameter file Error Add a line after [mysqld]Log =/tmp/mysql. logThen restart mysql,Shell> service mysql restartThen an error is

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

Enable MySQL 5.6 to support Emoji expressions Let MySQL support Emoji expressions. We recommend that you use the utf8mb4 character set in advance for MySQL databases involving wireless connections. MySQL 5.6 1 solution: Convert Mysql encoding from

Basic concepts of databases: mandatory for interviews, and basic concepts of databases Today, I will share with you the basic concepts related to database collection, which will be very helpful for your future work. 1. superkeys, candidate keys,