Database Administrator

MySQL read/write Splitting Based on Amoeba in CentOS Note: This configuration is based on CentOS 6.4_x86. Both MySQL servers are source code compiled (version 5.6.24), And amoeba proxy is version 2.2.0. Server Use Ip

Auto-start Oracle 11gR2 in Linux Oracle in Linux is running after installation. After the machine is restarted, Oracle does not add Oracle to the Windows service as in Windows. In linux, You need to manually start the Orcle service. Run the

Install the database Oracle client in Ubuntu 16.04 Install the Oracle database client in Ubuntu 16.04 to connect the Django project to a remote Oracle database. 1. Download the oracle client installation package: Go to

MongoDB knowledge point notes MongoDB knowledge point notes 1. How to read data from the backup Node The default value is not allowed. The following error is reported: testReplSet:SECONDARY> show dbs2016-07-19T10:25:03.196+0800 E QUERY [thread1]

New Features of Oracle 12C-Extended Data Types New Feature of Oracle 12C-extended data types. In 12c, compared with earlier versions, data types such as VARCHAR2, NAVARCHAR2, and RAW are extended from 4 K and 2 K bytes to 32 K bytes. As long as

Principle and Practice of MySQL master-slave Replication MySQL master-slave ReplicationMySQL master-slave replication copies the SQL command set originally created and modified databases to the slave database, and re-executes these SQL commands

Oracle cold Backup Recovery Process memoI. Fault approaching At noon one day, the mains supply was accidentally interrupted, and the UPS Power Supply in the IDC did not take over the power supply due to heavy load. All servers were restarted

Reading the return values of Oracle functions using Python Create a function in Oracle to return an index table. When we thought that the text could also transmit information, we suddenly came to the inspiration and set the return value to the text

Install MySQL in Ubuntu and perform simple operations Installing MySQL on Ubuntu is very simple and requires only a few commands. 1. sudo apt-get install mysql-server 2. apt-get isntall mysql-client 3. sudo apt-get install libmysqlclient-dev During

MySQL accidentally deletes the InnoDB data file for restoration Error reproduction:Use rm-f ib * to delete data files and redo log files. At this time, the mysql process still exists and mysql can still be used normally. File recovery:1: Find the

Redis non-Relational Database Service (Nosql) Introduction: Redis is an open-source, high-performance key-value system that can be used to cache or store data.Redis data can be persistent and supports multiple data types: string, list, hash, set,

Preparations before Datapump data migration (2) I wrote an article to analyze some preparations for Datapump data migration, and the response was good. In a recent scenario, it is better to use Datapump based on evaluation. The main reasons are as

Use udev for ASM in Oracle Linux6.7 1. RequirementsOracle Linux6.7 uses udev as asm/Dev/sdb /dev/asm-diskb/Dev/sdc /dev/asm-diskc/Dev/sdd /dev/asm-diskd/Dev/sde /dev/asm-diske/Dev/sdf /dev/asm-diskf 2. FaultIn Oracle Linux 6.7 under vmware vshpere5.1

Three methods of MySQL backup The main function of MySQL backup is to quickly, efficiently and securely solve problems in the case of hardware faults, software faults, natural disasters, hacker attacks, and human error, so as to avoid unnecessary

MySQL reports Row size too large 65535 reason and Solution MySQL error message: Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535 When a field type of MySQL table plug-in is text or a field type of text

Deploy Redis3 in CentOS7 CentOS7 Redis3 Study Notes 1 Official Redis Website:Http://www.redis.io/ 2 Redis:Http://download.redis.io/releases/redis-3.0.7.tar.gzHere we download the redis-3.0.7.tar.gz 3 Redis introduction:Redis is an open source (BSD

Oracle RAC system memory cannot be released Solution The environment is a real-time production database host on the current network. Hp-ux 11.31 + Oracle 10.2.0.4.0 RAC cluster.Two machines: RAC and essdb3 and essdb4.Physical memory 128 GB, SGA 64

Oracle archiving logs Archive Log is a non-active backup of redo logs. archive logs can be used to keep all redo history records. When the database is in ARCHIVELOG mode and the log is switched, the background process ARCH will save the redo log

Fast Switchover in Data Guard, some suggestions for Failover In fact, Failover and Switchover are both a headache and a key process for everyone to deal with disasters. Assume that you are sleeping in the middle of the night, and you are awakened by

Installing Oracle 11gR2 in RHEL 6.5 Record the process of installing Oracle 11gR2 in RHEL 6.5, and hope to help you. 1. Disable selinux and use vi/etc/selinux/config Selinux = disabled 2. Use yum to install rpm Yum-y install compat-db compat-db42