Database Administrator

MySQL master-slave replication case Working principle diagram: Principle of master-slave replication:It can be divided into synchronous replication and asynchronous replication. In the actual replication architecture, most of them are asynchronous

How to Learn PostgreSQL SQL syntax We can use the psql command to query the SQL syntax. Switch to the PostgreSQL user, [Doctor @ localhost ~] $ Su-postgresPassword:Su: Fault Identification[Doctor @ localhost ~] $ Su-postgresPassword:-Bash-4.3 $

MongoDB geospatial Index 1. Index: Creating an index takes both time and effort, and consumes a lot of resources. You can use the {"bakckground": true} Option to complete the process in the background and process the request properly. If the

Install mysql and linuxmysql in linux 1. Check whether the grep is installed. The-I option of grep indicates that case sensitivity is ignored when matching. [Root @ localhost JavaEE] # rpm-qa | grep-I mysql Mysql-libs-5.1.61-4.el6.x86_64 * It can be

HASH type of Redis data type, hash type of redis Data Type Web programmer blog: http://blog.csdn.net/thinkercode HASH type-Features Redis hash is a ing table between fields and values of the string type. Its Addition and deletion operations

Oracle Database startup caused by a loss of the registry project in the Windows registry ., Windows Oracle Oracle Database startup problems caused by a loss of the registry project in the Windows registry. Environment Description:1. windows 2008

Clear table data in SQL loop, SQL LoopSQL statement to clear table data Recently, database clearance tests are often required for projects, but truncate is slow and time-consuming. Therefore, you have written an SQL statement to clear table data in

PostgreSQL is installed on Ubuntu, and postgresqlubuntu Installation environment: Ubuntu 64bit PostgreSQL 9.0   1. Install PostgreSQL Enter the following command Sudo apt-get install postgresql   The system prompts you to install the

SQLServer -- How to completely copy a database, sqlserver Database For the sake of conciseness, the source database is referred to as S, and the target database is called T. SqlDelta is required in this article. Click to open the link. 1.

Resetlogs noresetlogs, resetlogsSQL> select * from v $ version where rownum = 1;BANNER--------------------------------------------------------------------------------Oracle Database 11g Enterprise Edition Release 11.2.0.1.0-ProductionSQL>!

[Mysql] a solution to master-slave data inconsistency, mysql master-slave Previous Article: re-establishing Synchronization After the Master/Slave node changes the ip addressThis is the case.Two active machines were migrated last night, and the

Use LOB Storage, uselobstorageIf LOB storage is not defined and LOB attribute size exceeds 4000 characters the attributes which overflow will automatically be placed in the tables tablespace in default configured LOB storage and index. if LOB

Oracle EBS maintenance and diagnosis learning summary, oracleebs maintenance and DiagnosisDocument directory Blog of Sunan Sheng 1. Basic Oracle status 2 1.1 check the Oracle instance status 2 1.2 check the Oracle listening status 2 1.3

SqlServer Bug: The replicate_ddl parameter is invalid. A bug was found in the latest architecture change tests for updatable subscriptions. During replication, when the Publishing Database changes the architecture of the Publishing Database, the

OPatch reports Prerequisite check "CheckActiveFilesAndExecutables" failed, opatchSymptom: When patching with Opatch, the following error is reported: [root@customer bin]# /u01/app/ora11g/product/11.2.0/db_1/OPatch/opatch auto /soft/psu/20299013/

[BI project notes]-New Task Processing and New bi tasksZookeeper The previous article describes how to use TFS to create a new work item. This article describes how to process it.   First, review the definition of the new work item at different

Caused by: java. SQL. SQLException: Field 'id' doesn' t have a default value, defaultvalue 1. Error description org.hibernate.exception.GenericJDBCException: error executing workat

[BI project]-New Task creation and bi new taskZookeeper The previous article describes how to handle a Bug. This article mainly describes how to create a work item for a new requirement using TFS.   It is assumed that there is a new requirement

Table operations in oracle and table operations in oracle The basic creation will not be mentioned. Here we will talk about some uncommon methods, which means they are easy to use. Create a table using a subqueryCreate a new book table using a

Mysql event execution stored procedure, mysql event Stored Procedure CREATE PROCEDURE InitializationData()BEGINupdate yt_products set number=number+100 where id=1;update yt_products set number=number+100 where id=2;update yt_products set