NAV: SLTechnology News&Howtos > Database >

• 

  Tracking and handling of failure of to-do data on integrated mobile platform (Mongodb, Oracle, SQLServer)

  Integrated mobile platform to do data failure tracking and processing Mongodb, Oracle, SQLServer scenarios: the company's integrated mobile platform backstage core database uses Mongodb read-write separation architecture, all heterogeneous system platforms (Finance, E)

  2022-06-01 06:05:40 Views: 222
• 

  DOCKER application

  Https://yq.aliyun.com/articles/40494?spm=a2c4e.11153940.0.0.2e933068PIF5zPhttps://yq.aliyun.com/arti

  2022-06-01 06:05:39 Views: 293
• 

  Oracle asm disk is formatted as a ntfs file system

  Database instance log: Tue Mar 01 12:18:12 2016SUCCESS: diskgroup ORADISKGRP1 was dismountedSUCCESS: diskgroup ORAD

  2022-06-01 06:05:36 Views: 286
• 

  What's New in Oracle 12C-RMAN recovery Table

  What's New in Oracle 12C-RMAN recovery Table how does oracle recover single table data? Scenario 1: simple processing and fast recovery 1 if the table has been delete, update, insert, and has been commit

  2022-06-01 06:05:31 Views: 287
• 

  Case-percona-online-schema-change various pits

  Online environment replication uses ROW mode. For hundreds of millions of tables, using pt online schema change to copy data from old tables to temporary tables will generate a large amount of binlog, which will cause master-slave delays before pt toolkit 2.1. pt

  2022-06-01 06:05:30 Views: 239
• 

  Child query of Oracle Notes

  Subquery when one of our operations needs to be demerited based on another query, then the query executed first is the subquery subquery is divided into: single row single column subquery: the result of the query has only one row, and there is only one field, multiple rows, and single column subquery: the result of the query has multiple rows, but only one column, multiple rows, and multiple columns.

  2022-06-01 06:05:30 Views: 223
• 

  Oracle table moves tablespace

  In oracle, you sometimes need to move tables to other tablespaces. Here are the steps to move them. First, use the following command to move: alter table table_name move tablespace tablespace_name

  2022-06-01 06:05:25 Views: 285
• 

  Teach you to write service discovery using zookeeper with your bare hands

  Zookeeper is a strongly consistent [lax] distributed database, which consists of multiple nodes to form a distributed cluster. If any node is hung up, the database can still work normally, and the client does not perceive failover. The client writes data to any node, and the other nodes can immediately

  2022-06-01 06:05:25 Views: 310
• 

  Summary of new features of Oracle 11gASM

  one。 ASM Fast Mirror resynchronization (ASMFast Mirror Resync) 1.1 No ASM Fast Mirror resynchronization whenever ASM is unable to write to an area allocated to a disk, it takes the disk offline and writes at least on other disks

  2022-06-01 06:05:03 Views: 302
• 

  Analysis of explain output column results of MySQL execution Plan

  1) id: the identification of each operation performed independently, indicating the order in which the object is operated; if the id value is large, it is executed first; if the same, the execution order is from top to bottom. 2) select_type: the type of each select clause in the query; 3) table: name, by

  2022-06-01 06:05:03 Views: 294
• 

  After years of silence, SQL is making a comeback

  Https://www.enmotech.com/web/detail/1/861/1.html introduction: after years of silence, today's SQL is making a comeback. What's the reason? What impact does this have on the data community? Take a look at the analysis of this article

  2022-06-01 06:04:57 Views: 308
• 

  11g use incremental backups to perform cross-platform transfer tablespaces to reduce downtime (xtts_rman)

  The downtime required to migrate data using cross-platform transport tablespaces is proportional to the amount of data being migrated. However, when using incremental backup for cross-platform migration, the downtime required to migrate data can be significantly reduced. The main steps of traditional cross-platform transfer tablespace: 1. Empty the transferred table in the source database

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

  The method of finding large Files in linux system

  Http://blog.csdn.net/bobo0915/article/details/51980650 can use the following command to find out which folder in the system has a problem, and then look at it layer by layer to find out which file it is. The command is first.

  2022-06-01 06:04:54 Views: 226
• 

  Jutoh for Mac (e-book production software) v2.96.14 Chinese active version

  Jutoh For Mac is an advanced and reliable eBook authoring software application that allows you to create a popular e-book format text editor from Jutoh templates, or to create your own cover design with a built-in cover editor. Jutoh for Mac download

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

  [Mysql] MHA configure virtual ip

  Virtual ip elegant speaking of Failover, there are usually two ways: one is the virtual IP address, and the other is the global configuration file. MHA does not limit which method to use, but allows users to choose. The way of virtual IP addresses will involve other software. I will not repeat the previous article here.

  2022-06-01 06:04:53 Views: 281
• 

  Zabbix3.0 installation (based on Ubuntu14.04)

  1. Environment preparation 1. Zabbix Monitoring system Service 1.1, VMServer02 operating system: Ubuntu 14.04IP address: 192.168.1.201 related components: zabbix, php, nginx/ Apache II, V

  2022-06-01 06:04:37 Views: 264
• 

  MySQL ERROR 1227 (42000) under Mac: Access denied; you need (at least one of)

  MySQL under Mac (with only one library) AC-IT002deMacBook-Pro:bin ac-it002 $mysql-u root-pEnter password:Welcome to the

  2022-06-01 06:04:37 Views: 212
• 

  PostgreSQL Source Code interpretation (191)-query # 107 (aggregate function # 12-agg_retrieve_direct)

  This section continues to introduce the implementation of the aggregate function, mainly introducing the implementation of the aggregate function without using the Hash algorithm, in which case it will sort first and then perform the aggregation, and the sorting operation has been completed before the execution of the ExecAgg node. The following describes the implementation of aggregation when sorting has been completed, the main

  2022-06-01 06:04:36 Views: 217
• 

  Oracle undo management

  Before http://blog.csdn.net/xujinyang/article/details/6822971 starts, let's think about a few questions. 1. How does the ora-01555 error occur? Is there any way to solve it?

  2022-06-01 06:04:36 Views: 286
• 

  Decompress and start MySQL

  Install MySQL. After decompressing zip, first rename my.default.ini to my.ini and put it in the root directory my.ini by adding basedir = D:\ mysql_test\ mysql-5.7.17-masterdat

  2022-06-01 06:04:36 Views: 235