Database Administrator

Monty Widenius, the father of MySQL, announced the establishment of an Open Database Alliance with the goal of becoming the industry center of Open source Database MySQL. Monty Widenius said it would join all MySQL-related development and services

1. installation environmentOperating System: Red Hat Linux Enterprise AS 4.0Database: MySQL 6.0.6Web server: Apache 2.2.9Script Language: PHP 5.2.6 2. Install MySQL 6.0.6 # Groupadd mysql# Useradd-g mysql# Tar xzvf mysql-6.0.6-alpha.tar.gz# Cd mysql-

When to use Oracle partitioning:1. Large Data Tables, such as tables larger than 2 GB. On the one hand, a 2 GB file is an upper limit for 32-bit OS, and the backup time is long.2. tables that contain historical data, such as the latest data, are

An earlier version of mysql server has been installed on the Linux server in use. When the rpm package is used for installation, a version conflict is prompted and the installation cannot proceed. The solution is as follows: 1. First, find all the

In the latest project, you need to convert the utf8-encoded MySQL database to utf8 (in the past, gb2312 to utf8) The method is as follows:Step 1:Run:./mysqldump-uroot-p -- default-character-set = utf8 -- extended-insert = false dbname> DBNAME_GB2312

This article describes the simple principle of ODBC and how to install, configure, and program ODBC in Linux/Unix. I. ODBC principles ODBC is the abbreviation of Open Database Connect, which is a unified interface standard proposed by Microsoft in 19

1. Execute the stored procedure in the Oracle database Proc. sh script content (in ibm aix environment) ORACLE_BASE =/oracle; export ORACLE_BASE ORACLE_HOME = $ ORACLE_BASE/product/10.2.0; export ORACLE_HOME ORACLE_SID = commdb; export ORACLE_SID $

1). MySQL installation layout in Ubuntu: /Usr/bin client program and mysql_install_db/Db database and log files (custom)/Var/run mysqld Server/Etc/mysql configuration file my. cnf/Usr/share/mysql Character Set, baseline program and error message/Etc/

Introduction The Flashback database is a point-in-time (PIT) database restoration method. This Incomplete recovery policy can be used to restore a database that is logically damaged due to human errors. After being introduced in 10 Gbit/s, it is

Oracle's set is fragmented. Here we will summarize it. SQL> set timing on; // set to display "time in use: XXXX" SQL> set autotrace on-; // set to allow analysis of executed SQL statements SQL> set trimout on; // Remove trailing spaces in each row

1. Perform all replication operations in the foreground where the Master node is not offline Basic Steps for recall:1. premise: the Master opens the binary log file and sets server-id = 1.2. account required to establish a slave service connection

Objects in sys users cannot be exported. SQL> select owner, segment_name, tablespace_name from dba_segments where tablespacE_name = 'users '; OWNER SEGMENT_NAME TABLESPACE_NAME------------------------------------------------------------SYS

Last Review: introduced the concept and installation of Neo4j, and introduced two tools: Git and Maven. This article describes the Neo4j Spatial project and space data (vector) storage.1. Introduction to Neo4j Spatial 1.1Neo4j Spatial concept The

To connect to the mssql database in Ubuntu, I found SQuirreL SQL Client for a long time. SQuirreL SQL Client Official Website: http://sourceforge.net/projects/squirrel-sql, 00402_2427. SQuirreL SQL Client has the following charm: Based on Java, it

Today in the RAC-DG experiment, encountered a lot of problems, this problem occurs in the operation of the use of pifle to create spifle Most people prefer to directly use alter system set xxx = 'xxx. XXX' scope = spfile When configuring RAC-DG

Creating a table in Oracle focuses on the table field type and corresponding constraints. 1. Create a table statement Create table tname ( Fied1 Type 1, Fied1 type 2, ........ ); Create table tname as subquery -- copy existing tables 2. Field

1. Test preparation1. Back up the master databaseDump database master to '/backup/master. dat' 2 lv_masrter size # Lsvg-l datavgDatavg:Lv name type LPs PPs PVs LV STATE MOUNT POINTLv_backup jfs2 320 320 1 open/syncd/backupLoglv00 jfs2log 1 1 1

Let's talk about the three Protection modes of DG.Maximum Protection:The maximum protection mode does not allow data loss. All transactions can be committed only after the logs of the master and slave databases are written. If a network exception

Recently, some netizens mentioned the problem of shrinking Oracle data files, which is a common problem frequently encountered by DBAs. Usually we need to shrink the corresponding data files to reduce the pressure on the disk space and improve the

Analysis has become an increasingly important topic in MongoDB because it is used in more and more large projects. People get tired of using different software for analysis (including Hadoop) and apparently need to transmit a large amount of