NAV: SLTechnology News&Howtos > Database >

• 

  Offline installation of PostgreSQL

  It is easy to install postgresql online, but in many cases, the server cannot be connected to the Internet and needs to be installed offline. Here are the steps for offline installation: 1. First of all, enter the official website: https://www.postgresql.org/2. Click Downloa

  2022-06-01 08:39:19 Views: 216
• 

  Problems encountered when sybase15 migrates the database

  When creating logical volumes, you first need to create pv pvcreate / dev/sdb, create pv, then start to create vg vgcreate vg_db / dev/sdb, create vg, and then start marking lv, that is, logical volume lvcreate-L 1.

  2022-06-01 08:39:19 Views: 223
• 

  MySQL data recovery full backup recovery and incremental recovery (take manual deletion database as an example)

  Data recovery schematic test environment MySQL5.51 first create a new database lampol data table testcreate database lampol;use lampol;create table test (id

  2022-06-01 08:39:11 Views: 300
• 

  Trove makes mysql5.5 Image based on centos7

  This document is to manually create the trove image of mysql5.5, the openstack version is newton1, create a basic virtual machine, log in to openstack to create a virtual machine, this virtual machine is used to create a trove image, and the root disk of the virtual machine will eventually be uploaded to

  2022-06-01 08:39:10 Views: 240
• 

  Redis cluster mode deployment (including networking and offline installation)

  System environment system version: CentOS 6.8x86x64 (for CentOS 7.*) gcc version 4.4.7 redis version: 4.0.8 installation method: source code installation redis package path: / opt/tools/ installation

  2022-06-01 08:39:10 Views: 252
• 

  Cmd imports dmp files of oracle data

  Having installed orcale earlier, import the database and start using it. The steps are as follows: set the system as sysdba login password for automatic expansion of the tablespace as the physical path to the data file of the empty query table SYSTEM tablespace, and the statement is SELE

  2022-06-01 08:39:07 Views: 287
• 

  ORA-600 kdsgrp1 error resolution case

  That morning, a database found an ORA-600 error Thu Feb 14 09:00:32 2019Errors in file / u01/app/oracle/diag/rdbms/xxxxdb/xxxxdb/t

  2022-06-01 08:39:07 Views: 221
• 

  Cloudstack problem record

  When you install CloudStack, three libraries, cloud, cloud_usage, and cloudbridge, are created. But after analysis, we found that only the cloud library is what we need. Common library tables in CloudStack: 1. Vm_instance

  2022-06-01 08:39:06 Views: 238
• 

  When logging in to sqlplus in Linux, user@SID is displayed

  Before setting up, login to sqlplus will have only one sql as shown below: our purpose is to display user@SID when logging in (instance name is masked, please understand) and find the directory: $ORACLE_HOME/sqlplus/admin to edit the file:

  2022-06-01 08:38:57 Views: 206
• 

  Recovery of oracle overwritten stored procedures for sharing of practical skills

  When writing or modifying a stored procedure, it is easy to encounter an accidental click to run, and the later code overwrites the previous stored procedure. How to recover, the quickest and most convenient way, flash query 1. Change the timestamp to create table h before overwriting

  2022-06-01 08:38:57 Views: 291
• 

  MySQL Index and transaction detailed explanation

  MySQL indexing and transaction detailed explanation 1. Preface ​ in the last chapter we explained the manual compilation and installation process of MySQL and the related database operation commands (sql statements). This paper will introduce the concept and principle of MySQL indexing and transaction in detail, and have a preliminary understanding of MySQL database view.

  2022-06-01 08:38:57 Views: 237
• 

  LVS load balancing Cluster-practical articles

  LVS load balancer cluster environment preparation: CentOS 7-1: scheduler, gateway (requires two network cards) outside: 12.0.0.1 inside: 192.168.200.1CentOS 7-2: website server (Apache) 192.168.200

  2022-06-01 08:38:45 Views: 207
• 

  Query Section of mongodb-query Selector

  Reference https://docs.mongodb.com/manual/reference/operator/query/ query selector: $eq matches a value equal to the specified value. $gt matches a value greater than the specified value. $gte match

  2022-06-01 08:38:44 Views: 224
• 

  OpenLDAP server installation and configuration

  1. OpenLDAP installation there are generally two ways to install OpenLDAP software under the environment of UNIX distribution operating system: one is to compile and install through the source code, and the other is to install it through the rpm software package that comes with the CD. These two installers are described below.

  2022-06-01 08:38:44 Views: 239
• 

  RDB and AOF of Redis

  1. Data snapshot RDB1.1 principle (1) RDB is to persist the data at a certain time to disk, which is a way of snapshot. (2) in the process of data persistence, redis will write the data to a temporary file until the persistence process is over.

  2022-06-01 08:38:44 Views: 292
• 

  Oracle ora-01578 ORACLE block corruption (file number 4, block number 840339)

  ORA-01578 is a kind of physical bad block / corruption of data block. Unlike logical bad / bad block, it usually appears with ORA-1110. Once ORACLE reads the damaged block, it will report Caused by: java.sql.SQLExc.

  2022-06-01 08:38:44 Views: 218
• 

  MySQL View, stored procedure and Storage engine

  MySQL View, stored procedure and Storage engine 1. The previous article on ​ has introduced the index and transaction of MySQL and the backup and recovery of MySQL. This article will describe the MySQL view, stored procedure and storage engine. II. MySQL view

  2022-06-01 08:38:40 Views: 279
• 

  Use PowerShell to call MTools to analyze MongoDB performance and send mail

  Use PowerShell to call MTools to analyze MongoDB performance and send a description of the problem: in the daily operation and maintenance of MongoDB, you often need to check the trend chart of the number of connections, slow queries, Overflow statements, connection sources. Solution: 1. Wi

  2022-06-01 08:38:38 Views: 253
• 

  Influxdb query write operation

  There are several ways to operate influxdb, there are scenarios where you like to write data in http API, or operate through influxdb terminals (my favorite type), each of which is suitable. Introduce how to operate through API interface and terminal: http://

  2022-06-01 08:38:34 Views: 225
• 

  Rapid construction of lamp in centos7 (separation of the three)

  CentOS 7, lamp (php-fpm); requirements: (1) the three are separated from three hosts; (2) one virtual host is used to provide phpMyAdmin; and the other virtual host is used to provide wordpress; (3) xcache.

  2022-06-01 08:38:31 Views: 293