Database Administrator

MHA installation and equivalence Configuration MHA consists of MHA nodes (which can be understood as subnodes) and MHA management nodes. Therefore, MHA installation is divided into two parts: Install MHA nodes and install MHA management nodes. This

Comparison and learning between MySQL and Oracle The storage engine in MySQL is very rich, commonly used include InnoDB, MyISAM, and so on. I also read a lot of information and have some knowledge about it, from some reference books, I can see that

MHA configuration file sample description Similar to most Linux applications, the correct use of MHA depends on a reasonable configuration file. MHA configuration file and mysql my. the cnf file configuration is similar. The configuration file is

MySQL simplifies INSERT and UPDATE through stored procedures MySQL simplifies INSERT and UPDATE through stored procedures Processing purpose: Execute UPDATE when the target record exists in the data table. When the target record does not exist in

How does a function return a result set in Oracle? In Oracle, function return result sets are sometimes used. The following is a demo: Create or replace type t_test as object(Id integer,Create_time date,Object_name varchar2 (60));Create or replace

Basic Principles of Oracle Indexing I. Basic indexing conceptsOracle provides two methods: Read all rows from the table (full table scan), or read a row at a time using ROWID. If you only access 5% of rows in the big data table and use indexes to

Deep Learning about Memcached and memcached Because Memcached distributed cache is used in a project in the lab, I have also learned about the distributed cache in depth during this time. This article will summarize my achievements and let's talk

The best way to obtain data from one table that is not in another table (Study on the Efficiency of JOIN and EXISTS) is as follows:Business Requirements: The company has a CRM broker management system. The most difficult problem encountered the day

(10) mysql variables and 10 mysql Variables Define Variables Syntax: declare var_name[,...] type [default value]; MYSQL variable definitions can only be defined in stored procedures or functions, unlike Oracle/SQL Server. This variable can only be

Loadrunner connects to the SQL database, obtains the verification code script, and loadrunnersql 1. Script protocol:Select web service 2. Script: Action (){ Int NumRows = 0;   // Establish a connection Lr_db_connect ("StepName =

Add the command to supplement logs for all columns of a table, table log command GGSCI (gg321) 47> exit [oracle @ gg321 ggs] $ sqlplus/as sysdbaSQL * Plus: Release 10.2.0.4.0-Production on Sun Apr 19 14:50:10 2015 Copyright (c) 1982,200 7, Oracle.

MYSQL binary installation + XFS, mysqlxfs1. Prepare partitionsYum install xfsprogs[Root @ ycdatadbsupport yum. repos. d] # mkfs. xfs-f-I attr = 2-l lazy-count = 1, sectsize = 4096-B size = 4096-d sectsize = 4096-L data/dev/sdbMeta-data =/dev/sdb

The difference between the database trigger deleted and inserted data: deletedinserted Differences between deleted and inserted dataInsertedStore data after insert and update operationsDeletedStore data before the delete and update operationsNote:

05-SQLite order by sorts result sets, 05-sqliteorderI. Overview of order by statements The order by statement is used to sort the result set based on the specified column. By default, the order by statement sorts records in ascending order.

HBase1.0.0 source code analysis-request processing process analysis using the Put operation as an example (1), hbase1.0.0putThe following code shows a simple code instance for HBase Put operations. The Connection connection = ConnectionFactory in

LeetCode Department Highest Salary, leetcodehighest TheEmployeeTable holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id. +----+-------+--------+--------------+| Id | Name | Salary |

Explanation of the OGG stats command and the oggstats command GGSCI (gg321) 19> stats extqdSending STATS request to extract extqd... start of Statistics at 17:53:06. output to/u02/ggs/dirdat/qd: Extracting from usera. taba to usea. taba: *** Total

Ubuntu PostgreSQL User Guide, ubuntupostgresqlInstall sudo apt-get install postgresql postgresql-contribapt-cache search postgresServer Settings After installation, you must first change the postgres user password and first enter the postgres

Further discussion on who is in front of the two index columns in the composite index -- Practice, index -- Further discussion on who is in front of the two index columns in the composite index -- Practice: The last time I talked about this example

Use yum in centos to install mysql and centosyum to install mysqlReference Article address: http://www.cnblogs.com/xiaoluo501395377/archive/2013/04/07/3003278.html Speaking of databases, we mostly think of relational databases, such as mysql, oracle,