NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 10g rac modifies public ip and vip

  Oracle 10g rac modifies public ip, vip and private IP [TOC] 1.IP address Planning Hostname current IP modified IPPublic IPnode1192.168.56.2019

  2022-06-01 22:45:18 Views: 277
• 

  Simple misoperation recovery

  Recovery scenario after misoperation of MySQL: 1. The database has a full backup every day. 2. Enable bin-log3 in the database and accurately locate misoperation statements. 1. Create a full backup. It is recommended to have-- master-data=2 parameter mysqldump-uroot

  2022-06-01 22:45:18 Views: 232
• 

  2018 OCP 052 up-to-date question bank and answers-35

  35 、 Your database is using Automatic Memory Management.Which two SGA components must be managed manua

  2022-06-01 22:45:15 Views: 298
• 

  Ocp latest question bank 052 new question tape answer collation-36 questions

  36, Which two are true about roles?A) A role can be granted a combination of system and object privil

  2022-06-01 22:45:12 Views: 299
• 

  Analysis of 052 new questions in OCP latest question bank-with answers-question 37

  37 、 USER1 grants SELECT, INSERT, and UPDATE privileges on USER1. EMP to USER2.SYS executes this comma

  2022-06-01 22:45:08 Views: 278
• 

  CentOS 7.5 1804 yum install Postgre

  First, preparatory work: 1.postgresql official website: https://www.postgresql.org2. Download page: https://www.postgresql.org/download/3.Red Hat

  2022-06-01 22:45:05 Views: 298
• 

  OCP certification 11g 052 exam latest question bank with answers-38 questions

  38, Which three are true about the Automatic Database Diagnostic Monitor (ADDM)? a) Its findings are a

  2022-06-01 22:45:05 Views: 283
• 

  MongoDB uses group by and displays other column max values

  The following script implements the function of deduplicating the word_info table through the word field and writing it to the word_info_new table db.word _ info.aggregate ([{$group: {_ id: "$wo

  2022-06-01 22:45:04 Views: 241
• 

  Mongodb timestamp to date format statistics

  In daily life, timestamps often exist in mongodb. The following is how to generate data db.test.insert ({"id": 20162, "create_time": 1554195600, "tim") based on the timestamp and date format.

  2022-06-01 22:45:04 Views: 266
• 

  Mongodb query case, golang Library mgo case

  Pipeline: = [] bson.M {bson.M {"$match": bson.M {"id": uid}}, bson.M {"$project": bson.M {"last_msg":

  2022-06-01 22:45:01 Views: 265
• 

  MongoDB query results are converted to an array

  / / data synchronization public function data_Sync () {$filter = []; $options = ['projection' = > [' _ id' = > 0]]; /

  2022-06-01 22:44:54 Views: 236
• 

  Mongodb performance pressure test

  Background I have done a benchmark stress test on all the basic components these days. At present, none of our open source basic components have been tested for performance. Developers often ask how much our RDS and MongoDB clusters can resist. At this time, I can't reply, because I myself.

  2022-06-01 22:44:54 Views: 215
• 

  [MongoDB] View the occupied space of the database collection and clean up the redundancy of the collection

  Check the occupied space tables = db.getCollectionNames (); tables.forEach (function (item) {stats=db.runCommand) under the library

  2022-06-01 22:44:53 Views: 212
• 

  Centos7 mongodb installation notes

  Configure the system source cat / etc/yum.repos.d/mongodb-org-4.2.repo [mongodb-org-4.2] name=MongoDB Repositorybaseurl=https:

  2022-06-01 22:44:53 Views: 300
• 

  The election process for the master node of the MongoDB replica set

  The replication set of MongoDB can automatically tolerate the downtime of some nodes. When there is a problem with the replication set, it will trigger the election-related process and complete the automatic switching between master and slave nodes. Each replication set member runs the heartbeat thread of all nodes of the replication set in the background, triggering a status check in two cases

  2022-06-01 22:44:53 Views: 278
• 

  Simple monitoring of mongodb itself

  First, mongodb provides its own monitoring tool mongostatmongostat is a status detection tool that comes with mongodb and is used under the command line. It gets the current running state of mongodb at regular intervals and outputs it. If you find the database,

  2022-06-01 22:44:47 Views: 303
• 

  MongoDB-4.2.2 installs and configures the account password for access

  0. Aim to download and install MongoDB and set password access. The following three installation packages, mongodb-org-server-4.2.2-1.el6.x86_64.rpm # MongoDB, will be downloaded from MongoDB's official website.

  2022-06-01 22:44:47 Views: 205
• 

  I have to tell you the principle of MySQL optimization.

  When it comes to query optimization in MySQL, I believe you have a lot of tricks: you can't use SELECT *, don't use NULL fields, create indexes reasonably, and choose appropriate data types for fields. Do you really understand these optimization techniques? Do you understand the work behind it?

  2022-06-01 22:44:29 Views: 251
• 

  MySQL master-slave replication and read-write separation

  MySQL master-slave replication and read-write separation experiment introduces that in the actual production environment, if the database is read and written on the same database, it can not meet the actual needs in terms of security, high availability or high concurrency, so generally speaking, it is through master-slave replication.

  2022-06-01 22:44:17 Views: 263
• 

  Set up PXC cluster under CentOS8

  About PXC PXC, which stands for Percona XtraDB Cluster, is a free MySQL cluster product produced by Percona. The function of PXC is to integrate different mysql real through the Galera cluster technology that comes with mysql.

  2022-06-01 22:43:53 Views: 264