Database Administrator

Xtrabackup backup of large databases (full backup and Incremental Backup) Xtrabackup Xtrabackup is a free Database Hot Backup Software open source by percona. It can back up InnoDB databases and XtraDB storage engine databases in non-blocking ways

Exploration of Access database migration and access database migration Background: The Access database architecture was previously designed for business information system software. After a period of operation management, it was found that Access

Install the Vbox extension package and the Vbox extension package **************************************** ******************************** ************** Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please

Oracle 11g PL/SQL function result cache, oracle11g Two experiments have been conducted to simulate the Oracle Performance Diagnosis art. The book says that if you don't need RELIES_ON, then the changes to the objects on which the function depends

[Course sharing] This article introduces how to transplant and develop an embedded linux system (Environment setup, uboot porting, and embedded Kernel configuration and compilation), and how to implement uboot. Embedded linux system porting and

Chapter 1 Securing Your Server and Network (1): select the SQL Server Running Account and chaptersecuringSource: http://blog.csdn.net/dba_huangzj/article/details/37924127, topics Directory: http://blog.csdn.net/dba_huangzj/article/details/37906349

Windows Installation mysql-5.7 compressed version detailed tutorial, windowsmysql-5.7Preface install the mysql database today and go to the mysql official website. For windows, there are two versions of files to download: one is the. msi

Reading: docker container and container cloud (2); reading docker Summarize the learning and building process of dockerI read the 3.1 kernel, which is quite awesome.After reading the plug-ins on the internet, I tried them based on python and

SQL Server Performance Tuning 3 Index MaintenancePreface The previous article introduced how to improve database query performance by creating indexes, which is just the beginning. If you do not need proper maintenance in the future, the indexes you

When calling the dynamic performance view related to Oracle in a process, package, function, or trigger, you must grant appropriate permissions. Otherwise, you will receive an error message indicating that the table and view do not exist. Even if

SQL Study Notes (19) ----------- about MySQL database optimization and mysql database Optimization A mature database architecture is not designed with high availability, high scaling, and other features at the beginning. It is gradually improved

(Illustration) mysql client mysqlworkbench in windows connects to the mysql server CentOS on the virtual machine, and the virtual machine installs centos I have installed the mysql server in CentOS Linux and mysql client mysqlworkbench in Windows,

PostgreSQL tutorial (13): database management details, postgresql details I. Overview: A database can be considered as a name set of an SQL object (database object). Generally, each database object (table, function, etc.) belongs to only one

SQL Server data encryption and decryption: migrate the database protected by TDE to another instance (2), sqlservertde -- Understand TDE-https://technet.microsoft.com/zh-cn/library/bb934049 (v = SQL .105). aspx TDE performs real-time I/O encryption

The OS package and OS patch required for installing oracle database 10gR2 under Solaris 10 or later, sparc10gr2 Reference: Oracle Database (RDBMS) on Unix AIX, HP-UX, Linux, Mac OS X, Solaris, Tru64 Unix Operating Systems Installation and

MongoDB (2)-learn about the installation configuration and mongodb installation Configuration I introduced the general theoretical knowledge of MongoDB. This article will install and use MongoDB on windows and linux. Of course, we will install

About Oracle Database shutdown and Oracle Database Shutdown I have talked about Oracle Database startup before. Let's talk about Oracle Database shutdown today. I. Three Phases of database ShutdownThe Oracle Database startup process involves three

Compile and install PostgreSQL and osxpostgresql in Mac OSX Originally, the official installation package was used. However, the installation package will create postgre, which is a bit uncomfortable on the login interface. After searching for a

S skills, Postgres skills If you need to add indexes when the business volume is large, you need to use CONCURRENTLY. Otherwise, your database will easily break down. For example create index CONCURRENTLY idx_order_records_bank_statist_uid on

In the process of using the iwms system, we often encounter data content replacement operations. Before telling you how to replace the data content, I suggest you first understand the data storage type of the SQL Server database: SQL Server Data