NAV: SLTechnology News&Howtos > Database >

• 

  Mongodb getting started command

  1: mongo getting started command 1.1: show dbs to view the current database (admin is related to management, user operations, security configuration, etc., need to be switched to the database. Local stores information from other databases. Test makes himself at will.) 1.2 use

  2022-06-01 13:54:10 Views: 284
• 

  105 database rules of trustworthiness

  As a financial technology company, a large number of businesses of Yixin rely on databases. How to improve the overall database application level of the company is a major challenge to DBA, but also of great practical significance. In many years of work at Yixin, the author, together with the team, has summarized and sorted out the rules for the use of traditional relational databases.

  2022-06-01 13:54:04 Views: 272
• 

  Oracle Goldengate OGG-01028 processing of bare device file system on HP platform

  A telecom operator established a number checking system between the 3G system and the 4G system because the number states of the two systems were not consistent. The source side uses Oracle Goldengate software, and the target side uses the Kafka self-written CUE program to parse the Trail files transferred by the source side. Eye

  2022-06-01 13:54:01 Views: 292
• 

  Detailed explanation of mysql Multi-source replication

  You should know that compared with other databases, the most important feature of mysql is master-slave replication, but the previous version only supported one master and multiple slaves at most. For some statistical classes, cross-database is needed, which is a troublesome thing. In the past, it could only be handed over to database middleware (m

  2022-06-01 13:54:01 Views: 294
• 

  Oracle11g startup and shutdown

  At startup, the parameter files are read sequentially in the specified directory: SPFILESID.ora, SPFILE.ora, initSID.ora, Init.ora. There are four states of database: shutdown (database and instance are closed) and NOMOUNT (real

  2022-06-01 13:54:01 Views: 217
• 

  The solution to the failure to start the OracleDBConsoleorcl service when starting Oracle under Windows

  OracleDBConsole [Sid] is the Oracle enterprise manager, and the management mode is the browser operation mode. The [SID] here is Oracle SID. If the default installation is orcl, this prompt shows OracleDBConso.

  2022-06-01 13:54:01 Views: 209
• 

  Overview of Database system

  What is a database database (Database DB) refers to the warehouse that organizes, stores and manages data according to the data structure, is a collection of related data stored together, and what is the database management system database operating system (Database Management Sys)

  2022-06-01 13:54:01 Views: 267
• 

  (2) centos7--MySQL-5.6.36 backup

  MySQL backup and recovery data backup type 1, physical backup cold backup: backup operation when the database is closed. Hot backup: backup operation while the database is running, this method depends on the log files of the database. Warm backup: database lock table (not writable but readable

  2022-06-01 13:54:00 Views: 231
• 

  Hadoop+Hbase installation and configuration record

  Production environment: 3 machines: master (192.168.0.61), slave1 (192.168.0.62), slave2 (192.168.0.63) Note: hostname is set to master/slave1/

  2022-06-01 13:54:00 Views: 301
• 

  Uninstall the Oracle database or client ​

  This article is suitable for uninstalling an Oracle database or client in a Windows environment. This method is generally common in windows with various versions of Oracle uninstall. Note that if the client and server are on the same server and you only want to uninstall one of them, the following methods are not recommended

  2022-06-01 13:54:00 Views: 263
• 

  Mysql local data directory migration

  Requirement: there is no space in the original directory of mysql. The mysql directory mkdir-p / home/mysql3306/datamkdir-p / home/mysql3306/logmkdir-p / h needs to be migrated locally.

  2022-06-01 13:53:59 Views: 272
• 

  Mongodb queries the document of embedded list with size greater than 1

  Db.user_profile.find ({$where: "this.disk_rack.length > 1"}), but this js engine executes very slowly, and a better way is to CreateextrafieldN.

  2022-06-01 13:53:59 Views: 216
• 

  How to make tree dataset to realize organizational tree report in FineReport

  1. Problem description FineReport, the organizational tree report is implemented by id and parent id in the organizational tree report. if there are many levels, it will be cumbersome to set the filter condition and shape for each cell, so FineReport provides a special data set-tree dataset, only

  2022-06-01 13:53:47 Views: 248
• 

  The usage of oracle case when

  SELECT col1, col2,CASEWHEN col3 > 1 AND col3 < 2THEN '1'WHEN col3 > 2 AND col3 < 3THEN' 2'WHEN col3 >

  2022-06-01 13:53:46 Views: 208
• 

  A probe into the DR and BDR Election rules of OSPF and the reasons why the highest RouterID is non-DR in the actual environment

  As a typical analytical record, share it with those in need. 1. OSPF Protocol describes OSPF (Open ShortestPath First) Open shortest path first Protocol an open dynamic routing protocol developed for IETF, which is based on the current link state

  2022-06-01 13:53:46 Views: 228
• 

  Oracle Procedure record

  1. The so-called stored procedure (Procedure) is a set of SQL statements used to complete specific database functions. The set of SQL statements is compiled and stored in the database system. When in use, the user specifies the name of the defined stored procedure and gives the corresponding stored procedure

  2022-06-01 13:53:46 Views: 207
• 

  Summary of installation problems of MySQL5.7 source code

  Compile and install the mysql5.7 version, want to try out the new version features, found that there are some changes with the previous version 5.6 compilation, sum up to avoid further pit in the future. 5. 6 installation method cmake version 5. 7 compiling cmake requires a minimum version of 2. 8, currently 2. 8.

  2022-06-01 13:53:43 Views: 222
• 

  Introduction to Percona installation, configuration and Management of Linux platform _ MySQL Database Foundation and Project practice 05

  Introduction to Linux platform Percona installation, configuration and Management _ MySQL Database Foundation and Project practice 05 Video tutorial Learning address http://edu.51cto.com/course/12557.htmlOracle/MySQL number

  2022-06-01 13:53:43 Views: 267
• 

  Hbase Learning Notes 1 Mui-simple summary of script

  Recently, I have learned the relevant knowledge of hbase, and I have also taken a look at the scripts under the bin/ directory of hbase. I don't understand many of the details of the scripts. I have an understanding of the general outline. Make a summary of the study:. "$bin" / hbase-config.sh call script hbase

  2022-06-01 13:53:39 Views: 270
• 

  Is it possible to update Mysql slave?

  Recently, the platform has to be migrated. Due to the requirements of the business migration process, it is hoped that slave can not only ensure that the data of master can be synchronized to slave, but also hope that slave can be update. This requirement, as a DBA, is basically acceptable from the database level alone.

  2022-06-01 13:53:39 Views: 236