Database Administrator

Create a Neo4j Cluster Environment Introduction: Neo4j is currently the mainstream graph database. It also provides highly available cluster solutions. This article will try to build a highly available Neo4j environment. 1. What is graph

Oracle null value processing function /*********** NUL, NVL2, and NULLIF usage in Oracle ***************/ NULL indicates a NULL value or an invalid value. 1. NVL (expr1, expr2) Function If expr1 is NULL, expr2 is returned. If not NULL, expr1 is

Create an Oracle whitelist for RAC Due to business needs, you need to use a whitelist to restrict the addresses of users logging on to the database, and decide to use the database whitelist function! Generally, you only need to add the following

The RedHat Enterprise Linux 5 installation was successful, but many errors occurred while installing Oracle. The official Oracle 10g version website is here. You do not need to register for downloading with thunder. You need to register for IE

1. Default Processing Oracle considers null as the maximum value by default in Order by, so if it is ASC in ascending Order, it is placed at the end, and DESC in descending Order is placed at the top. 2. Use the nvl Function The nvl function can

Database-stored procedures ., Database Stored Procedures Stored Procedure: Stored Procedures (Stored Procedure) are a set of SQL statements for specific functions in large database systems. They are compiled and Stored in the database, you can run a

ERROR OGG-01161 Bad column index (88), ogg-01161column after table schema change09:38:31 ERROR OGG-01668 PROCESS ABENDING.2014-07-31 09:38:31 ERROR OGG-01161 Bad column index (88) specified for table WIP. WIP_PARAMETERS, max columns = 88. The net

Use python to batch import data to Redis, and use pythonredis to import data1. Batch import data using pipeline Class Redis_Handler (Handler): def connect (self): # print self. host, self. port, self. tableself. conn = Connection (self. host, self.

Mongodb mapreduce usage summary, mongodbmapreduce This article is from my blog: mongodb mapreduce usage Summary  As we all know, mongodb is a non-relational database. That is to say, each table in the mongodb database exists independently and

High Availability of MySQL-keepalivd + mutual master and slave, mysqlkeepalivdObjective: to configure a keepalived Hot Standby architecture and master-slave ReplicationPlanning:Master1 zlm177 192.168.17.177Master2 zlm188 192.168.17.188Vip 192.168.17.

ORA-00911: Invalid character error, invalid ora-00911 character ORA-00911: Invalid character error -- caused by a minor error in the compilation environment   Implementation of a function script statement, compile, there is a ORA-00911 error, at

Chapter 1 Securing Your Server and Network (4): Use the virtual service account, chaptersecuringSource: Workshop Without the consent of the author, no one shall be published in the form of "original" or used for commercial purposes. I am not

[Translated from mos] Using index quick full scan (index ffs) to avoid full table scan, mosffs Using index quick full scan (index ffs) to avoid full table Scan Reference Original:Index Fast Full Scan Usage To Avoid Full Table Scans (Doc ID

Solution: QSqlDatabase: an instance of QCoreApplication is required for loading driver plugins, qcoreapplication When QSqlDatabase is used, the error QSqlDatabase: an instance of QCoreApplication is required for loading driver plugins is reported

02-mysql-installation, mac installation 02 mysql02-mysql-Installation ---- MySQL installation version And technical documents Mysql current common version mysql-5.6.15.tar.gz ---- MySQL compilation and Installation 1.Installation environment

1.1.1. If a crash happens thisconfiguration does not guarantee that the relay log info will be consistent [Environment description] Msyql5.6.14 [Error message] When mysql slave is started, the following Warning occurs in error. log: [Warning] Slave

As the database data volume continues to grow, some tables need to be converted from normal heap tables to partition tables. There are several different methods for this operation, such as exporting table data, creating a partition table, and then

-- Buffer hit rate: the ratio of the buffer hit rate between the obtained data and all accessed data. The normal metric is 90% ~ 100%. However, it may be lower-- 90%. The buffer hit rate is affected by the data block buffers parameter settings in

Method 1: press ctrl + backspace while using the backspace key. Method 2: Add the following content to any startup script:[Oracle @ night ~] $ Tail-1. bash_profileStty erase ^ H Stty indicates set tty, which is mainly used to check and modify the

From the definition, we can see that the Schema is a set of database objects. To distinguish each set, we need to name this set, these names are the nodes with similar user names that we see in the Enterprise Manager Solution. These nodes with