Database Administrator

Implementation of MySQL read/write splitting in RHEL6.5 I. Requirements 1. Configure two MySQL servers and one proxy server to implement read/write splitting of the MySQL proxy. 2. You only need to access the MySQL proxy server. The actual SQL query

In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved? In Linux, MySQL reports the Table 'xxx' doesn' t exist error. How can this problem be solved? Problem: The program reports the error of Table 'xxx' doesn'

PL/SQL Exception error handling A good program should be able to correctly handle all kinds of errors and recover from errors as much as possible. Oracle provides EXCEPTION and exception handler for error handling. -----------------------------------

Use Percona XtraBackup in multiple instances Background Percona XtraBackup is a backup tool developed by Percona. It mainly has two tools: XtraBackup and innobackupex. Innobackupex encapsulates XtraBackup and is a perl script. This document is

Oracle EXP export error EXP-00091 Analysis Solution Oracle EXP/IMP is an early data backup and restoration tool. It is widely accepted by the industry for its ease-of-use and powerful features. Some development tools (such as PL/SQL Developer) even

Check the ORACLE warning File Script and oracle warning script Check the important information within two days: Vi alter_error.sh echo "Check Alter Error:"cat $TRACE/alert_$ORACLE_SID.log | grep -E

SQL Left, Right Join, and other operators.1. query all the data in tableA and tableB and the data in tableA in tableB.Select * from tableA A left join tableB B on A. key = B. key2. query and exclude the data in tableB and the remaining data in

Common Oracle functions-date functions, oracle date functions In the development and use of oracle, a variety of date functions are often used. The online date functions are searched for in batch, and there are many minor problems to use. I will

Mssql Job, mssql 1. What is a job? A job is a series of specified operations performed by the SQL Server Agent in sequence. A job can execute various types of activities, including running Transact-SQL scripts, command prompt applications,

Left join, join, right join difference, leftjoinLeft join returns records that include all records in the left table and join fields in the right table.Right join returns records that include all records in the right table and the joined fields in

Simple tutorial on SQL statements in linux --- simple tutorial on table connection and SQL Now we will introduce the concept of Join. To understand the connection, we need to use a lot of commands we have introduced before. Let's assume that we have

Development: Software caused connection abort: recv failed, abortrecv Ibatis is widely used recently, and many small and strange problems have been encountered in the middle, but it has been quite difficult for me for a long time. Then record it:

2. add, delete, and manage multi-node Master/Slave clusters in Windows 7 of mongodb cluster. mongodbwin7 Reprinted please indicate Source: http://blog.csdn.net/tianyijavaoracle/article/details/41744557 I. mongo Replica Sets three nodes are deployed

SQL like usage fuzzy query and SQL fuzzy query Fuzzy query: References: http://www.w3school.com.cn/ SQL/SQL _wildcards.asp When searching for data in a database, you can use the SQL wildcard.SQL wildcard Like When searching for data in a database,

Add, query, modify, and delete operations on data in basic SQL statements1. create a database: create database ;For example, create database student;2. connect to an existing database: use ;For example, use student;3. delete a database: drop

Oracle _ advanced subquery, oracle _ advanced subqueryZookeeper Oracle _ advanced subquery ① SubqueryA subquery is another SELECT statement nested in an SQL statement.Subquery (internal query) is executed before the master query is executed.Main

Percona-xtrbackup for multiple instances (), perconaserver Background Percona-xtrabackup is a backup tool developed by percona. It mainly has two tools: xtrabackup and innobackupex. Innobackupex encapsulates xtrabackup and is a perl script. This

When rac _ executes grid self-check, a prompt is displayed for executing the runfixup. sh script, gridrunfixup. sh. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

When rac is installed on the grid, the system reports the INS-41112 error and the racgrid reports the ins-41112 error. Original Works are from the blog of "Deep Blue blog". You are welcome to reprint them. Please note the following source when

How to speed up database query and speed up database1. To optimize the query, try to avoid full table scanning. First, consider creating an index on the columns involved in where and order.2. Try to avoid null value determination on the field in the