PHP

After carefully studying the GoldenGate enterprise-level O & M practices, I focused on my understanding of several OGG processes. Combined with my understanding of the principles, I tried the experiment for nearly two days and configured it four

I think timesten is a bit more powerful. You can directly load the entire table to the timesten cache database through ttisql. The following is an example. 1. Create a table "test" in oracle ". I think timesten is a bit more powerful. You can

We all know that MySQL master-slave replication is transmitted in plain text, which is not allowed for some special businesses. Next we will try to build an SSL-based master-slave replication environment: RHEL5.8SELinux disabled, iptables disabled,

In the master-slave architecture, create an event on the master, as shown below: mysqlshowcreateevent 'insert' \ G; * *************************** 1. row ***************************.. In the master-slave architecture, create an event on the master,

Index design is an important part of database design and plays a vital role in database performance. However, index design is not so easy, performance is not so easy to get, a lot Index design is an important part of database design and plays a

Someone asked why SQL server data has changed, but why is the best modification date of database files and log files not changed. In fact, this is a normal behavior. The modification date of the SQLServer file is in SQLSer Someone asked why SQL

During this period, when purchasing storage and communicating with many storage vendors, we mentioned that it supports dynamic expansion of storage capacity. For example, if the original storage capacity is 5 TB, A lun will be allocated. Later, due

The installation of the OracleRAC database is more complex than that of a standalone database, because the entire installation process involves network, operating system, and storage. Improper configuration of one link may cause installation failure.

Since MySQL5.5 released its first version, a new record is added to the GRANT permission list: PROXY. Do not think this is the previous MySQLProxy. In fact, this is used as a vest for users. Let's come Since MySQL5.5 released its first version, a

1. Oracle cluster architecture: OracleRAC, the full name is OracleRealApplicationCluster, which is a real application cluster. It is a parallel cluster system provided by oracle. The entire cluster system is composed of OracleClusterware. 1. Oracle

1. Database Management SQL statement 1, Description: Create a database CREATEDATABASEdatabase-name2, Description: Delete the database dropdatabasedbname3, Description: Create view: createviewviewnameasselectstatement Delete view: dropviewviewname5,

1. What is implicit transaction? This is actually a concept that is not easy to understand. Let's take a look at what the document says. When a connection is operated in a recessive transaction mode, the SQLServer Database Engine instance

Fault Phenomenon for a province Settlement Database Application in the run stored procedure found error ORA-30036: unabletoextendsegmentby8inundotablespaceUNDOTBS1 after a series of troubleshooting analysis: view the undo tablespace Fault Phenomenon

Data integrity is the most critical for an enterprise to operate normally. Therefore, we need to master data backup and recovery methods in our work; the following is a summary of the three methods for Mysql database backup. Data integrity is the

Oracle current online log group corrupt processing 1 oracle log Features Summary 1 Oracle log switching rules (switching from maximum sequence # to minimum sequence #) eg is as follows: the next log group will be sequenc Oracle current online log

Summary 1: About MySQL table data size, we know that mysql stores data files in tablespaces. when mysql uses the innodb Storage engine, mysql uses tables to store data points. Summary 1: About MySQL table data size, we know that mysql stores data

MMM Introduction: MMM is the Master-MasterReplicationManagerforMySQL (mysql Master replication manager). It is a scalable script suite for monitoring, failover, and management of mysql Master replication configurations. MMM Introduction: MMM is the

This article summarizes and analyzes some commonly used SQL statements. For your reference, you may need it. 1. SQL row and column conversion problem: Suppose there is a student Partition Table (tb) as follows: name course score Zhang San Chinese 74

In earlier versions, if a high-load machine is restarted and a large amount of hot data in the memory is cleared, it will re-load the data from the disk to the Buffer_Pool buffer pool, in this way, the performance will become very poor during peak

1. Shared resources of a queue can be accessed by multiple sessions and processes at the same time. Therefore, access to these resources must be protected. In Oracle, apart from PGA, everything (including memory, disk, CPU, table, index, transaction,