Database Administrator

MySQL Data TypesMySQL Data Type MySQL supports multiple data types, including numeric, date/time, and string. Numeric data type: It can be integer TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT, FLOAT and DOUBLE, or DECIMAL. DATE/TIME type: Includes

Oracle 10gR2 enables asynchronous IO under RHEL 5 Record the steps for enabling asynchronous IO for Oracle 10gR2 under RHEL 5 Platform: RedHat Enterprise Linux 5 64bit, Oracle 10gR2 10.2.0.4 64bit 1. First install the following necessary rpm

C-Basic redis cache access Introduction Let's talk about redis installation. The environment used here is. Linux version 4.4.0-22-generic (buildd@lgw01-41) (gcc version 5.3.1 20160413 (Ubuntu 5.3.1-14ubuntu2) ) #40-Ubuntu SMP Thu May 12 22:03:46 UTC

Precautions for revoking DBA roles Oracle has very fine-grained permissions. To facilitate the management of numerous permissions, Oracle introduces the role logic concept and also sets many roles in the system. In actual applications, application

Implementation of ASM Resizing in VirtualBox Implement online ASM resizing 1. First disable the Cluster[Root @ node1 bin] #./crsctl stop crs[Root @ node2 bin] #./crsctl stop crs Shutdown, halt Create two vdi disks on the first host, set the sharing,

Oracle Database basics-Installation I. Basic Database knowledge 1. Concept The Database Management System (DBMS) is a technology used in computers to manage, store, and share data. 2. Category Database development can be divided into the following

Solution for Oracle Database User Account being expired The Oracle database account has expired. You must change the password before you can use it again. But sometimes, for various reasons, we do not know what the plain text of the original

Install, configure, and apply MySQL 5.7 in CentOS 7 MySQL 5.7 and earlier versions have some differences. The complete installation, configuration, and application process of MySQL 5.7 in CentOS 7 may be useful for beginners.The installation

MySQL 5.6.x semi-sync replication Configuration EnvironmentMaster Database: CentOS6.5 x64 192.168.0.65 mysql-5.6.29Slave Database: CentOS6.5 x64 192.168.0.66 mysql-5.6.29 Connection: MySQL 5.6 master-slave synchronization configuration case The

Detailed description of Redis info Parameters The official Redis website has clearly explained info. Refer to the documentation. As you can see, the output result of info is several pieces, including Servers, Clients, and Memory. You can specify a

MRP0-Background Media Recovery terminated with error 1111 Due to the improper configuration of db_file_name_convert, the data file cannot be automatically synchronized to the standby database for troubleshooting.Check Master/Slave log

Install and use Redis in Linux What is Redis? Redis is an open-source log-type and Key-Value database written in ansi c language that supports Network, memory-based persistence, and provides APIs in multiple languages. Redis is a key-value storage

12 tips for easy survival in Apache Hive Learn to live with Apache Hive in 12 easy steps Hive allows you to use SQL on Hadoop, but optimizing SQL on a distributed system is different. Here are 12 tips that allow you to easily master Hive. Hive is

MySQL Engine Features-InnoDB redo log roamingPreface InnoDB has two very important logs: undo log and redo log. The former is used to ensure the atomicity of transactions and the MVCC of InnoDB, and the latter is used to ensure transaction

MySQL read/write splitting using MyCAT MyCAT is a database middleware developed based on Alibaba's open-source cobar product. It is jointly developed and open-source by several talented people with lofty ideals. Provides highly available data

Create an Oracle 12c user Oracle 12c accounts can be divided into public accounts and local users. A common account is created under CDB and can be used by all PDB users. A local account can only be created in PDB. Create a public userAlter session

ASM Single Instance CRS-4124, CRS-4000 error handling Install GI. Due to limited notebook resources, you have installed Oracle11g GI so that you can learn ASM. After the installation is complete, everything works normally.However, the following

How to install Redis in Linux Redis will be used in recent projects. We will share our learning experience with you during this period. This is a summary of the learning results during this period and technical refinement. I hope you can criticize

Considerations when enabling full log query in MySQL 5.6 Today, because I want to query the call of an SQL statement, I started the full query log in production and thought that I only need to write it like this in my. cnf: Log =/home/logs/mysql.

Connect SQL plus to Oracle There are three methods for SQLPlus connection. 1. sqlplus/as sysdba Operating system authentication does not require the database server to start listener or the database server to be available. For example, if you