Database Administrator

Innobackupex-based full Backup Recovery For Hot Standby MySQL databases, xtrabackup is the choice of most DBA friends. Xtrabackup is embedded with an innobackupex for Hot Standby MySQL database. This article describes the full backup recovery based

MongoDB log Rotation MongoDB can use a standard method to rotate logs, that is, to obtain the current log and enable a new one. To achieve this, the mongod instance renames the current log file by adding a UTC (GMT) timestamp at the end of the file

Oracle and MySQL String concatenation I. MySQL In Java, we usually use the plus sign (+) to concatenate strings. in MySQL, we can also use the plus sign (+). For example: Add test data first Create table test (Id INT,Name VARCHAR (10 ),Score

Solve the problem that the database cannot automatically collect statistics due to Oracle 11g installation. Recently, it was found that some Oracle 11g databases could not automatically collect statistics. Some View query results are as follows: SQL>

Introduction to Robomongo, robomongo Author: zhanhailiang Date:Introduction Robomongo is a Shell-based cross-platform MongoDB management tool. The relationship between Robomongo and MongoDB is equivalent to that between PHPMyAdmin and

An error is reported when java connects to mongodb. An error is returned when you write a short test program, depressing public static void main(String[] args) { try { Mongo mongo = new Mongo("10.2.167.27",27017); DB

Nodejs uses the mysql tutorial in xampp, nodejsxampp The following describes how to connect to the mysql database of the local machine through node. js: Var mysql = require ('mysql'); var connection = mysql. createConnection ({host: 'localhost',

Oracle compares two table structure differences and data differences. oracle differencesIn the work, we need to fulfill the following requirement: compare the two tables with the same structure and find the difference. Compare the two tables with

ORACLE query optimization and gather_plan_statistics hint, oracledbmsgather Query Optimization Methods and gather_plan_statistics hint:After 10 Gb, we can use the gather_plan_statistics prompt to learn more about SQL Execution statistics. The usage

SQL statements for report statistics and SQL statement reports-- Some Basic SQL functions used-- Returns the middle-aged value of the date: SQL YEAR function.-- Return the value of the Month in the date: SQL Month function.-- Return the value of the

[Password File loss-restore-1], password loss-1 Use oracle10g as the test version to delete the 10g password file: [Oracle @ oracle ~] $ Rm/u01/oracle/10g/dbs/orapwjadl10g Log on to the database remotely, and the password file will only take effect

[Oracle] uses the CONFIGURE command to reconfigure the recovery window to 60 days, configurecommand You set the recovery window to seven days and the backup optimiza Tion to ON using the CONFIGURE command of Recovery Manager (RMAN). Most recent

Connect to the Mysql server remotely. 1. Command Line: C:/> mysql-h 192.168.0.53-P 3306-u vicky-padmin The local computer is Windows 7, and the remote computer room is Linux. 192.168.0.53 is the IP address of my remote linux system. After the

The error *** Please move GoldenGate to its own tablespace, movetablespace is reported when you run the GOLDENGATE ddl_setup. SQL script. SQL> @ddl_setup Oracle GoldenGate DDL Replication setup script Verifying that current user has privileges to

Crash recovery and AUTORESTART parameters, crashautorestartThe impact of this parameter setting has been experienced twice in the production system:For the first time, an unimportant system WAS installed on a virtual machine. All applications of

Qt compiles mysql and creates a table before importing it. qtmysqlIn view of the fact that many students are always unable to compile myql for Qt and encounter various problems, I would like to write this tutorial to help students who need it.First,

Simple tutorial on SQL statements in linux --- CREATE INDEX, simple tutorial --- create Index helps us quickly find the required information from the table. For example, suppose we want to find a message in a gardening book about how to plant green

Linux SQL statement concise tutorial --- BETWEEN, concise tutorial --- INThis command allows us to capture the values in the database according to the limit of one or more non-consecutive (discrete) values.BETWEENSo that we can use a range to

Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT., mysqlbinlogI. Problem Description014-12-15 20:00:29 4398 [Warning] Unsafe statement written to the binary log using statement format since

If a column is empty, select non-null. If a column is empty, select For example, the question that someone in the front-end time group asked is just blank and I will pay attention to it. Status quoDbone = # select * from tb_test;Id | uname | addr----