NAV: SLTechnology News&Howtos > Database >

• 

  Install under Linux of mongodb

  1. Download the installation package tar xvf mongodbxxxxx.tar # extract the installation package mkdir / usr/local/mongodb # and create the mongodb folder cd mongodb-linux-x86

  2022-06-01 22:25:20 Views: 291
• 

  MongoDB (4. 0) slicing-- big data's way to deal with it

  What is a database application with high data volume and throughput will cause great pressure on the performance of the stand-alone machine, a large amount of query will exhaust the CPU of the single machine, and a large amount of data will cause greater pressure on the storage of the single machine, which will eventually deplete the memory of the system and transfer the pressure to the disk IO. MongoDB fragmentation is done using the

  2022-06-01 22:24:55 Views: 266
• 

  The problem of cable connection in big data Center

  Cable interconnection is critical to any data center network, and fiber optic cable is the preferred medium. With the growing demand for bandwidth and faster data transmission, this kind of media becomes complex. In today's blog, we outlined best practices and pitfalls to avoid when doing these complex installations. Combined with new technology

  2022-06-01 22:24:55 Views: 235
• 

  MySQL database-MHA high availability cluster architecture (actual combat! )

  Introduction to MHA (1) introduction to MySQL is currently a relatively mature solution in terms of high availability. It was developed by youshimaton, a Japanese DeNA company (now working for Facebook), and is an excellent set of fault cutting under MySQL high availability environment.

  2022-06-01 22:24:55 Views: 257
• 

  SQL updates one table with data from another table

  Update the A1 SET A.A1 of Table A with the data of Table B (B1 column, B2). Column A2 SQL Server:update A SET A.A1 = b.B1 FROM A, B WHERE A.ID1 = B.ID

  2022-06-01 22:24:55 Views: 248
• 

  The 1236 error in the mysql database cluster causes the master database and slave database to fail to synchronize.

  The sync_binlog parameter in / etc/my.cnf sets the number of transactions accumulated before dropping the disk description: 1. The data is saved to the database and the binlog disk is set up at the same time. The data is stored in memory first, reaching the set number of transactions before falling to 3. 5%. Read from the library is

  2022-06-01 22:24:52 Views: 236
• 

  MySQL-- indexing and transactions, storage engines MyLSAM and InnoDB

  The concept of index 1. The index in the database is similar to the catalogue of books. ● in a book, you can quickly find the required information without reading the whole book. The catalog in the ● book is a list of words, which indicates the page number 2 containing each word. The database index ● in the database, the index makes the database program.

  2022-06-01 22:24:52 Views: 227
• 

  Oracle RMAN automatic recovery

  In daily work, Oracle database recovery is sometimes needed, such as setting up test environment, finding historical data, recovery testing and so on. It is recorded that recovery scripts can be executed through scheduled tasks or nohup to improve the efficiency of the whole operation. The test environment used here is as follows

  2022-06-01 22:24:48 Views: 261
• 

  How to avoid running away when deleting the library

  It is also an old problem to delete the database and run away from the delayed node solution. It can be seen that mistakenly deleting data in the process of operation and maintenance database, or the developed code has bug, resulting in mistaken deletion of data is not uncommon. However, there are also many schemes to restore or prevent erroneous deletions, such as the SQL management system, S, which will be implemented.

  2022-06-01 22:24:25 Views: 272
• 

  M has SQL advanced query

  Query WEHRE LIKE BETWEEN IN ON OR according to specific conditions. The UNION keyword joins multiple tables together to process SELECT expression1, expression2,... Exp

  2022-06-01 22:24:25 Views: 242
• 

  [3 minutes daily technical practical information | interview questions + answers | Redis (1)

  1. What is Redis? * * what are the usage scenarios? * * Let's first understand the classical CAP theory: consistency: consistency at the data level. Availability: refers to availability at the system level. Fault tolerance: refers to the fault tolerance from the network level. The database is gradually changing from the relationship.

  2022-06-01 22:24:24 Views: 259
• 

  SoapUI makes a REST request, and the POST method submits the data to the database

  At first, I thought I wanted to add the key and value of the json string one by one, but the result was always 300. the parameter was wrong, but later I found it (https://www.joecolantonio.com/2013/08/31/soapu).

  2022-06-01 22:24:21 Views: 263
• 

  MySQL practice: Foundation + development + optimization + management and maintenance. Don't say no after reading this.

  In recent years, open source databases have become more and more popular. Due to the advantages of free use, simple configuration, good stability and excellent performance, open source database occupies a large market share in middle and low-end applications, and MySQL is an outstanding representative of open source database. MySQL data

  2022-06-01 22:24:00 Views: 296
• 

  Detailed explanation of the principle and Management of MongoDB replica set Election

  The nodes of the MongoDB replication set are elected to the master node. The process of election between the replication set nodes is described below. The principle of MongoDB replication is based on the operation log oplog, which is equivalent to the binary log in MySQL. Only records that have changed are recorded. Replication is to put the master

  2022-06-01 22:23:57 Views: 265
• 

  Talking about MGR-the communication module Part2 between members

  The communication module is divided into three parts. 1. The local packet receiving part is responsible for receiving data transmission requests from local members to other modules, and the received data packets are put into the local data queue for processing. two。 The communication part between members is responsible for communicating with other members. Communication work includes: reading from local data queues

  2022-06-01 22:23:56 Views: 252
• 

  Install the latest version 4.0 of MongoDB, and configure and start the instance

  About MongoDB: 1.MongoDB is an open source document database based on distributed file storage and the industry-leading NoSQL database written in C++. two。 In the case of high load, adding more nodes can ensure server performance. 3.Mo

  2022-06-01 22:23:46 Views: 286
• 

  MongoDB deletes all data in the collection

  1. View the data in the collection and format db.runoob.find (). Pretty () 2. Delete all data db.runoob.remove ({}) 3. View the data in the collection and format it in db.runoob.find ()

  2022-06-01 22:23:39 Views: 300
• 

  Download method of electronic version of Oracle 11g OCM certificate

  Oracle 11g OCM certificate electronic download method 1 login: Oracle official website is as follows: http://certview.oracle.com/ two options three choices print can be downloaded to the local BTW: you can also choose OCP

  2022-06-01 22:23:32 Views: 298
• 

  Dual hosts of KeepAlived+ with high availability of MySQL

  In MySQL's highly available KeepAlived dual-host production environment, one mysql host has a single point of failure, so ensure the high availability of mysql, that is, two MySQL servers. If one of the MySQL servers dies, the other can replace it immediately.

  2022-06-01 22:23:17 Views: 237
• 

  A case study on the Application and War of redis geo Geographic location system

  Proper nouns geographic Geographic radius Radius range; Radius (distance); redis GEO implementation using circular area measured by radius redis GEO mainly includes the following two techniques: 1. Use geohash to save geographic location.

  2022-06-01 22:23:06 Views: 298