Database Administrator

High Availability of MariaDB dual-master N slave replication-Implementation of MMM Architecture 1. MMM OverviewMMM (Master-Master replication manager for Mysql) is a flexible script program for monitoring and failover, manage the configuration of

How to install Oracle 12c in RedHat Linux 6 Step 1: To install Oracle on RedHat Linux 6, you must install the corresponding software package before installing Oracle. In different operating system environments, the software package requirements are

The IP address of the Oracle restricted connection, and the ip address of the oracle restricted connectionIn oracle, you can control which IP addresses can connect to the database and which IP addresses cannot connect to the database. In 9i and

ORACLE 11G Data Guard role conversion, 11 gguard1. ORACLE login uard Role SwitchingDataGuard is now the mainstream disaster tolerance solution. Due to its strong adaptability to the network, it can adopt synchronous real-time transmission mode and

SQL Optimization-logical Optimization-subquery optimization (MySQL) and sqlmysql 1) subquery concept:When a query is a subquery of another query, it is called a subquery (a query statement is nested in the query statement ). Subqueries are located:

Add columns with default values in Oracle tables (including new 12C features) and oracle12c This is a problem that I have been paying attention. 11G has been improved on this issue, and 12C has some new features. For a discussion on the new features

5. Basic Redis commands --- unordered set, redis command --- set1. Each element in the set is unique and has no order.2. Comparison between set and list Set List Storage content Up to 2 ^ 32-1 strings Up to 2 ^ 32-1

Modify the Tomcat port number method and the tomcat port number Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable

MySQL5.5.21, mysql5.21 MySQL is required for a recent project. By the way, I have picked up a database that has not been completed for a long time! You may need to write a series of study notes on MYSQL! When it comes to database installation, it is

Restructuring the data room charging system-view and restructuring the data room Charging System During the first knock on the data center charging system, the database directly places these fields in a table based on the table and field used

Mssql deletes all tables in the database and mssql deletes the database. for this operation, you can first learn about the system table sysobjects (which has been written in the previous blog), and drop, truncate, delete. ------------ Delete the

KETTLE _ memory overflow error and kettle overflow error Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when reprinting them. Otherwise, you will be held legally liable for

Define system fields in QlikView and qlikview Fields In Settings-> User Preferences, there is a "Show System Fields" option. If this option is selected, you can select the system field when creating a List Box. Otherwise, no. How to define system

Multiple SQL tables query and computing statistics code based on ACCESS and ASP, accesssql Recently, I am writing a few management systems about "Project-Subitem-Task", saying that the system is a bit exaggerated. It is basically a multi-Table query

Oracle database software patch on windows platform, oracledatabaseFor windows: Oracle provides bundled patches for Microsoft Windows platforms. recommended patches are encoded in these bundles rather than as separately downloadable patches. see Note:

[MongoDB] MongoDB's missing knowledge points and mongodb's missing knowledge points Up to now, I have read three mongodb books. Today, when I read the MongoDB authoritative guide by Kristina Chodorow in the United States, I found that there are

Database mode: database mode Three-Level mode structure: external mode, mode, and internal mode I. Schema) Definition: Also known as the logical mode. It is the logical structure and feature description of all data in the database and is the public

About ORA-03113: End of communication channel, ora-03113 Channel Author: iamlaosong A SQL query statement, successful execution or error, irrelevant to the statement, but related to the value in the condition, the error is the ORA-03113: The end of

Mysql cursor example mysql cursor simple tutorial, mysql cursor example tutorial From mysql V5.5, a major change was made, that is, InnoDB was used as the default storage engine. InnoDB supports transactions and has the relevant RDBMS features:

Oracle SQL statements are fast and slow, while oraclesql statements are fast and slow. Today, I encountered a very strange problem. One SQL statement is very slow in PL/SQL developer and takes 9 s. The problem SQL: SELECT * FROM GG_function_location