Database Administrator

MySQL master/dual Server Load balancer MySQL dual-host master architecture, coupled with Load Balancing Devices, can achieve high performance and high availability of mysql database load balancing, the server Load balancer device can divide the load

Verification checkpoint SCN during Oracle Database startup SCN (System Change Number) is an important mechanism for Oracle databases. SCN is used when the database is started, read consistency, data recovery, and FLASHBACK operations. 1. the SCN

Oracle enhanced date functions -- Change the database time zone to UTC + 8 Alter database set TIME_ZONE = '+ 08:00 '; /* An error may occur during the modification: ORA-30079: the database time zone cannot be changed when the database has a

Enable MySQL remote connection in Linux How to enable MySQL remote connection in Linux. By default, the root user of MySQL can only access MySQL locally and cannot remotely connect to and manage MySQL databases. How can I enable MySQL remote

The 0RA-01400 error is reported when the materialized view is refreshed. Background: materialized view is one of the three major tools for data warehouse refresh. In actual work, it is used for data extraction on heterogeneous platforms. Today,

Problems encountered during upgrading MySQL 5.1.61 to 5.6.19 in CentOS 6.3 and Their Solutions Environment: MySQL 5.1.61 Operating System: CentOS 6.3 Objective: To upgrade to MySQL 5.6.19 First, yum is not feasible. because the yum source is not

Install MySQL 5.6 using the source code in Linux MySQL is an open-source database, so it can be installed based on the source code. Source code-based installation provides more flexibility. That is to say, we can select a suitable compiler for our

Oracle 11g flash back archiving Technology Oracle flash back Data Archiving Oracle flash back data archiving can be used to automatically track and archive data in tables with flash back data archiving enabled. This ensures that the flashback query

How to Diagnose Oracle Data Pump-How to add diagnostic information to the Data Pump, diagnosepump- There are still many bugs in the 11g Data Pump (expdp/impdp), and we often encounter inexplicable card death, which makes people feel overwhelmed. I

In MSSQL, with as and timeline are used to calculate the details and total number of news releases. With cr as (SELECT AddTime, [edit name 1], [edit name 2], [edit name 3] FROM (SELECT NewsID, AddTime, AuditingUser FROM News) AS a distinct (COUNT (.

Install and start mongodb in linux.1. decompress the downloaded package to the directoryLamp @ QA-clg server $ tar-zxvf mongodb. tgzAfter installation, check:[Lamp @ QA-clg Co., mongodb-linux-x86_64-2.4.6] $ cd bin[Lamp @ QA-clg bin] $ lsBsondump

The fastest migration of mysql Data Tables. The storage engines of mysql are myisam and mysqlmyisam. Link: http://blog.csdn.net/u010670689/article/details/41346689 Requirements: During product development, there is a project branch, and the

UNION and union all operators, unionall OperatorsUNION operator The UNION operator is used to merge the result sets of two or more SELECT statements. Note: 1. SELECT statements within UNION must have the same number of Columns 2. Columns must also

Mysql RAND () casually query record efficiency issues and solutions to share, mysqlrand Efficiency has always been a problem during our development, especially for a lot of large data operations. Today we have a random query of data, at the

Java operation MySQL database access images and other types of files, other types of mysql1. Notes 1. When the database field isBlobType, must usePreparedStatementInSetBinaryStream (int, InputStream, int)Method;2. When the database field

About mysql stored procedure creation dynamic table name and parameter processing, mysql Stored ProcedureReprinted please indicate the source: curtain roll west wind column (http://blog.csdn.net/ljxfblog) Recently, the game started its second

Oracle _ controls user permissions, oracle controls User PermissionsZookeeper Oracle _ control User Permissions ① PermissionDatabase Security:System SecurityData securitySystem permissions: Database PermissionsObject permission: permission to

WAS7 adds the "Login Password Authentication" method, was7 Login Password Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held

Centos6.5 installation Oracle11gR2 (64-bit), centos6.5 installation tutorialCentos6.5 install Oracle11gR2 (64-bit) and centos6.5 (My virtual machine environment) 1. Download The centos6.5 installation package. For example: 2. Download the oracle

Network problems occurred during rac_grid self-check. rac_grid self-check Network Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be