Database Administrator

Redis master-slave replication network transient disconnection Record several interesting usage first1. Repeated executionThe-r option repeats the number of times specified by a command.-I: Set the interval between command execution.For example, you

Two ways to export a table (DMP file) from Oracle Oracle exports tables (DMP files) in two ways: Method 1: export using PL/SQL Developer:Menu Bar ----> Tools ----> Export Tables, for example, you can set relevant parameters: Method 2: Use the cmd

Install Oracle 7.1 configurations on AIX 11.2 1. Operating System Installation1. Start the instance and place it on the system disc.2. Select 1.SMS Menu-> 5. Select Boot Options-> 2. Select Boot Devices-> 3.CD/ DVD3. Select F1 enter system console4.

MySQL High Availability DRBD + Heartbeat + MySQL1. Architecture Mysql: Master 10.24.6.4: 3306 VIP: 10.24.6.20 The VIP and mysql must be in the same network segment; otherwise, the ping fails.2. References 3. DRBD shared memory settings Shared Hard

Navicat Premium common functions Navicat Premium common functions 1. Shortcut Keys1.1. F8 quickly returns to the current Object List 1.2. Press Ctrl + q to open the query interface 1.3. Ctrl + d quickly modify the current table structure 1.4. Ctrl +

Migrate MySQL database data to SQL Server Recently, due to work requirements, it is relatively simple to migrate a mysql database to sqlserver, which is only a data migration task. For mysql migration to sqlserver, we need to use the mysql odbc

Install the stress testing tool swingbench in Linux Many people may have a irrational idea about graphic tools. They feel that as long as a graphic interface is used, the technical content is lost, and the graphics can be a little bit of something,

Create a stored procedure instance in MySQL The MySQL stored procedure is a new feature added since MySQL 5.0. The advantages of stored procedures are as follows. However, the most important thing is the execution efficiency and SQL code

Verify MyCAT ER sharding Here, we have constructed two tables. All the children's shoes familiar with Oracle know that dept (Department table) and emp (employee table), where deptno in dept is the foreign key of dept_no In the emp table. The

Build an Oracle10g Database Based on LVM bare devices on Oracle Linux 5.11 Software: VMware11 Operating System: Oracle Linux 5.11x64Database: Oracle 10.2.0.5 x64Host Name: odb. test. localIP Address: 192.168.223.100 # the VM host network is

Use SQL statements to repair SQL Server databases When using the SQL Server database, some small errors may occur in the database due to power failure or other reasons, such as the slow retrieval of some tables and the failure to query Qualified

SQL Server automatic backup script SQL Server backup script: Third-party backup, and differential backup at other times. declare  @device  varchar (30); declare  @filename  varchar (50); declare  @datetime  varchar (50);

Restoration After Oracle data files are physically deleted This is the case for system management. It is inevitable that files will be deleted by mistake. How can we restore an Oracle data file one day? (The database is OPEN and is not closed)

Install Oracle 11G R2 on CentOS 5.10 Operating System: CentOS 5.10 64-bit Database: Oracle 11G R2 (version 11.02) When installing the operating system, note that the swap partition size cannot be less than 2G 1. synchronize clock and

HBase table data Paging HBase is a key technology in the Hadoop Big Data ecosystem technology circle. It is a columnar database for Distributed Storage of big data. For more details about HBase, friends can search on the Internet, and I will write a

ORA-12154 TNS cannot parse the specified identifier Report on using pl/SQL developer to access a remote Linux database in WinORA-12154 TNS cannot parse the identifier, but SQLPLUS is normal under WinC: \> tnsping lin_hjj TNS Ping Utility for 64-bit

The 11g asm disk cannot be automatically mounted. I started ASM today and found that only one SYS_DG DISK is mounted (used to store OCR and VOTING DISK information). The other two DISK groups DATA_DG and DG_FRA do not mount.Environment: OS = RHEL 6

Install MySQL 6.4 Binary Package in 64-bit CentOS 5.6 I do not like it because I want to install MySQL in Linux and it is very complicated to use the source code package: 1. You need to install the GCC compiler. While I installed linux with minimal

MySQL revokes an authorization Create test tableCreate table t1 (id int );Create table t2 (id int );Create table t3 (id int );Create table t4 (msg varchar (100 )); If the wildcard is used for authorization.Grant select, insert, update, delete on

Oracle multi-Table query optimization Oracle has a high-speed buffer concept. This high-speed buffer is used to store the executed SQL statements. Therefore, oracle has to do a lot of work when executing SQL statements, such as parsing SQL