Database Administrator

DB2 cross-Database Access Table Today, let's talk about how DB2 implements cross-database access to tables? It took a long time for me to test successfully, so I decided to share with you! Okay, you don't have to talk about it anymore! Let's get

High Availability of MySQL: Keepalived + MySQL (dual-master hot standby) Environment Description:OS: CentOS6.5 _ X64MASTER: 192.168.0.202BACKUP: 192.168.0.203VIP: 192.168.0.204 1. Configure two Mysql master-master Synchronization[Root @ master ~] #

Use RMAN for data migration Use RMAN for data migration 1. view the SCN and back up the database. Run {Allocate channel c1 type disk;Allocate channel c2 type disk;Allocate channel c3 type disk;Allocate channel c4 type disk;Allocate channel c5 type

B + tree indexes and tree indexes In the database, the height of the B + tree is generally 2 ~ Layer 3, that is, for the row record of a key value, it only needs 2 to 3 times of IO at most. The InnoDB Storage engine table is an index organization

Implementation of WEBSERVICE and ebsdbws through DBWS package in Oracle EBS interface developmentIntroduction In the 9i era, Oracle released an extended package to support PL/SQL access to Web Services. In Oracle 10 Gb, this feature became more

MySQL and MsSQL real-time automatic data synchronization, mysqlmssqlSyncNavigator enables remote database synchronization, resumable data transfer, and heterogeneous data synchronization. Recently, I encountered a problem about how to share, export,

Data cleansing Note: determines whether it is a date function or a note date Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the right to

Shell regularly creates Hive table partitions and shellhive partitions First, let's take a look at the hive help command: [hdfs@xxx hive]$ hive -hMissing argument for option: husage: hive -d,--define Variable subsitution to apply to

Import sqlsever and excelsqlsever in excel Now we usually add some data to the database when testing the software. If the amount of required data is small, it is easy to say, but it will be too slow to add multiple entries, in fact, we can download

Web Attack and Defense-SQL injection attacks The root cause of SQL injection attacks is SQL specification vulnerabilities. However, due to the long-term existence and use of the specification, it is almost impossible to modify the specification,

Database review 4-view and database ReviewDatabase review the concept of CH6 view 6.1 ViewIs exported from one or more tables (or views)Virtual table, DBMS onlyData DictionaryWhile the view data is still actually stored in the exportedBase

MySQL programming on linux (2): Basic MySQL syntax operations, linuxmysql [Copyright statement: respect originality. For reprinted content, Please retain the Source: blog.csdn.net/shallnet. this document is only intended for study and exchange

MySQL programming on linux (III): MySQL advanced syntax, linuxmysql[Copyright statement: respect originality. For reprinted content, Please retain the Source: blog.csdn.net/shallnet. this document only provides learning and communication, and does

The OGG process that cannot be seen in the ggsci command prompt, ggsciogg [Oracle @ lei1 ggs] $ ggsciOracle GoldenGate Command Interpreter for OracleVersion 11.1.1.1.2 customized Linux, x64, 64bit (optimized), Oracle 10g on Oct 4 2011 23: 50: 20

Data mining using excel (2) ---- analyze key influencing factors and excel Data Mining   Use excel for data mining (2) ---- analyze key influencing factors   After configuring the environment, you can use excel for data mining. For environment

MongoDB query command details, MongoDB command details 1. query all records Copy the Code as follows: db.userInfo.find(); Equivalent:Select * from userInfo;By default, 20 records are displayed on each page. If no record is displayed, you can use

TPS for mysql computing within the specified time; tps for mysql computing if a friend leaves a message, you must monitor the TPS at AM for the specified time, write a 10-second TPS method. #! /Bin/bashexport black = '\ 033 [0m' export boldblack ='

Dbca, dbca create databaseError message: [oracle@db01 ~]$ dbca -silent -responsefile dbca.rsp Copying database files1% complete2% complete4% complete12% complete100% completeLook at the log file "/DBSoft/oracle/cfgtoollogs/dbca/woo/woo.log" for

About innodb purge thread and master thread, innodbpurge ByInnodb_purge_threads controls the number of purge threads. (> = 5.6.5) The default value is 1 and the maximum value is 32. The default value 1 indicates that the purge operation of innodb

OGG target checkpoint table drop repair method, oggcheckpoint   OGG target checkpoint table drop Repair MethodReference: OGG Replicat Failed Due To Check_point Table beingTruncated (Document ID 1319832.1) 1. First, start repfull reports the