NAV: SLTechnology News&Howtos > Database >

• 

  Exchange server 2010 database display failed and shelved

  [failure phenomenon] [solution] after viewing, it is due to the difference in the number of log replication between the master database and the slave database. After enabling the log cycle feature in the database setting, the database is re-mounted and the database replication status returns to normal.

  2022-06-01 06:49:04 Views: 253
• 

  Installation and configuration of Oracle 11g RAC One node

  1. Introduction to RAC One Node 1. Rac one node database can be converted into RAC database, and the conversion process can be online without stopping the RAC one node database; 2. Rac one node can create multiple rac on

  2022-06-01 06:49:01 Views: 269
• 

  Wanli (pick one) open source GreatDB and other introduction

  Wanli Open Source continues to enrich its own product line, and has successively launched a series of stand-alone database management systems (GreatDB), distributed database management systems (GreatDB Cluster) and security databases (Grea).

  2022-06-01 06:49:00 Views: 263
• 

  Design and implementation of distributed temporal Database QTSDB

  The existing open source time series database influxdb only supports stand-alone operation. When faced with a large number of data writes, there will be slow query, high machine load and single machine capacity limitations. In order to solve this problem, the infrastructure team developed a cluster version on the basis of stand-alone influxdb.

  2022-06-01 06:48:56 Views: 202
• 

  Use BBED to understand block structure

  There are two main types of Oracle data blocks: file header blocks and data blocks. Let's first introduce the data block: the data block is simply divided into the following layers: BBED > set dba 1Magne58914 DBA 0x0040e

  2022-06-01 06:48:52 Views: 263
• 

  Mysql RSA private key file not found

  Install mysql error [Note] RSA private key file not found: / db/mysql5.6/data//private_key.pem. Some authenticat

  2022-06-01 06:48:51 Views: 289
• 

  PXC+haproxy+keepalived environment building

  Environment preparation: three-node PXC. For deployment process, please see: http://blog.itpub.net/30135314/viewspace-2219505/192.168.8.51192.168.8.52192.168.8

  2022-06-01 06:48:48 Views: 270
• 

  MHA practice of MySQL High availability Architecture

  This article mainly describes the highly available rapid deployment steps of MHA and the simple use of command 1, download and install package mha dependency package: http://rpm.pbone.net/index.php3perl-DBD-MySQLperl-Config-

  2022-06-01 06:48:48 Views: 242
• 

  Use these 3 TDPO utilities to troubleshoot IBM TDPO backup and connection issues

  IBM Tivoli Data Protection for Oracle provides 3 utilities to troubleshoot the problems or issues fa

  2022-06-01 06:48:48 Views: 225
• 

  ORA-00119&ORA-00130& Hostnam

  Today, when restoring a test database, use pfile to start the database instance after deleting the original library file, and always report an error: SQL > startup nomount pfile='?/dbs/test.txt'ORA-00119: inva

  2022-06-01 06:48:47 Views: 224
• 

  [cloud and Enmo] performance optimization: rational configuration of large memory pages (HugePage) in Linux environment

  Original 2016-09-12 Xiong Jun [Yunhe Enmo] performance Optimization: rational allocation of large memory pages (HugePage) Xiong Jun (Lao Xiong) General Manager of Xiong Jun (Lao Xiong) Cloud and Enmis District General Manager Oracle ACED,ACOUG core member PC Server Development

  2022-06-01 06:48:43 Views: 302
• 

  Percona 5.7Open gtid

  # # configure gtid_mode=on enforce_gtid_consistency=on to enable automatic lookup node replication of Gtid from the library: stop slave; change master to master_

  2022-06-01 06:48:42 Views: 202
• 

  Ctrip's Road to Dubbo

  This article is based on Dong Yiquan's speech at Dubbo Community developer Day in Shanghai. Why did Ctrip introduce Dubbo in the first place? In fact, since the end of 2013, Ctrip has mainly used the SOA micro-service framework based on the HTTP protocol. This

  2022-06-01 06:48:42 Views: 260
• 

  Several problems of mysql5.7

  1) shutdown of mysql5.7: for mysql installed in rpm mode on centos 7, systemctl stop mysqld.service / service mysqld stop must be used to close it.

  2022-06-01 06:48:42 Views: 289
• 

  Online environment MySQL5.5 upgrade to 5.6

  This paper mainly records the process of upgrading the online environment percona5.5.35 to 5.6.32-78.0. Welcome to reprint, please indicate the author and source. Author: Zhang Zheng blog: http://space.itpub.net/26355921

  2022-06-01 06:48:42 Views: 232
• 

  Explain the election mechanism of MongoDB in an easy-to-understand way

  If the primary node goes down or fails, the other nodes will choose a new primary node. The election process can be initiated by any non-master node, and then a new master node can be elected according to the priority and Bully algorithm. Until the primary node is elected, the entire cluster service is read-only and cannot perform write operations

  2022-06-01 06:48:41 Views: 234
• 

  On the role of MYSQL flush table

  The level of function of MYSQL flush table is limited and needs to be learned. If there are any mistakes, please correct them. First give the official document:? FLUSH TABLESCloses all open tables, forces all ta

  2022-06-01 06:48:41 Views: 225
• 

  Sql server's handling of dates

  The following is the SQL date interception & SQL Server date comparison date query commonly used statements select CONVERT (varchar, getdate (), 120,120) 2004-09-12 11:06:08selec

  2022-06-01 06:48:41 Views: 218
• 

  MySQL optimization guidelines that veteran drivers must also master

  When the number of MySQL records in a single table is too large, the performance of adding, deleting, modifying and querying will decline sharply. This article will provide some optimization references. You can refer to the following steps to optimize. Single table optimization unless the single table data will continue to rise in the future, do not consider splitting in the first place, split will lead to logic, deployment,

  2022-06-01 06:48:33 Views: 215
• 

  Can't open and lock privilege tables: Table & # 039 witch mysql.username contacts 039; doesn't exist

  [root@szq scripts] # service mysqld startStarting MySQL..The server quit without updating PID file (/

  2022-06-01 06:48:33 Views: 215