Database Administrator

Over the past two days, I have been tossing WordPress, upgrading the system, adding various plug-ins, and then setting up the environment at home to start debugging. Everything went smoothly. After using the WordPress Database Backup tool to back up

After logging on to JR today, I found my title was "veteran expert ". Flattered. It only means that I have been here for a while. JR has done a good job and provided a platform for communication. Let's get down to the truth. Recently I encountered a

The RedHat system can be found on the Internet. There is no article about the MySQL cluster of the Ubuntu system. I am writing the Ubuntu MySQL cluster method. Don't scold me for being a newbie. Introduction to the network environment: Test

Database: SC _source and SC _dest Requirement: Copy all objects under the product user in SC _source to SC _dest. I. preparations: 1.1 place the SC _source and SC _dest databases in the archive Mode 1.2 if some tables do not have a primary key,

Today, Xiao Qiu said that there was a problem with running Dotcms In Ubuntu. I also tried it and found that there was always a problem that the table Dotcms could not be found. the group _ problem exists in my database. However, I found that this

(1) Check whether MySQL 3306 is open to the outside world. By default, MySQL does not provide the external access function. The method is as follows: 1 ~ # Netstat-an | grep 3306 2 tcp 0 0 127.0.0.1: 3306 0.0.0.0: * LISTEN It can be seen from the

Download sakai-demo-2.6.2 from the official website, the default is the memory database hsqldb, want to use mysql. So ...... 1. How do tables, fields, and data in mysql come from? I found it on the official website. I didn't find mysql backup files,

One or several autonomous transactions can be defined in a transaction (outer transaction. An autonomous transaction can be committed independently without affecting the outer transaction. Similarly, the rollback of the outer transaction does not

Oracle 11G R2 RAC modify archive Mode The non-archive mode is used by default after the database is created. You need to modify it. Recommended reading: Oracle 11g rac ocr and db_unique_name Configuration Reconfigure and uninstall Oracle 11GR2 Grid

MySQL is the first choice for MySQL redundancy solutions for lightweight databases. The following is the configuration process of MySQL's asynchronous master-slave replication. First configure the system yum. Here we will introduce the installation

Postgresql has added the External table access function since 9.1. This function allows the database to directly read files other than the database, such as csv or text files. DML is not supported for the moment. Postgresql has various plug-ins that

Long transaction impact OGG is a transaction-level real-time replication tool. That is to say, OGG only copies committed transactions. Before a transaction's commit or rollback occurs, it stores the operations of each transaction in a managed

Field constraints for creating an Oracle database: Non-empty ConstraintUnique ConstraintConstraints on Field ValuesDefault ValueForeign key constraint Create table tab_class (Class_id number primary key,Class_name varchar2 (10) not null

Install Oracle 11g single-instance database on Linux under vmvm 1. Environment and pre-installation plan: Virtual Machine and OS are as follows Environment: VMware Wordstation ACE version 6.0.2 Operating System: OracleLinux-R5-U8-Server-i386-dvd

Distributed transactions The Innodb Storage engine supports XA transactions and distributed transactions. Distributed Transactions allow multiple independent transaction resources to participate in a global transaction. Transaction resources are

It has been several years since the Oracle flash back zone was launched at 10 GB and continues until now. Oracle flash back is prepared for RMAN. Although aside from it, we can also perform database backup and recovery, Oracle is strongly

Union: Perform Union operations on two result sets, excluding duplicate rows, and sort the default rules at the same time; Union All: Perform Union operations on the two result sets, including duplicate rows without sorting; Intersect: intersection

I. Features of ASM1. automatically adjust the I/O LoadASM can automatically adjust the I/O load in all available disks, which not only avoids manual I/O adjustment, but also optimizes the performance, with ASM, you can increase the database size

Preface Today we will share with you the technology on Oracle control files. Without a long journey or even a thousand miles, without a small flow, it cannot become a sea of rivers. Oracle technology is profound and profound. With the power of my

1. Control Structure of PL/SQL, including selection structure, loop structure and jump Structure Rlwrap SQLPLUS spool to dynamic Log File Name Oracle SQLPLUS prompt settings Accelerate SQL return by setting SQLPLUS ARRAYSIZE (row prefetch) 1. Select