Database Administrator

Enable MongoDB IP Security on Ubuntu By default, MongoDB3.6 rejects unauthorized links from accessing the public network to protect data from external threats. MongoDB only listens to local links, unless you add rules to allow listening to other

MySQL field content is case sensitive Data is migrated from Oracle to MySQL. Since Oracle is case-sensitive in the past, the default configuration is used for MySQL configuration, resulting in some data import failures, and some unique keys report

Deep understanding of Oracle sequence Oracle Sequence: Sequence creates, uses, modifies, and deletes data. Sequence is an object used to generate continuous integer data. A sequence is often used as a growth column in the primary key. It can be

Oracle GoldenGate Studio graphical interface management tool Installation Oracle GoldenGate Studio is a graphical interface management tool that allows you to conveniently complete OGG replication design. To install this tool, you need Java 8 (1.8)

Mysql-proxy read/write splitting :Mysql-proxy-0.8.3-linux-glibc2.3-x86-64bit.tar.gzHttp://downloads.mysql.com/archives/proxy/Add User:[Root @ martin tools] # groupadd-r-g 303 mysql-proxy[Root @ martin tools] # user add-g mysql-u 303-r-s/sbin/nologin

Install and start MongoDB 3.0 in RHEL7 MongoDB Introduction MongoDB is an open-source document-type database that supports indexing, replication (replica set), and data sharding. It can be used to build a high-performance, highly available, and

MySQL slow query log MySQL supports slow query logs. You can configure query records that have exceeded the specified time for SQL query to log. This is a very effective tool in optimizing SQL queries and can help us quickly locate the problematic

Configure HugePage for Oracle 11gR2 in Linux HugePage is a performance optimization tool for Oracle in Linux. For database systems in the shared memory area (SGA), we recommend that you configure HugePage at the operating system level to provide

SQL Server database replicationIntroduction: SQL replication can solve many problems in running database-driven applications. Because the sending/subscription mode is not easy to understand, complicated scripting languages and monitoring and

MySQL5.6 5.7 user temporary table comparison Session-based temporary tableThe structure and content of the temporary table generated by default in MySQL5.6 are all in tmpdir5.6 The temporary tablespace without ibtmp1 is placed under tmpdir. Of

Configure GTID for MySQL and MariaDB master-slave Clusters I wrote MySQL and MariaDB traditional master-slave cluster configuration, which is very mature. Since Mysql5.6 and MariaDB10.0, a new master-slave GTID solution has been available. However,

Redis data type and Application Scenario, redis data type scenario I. redis features All data is stored in memory and read/write at high speed Provides a wide range of data types: string, hash, set, sorted set, bitmap, hyperloglog The AOF and

Comparison between MySQL and Oracle: Four-condition loop statement: mysqloracle Loop statement No. Category ORACLE MYSQL Note 1 IF statements use different IF iv_weekly_day = 'mon 'THENIi_weekly_day: =

Modify the mysql password and mysql password 1. If there is no password Mysql-u root Mysql> set password for 'root' @ 'localhost' = PASSWORD ('newpass ');2. If you already have a password, you can use: Mysqladmin-u root password "newpass"

I have already said in many speeches that the best way to improve your system is to avoid "stupid things" first ". I am not saying that you or the things you develop are "stupid", but some decisions are easily ignored by people, I don't know how

1. find MongoDB uses find for query. The query is to return a subset of the documents in a collection. The range of the child set is from 0 documents to the first parameter of the entire set. find. Determines which documents are to be returned. The

-- Method 1: Query dba_tab_columns Select COLUMN_NAME, DATA_TYPE, DATA_LENGTHFrom dba_tab_columnsWhere table_name = upper ('table name ')Order by COLUMN_NAME -- This method requires the DBA permission. -- Method 2: Query user_tab_colsSelect

BKJIA exclusive release: DB2 joins Oracle Data steps 1. Install DB2 2. Install the link connector Alternatively, you can install InfoSphere DB2InfoSphere DB2 as a restricted DB2 version. It has a link connector that can be used to connect to other

The following environments are representative of the general configuration and work environment of small and medium-sized enterprises. I hope this article will help you understand the MySQL database performance tuning method in Linux. BKJIA

Oracle Database system is a complex software system. The Oracle architecture refers to the relationship between the components of the Oracle database management system and these components, including the memory structure, background process,