Database Administrator

Top data recovery skills: how to restore garbled files? What should I do if the data recovery file is garbled? Top data recovery software restores data based on different types of deleted files. It extracts all files suspected to be deleted from

MySQL Binary Package update MySQL 5.7 With mysql_upgrade MySQL is usually deployed using binary packages. Therefore, when you upgrade MySQL, You can decompress the latest MySQL package to basedir, of course, if MySQL does not have any data, you can

Install Redis and MongoDB in CentOS 7 The previous article recorded Node. js. This time we talked about installing Redis and MongoDB in CentOS 7, so we basically installed the entire development environment of Node. js.Redis Installing apsaradb for

Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19)Oracle 10g R2 RAC manual patching PSU (10.2.0.5.19) I. Preparations 1. database environment Operating system version: RedHat 5.8x64Database Version: Oracle 10.2.0.5 x64 RACCluterware: 10.2.0.5Oracle

Why cannot I enable ADG for Oracle 11g slave database? Today, we have encountered a strange problem, but there is an essential cause and effect behind the strange phenomenon.During an Environment check in the afternoon, it was found that the standby

Oracle RMAN backup-control file backup Go to the RMAN page Rman target/ RMAN> Change the backup mode of control files to automatic backup RMAN> configure controlfile autobackup on; Check whether the backup of the control file is automatic

2015 annual selection of open-source large inventory: Science This year is a very fruitful year for open-source science. Opensource.com published a series of articles about how open source Science plans change the current research methods,

Node. js nano library to process couchdb: timeout required I want to use the nano library. I used db. search/db. get/db. destroy/db. insert, but there is no way to add timeout. Many async functions can pass the callback as a parameter. I don't want

Use the AWK tool in Cygwin to view mysql binlog logs Linux tools are really powerful. However, as a person who does not have the right to use Linux machines or who does not use Linux for development, it is really inconvenient to use some commands, a

PostgreSQL export data dictionary documentation You need to sort out the data dictionary documents of the current database on the project. The project is not standardized. Such documents should be supplemented later. Each field in these tables is

In the SQL statement ---- delete table data drop, truncate, and delete usage, droptruncate Reprinted from: http://www.cnblogs.com/1312mn/p/4422396.html I. SQL syntax 1. drop table name eg: drop table dbo. Sys_Test2. truncate table name eg: truncate

Use Amazon Machine Learning and Amazon Redshift to establish a binary classification model, amazonredshift Most of the decisions in daily life are in binary format. Specifically, such questions can be answered by "yes" or "no. There are also many

Null and SQLnull in SQL A summary of null in Oracle SQL is as follows:1.1 null The null value is still null. Null is an unallocated, unknown, or not applicable value. Ø null is neither 0 nor a space.  1.1.1 null Value Calculation The result of the

PL/SQL-related data dictionary and plsql-related dictionary Data Dictionary related to PL/SQLHttp://www.oracle.com/technetwork/issue-archive/2012/12-nov/o62plsql-1851968.html Sometimes, we encounter the following problems during PL/SQL development:1

Optimization of SQL massive data query and non-use like processing solutions, data query like 1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid

Sort goldengate parameters and goldengate ParametersManager parameter: AUTOSTART: Specifies the processes automatically started when mgr starts. autostart er * AUTOSTART extract extszAUTORESTART: Specifies the processes that can be restarted

Report example -- use Jasper report to implement MongoDB join and jaspermongodb Diverse data sources are common issues in report development. However, it is difficult to use report tools such as JasperReport to handle them. For example, the results

Data cleansing Note: string to date: the problem caused by timestamp; note to attract Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. You must specify the source when you repost them. Otherwise, you have the

Mydumper's. metadata file is missing, mydumper. metadata To migrate MySQL Data today, decompress the file backed up by mydumper and import it through myloader. However, this error occurs at the import time: ** (Myloader: 766): CRITICAL **: the

What is the difference between MyISAM and InnoDB Storage engine? myisaminnodb Storage 1. MyISAM does not support advanced transaction processing, whereas InnoDB does. 2. MyISAM emphasizes performance and speed, while InnoDB provides advanced