NAV: SLTechnology News&Howtos > Database >

• 

  Automatic initialization of SQL Server 2017 AlwaysOn AG (9)

  SQL Server VDI backup principle Analysis SQL Server provides a virtual device interface (VDI) API to help independent application providers support the integration of SQL Server backup and recovery operations into their products. These API settings

  2022-06-01 10:52:50 Views: 211
• 

  HBase client FAQ org.apache.zookeeper.client.ZooKeeperSaslClient

  An error occurred when linking HBase with HBase client today. There are two errors as follows: 1. Org.apache.zookeeper.client.ZooKeeperSaslClient: SecurityException:

  2022-06-01 10:52:20 Views: 242
• 

  SQL Server data Automation Operation and maintenance

  SQL Server data automation operation and maintenance staff talked about the current database types, which are mainly popular Mysql, Sql Server, Oracle and so on. I believe we are already very familiar with the differences, so we will not introduce them here. Today, we will mainly introduce my recent

  2022-06-01 10:52:20 Views: 301
• 

  Oracle11gR2 installation tutorial

  ORACLE 11g R2 detailed installation instructions directory 1, environment description.

  2022-06-01 10:52:20 Views: 224
• 

  Errors encountered in installation and compilation of keepalived source code

  Install some dependency packages first. We can not go to-y here so that we can see how many dependent packages there are in the software to be installed, which are install and which are updateyum install kernel-devel openssl-de.

  2022-06-01 10:52:16 Views: 203
• 

  How to set the default editor of sqlplus under Linux to Vi (I use Oracle Linux 5.4 here)

  This method is to refer to one of the ITPUB forums to take notes, but also to share with you, convenient to use later, hehe method 1: su-oracle to edit Oracle users under the directory. Bash_profile to add export to it.

  2022-06-01 10:52:08 Views: 284
• 

  Oracle uses a BUG of the cast () function

  Today, I accidentally found a small problem when using Oracle, that is, when using the cast function to convert types, the text was truncated. It is now posted as follows: Select Cast ('unfilled' As Nvarchar2 (16)) As Hg F

  2022-06-01 10:52:08 Views: 217
• 

  Interceptor+Cookie is used in SpringMVC to realize automatic login within a certain number of days.

  A brief introduction this article mainly introduces: how to use Interceptor+Cookie in SpringMVC to achieve automatic login within a certain number of days. At the same time, it also introduces that "if the verification fails, jump to the login page and log in after entering the user name, password, etc."

  2022-06-01 10:51:48 Views: 286
• 

  Materialized view

  Example: DROP MATERIALIZED VIEW MV_YYJL;CREATE MATERIALIZED VIEW MV_YYJLUSING NO INDEXREFRESH FAST ON COMM

  2022-06-01 10:51:47 Views: 236
• 

  Use Docker manual & redis-trib.rb side

  The problem of redis Sentinel + Master-Slave assumes that we have configured 200 GB of memory on a master-slave machine, but when the business requirement is 500G, the master-slave structure + Sentinel can achieve high availability failover + redundant backup, but it can not solve the problem of data capacity. Use Sentinel, redis

  2022-06-01 10:51:38 Views: 279
• 

  [SQL SERVER] SQL statement queries listed libraries and tables

  First, list database 1. List all libraries use master;goselect name,dbid from master.dbo.sysdatabases2. Only the user library use master;goselect is listed

  2022-06-01 10:51:37 Views: 275
• 

  MYSQL (4) query performance optimization

  Optimize data access 1. Whether to request an unwanted data solution from the database: a. Add limitB after query. Write the required column after Select instead of * 2. Whether to scan additional data database access speed from slow to fast: full table scan, index scan, range scan

  2022-06-01 10:51:35 Views: 303
• 

  Detailed explanation of oracle12c installation

  The recommended installation conditions for oracle12c installation are: 4G memory, 8G swap partition, and no less than 20g installation directory. Download the software package on the official website: https://www.oracle.com/downloads/index.html 1. Turn off fire prevention

  2022-06-01 10:51:05 Views: 294
• 

  DG ora-ORA-16016 error

  The slave library cannot be opened: SQL > alter database open;alter database open*ERROR at line 1:ORA-10458: standby database requ

  2022-06-01 10:51:05 Views: 261
• 

  Redis cluster

  Redis Cluster basic introduction Redis cluster is a facility installation that can share data among multiple Redis nodes. Redis clusters do not support Redis commands that need to process multiple keys at the same time, because executing these

  2022-06-01 10:51:05 Views: 237
• 

  [MongoDB] Spring Data Mongo

  Spring Data Mongo notes

  2022-06-01 10:51:02 Views: 228
• 

  How do the three databases obtain the records from m to n in the table (n is greater than m)

  1. Oracle database: (note: tableName.id refers to the primary key of tableName) select * from (select tableName.*,rownum as con from table

  2022-06-01 10:51:01 Views: 260
• 

  Synchronization and Separation of MySQL Master and Slave

  Description: in the actual production environment, if the read and write of the database are all operated in the same database server, no matter in terms of security, high availability, or high concurrency, it can not meet the actual demand at all. Therefore, generally speaking, the data is synchronized by master-slave replication.

  2022-06-01 10:50:31 Views: 257
• 

  Group_replication_member of the MGR parameter

  First, environment MGR 8.0.17 three nodes, roidb1, roidb2, roidb3II, test 1, default group_replication_member_weight=502, set the weight of roidb2 to 100se

  2022-06-01 10:50:31 Views: 292
• 

  Installation and configuration of Postgresql9.6.6 under Centos6.6

  First, the environment introduces the system platform: CentOS release 6.6 (Final) Postgresql:postgresql-9.6.6SELINUX=disabledIptables shuts down 2, the installation process 1. Installation

  2022-06-01 10:50:30 Views: 237