Database Administrator

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

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

MySQL master-slave replication configuration case A master-slave MySQL replication configuration case where the environment is 111.111.111.110 and the slave database is 111.111.111.111. 1. Create a dedicated user for database replication in the

ORA-00600 [kjctr_pbmsg: badbmsg2] Recently encountered errors ORA-00600 [kjctr_pbmsg: badbmsg2], and lead to RAC node instance restart, the final confirmation of the problem caused by private network instability. ORA-00600: internal error code,

Vip address not visible in MySQL MMM Architecture After you build a high-availability MySQL MMM (Master-Master Replication Manager) architecture, you cannot see the vip address, after finding a large number of articles on the Internet and observing

View and remove blocked sessions in Oracle For more information about how to view and remove Oracle blocking sessions, here we will only talk about the operation steps, not the principles. Session 1 update object ticket not submitted When

Use MySQL-MMM for MySQL cluster deployment Background: The mysql synchronous replication function (as described in my previous article) is only a dual-machine hot backup function, and cannot automatically switch the Mysql link. This configuration

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 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,

[MSSQL] use the convert function to implement dynamic row-to-column conversion. Environment requirements: 2005 + In daily requirements, we often need to handle row-to-column operations. If it is not a dynamic row, we can use case when listing. When

How can I associate my boyfriend's QQ account? QQ1622863529, small qq1622863529Query serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries, delete QQ chat records, modify QQ chat

How can I view others' consumption records? QQ1622863529Query serviceConsult QQ: 1622863529 to query QQ chat records, chat content queries, QQ audio queries, video content queries, delete QQ chat records, modify QQ chat records, and delete chat

Big Data Table query optimization solution and data table optimization solution If a large table contains millions, tens of millions, or even hundreds of millions of data records, the query results should be queried in real time within 10 seconds.

Bbed modify undo segment status (ORA-01578), bbedora-01578 ZBDBA@orcl11g>select * from zbdba;select * from zbdba *ERROR at line 1:ORA-01578: ORACLE data block corrupted (file # 3, block # 1449)ORA-01110: data file 3:

[Recovery, 1] redo log recovery situations, redo logsRecovering After the Loss of Online Redo Log Files If a media failure has affected the online redo logs of a database, then the appropriate recovery procedure depends on the following

Concurrency problems: access to large data volumes and access to concurrent data volumes Today, I suddenly noticed this problem. I have read a lot from the Internet and have benefited a lot. Record it and review it later ~ I have encountered this

Green Time converted to normal time, green time converted Uscdbmt @ rac1: ~> Date + % s1414741902 In oracle, how does one convert this 1414741902 to a normal time format?   Select Numtodsinterval (1414741902-TO_NUMBER (SUBSTR (TZ_OFFSET

A bird's eye view of database system principles and database system principlesThe database system is a data management system. First, we design the data. When talking about the data, we need to look at the development of the database system from the

Oracle view Summary (create, query, modify, delete, etc.), oracle View View definition: -A view is a virtual table.--A view is created on the basis of an existing table. The tables on which a view is created are called base tables. -The statement

Two SQL tables are associated to modify data, and two SQL tables are associated with data. Hr_w.planweek DepartMent weekly schedule: DepartMent name, DepartMent ID. G_group Department table: gname Department name, gid department id Manage the