PHP

I. Server 1. Status Monitoring (1) is the server accessible? (2) is the corresponding database service enabled? (3) errors or alarms in Operating System Event Logs (4) Monitoring of server status of available disk space, whether using third-party

I. Requirement Description I have been learning mysql-mmm recently. I think this architecture can be used in our company's business in the future. Our company's business is single-host, multi-instance deployment, therefore, I want to deploy

One afternoon, the development report said that when the DML operation was executed, the database reported an error where the transaction log was full. The specific information is as follows: $ db2deletefromtzsdb01DB21034E this command is processed

Tutorial environment: ORACLE11GR2 and CENTOS6.232 (replace the redhat Yum source with 192.168.233.10 and NAT network). For VM8.0 installation, refer to the official website documentation and some articles to configure parameters as much as possible.

Recently, according to the company's plan, we need to incrementally fetch data from some tables in the previous SQL Server database to the ORACLE database, and decide to use the newly added CDC (Change Data Capture) function in sqlserver2008.

Single-row functions-character functions although each database supports SQL statements, each database also has the operation functions supported by each database. These are single-row functions. If you want to develop a database Single-row

The hash index is implemented based on the hash table. It is only valid for queries of all columns that precisely match the index. For each row of data, the storage engine calculates a hash code for all index columns, calculate the rows with

Directly cut the topic. There is A table in the table: ChenJiID, DanWeiID, Name, and ChenJi. The IDDanWeiIDNameChenJi ---------------------------- the consumer opens two connections in the query analyzer to connect A to begintrant. There is a table

1. log on to the ASM instance and check whether the ASM disk is correct [oracle @ rhel5 ~] $ ExportORACLE_SID + ASM [oracle @ rhel5 ~] $ SqlplusassysdbaSQLselectname, statefromv $ asm_diskgroup; & nbsp .. 1. log on to the ASM instance and check

This article translates MongoDBProductionNotes in MongoDBManuel. This section focuses on considerations that affect performance and reliability in the production environment, This article is to translate the MongoDB Production Notes section in

ORACLE uses the ASM storage. When creating a database, the redundant attribute of the disk group uses EXTERN. To change the disk group to NORMAL, perform the following steps: ORACLE uses the ASM storage. When creating a database, the redundant

One of the daily work of the system administrator is to upgrade the service, add a patch for the service or upgrade some fancy functions. In early 2013, the latest MySQL5.6 was released with the goal of providing more One of the daily work of the

The software cmake is required for mysql version 5.5 and later compilation and installation. The cmake feature is independent from the source code compilation. The compilation can be performed in another directory instead of the source code

In Linux, add the MySQL service to the System Service of the server. 1. Understand the MySQL program path. MySQL data directory: homemysqldataMySQL program Directory: usrlo In Linux, add the MySQL service to the System Service of the server. 1. Find

Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ( Due to production requirements, you need to copy the rmtel user data to rmtel_xzy, but exclude the rmtel user ( Scenario: Due to

Note: This article has been published as a cover report in Article 2013 of Shenyang software in 16th. The year 2013 is called the year of big data by the Chinese IT industry. If you don't talk about big data, it seems that you can't keep up with the

What are the rare problems with installing Oracle11gXE in Configure in Ubuntu? Is Oracle 11g XE installed on Ubuntu a rare problem in Configure? I can only say that it seems that I have solved this Configure problem, but I still want to

MySQL master-slave synchronization build master database: IP: 192.168.18.204 edit etcmy. cnf file open log-binvimetcmy.cnflog-binapplicationmysqld MySQL master-slave synchronization build master database: IP: 192.168.18.204 edit/etc/my. cnf file

1. logon and exit command of RMAN: Method 1: $ rmannocatrman directly enters rman to back up data in non-catalog mode, or do not use nocatalogrman> connect 1. Run the following command to log on and exit RMAN: Method 1: $ rman nocatalog directly

When we have a large number of Redis or Memcached instances, we can only use some data distribution algorithms (such as consistent hashing) on the client side to implement Cluster Storage features. Although When we have a large number of Redis or