Database Administrator

MySQL Security optimization using aliases to prevent misoperation Background: When a newbie experiences misoperations, he deletes my entire test table (test, no backup) Operation Command: Mysql> update test set name = 'Tom '; Result: All name

Summary of Oracle archive logs 1. Open archive logs Sqlplus/as sysdbaSQL> shutdown immediate;SQL> startup mount; # Open the control file instead of the data fileSQL> alter database archivelog; # Switch the database to archive ModeSQL> alter database

Summary of various MySQL logs Log Type: Error log) General log) Binary log) Relay log) Slow log) Redo log of InnoDB Engine Error Log Log-error = error. log Save the storage path to datadir without specifying the hostname. err Record mysql

On the design scheme of the Oracle standby Database Oracle's ADG is needless to say. In terms of storage circles, the storage is changing from passive to active, but in general it is being snatched by software and RAID is snatched by ASM, snapshots

MySQL stored procedures and triggers I. Stored Procedure The basic format of the stored procedure is as follows: -- Declare the Terminator-- Create a stored procedureDELIMITER $ -- declare the end of the stored procedureCreate procedure pro_test () -

Oracle viewing Object Information 1. View information about all objects of a user: SELECT owner, object_type, status, COUNT (*) count #FROM all_objectsWhere owner = 'xxx'Group by owner, object_type, statusOrder by 2; 2. view the number of rows in

Monitoring startup reports TNS-12537, TNS-12560 Error Environment Description: OS: CentOS 6.5 DB: Oracle 11.2.0.3 Problem: the following error is reported when the database starts the listener: [Oracle @ localhost admin] $ lsnrctl start Connecting

Centos 7 installation configuration Redis-3.0.0 Centos 7 installation configuration Redis-3.0.0 1. install necessary packages yum install gcc Ii. Installation in Linux # Download wget http://download.redis.io/releases/redis-3.0.0.tar.gztar zxvf

Automatically add partitions for Oracle user tables This program can be executed as an Oracle JOB before the 28 th day of every month (taking into account the reason for the day of May 1), automatically adding partitions to the partition table of

Two MySQL services run on one server Two MySQL services run on one server 1. Add a group, add a user to the group, and decompress the package. Groupadd mysql Useradd mysql-g mysql-M-s/sbin/nologin Tar-zxvf

Upgrade MySQL 5.6.23 to MySQL 5.7.9 Upgrade MySQL 5.6.23 to MySQL 5.7.9 New Features of MySQL 5.7.9 I. Security 1.1. The plugin field of mysql. user cannot be blank. The default value is mysql_native_password instead of mysql_old_password. The old

High-availability installation of Redis in CentOSHigh-availability installation of Redis in CentOS [x] environment Introduction: Master: T1 Slave: T2 VIP: 192.168.68.45 [X] installing Redis (Master, Slave) Note: The flushall modification before

Performance of MariaDB 10.1 and MySQL 5.7 on common commercial hardware When you read my previous article about MariaDB 10.1 GA performance, you may be confused why I haven't mentioned MySQL 5.7 words. There are two reasons: First, MySQL was not GA

Install innobackupex in binary mode Purpose Install innobackupex in binary mode Environment OS: CentOS 6.6 32bit Introduction Official Website: https://www.percona.com/ Https://www.percona.com/downloads/XtraBackup/LATEST/ After opening the webpage,

Using innobackupex to back up a single MySQL database Purpose Using innobackupex to back up a single MySQL database Environment OS: CentOS 6.6 32bit Introduction Official Website: https://www.percona.com/ Https://www.percona.com/downloads/XtraBackup/

Connect Oracle to MySQL on Linux [Preface] The method for connecting Oracle to MySQL on the Windows platform has been introduced. Most of Oracle and MySQL are now on the Linux platform, and this requirement is also available recently, let's record

How to evaluate real concurrent sessions in Oracle In Oracle, you can view concurrent sessions in the dba_hist_active_sess_history view. You can use the following script to query the maximum concurrency, current connections, and maximum connections

MySQL 5.7.9 source code compilation and installation instructions I. Environment Description 1. Operating System System Version: RHEL 6.3X64 Operating system installation type: Basic System installation package: gcc-c ++ bzip2 (default) bzip2-devel

Oracle RMAN repairs logical Bad blocks RMAN implements block recoveryThe trial of Rman can achieve block-level data recovery. In the traditional restoration method, that is, a data block of a data file is damaged, the entire data file cannot be used

Another Implementation Method for SQL like clauses (faster than like), like clauses Generally, when fuzzy search is used, you will think of LIKE Select * from table where a like '% character %'If an SQL statement uses multiple like fuzzy queries and