Database Administrator

Oracle sequence, index, and synonym A simple record of knowledge about Oracle sequences, indexes, and synonyms. 1. Common database objects Ii. Sequence Sequence: a database object that can be used by multiple users to generate unique values.

InfluxDB server startup process Operating System: CentOS7.3.1611 _ x64 Go language version: 1.8.3 linux/amd64 InfluxDB version: 1.1.0 Source code path: github.com/influxdata/influxdb/#/influxd Program entry (main. go ): Func main (){Rand. Seed (time.

Monitor MySQL Master/Slave synchronization latency There are usually two ways to monitor the latency between MySQL master and slave: Seconds_Behind_Master and mk-heartbeat. Method 1: monitor the value of the Seconds_Behind_Master parameter output by

New Features of Oracle 12C-online migration of table partitions or subpartitions Oracle 12c: new feature-online migration of table partitions or subpartitions. It is no longer necessary to migrate table partitions or subpartitions to different

MySQL multi-instance application configuration and deployment guide I. Functions of multiple Mysql instances 1. effectively use server resourcesWhen the resources of a single server are surplus, the remaining resources can be fully utilized to

Semi-synchronous replication in MySQL master-slave Replication Experiment MySQL uses the plug-in provided by Google to complete the semi-synchronous replication model; the physical machine is still Windows 7, and the virtual machine is CentOS

How to change the root password of MySQL in CentOS How to change the root password of MySQL in CentOS 1. log on to mysql with an account Mysql-u rootOr # mysql-uroot-p 2. Change the user database Command: mysql> use mysqlMysql> use mysqlReading

MySQL Engine Features-InnoDB undo log roaming This article describes the entire Undo lifecycle process. The code analysis is based on the latest version of MySQL5.7. This article can also serve as a guide to the Code for understanding the entire

Install DBI and DBD in Linux 1. Media downloadWww.cpan.org open the home page of cpan, and then click search.cpan.org to search for DBI and DBD: Oracle-Rw-r -- 1 oracle oinstall 592307 Apr 5 DBI-1.633.tar.gz-Rw-r -- 1 oracle oinstall 452537 Apr 5

Use MongoDB C # official driver to operate MongoDB To use MongoDB in C #, you must first have a C # drive supported by MongoDB. C # has many types of drivers, such as samus. Most of the Implementation ideas are similar. Here we first use the

MongoDB basic operation learning notes Record the basic operations of MongoDB today. This is only the most basic operation, so it should be mastered. Database A database is a collection of physical containers. Each database has its own file system.

Oracle 12c auto-incrementing column Identity Columns In the 12c version of Oracle, Oracle implements auto-increment columns similar to auto_increment in MySQL. Let's take a look at how Oracle is implemented. Oracle Database 12c Enterprise Edition

Seven differences between MySQL and Oracle: User Permissions: mysqloracle User Permissions No. Category ORACLE MYSQL Note 1 Create user Create user user_name identified by

Onsql and MySQL Start and Stop scripts and onsqlmysql scripts Start and stop onesql. A total of four parameters are {start | stop | restart | status}. You only need to slightly change the three file paths in the header to start and stop a single

Redis configuration cluster, redis ClusterConfigure the cluster configuration environment in redis Environment centos 6.6 redis 3.0.2 For convenience, copy three copies of the redis environment under a folder, with the suffix representing the

Common Database interview questions and database questions Paradigm 1: Each column in a database table is a basic data item that cannot be further divided. values or duplicate attributes are not allowed. For example, if a table contains a phone

I made a php program to add form data to the database. I used the mysql extension library function to perform operations on the mysql database to add, delete, update, and query words. The running environment is a common mysql database, php, and

Although SQL Server 2008 is now a new database system. However, it will be updated in the future. Therefore, when deploying SQL Server 2008, the database administrator still needs to consider backward compatibility issues. To reduce the trouble of

PD reverse engineering: using windows Data Source Management to create ODBC Data sources 1. Open the control panel and manage tools   2. Open the data source   3. Select the database type you want to operate on, such as SQL Server) 4. Enter

What is Bloom Filter] Bloom Filter is a space-efficient random data structure. It uses a bit array to easily represent a set and determines whether an element belongs to the set. The efficiency of the Bloom Filter has a certain price: when