OracleGoldenGate installation Configuration

OracleGoldenGate can be used to migrate and synchronize data on heterogeneous platforms. It is based on database log structure changes and obtains data by parsing online logs or archiving logs on the source end. Oracle GoldenGate can be used to

MySQL index and Query Optimization

The index type: Oslash; a common index is the most basic index type and has no limitations such as uniqueness. Oslash; the unique index and general index are basically the same, The index type: Oslash; a common index is the most basic index type and

MySQLexplain analysis Query

You can use the EXPLAIN or DESC keyword to simulate the optimizer to execute SQL query statements to know how MySQL processes your SQL statements. This helps you analyze your query statements. You can use the EXPLAIN or DESC keyword to simulate the

Detailed description of data table operations in MySQL (1)

With MySQL, you can choose between the three basic database tables. When creating a table, you can tell MySQL which table type it should use for the table. MySQL will always create a. frm file to save the table and column definitions. Indexes and

Use the MySQL built-in replication function

The internal replication function of MySQL is implemented between two or more servers by setting the master-slave relationship between them. One of them serves as the master server and the other as the slave server. This section describes how to

Collation of essential knowledge points of OracleRAC

Database Planning should be oriented to business characteristics and needs, rather than RAC for the availability of RAC. In fact, RAC is not omnipotent, and the following knowledge points need to be mastered. Database Planning should be oriented to

Deploy and use memcachefs

Introduction to the deployment and use of memcachefs: memcachefs is a FUSE-based memcached File System That mounts the Memcache service to a local machine. Allows you to view cached data, like files on a disk. Introduction to the deployment and use

Go deep into MySQL permission system (1)

MySQL has an advanced but non-standard security authorization system. mastering its authorization mechanism is the first step to start operating MySQL databases. For a person familiar with basic SQL operations, it is also a hard part of all MySQL

Sun: won't close any source code MySQL always open source

SUN said at the MySQLConferenceandExpo meeting last week that it would close some of the Mysql source code, which immediately aroused anger in the open source community. Currently, SUN's CEOMartenMickos clarified that MySQL is always an open source

Where does MySQL migrate to the Sun free database?

In emerging Internet businesses, MySQL was used by enterprises as a server used for website databases, such as amazon.com, Google, and Slashdot. As a general-purpose database, MySQL still plays its due role in supporting customer-oriented Web

MySQL Enterprise major update add query analysis tool

[51CTO comprehensive report] Sun announced a major version update for the MySQLEnterprise subscription service. Sun has added a query and Analysis Tool (MySQLQueryAnalyzer) for the MySQL Enterprise Edition to help track and analyze the problem code,

New MySQL versions around Sun betray open source?

A few months ago, the famous open-source database MySQL was won by Sun at a price of 1 billion US dollars, which caused hot comments from people in the open-source industry, this purchase will affect this open-source database and the open-source

Three Tips for improving MySQL query efficiency (1)

[From Chen Min's blog] MySQL is increasingly used in database applications due to its small size and efficient operations. When I was developing a P2P application, I used MySQL to store P2P nodes. Because P2P applications have tens of thousands

Use bbed to modify data

Bbed is a powerful tool that allows us to directly modify the corresponding content from the data file through oracle ZBDBA @ orcl11gselect * fromemp; EMPNOENAMEJOBMGRHIREDATESALCOMMDEPTNO -------------------------------------------------------------

MHAmasterha_check_repl detection process

Whether the MHA deployment and configuration are OK. We can use the masterha_check_ssh and masterha_check_repl scripts provided by MHA to check whether the MHA deployment and configuration are OK. Masterha_check_repl Detection Whether the MHA

Oracle RMAN database backup and recovery in non-archive Mode

1. SQLgt; archiveloglist for database backup in non-archive mode; automatic archiving in non-archive mode in Database Log mode disable the archive endpoint USE_DB_RECOVERY_FIL 1. SQLgt; archive log list for database backup in non-archive mode;

Oracle RMAN backup and Restoration

RMAN supports Incremental Backup: databases, tablespaces, and only blocks used in data files can be backed up as backupset tablespaces. The ing relationship between the tablespaces and data files: dba_dat RMAN supports Incremental backup: databases,

Connection between MySQL and clients (1)

This article demonstrates how to use the mysql client program to connect to the database server. Mysql is an interactive program that allows you to connect to a MySQL server, run the query, and view the results. Mysql can be used in batch mode: You

GlassFish and the MySQL Community jointly release new software packages

Just after the MySQL acquisition, the GlassFish and MySQL communities announced the release of the optimized software package, which is available for download. The software package includes GlassFishV2, MySQLServer5.0 (5.0.51a), and MySQLJDBCdriver5.

Query field types by table name and field name

Today, I encountered a problem: I want to obtain the field type of this field through the table name and field name. I found a lot of methods on the Internet, but I was not successful (my database knowledge is scarce ). Later, I found a correct

Total Pages: 12780 1 .... 9485 9486 9487 9488 9489 .... 12780 Go to: GO

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.