Database Administrator

Sort out common MongoDB operation commands Mongodb operation commands (note that all commands starting with "db." Must be used to access the specified database before the operation)Connect to the database:/Usr/local/mongodb-3.0.4/bin/mongo 192.168.6.

Oracle 11g elastic uard automatic start service Oracle 11g elastic uard automatic start service Only for better performanceJust to do better Script name: oracledg #! /Bin/bash# Chkconfig: 2345 98 01# Description: Oracle database migration uard

Oracle partition table data migration and Management Automation Process The following process is centered on the company's Oracle Database runtime environment. It is mainly written to achieve automation.Process completion tasks include1.

MySQL-Proxy implements MySQL read/write splitting to improve concurrent Load Working topology:110018378. jpgA powerful function of MySQL Proxy is to implement "read/write splitting". The basic principle is to let the primary database handle write

View the version of the remote Redis Server How can I view the version of a remote Redis server? What should I do if I have no SSH access permission for the remote Redis server and want to know which version of the Redis server is used? It's easy to

Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: oraclememorytarget Note the following when increasing memory_max_target and memory_target in oracle db 11g in linux: [oracle@hosta ~]$ sqlplus / as

SqlServer obtains the latest full backup time of the database, and sqlserver obtains In application scenarios, SqlServer Incremental backup is performed on the basis of full backup. If you need to recover, you also need to restore the full backup

New Feature of oracle12c-Pluggable Database (PDB) and oracle12cpluggable 1. Advantages of new features of 12c PDB 1) Multiple PDBs can be integrated into one platform. 2) A new PDB or an existing PDB clone can be provided quickly. 3) through the

Insert child table fields in Birt dynamically, and insert fields in birt dynamically The database table dColThread is the primary table and the primary key is tID. DColQuestion is a sub-table and the foreign key is tID, as

HBase learning Summary (3): HBase data model and working mechanism, hbase Model I. HBase Data Model The logical entities in HBase mode include:(1)Table): HBase uses tables to organize data. The table name is a String consisting of characters that

SQL learning uses order by to sort by specified order or custom order, sqlorder We usually need to provide the customer with a custom sorting method for the query results based on the customer's needs. What are the implementation methods of SQL, the

Mysql dual-machine Hot Standby Master/Slave configuration, mysql dual-machine Hot Standby Master/Slave ConfigurationReplication on mysql:Master/Slave.Master server is the production MySQL instance.Slave server is the java host (123.57.39 .*).First

Modify the logon authentication method in oracle and perform oracle logon authentication. By configuring the sqlnet. ora file, we can modify the oracle login authentication method.SQLNET. AUTHENTICATION_SERVICES = (CNT); operating system-based

For more information, see .   -------------- Note: The following operations are performed in rhel vnc, not in secureCRT. -------------------------- Cause: If it is executed in secureCRT, m Lu will be shown as: m Lu. See the following. Why? I

MySQL Optimization-query and mysql Optimization Reprinted please indicate the source: http://blog.csdn.net/l1028386804/article/details/46580589 Basic select syntax in MySQL Select attribute list from Table Name and View list [where condition

New Features of 11g rman blockrecover, rmanblockrecover Reference:New Rman Blockrecover command in 11g (Recover upload uption list) (Document ID 1390759.1) New Features of 11g rman blockrecover:Note: The blockrecover command for 10 Gb is discarded,

. Net connection to oracle Database --- Shinepans, oracle --- shinepansFAQ: 1. the reference solution is missing. Add reference: using System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using

Mysql transactions, concurrency issues, lock mechanisms, mysql transactions1. What is a transaction? A transaction is a combination of one or more database operation statements. It has four features: ACID. Atomicity Isolation: transactions are

Redis memory management code comment, redis memory management comment Zmalloc. h /* Zmalloc-total amount of allocated memory aware version of malloc () ** Copyright (c) 2009-2010, Salvatore Sanfilippo * All rights reserved. ** Redistribution and

Oracle single row function, oracle Single-row function syntax Function_name (column | expression, [arg1, arg2,...]) Parameter description: Function_name function name Column name Expression Arg1, arg2,... Parameters Single Row function category: