Showing entries 1 to 10 of 17
7 Older Entries »
Displaying posts with tag: architect (reset)
MySQL Role-Based Security, Data Masking and Auditing Presentation

At our September 2016 New York City MySQL Meetup was a demonstration of how to implement role-based security in MySQL using Hexatier. In addition, several other important security features demonstrated included role based dynamic data masking down to a per column level and full statement auditing.

Thanks to Scott Unrick, Lead Database Administrator at Teladoc for the great presentation. Slides are available here.

Hexatier – MySQL Role-based Security & Data Masking from

[Read more]

we use tcpcopy to make real traffic on our core systems. Many problems will be found in advance if we enlarge queries several times.


Infiniflash Benchmark

Sandisk (FusionIO) and Nexenta are working together to build this SDS solution.

Infiniflash is a very large SDS production, which manages for very large DW system who requires large storage space and also high IOPS.

We test infiniflash system ,read this Infiniflash_benchmark

MySQL distributed message system

Based on messages, we create mysql replication platforms , using async message to build strong distributed subscription system.

read this PDF :


因公司业务发展迅速,部门现在招两个mysql dba 同学,目前本人在平安健康互联网(平安好医生)数据团队,负责数据库的整体规划,想来的同学可以发简历到我的邮箱 靠谱的公司靠谱的团队 :)



TokuDB benchmark on PCIe

MariaDB TokuDB benchmark on FusionIO ,Compare TokuDB and InnoDB engines.

read: TokuDB_benchmark

NVMFS Supports Atomic Writes

Benchmark for NVMFS (supports atomic writes ,so we can close double-write option on specific MySQL version )

tips: some Flash-based cards could support large block map , the main idea is to avoid fractured page writes.

How to configure AWR system

In this article, we introduce myawr and mongoawr system .

Read this PDF, you will learn how to configure them.

How to configure AWR system.

How to configure Tcpdump system

MySQL Tcpdump system : use percona-toolkit to analyze network packages

We can identify problem SQLs with high execution frequency.

With DBMON system and AWR system we can find problem SQLs in a special time (high frequency, occurs over a period of time)

View this PDF:

How to configure WEBM

Architecture of WEBM system.


View this PDF:

Showing entries 1 to 10 of 17
7 Older Entries »