rdbms

Scripts: report the index fragmentation status

May 14, 2012 maintain, oracle No comments

/* ************************************************************* */
/* Index Fragmentation Status (idsfrag.sql): */
/*[……]

Read more

MySQL Plug-in for EM 12c

May 11, 2012 MYSQL No comments

来自pythian mysql project

With this plug-in, a DBA can add a new MySQL target just as they can an Oracle database. Oracle Enterprise Manager Agent[……]

Read more

11G New feature: Failed Logon Delays

April 27, 2012 11g, oracle 4 comments

在pub上看到一个不错的帖子 oracle 11g password delay

对这个特性 做如下说明

Failed Logon Delays

A hacker may attempt a brute force hack to break into your Oracle D[……]

Read more

11gR2 rac ora.asm error (ASM)

April 26, 2012 maintain, oracle, RAC No comments ,

ASM – ora.asm error

11.2.0.3 RAC CRS 无法启动

[ohasd(25286)]CRS-2112:The OLR service started on node db-41.
2012-04-25 14:46:13.120
[ohas[……]

Read more

ASM Preferred mirror Read

April 25, 2012 oracle, RAC 2 comments

ASM Preferred mirror Read

Introduction

The concept of the Preferred Read is not a new idea, but is now implemented in Oracle’s ASM volume[……]

Read more

“hcheck.sql” script to check for known problems in Oracle8i, Oracle9i, Oracle10g and Oracle 11g

April 20, 2012 Internals, oracle No comments

Execution Environment:

Access Privileges:
Requires to be run connected as SYS schema

Usage:
$ sqlplus
SQL*Plus: Release 9.2.0.2.[……]

Read more

diff-hidden parameter between 10g and 11g

April 16, 2012 11g, oracle No comments

看到刘兄的一篇文章转载下

Reference:http://www.oracledatabase12g.com/arch[……]

Read more

mysql High Availability -MHA

April 10, 2012 Architect, MYSQL 1 comment

最近跟同事测试了下MHA 作为mysql 高可用方案的一种 MHA具有很多优点 DeNA目前采用这种架构 支撑2亿+PV的访问

MHA
一.MHA介绍

MHA自动化主服务器故障转移,快速将从服务器晋级为主服务器(通常在10-30s),而不影响复制的一致性,不需要花钱买更多的新服务器,[……]

Read more

Exadata vs Teradata

April 1, 2012 Exadata, oracle No comments

Teradata 与 Exadata 的一些对比说明,由于是TD出来的文档 所以有一些片面之词

[……]

Read more

drbd+heartbeat+mysql slave 方案

March 29, 2012 Architecture, MYSQL No comments

drbd+heartbeat+mysql slave 方案

测试机器IP:public
10.2.0.181 — drbd+heartbeat
10.2.0.182 — drbd+heartbeat
10.2.0.183 — mysql slave
10.2.0.184[……]

Read more