NAV: SLTechnology News&Howtos > Database >

• 

  MongoDB 3.0 replica set building

  Environment configuration architecture: one master and two slaves (three virtual machines) system version: CentOS Linux release 7.4.1708 (Core) MongoDB version: 3.0.15MongoDB installation the following operations need to be carried out in all three virtual machines

  2022-06-01 22:11:52 Views: 294
• 

  Report Builder 3.0Connect to ORACEL database

  One: Report Builder 3.0 create a database connection and then click next step two: date parameter setting three: oracle dataset parameter assignment ORACLE uses ":" way, SQL SERVER uses "@" way. Oracle is not required

  2022-06-01 22:11:22 Views: 208
• 

  Only one entry is left for mongodb de-reoperation.

  Original table record: the same entry as related_type=1 and action_type=3 and related_id needs to be deleted. Only one is left to weigh. Db.user_action_log.aggregate ([{$

  2022-06-01 22:11:18 Views: 201
• 

  Redis-Common Command

  The format is messy, mainly to record some usual operations and learning process. 1, check the number of 127.0.0.1 aof 6379 > dbsize (integer) 62, and manually rewrite the aof file 127.0.0.1

  2022-06-01 22:11:18 Views: 279
• 

  3.Ubuntu installs MongoDB Enterprise Edition

  The latest content of 3.Ubuntu installation MongoDB Enterprise Edition will be updated at the origin server. Reprint please keep the original link: http://dashidan.com/article/mongodb/index.html ① through the installation package management system guide

  2022-06-01 22:11:18 Views: 274
• 

  Elasearch time query and grouping statistics

  / * query data from ES * ES time if not set, the default is UTC time, which is 8 hours different from Beijing time. When querying statistics, if statistics are not made, the data will definitely be inaccurate. * ES version: 6.4.1. Jav used

  2022-06-01 22:10:48 Views: 245
• 

  Introduction to the use of tools that come with MySQL

  Preface in MySQL, there are many powerful tools, such as mysql, mysqladmin, mysqldump and so on. This blog post will write down the use of some command tools. 1. Mysql command Mysql command is the most frequently used command tool

  2022-06-01 22:10:48 Views: 297
• 

  UNDO tablespace error ORA-01190:O after RMAN backup and recovery

  RMAN full recovery data (with rman backup scheduled at 9 o'clock every day) 1. Log in to rmanC:\ Users\ My > rman target / recovery Manager: Release 11.2.0.1.0-Production on

  2022-06-01 22:10:47 Views: 265
• 

  Mongondb configuration parameters

  Configuration file content: cat / etc/mongodb.confstorage:dbPath: "/ data/databases/mongodb" directoryPerDB: truejournal:ena

  2022-06-01 22:10:47 Views: 236
• 

  [Dameng database] Activiti connects to Dameng database

  First of all, activiti supports linking dm, we need to solve the problem of how to configure: only need to modify two configuration files: 1. The first is the configuration of jdbc: change the driver, class name, connection string, etc., the following is the configuration mode: that is, the connection string is changed to Dameng. two。

  2022-06-01 22:10:39 Views: 213
• 

  Date-related statement

  1. Find the number of days of this month process select getdate () current date select day (getdate ()) current day select getdate ()-day (getdate ()) last month last day select d

  2022-06-01 22:10:25 Views: 257
• 

  Interceptor pagination of MyBatis

  Lu Chunli's work notes are not as good as bad notes. the paging of the database mainly includes physical paging and logical paging. Physical paging: the paging method provided by the database itself, such as MySQL's limit, Oracle's rownum, SqlServer's top, has the advantage of efficiency.

  2022-06-01 22:10:25 Views: 285
• 

  Zabbix uses Python to monitor the status of MongoDB replica sets

  The company has Windows and Linux servers, both of which have built MongoDB replica sets, and all of them need to be monitored in the zabbix platform. The Linux system can be implemented directly using shell scripts, but the Windows system

  2022-06-01 22:10:25 Views: 228
• 

  Related sql statements commonly used in oracle

  1. Oracle commonly used related sql statements 1. Connect to database su-oracle-c "sqlsplus user / password Note: login for the first time with sqlplus / as sysdba Note: close the database: note: shu

  2022-06-01 22:10:25 Views: 211
• 

  Configure redis master-slave replication and highly available clusters

  1. To install redis, download the redis installation package [root@mymaster yasuobao] # pwd/root/yasuobao [root@mymaster yasuobao] # wget http:

  2022-06-01 22:10:13 Views: 290
• 

  Greenplum-Resource queue Management

  Preface in Greenplum, each user will correspond to the resource queue. Resource queue Zhang has good applications in many scenarios. For example, many people share databases and need to develop inaccessible queues for different people to control resources. If it is not specified by default, it corresponds to the pg_default resource queue pair.

  2022-06-01 22:10:07 Views: 243
• 

  Index of 4.mongodb

  What is an index? Indexes can usually greatly improve the efficiency of queries. If there is no index, MongoDB must scan each file in the collection and select those records that meet the query criteria when reading data. The query efficiency of scanning a full collection is very low, especially when dealing with a large amount of data.

  2022-06-01 22:10:04 Views: 279
• 

  If you test your MongoDB application upgrade?

  If you test your MongoDB application upgrade? Original English text: http://blog.mongodirector.com/how-do-you-test-your-mongodb-application-upgrad

  2022-06-01 22:10:04 Views: 249
• 

  MongoDB replication set

  MongoDB replication sets Overview replication sets are additional data replicas, the process of synchronizing data across multiple servers, replication sets provide redundancy and add data availability, and the advantages of restoring replication sets to services interrupted by hardware failures through a replication set are as follows: make the data more secure. High data available

  2022-06-01 22:09:34 Views: 208
• 

  Cracking the MySQL password on Windows

  1. Open the service Win+R and enter service.msc to find the MySQL service to stop. Open cmd and go to the bin folder of MySQL and type mysqld-nt--skip-grant-tables to enter directly.

  2022-06-01 22:09:33 Views: 299