Database Administrator

Percona-toolkit installation and introduction MySQL database is one of the best lightweight and open-source databases. Its features, management, and robustness are quite different from those of Oracle. Therefore, there are many powerful third-party

Use Percona XtraBackup in multiple instances Background Percona XtraBackup is a backup tool developed by Percona. It mainly has two tools: XtraBackup and innobackupex. Innobackupex encapsulates XtraBackup and is a perl script. This document is

Configure the MySQL server for Master-master Replication StatementAuthor: Last Night starsBlog: http://yestreenstars.blog.51cto.com/This article was created by myself. If you need to reprint it, please indicate the source. Thank you for your

Is NoSQL true or not? To NoSQL or not toNoSQL With the emergence of a large amount of data, NoSQL database architecture is being used by more and more people, because NoSQL architecture is more effective in big data processing. Today, when you need

Quickly build a Linux operating system + Oracle database environmentI always wanted to learn about the O & M of Oracle databases in Linux, but the process of installing the Linux operating system from the beginning and then installing the Oracle

Corosync achieves high availability of MariaDB Database Service Solution: Corosync + pacemaker provides HA solutions. Use the shared file system exported by the NFS Shared Server as the data directory; The topology is as follows: Install LAMP

Oracle static listener registration details, oracle details Oracle static listener registration details There are a lot of articles on oracle listening for static registration on the Internet, but most of them are a simple example, there is no

11g new feature _ visible and invisible index, and 11g new feature index visible When you want to evaluate the impact of an index on your SQL query statement, when your database is 11 GB, you can quickly set the index to VISIBLE or INVISIBLE. In

In Atitit. Hibernate, Criteria uses summary and join queries and queries o9o and hibernatecriteria by sub-objects. In Atitit. Hibernate, Criteria uses summary and association query and queries o9o by sub-Object   1. Criteria, Criterion, 13. Criteria

[Oracle] Chapter 5 cursor and trigger, Chapter 5 oracle cursor Chapter 5 cursor and trigger Cursor: Implicit cursor: % FOUND, % NOTFOUND, % ROWCOUNT 1.% FOUND usage. The % FOUND attribute returns TRUE only when the DML statement affects one or more

Replication between mysql tables, the same database and different databases, mysql table replication Database Mysql statement We can first export the structure of table t1 under test, and then create a new table test1.t1. Execute the following

SQL string data is sorted by int type, stringint Note: I found a problem during wms invoicing: A warehouse receiving ticket (T_OutIn_BoxTop), which should be divided into multiple boxes during warehouse scanning. The box number (BoxTop_No) can be

A perl script, used to send remote MySQL commands, perlmysql Below is one of the basic scripts to write some scripts that simplify management operations. For a user who has never used a perl script, it is still difficult to directly use the

ORA-00600 [kqlInvObj: user] processing, ora-00600kqlinvobj Today, our brother called us to say that after I installed 11.2.0.1.0 on the Development Database (win7 64bit), I had a problem with the Data Pump derivative, which was hard to solve. Then I

Database ----- catalog and schema introduction, ----- catalogschema In the SQL environment, both Catalog and Schema are abstract concepts. They are mainly used to solve naming conflicts. A database system contains multiple Catalog, and each Catalog

Use pipelines to migrate data and pipelines to migrate dataWhen the disk space is insufficient, use the named or anonymous pipeline to migrate and import data. Pay attention to the permission of the named pipeline. 0. Name PIP 0 [pg @ h1 ~] $ Psql

ORACLE Experiment 2: oracle Experiment Experiment 2: Data manipulation Lab hours: 4 hours Lab type: Comprehensive Lab requirements: Required I. Tutorial Purpose 1. Master SQL data query statements; 2. Master the use of SQL Aggregate functions; 3.

Mysql modifies the database's storage engine (InnoDB), mysqlinnodbThe current example is to change the engine MyISAM to innodb.View the supported database engines and default database engines of the current databaseDatabase-supported engines and

Database Retrieval statements and Database Retrieval statements 1. Basic SELECT usage 1.1 simple data retrieval 1.1.1 retrieve required Columns You only need to execute "SELECT * FROM name. SELECT * FROM T_Employee. The SELECT * FROM T_Employee

Use the FREDATED engine for cross-instance access, and the fredated engine for cross-instance access Cross-database server and cross-instance access is a common access method, which can be implemented through db link in Oracle. For MySQL, there is a