NAV: SLTechnology News&Howtos > Database >

• 

  Percona-xtrabackup full and incremental backup and recovery

  Xtrabackup is a mysql database backup tool provided by percona. According to official introduction, it is also the only open source tool in the world that can hot standby innodb and xtradb databases. Its main characteristic is that the backup process is fast and reliable.

  2022-06-01 16:34:31 Views: 306
• 

  Insert data and add statements in MySQL data Table

  Each database has the function of adding, deleting, changing and querying, so let's briefly talk about the usage of MySQL INSERT statements. The INSERT INTO table MySQL INSERT statement allows you to insert one or more rows into a table (column1,column2

  2022-06-01 16:34:31 Views: 258
• 

  What is a subquery?

  When the result of a query is the condition of another query, it is called a subquery, and a subquery is another SELECT statement within the SQL statement. You can include children wherever it is an expression in the SELECT, INSERT, UPDATE, or DELETE command

  2022-06-01 16:34:31 Views: 262
• 

  Deploy user-defined Observer Coprocessor in Hbase0.98.4

  Hbase has supported Coprocessor (coprocessor) since 0.92, which aims to enable users to run their code on regionserver, that is, to move the computing program to the location where the data is located. This is similar to MapReduce.

  2022-06-01 16:34:27 Views: 206
• 

  Linux oracle 11g installation

  Centos6.5 64-bit basic server installation oracle11g_r2 64-bit author: Liu Meiqiu date: 2017.06.051, install dependency package # yum-y install gcc gcc-c++ make binu

  2022-06-01 16:34:27 Views: 287
• 

  Let's talk about LOAD and SOURCE.

  There are two main ways to import data in MySQL: LOAD and SOURCE. Let's take a look at the characteristics of both. The binary log format and the table structure used during the test are as follows: (root@localhost) [(none)] > SHOW V

  2022-06-01 16:34:26 Views: 250
• 

  ORA-07391: sftopn: fopen error, unable to open text file

  11G rac the pfile error of the database created by spfile is as follows: SQL > create pfile='/u01/inittips1.ora' from spfile;create pfile='

  2022-06-01 16:34:26 Views: 212
• 

  Migration and Integration of redmine and testlink

  Redmine migration (redmine uses bitnami redmine one-click installation, the environment is apache+mysql+php) install bitnami redmine in the new environment with one click. After installation, perform the following actions: 1.

  2022-06-01 16:34:15 Views: 252
• 

  Mongodb is reinstalled under debian

  Shell > aptitude search mongodbi mongodb-An object/document-oriented database (metapackage) I mongodb

  2022-06-01 16:34:14 Views: 284
• 

  Oracle modifies db_name method

  -the method of modifying database db_name SQL > startup mountORACLE instance started.Total System Global Area 413372416

  2022-06-01 16:34:14 Views: 276
• 

  Analysis of message queuing application scenario

  Distributed message service DMS is a fully hosted high-performance message queuing service, which provides normal queue, ordered queue, Kafka, ActiveMQ, RabbitMQ, compatible with HTTP, TCP, AMQP protocols, and provides flexible and reliable asynchronous communication mechanism for distributed applications.

  2022-06-01 16:34:02 Views: 280
• 

  Practical Mariadb galera Cluster cluster architecture

  Mariadb galera Cluster installation: operating system: Centos7.4 version number of clusters: 3 node host information: 192.168.153.142 node1 selinux=disabled firew

  2022-06-01 16:33:55 Views: 205
• 

  Oracle11g entire DB migration

  Instance name: PCBMES migrates the oracle11gr2 database under / oracle_ebs/pcbmes/db to the / ebs/pcbmes/db directory. Preparation 1. Create a pfile file (DB starts using spfile

  2022-06-01 16:33:55 Views: 301
• 

  WMY 6-2 configure SQL Server database

  After installing the database, enter the database from the start menu. Login database prompt: you can open the SQL agent here, right-click to open the agent. As shown in the following figure, expand the database, add the database here, and add it according to the actual needs. (the figure shows that the Vmware VDI environment should

  2022-06-01 16:33:55 Views: 222
• 

  Mysql deletes the table from the command line

  Mysql deletes Table 1 from the command line. Syntax: DROP TABLE IF EXISTS table name; 2. Syntax parsing: DROP TABLE: delete the table command IF EXISTS: determine whether the table exists, if there is to delete the corresponding table, if not save

  2022-06-01 16:33:45 Views: 280
• 

  Zabbix- Historical data Clean sql

  Mysql Historical data Clean sql:truncate table history_log;truncate table trends_uint;truncate table trends;truncate

  2022-06-01 16:33:42 Views: 270
• 

  Easy to learn about database transactions

  The title index transaction function transaction process isolation level example verifies that the transaction function transaction is a function to ensure the integrity of the data in the database system, such as the payment service in the Internet industry, no matter what the server is abnormally interrupted for whatever reason, the customer either pays successfully or does not pay successfully, the amount of the database will be paid successfully.

  2022-06-01 16:33:42 Views: 223
• 

  Mycat read-write separation and library disassembly table comprehensive experiment 1:mysql master-slave and garela cluster environment preparation

  Data Planning: Haproxy Cluster haproxy01 node127 192.168.31.127haproxy02 node128 192.168.31.128Mycat Cluster mycat01 node11

  2022-06-01 16:33:37 Views: 217
• 

  11gr2 environment imp import reports IMP-00051 and IMP-00008 errors

  Today, the customer encountered the following error message IMP-00051: Direct path exported dump file contains illegal column lengthIMP when importing data from imp

  2022-06-01 16:33:37 Views: 220
• 

  Goldengate ERROR OGG-01296 Error mapping from

  When dealing with goldengate data synchronization, the source side is out of sync with the target side, which may be due to different table structure, data and indexes. The problem is still found after importing all the tables from the source side to the destination side (ERROR OGG-01296 Error mapping fr

  2022-06-01 16:33:37 Views: 253