NAV: SLTechnology News&Howtos > Database >

• 

  MariaDB Galera Cluster deployment practice

  Official document: the working principle of http://galeracluster.com/documentation-webpages/index.html I and Galera Cluster is mainly concerned with data consistency. Business

  2022-06-01 15:38:10 Views: 252
• 

  Two interesting REDO LOG ERROR processing methods

  Two interesting REDO LOG ERROR processing methods system environment: operating system: AIX-5300 database: Oracle 10g (10.2.0.1.0) case description: database (archive mode) non-current log group is destroyed, but due to the destruction mode

  2022-06-01 15:38:10 Views: 298
• 

  How to get started with MongoDB (2)

  3. The matching of null's processing null in the query is interesting: null matches not only documents where the value of the specified key is indeed equal to null, but also documents where the key specified by the query does not exist. For example, insert the following three documents: > db.users.ins

  2022-06-01 15:38:10 Views: 201
• 

  Zabbix3.4.12 web page shows an exception

  Environment: OS:rhel6.9zabbix:3.4.12MySQL:8.0.11 's inability to read database information caused the web interface to display an exception into the query because groups was used as a reserved word after the MySQL8.0.2 version, resulting in information about group

  2022-06-01 15:38:07 Views: 260
• 

  Execution plan related to bitmap index

  Bitmap index is another type of index in oracle database besides B-tree index. It is mainly used in data warehouse or DSS system. In data warehouse or DSS systems, bitmap indexing is much faster than B-tree indexing for some types of sql, which is mainly implemented by bitmap indexing.

  2022-06-01 15:38:07 Views: 282
• 

  Oracle creates users, tablespaces, and empowers

  -- create tablespace create tablespace test_tpsdatafile 'D:\ app\ Administrator\ oradata\ orcl\ test_tps.dbf'size 1500m

  2022-06-01 15:38:06 Views: 266
• 

  Log in to plsql and report an error the account is locked-user is locked

  Log in to the database server and enter the oracle user [root@uumsnormal-oracle admin] # su-oracle [oracle@uumsnormal-oracle ~] $sqlplus

  2022-06-01 15:38:06 Views: 223
• 

  Oracle data import and export

  I am the new of Oracle, and that i need to learn more about it. But as you know, here is the comp

  2022-06-01 15:38:06 Views: 282
• 

  Construction of mongoDB replica set

  About the environment 192.168.1.151 FedoraServer is used as the master library of the replica set. There is already a data 192.168.1.152 FedoraServer slave database and an empty instance 192.168.1.153 FedoraSe

  2022-06-01 15:38:03 Views: 290
• 

  Patch Oracle single instance

  1. Update opatch package 1.1 chown oracle.oinstall p6880880_112000_Linux-x86-64_opatch.zip1.2 unzip p6880880 11200

  2022-06-01 15:38:02 Views: 302
• 

  Advanced MySQL Database (1)-- data Integrity

  MySQL Database Advanced (1)-data Integrity 1, data Integrity introduction 1, data Integrity introduction data redundancy refers to the existence of some duplicate data in the database, data integrity means that the data in the database can correctly reflect the actual situation. The integrity of data refers to the reliability and accuracy of data.

  2022-06-01 15:37:58 Views: 238
• 

  Oracle tablespace data file movement

  Oracle tablespace data file movement system: windowsoracle:10g implements moving data files in user tablespaces from a certain path to a path. 1. Case tablespaces of oracle for non-system tablespaces that can be offline (E)

  2022-06-01 15:37:58 Views: 283
• 

  DB2 SQL Replication configuration method

  Replication Server products include SQL replication and Q replication. Compared with SQL replication, Q replication data transmission technology with the help of IBM queue mechanism, thus improving the efficiency and reliability of data transmission, can achieve repeat per second.

  2022-06-01 15:37:53 Views: 274
• 

  [n version] openstack-- basic Environment preparation (2)

  [n version] openstack-- basic environment ready I. version evolution version name version date contains component code name Austin2010-10-21 Nova Magi SwiftBexar2011-02-03 Nova Magi Swift Glanc

  2022-06-01 15:37:47 Views: 297
• 

  Sql is injected into junior high school learning.

  The following three documents are easy to understand about SQL injection. Organize the collection of * Web articles-SQL injection * * Elementary: http://bbs.ichunqiu.com/thread-9518-1-1.html******We

  2022-06-01 15:37:46 Views: 206
• 

  Tencent Technical Engineering | Tencent's only time series database: CTSDB decryption

  Background: with the rapid development of the Internet, the rapid expansion of big data and the rapid rise of the Internet of things, we find that most of the data in life and work are gradually related to time. For example, the real-time steps of the Wechat movement, the daily closing price of the stock, the device status of sharing bikes, and so on. In order to store these and

  2022-06-01 15:37:20 Views: 272
• 

  How to execute PHP code for a string

  Recently, due to the needs of the project, led to a topic: how to execute string php code (php and html mixed). Note: traditionally, php code is stored in a file and can be run directly. In the case discussed below, if the php code is obtained from the database, such as

  2022-06-01 15:37:19 Views: 293
• 

  Redis common operation commands

  Connection related: redis-cli-h-p shutdown # close redis-cli [- c if cluster needs to add this parameter]-h-p # connection. If authentication connection is enabled, you need to enter AUTH before you can perform subsequent operations and help after connection.

  2022-06-01 15:37:19 Views: 268
• 

  Python3 removes Excel blanks

  [environment] under Windows 10, Python 3.6, using third-party package openpyxl. [config.ini] [config]; Excel file name XlFile=D:\ test\ test.xlsx

  2022-06-01 15:37:19 Views: 246
• 

  Postgres 9.6.5 rebuild Control Fil

  The parameters of the new version of pg_resetlog have changed. Before looking for Dege's article on the Internet, I looked at the method of rebuilding the control file, and then compared the actual change parameters to make it easier for everyone to solve the problem. Postgresql9.2Options:-l

  2022-06-01 15:37:19 Views: 279