New methods for configuring synchronous replication in MySQL5.6 and solutions to common problems

New methods for configuring synchronous replication in MySQL5.6 and solutions to common problems MySQL5.6 adds a method that does not need to set the log_bin file and log location. Before that, we need to view the master machine information (show

Logical and physical databases in Oracle

Logical and physical databases in Oracle Oracle abstracts the logical storage structure to adapt to different underlying physical structures. There are two advantages: (1) so that Oracle users only need to understand the data logic and do not feel

Installing and configuring Oracle Database Control Using Emca on the command line interface

Installing and configuring Oracle Database Control Using Emca on the command line interface As a loyal user of the command line, the O & M of the server software tends to be completed using commands or scripts, so it is annoying to use a large

How to solve the first time that PHP connects to Oracle is very slow

How to solve the first time that PHP connects to Oracle is very slow The database uses Oracle 11gPHP connection to Oracle is very slow PHP is very slow to connect to Oracle, as shown in the following figure: If you haven't connected to oracle for

Install MySQL 5.6 using the source code in Linux

Install MySQL 5.6 using the source code in Linux MySQL is an open-source database, so it can be installed based on the source code. Source code-based installation provides more flexibility. That is to say, we can select a suitable compiler for our

Install the full version of MySQL source code in Linux

Install the full version of MySQL source code in Linux Install MySQL in Linux, usually by using RPM and source code. For the production environment, you need to customize the installation path, data file location, Character Set, and supported

Create an Oracle 11g database using commands

Create an Oracle 11g database using commands This document describes how to create an Oracle database that complies with the OFA specification using the create database Command of the Oracle database. 1. Set the environment variable (vi.

Oracle database backup and recovery (expdp and impdp)

Oracle database backup and recovery (expdp and impdp) Refer: Oracle 11g beginner's Guide The materials on the Internet are fragmented, and most of them cannot complete the required functions. Preparations 1. configure it in the bin directory of the

Is NoSQL true or not?

Is NoSQL true or not? To NoSQL or not toNoSQL With the emergence of a large amount of data, NoSQL database architecture is being used by more and more people, because NoSQL architecture is more effective in big data processing. Today, when you need

Six flashback technologies in Oracle, flashback

Six flashback technologies in Oracle, flashback The Flashback technology is based on the content in the Undo segment, so it is limited by the UNDO_RETENTON parameter.To use the flashback feature, you must enable automatic undo tablespace

Execute MySQL statements in Shell scripts

Execute MySQL statements in Shell scripts For automated O & M, such as backup and recovery, DBA often needs to encapsulate SQL statements into shell scripts. This article describes several methods for calling SQL statements in a MySQL database in a

Oracle flash back table experiment

Oracle flash back table experiment Oracle job: flashback table experiment 1. Construct the flb_test table, with no less than 10000 rows of data; TEST_USER1 @ PROD> create table flb_test (id number, dd date ); Table created. TEST_USER1 @ PROD> begin2

Recovery after the Oracle data table is dropped

Recovery after the Oracle data table is dropped Oracle Data Tables store drop tables and indexes in the recycle bin (the recycle bin function must be set for the production database) Because the current generation environment has re-created many

An example of solution to system downtime caused by full archiving logs of Oracle databases

An example of solution to system downtime caused by full archiving logs of Oracle databases When the first downtime occurs, the system memory overflows. Therefore, the application server is restarted and an error is reported when the application

Oracle Database Recycle Bin

Oracle Database Recycle Bin For Oracle databases, to ensure data security, we need to set the database recycle bin function, which is enabled by default. Follow these steps to view and modify the settings. 1. Check whether the database's recycle bin

Solutions for full ORA-00257 archiving logs

Solutions for full ORA-00257 archiving logsBackground: In the previous blog, we mentioned how to enable or disable the ARCHIVELOG mode () of Oracle. After I set the database to archive mode, I tried to connect to the database again the next day,

Memory_target cannot be started because of improper settings.

Memory_target cannot be started because of improper settings. Today, I encountered another "strange" problem during troubleshooting.The SGA Automatic Storage Management has been disabled in the Test Library. As a result, the shared_pool_size

RMAN-20505, ORA-0119, ORA-27400 encountered in RMAN recover

RMAN-20505, ORA-0119, ORA-27400 encountered in RMAN recover This is a RAMN restoration task. The production end is Oracle 11.2.0.4 RAC and the data files are stored in the file system. The disaster recovery end stores data files in the Oracle11.2.0.4

Notes for getting records using rowid and rownum

Notes for getting records using rowid and rownumWe know that rowid and rownum can be used as fake and shoddy in Oracle and are mainly used to locate specific records in the table, but they are different, rowid corresponds to the physical address of

Use shell to customize awr scripts

Use shell to customize awr scripts When you diagnose performance problems, awr is an indispensable tool? /Rdbms/admin/awrrpt. SQL may be used too much, and sometimes it may be too cumbersome to input parameters. Copying a snapshot list is not

Total Pages: 1013 1 .... 372 373 374 375 376 .... 1013 Go to: GO

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.