NAV: SLTechnology News&Howtos > Database >

• 

  Rapid Construction of redis single Point Database

  Redis installation and configuration 1. Environment: 1. System version [root@c700001 ~] # cat / etc/redhat-release CentOS Linux release 7.4.1708 (Core)

  2022-06-01 21:53:33 Views: 237
• 

  Xtrabackup-24-2.4.15 installation notes

  [root@mysql01 soft] # rpm-ivh percona-xtrabackup-24-2.4.15-1.el6.x86_64.rpmwarning: percona-xtraback

  2022-06-01 21:53:33 Views: 231
• 

  Detailed explanation of MySQL log

  The preface MySQL log records the daily operations and error messages of the MySQL database. MySQL has different types of log files (each stores different types of logs). From the logs, you can query the operation of the MySQL database, user operations, error information and so on. MyS

  2022-06-01 21:53:09 Views: 216
• 

  The business involved in MongoDB is slow-- slow query optimization analysis case-- and parameter description.

  Description: the optimization case is intended to express the need to understand the meaning of each parameter, combined with business analysis and logical implementation, as well as how to select the index and column order (not described here). The environment describes: MongoDB version 3.0.9, replica set 3 nodes, memory 64GB cp.

  2022-06-01 21:53:03 Views: 210
• 

  10 necessary MySQL questions for interview

  MySQL affairs is a question that we are often asked when we interview middle and senior developers. Although many people often write fluently with MySQL,SQL sentences, they always don't know where to start when they are asked these questions during the interview. Let's take a look at what MyS is.

  2022-06-01 21:53:03 Views: 201
• 

  CentOS 6.8 system installs Oracle 12.1.0.2.0 database

  Resources to prepare a host that has installed the CentOS 6.8x86x64 system, you need to install the desktop environment and Firefox browser. If only the command line environment is installed, after configuring the yum source, use the command yum groupinstall "Desktop

  2022-06-01 21:53:03 Views: 261
• 

  Sybase uses bcp for single table backup and recovery

  The common data backup format is: bcp dbname..tablename out c:\ temp\ filename-Usa-Ppassword-Sservername-c, where dbname is the database name

  2022-06-01 21:53:03 Views: 281
• 

  How to check whether the current CRS is in enable or disable

  The following document information comes from the official MOS documents. After detailed testing, it is confirmed that CRS starts from 10g by default when the operating system starts. Sometimes, in order to facilitate maintenance operations, we generally prohibit CRS from booting itself with the operating system, whether 10g or 11g Oracle.

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

  Skype for Business Server 2015 backend database configuration mirror witness (mirroring witness)

  In the early deployment of Skype for Business Server 2015, 2 backend databases were used and mirroring was used, and the witness database was not configured. When the primary database is down, the database needs to be migrated manually. Now, the witness database is configured to achieve automatic failover. 1. Ann

  2022-06-01 21:52:48 Views: 236
• 

  Take Zhang Zhidong & lt; Chinese and Western shaping & gt; to rehearse & lt;Java/Hbase + Centrgt; Cloud platform Architecture thinking

  As I have long-term project cooperation with Japanese IT industry, sometimes working in Barcelona, Spain (or Tokyo, Japan), I like to study the naval warfare of the Spanish Armada, including things related to the Sino-Japanese War (because it is closely related to the Taiwan where I was born). For example, it was defeated in the Sino-Japanese War.

  2022-06-01 21:52:41 Views: 279
• 

  Data is inserted with special characters & and followed by characters that are mistaken for variable names (inser

  Please check your SQL when the following error occurs. There must be a special character & in the value. If it's useless, delete it directly, and if it's useful, you need to deal with it (the default insert value with a & symbol followed by a string will be mistaken for a variable name). How to deal with it (meaning to

  2022-06-01 21:52:38 Views: 223
• 

  GoldenGate delete all Trail files and restore

  Today, when cleaning the Trail files of GoldenGate, all of them were accidentally deleted, resulting in the suspension of the EXTRACT process on the source side of GoldenGate and unable to start. 1. Delete the EXTRACT process of the source-side database: GGSCI (crm_mas

  2022-06-01 21:52:37 Views: 276
• 

  Hbase connects to external ZK

  Hbase is installed today, in order to share ZK with kafka, etc., so there is no Hbase with ZK. As a result, the pit appears. After Hbase configuration is completed, the log is as follows: Java HotSpot (TM) 64-Bit Server V

  2022-06-01 21:52:37 Views: 212
• 

  HBase installation configuration

  1. Download the hbase installation package http://www.apache.org/dyn/closer.cgi/hbase/2, and put hbase-1.0.1.1-bin.tar.gz in the folder of your choice, such as / roo

  2022-06-01 21:52:37 Views: 224
• 

  The creation of Oracle synonyms

  Create a public dblink. Create public database link test_link connect to csservicedb identified by huawei12

  2022-06-01 21:52:37 Views: 271
• 

  Getting started with HBase

  Create a table: hbase (main): 005info 0 > create 'users','info', where info is a column family of the users table, and the table in HBase must have at least one column family. HBase did not mention any columns when creating the table

  2022-06-01 21:52:37 Views: 281
• 

  Continuous overdue

  IF EXISTS (SELECT FROM SYS.TABLES WHERE NAME='SPD') DROP TABLE SPD;WITH CTE1 AS (SELECTIIF (PD_DueDT > = I

  2022-06-01 21:52:36 Views: 263
• 

  MyCat startup error: java.net.UnknownHost

  Environment: Mycat-server-1.6.6.1-releaseLinux environment, linux hostname myvmhost-1, MyCat startup error messages are as follows (log file logs/wrapper.log): Launc

  2022-06-01 21:52:36 Views: 265
• 

  Postgresql replication referenc

  1. Create a replication user: CREATE USER repl WITH replication login password 'repl';2. Edit the recovery file: cat / pgdata/10/data/

  2022-06-01 21:52:36 Views: 205
• 

  SQL Server modifies the inside of the table structure

  The inside story of modifying a table structure not all ALTER TABLE changes require SQL Server to change each row when the ALTER TABLE command is used. SQL Server can execute ALTER TABLE command 1. 1 in three basic ways.

  2022-06-01 21:52:36 Views: 216