NAV: SLTechnology News&Howtos > Database >

• 

  Deploy a MongoDB sharding cluster on CentOS7

  An overview of MongoDB sharding is a method of using multiple servers to store data to support huge data storage and manipulation of data. Sharding technology can meet the needs of the massive growth of MongoDB data, when a MongoDB server is insufficient to store large amounts of data or to provide

  2022-06-01 17:13:17 Views: 239
• 

  Deploy multiple instances through the MySQL 8.0 binary installation package

  Extract the installation package cd / usr/localtar xvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xzmv mysql-8.0.12-linux-glibc2.12-

  2022-06-01 17:13:17 Views: 250
• 

  Oracle DBCA creates an instance

  Using DBCA to create instance is very simple and fast, that is, it takes more effort to configure the visual interface according to linux server. Please refer to the attachment for details. Attachment: http://down.51cto.com/data/2364746

  2022-06-01 17:13:17 Views: 296
• 

  The use of records_per_block parameter

  1. BLOCK is the smallest storage and processing unit in the database, including the header information data or PL/SQL code of the block itself. The RECORDS_PER_BLOCK parameter is used to set the maximum number of records in each BLOCK, which is first found in all BLOCK of the current table.

  2022-06-01 17:13:17 Views: 293
• 

  Query MongoDB oplog.rs

  Oplog is Capped Collection and allocates 5% of the free disk space by default. Let's take a look at oplog.rs: rs_test:SECONDARY > use localswitched to db loca

  2022-06-01 17:13:07 Views: 218
• 

  Import files in pl/sql txt format into Oracle

  Select the tool for pl/sql-text Import 2. 3.

  2022-06-01 17:13:07 Views: 288
• 

  Oracle 11g R2 data Dictionary

  A data dictionary is a collection of tables and views in which oracle stores key information. The oracle process maintains these tables and views in the sys schema, that is, the owner of the data dictionary is the sys user, the data is stored in the system table space, and the data dictionary describes how the actual data is

  2022-06-01 17:12:56 Views: 253
• 

  ORACLE configuration event parameters

  The following test comes to 11G1, the version of the database www.htz.pw > select * from vicious version of BANNERMAIL-

  2022-06-01 17:12:56 Views: 208
• 

  Mysql database password modification

  Unknown database password or first login can be used this method: if you are changing the password, stop the mysql service systemctl stop mysqld1 to modify the configuration file, skip the password to enter the database vim / etc/ my.cnf [mysqld] sk

  2022-06-01 17:12:55 Views: 288
• 

  Oracle starts error reporting ORA-00838

  System environment: Windows server 2008 R2 database version: oracle 11.2.0.1 RAC for the customer to check the database and found that the 128g memory utilization configured by the customer's system is very low, so I want to increase the memory, so I set a few

  2022-06-01 17:12:55 Views: 281
• 

  Mysql sub-library backup script

  #! / bin/bash#Author:heyic.m@gmail.com# is backed up by database. You can exclude the specified database # 2016-06-08 create.#2017-02-21 add expire_days.#

  2022-06-01 17:12:55 Views: 237
• 

  Add, modify, delete and merge Oracle partition tables. The method of transferring ordinary table to partitioned table

  one。 Partition table theory Oracle provides partitioning techniques to support VLDB (Very Large DataBase). By judging the partition column, the partition table puts the different records of the partition column into different partitions. Partitions are completely transparent to the application. Oracle

  2022-06-01 17:12:55 Views: 261
• 

  CentOS 7 deploys MySQL 5.7Master-Slave replication (traditional and GTID)

  Record ♪ (^ ∇ ^ *) 1, replication of binaries and locations; 2, master-slave replication based on global transaction identifier (GTID): (test environment is CentOS 7.3) 1, based on binary log files (traditional) (1), working principle: 1, Mast

  2022-06-01 17:12:54 Views: 263
• 

  Add filtering, grouping, sorting, and multiple tables for mysql equivalent connection cases

  Add screening # case: the name of the employee with bonus and the name of the department, SELECT last_name,department_nameFROM employees AS ePersonnal AS dWHERE

  2022-06-01 17:12:54 Views: 271
• 

  Deployment of SOL Server database library

  1. Database basic concept data: symbolic data tables that describe things: data tables are composed of records (rows) and fields (columns). Database management system: database management system: database management and maintenance DBMS database administrator: DBA is responsible for database management and maintenance database system: by hardware,

  2022-06-01 17:12:54 Views: 266
• 

  MySQL Learning (7): the implementation principle of Innodb Storage engine Index

  Summary in the database, the index is just like the directory of the tree to speed up the search of data. For a SQL query operation, according to the index, quickly filter out the data that does not meet the requirements and locate the data that meets the requirements, so that you do not need to scan the whole table to get the required data. In innodb storage

  2022-06-01 17:12:54 Views: 219
• 

  Detailed explanation of hadoop biosphere

  Learning and using hadoop for a year, here mainly share the overall understanding of hadoop, introduce the relevant components by category, and finally provide a suggested learning route, hoping to provide reference for beginners of hadoop. 1. What are the core components of Hadoop?

  2022-06-01 17:12:50 Views: 243
• 

  Using Percona Monitoring Plugins to monitor MySQL in Zabbix

  Percona Monitoring Plugins is used in Zabbix to monitor MySQL1. Install zabbix agent [root@szlinux01 ~] # rpm-ivh http://re

  2022-06-01 17:12:38 Views: 203
• 

  ORA-01940: cannot drop a user that is currently

  Oracle deletes a user. Error: 12:17:05 SYS@RCBD1 (BAPRCDB) > drop user GSDPAY cascade;drop user GSDPAY cascade*ERROR

  2022-06-01 17:12:38 Views: 233
• 

  MongoDB specified type query data

  1. View the collection show collections2. Add data db.runoob.insertMany ([{'title':'data1','url':' https://blog.51cto.com] to the collection

  2022-06-01 17:12:27 Views: 230