MySQL master replication + Keepalived to create a highly available MySQL Cluster

MySQL master replication + Keepalived to create a highly available MySQL Cluster In response to the company's needs, we have created a safer mysql cluster to implement mysql failover. After several days of research, we can finally share the results.

Use GoldenGate to synchronize data from MySQL to Oracle in real time

Use GoldenGate to synchronize data from MySQL to Oracle in real time Use GoldenGate to synchronize data from MySQL to Oracle in real time Step 1: Configure mysqlModify the configuration file my. ini# For goldengateLog-bin = "C:/mysql/logbin.

Signalled during ORA-1031

Signalled during ORA-1031 Error message: ORA-1031 signalled during: create tablespace name datafile '+ data' size 10 M autoextend on next 5 M maxsize unlimited... Problem description In the newly deployed Oracle environment, a designer user needs

Solutions to frequent sleep processes in MySQL

Solutions to frequent sleep processes in MySQL The company has a Linux server dedicated to running the company's WEB services. due to historical reasons, there are a large number of sites and pages, which often lead to a large number of sleep

Oracle online extended partitions

Oracle online extended partitions In the Oracle Partition Table operation, when a partition already has the largest partition, how can we expand the partition again? The simple method is to delete the maximum partition first, then add the required

ORA-16014: Log 1 serial number 242 Unarchived, no available destination

ORA-16014: Log 1 serial number 242 Unarchived, no available destination SQL> alter database open; *Row 3 has an error:ORA-16014: Log 1 serial number 242 Unarchived, no available destinationORA-00312: Online log 1 thread 1:'C: \ Oracle \ PRODUCT \ 10.

Oracle uses regular expressions for four main functions

Oracle uses regular expressions for four main functions Oracle Regular Expression functions: regexp_like, regexp_substr, regexp_instr, regexp_replace Oracle uses regular expressions for four main functions: 1. regexp_like can only be used for

ORA-12516 TNS: Listeners cannot find available handlers that meet protocol stack requirements

ORA-12516 TNS: Listeners cannot find available handlers that meet protocol stack requirements Problem scenario: A previous database was used for testing (department A). Last night, another test department (Department B) came to test the program.

ORA-12519 error process error

ORA-12519 error process error After the system runs normally for one month, the following error occurs on the first day of the launch. After a long time, you have no idea. Later find the database listening exception, found that ORA-12519 rejection

Relationship between Oracle instances and databases

Relationship between Oracle instances and databases Databases are physical and physical storage of data. They consist of files stored on disks, including control files, data files, and redo log files; The instance is logical and consists of the

Brief Analysis of Oracle execution plan

Brief Analysis of Oracle execution plan 1. How to open the execution plan: Turn on the Execution Plan (execute set autotrace traceonly/off) and if you are prompted for a SP2-0611, SP2-0618, follow these steps to create the appropriate user. 1. log

Oracle configuration file Introduction

Oracle configuration file Introduction Profile file or. bash_profile file (system-level environment variable file:/home/Oracle ); Oratab file (oracle self-run file:/etc/oratab ); InitSID. ora or spfileSID. ora file (database instance initialization

Configure DataGuard to report to ORA-12528

Configure DataGuard to report to ORA-12528 (In the creation of DataGuard, run rman recovery error ORA-12528 error; The script is as follows: RMAN> connect auxiliary sys/Oracle @ SCMPRD02 Solution: 1. Check whether the listener is started. Script:

ORA-16753 error troubleshooting

ORA-16753 error troubleshooting 1. Use dgmgrl to set the database to read-only mode: DGMGRL> edit database dg_name set state = read-only; ORA-16753 Resource guard cocould not open standby database Cause: Resource guard cocould not open standby

Oracle uses TRACE for SQL Performance Analysis

Oracle uses TRACE for SQL Performance Analysis If the SQL _trace parameter is set to true, the entire instance will be tracked, including all processes: User processes and background processes, which may cause serious performance problems and must

Oracle NET configuration and working principle

Oracle NET configuration and working principle Oracle NET is a software layer that supports conversion between different network protocols. Different physical machines can communicate with each other through this software layer, specifically

Oracle implements function-based indexing

Oracle implements function-based indexing Use Cases:When a query runs slowly. By checking the where clause, it is found that the SQL lower function is applied to a column, and the lower function prevents the use of existing indexes on the column.

Oracle imports data to another database through the data pump network without generating DMP files

Oracle imports data to another database through the data pump network without generating DMP files This document records an Oracle Data Import experience for future review. Because the project needs to import the database (USER1) on server A to the

Create a tablespace in Oracle and test it with the user

Create a tablespace in Oracle and test it with the user The Oracle tablespace is described as follows: Temporary tablespace: used for grouping operations when sorting large data volumes. Normally, these operations are completed in the memory, but

Oracle Character Set Analysis

Oracle Character Set Analysis There are many types of character sets. The first character set was ASCII. Since the number of characters supported by ASCII is very limited, many encoding schemes, such as Unicode, were introduced later. Unicode is a

Total Pages: 1013 1 .... 401 402 403 404 405 .... 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.