ACE Profile

Full Name

ACE Pro

Job Role Chief Data Architect

Company Beijing Sandata Technology Co., Ltd

Country China, People's Republic of

Top Expertise Database

Focus Area Database

About Xiaogang

1. 18 years experience in database, including Oracle8i, 9i, 10g, 11g, 12C, 19C installation, backup, recovery, high availability (ADG RAC) and tuning. Mastering the knowledge of Oracle's architecture, including memory structure, physical storage, SQL Tuning and more. 2. MySQL 5.6, 5.7, 8.0. Learn about MGR+Router+shell. Mastering the knowledge of the architecture of MySQL, including memory structure, physical storage, SQL Tuning and more. Familiar with using MySQL multisource replication, filtering replication. 3. Other databases including Redis, MongoDB, elasticsearch, neo4j, HBase, Hive, impala, PostgreSQL, greenplum,influxdb, and familiar with their high availability and tuning. 4. Participating Oracle projects covering government, business, public security, transportation and finance areas. 5. Personal Technology Blog Address: http://blog.itpub.net/myarticle/?type=1 With nearly 800,000 views. 6. Lecturer of MySQL OCP: Lecturer Introduction Address: https://enmoedu.com/About/ Trained over 500 OCP trainees for MySQL. 7. Continuously learn from ACEs in China to improve my own capabilities. 8. Understand the advantages and disadvantages of various databases, using Oracle and MySQL skills to integrate other databases. 9. ITPUB Memory Database Moderator and Core Expert; Gold consultant. ITPUB Memory Database Block URL http://www.itpub.net/forum-162-1.html User name: xuexiaogang 10. Familiar with Oracle golden gate. Handled using MySQL, Oracle, and synchronize data to Oracle, MySQL, kafka, hbase, hive using Ogg. Promote the use of Ogg. 11. Mastering the knowledge of TimesTen and promote the use of TimesTen. 12. Learn about Exadata and gain insight into its hardware advantages. Promote the use of Exadata.

Expertises Database MySQL Oracle APEX Oracle GoldenGate Service Java SE

Links

Latest Contributions

#SELECTION#

#ICON_HTML#

MySQL的replace使用分析

Jan 08, 2026 - Blog post -

MySQL 8

#ACTIONS#
#SELECTION#

#ICON_HTML#

一个在使用方法上的低级错误（MySQL场景）

Jan 08, 2026 - Blog post -

MySQL 8

#ACTIONS#
#SELECTION#

#ICON_HTML#

一次DDL引发的数据库异常关闭

Dec 09, 2025 - Blog post -

MySQL 8

#ACTIONS#
#SELECTION#

#ICON_HTML#

数据库分页 LIMIT 100,200 居然查了 300 行？

Nov 05, 2025 - Blog post -

Oracle Database (EE)

MySQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

Oracle和MySQL数据库中做线性回归

Nov 01, 2025 - Blog post -

Machine Learning

#ACTIONS#
#SELECTION#

#ICON_HTML#

从大数据到数据库

Aug 25, 2025 - Presentation - in-person or virtual - Database Technology Conference China 2025

Oracle Database (EE)

#ACTIONS#
#SELECTION#

#ICON_HTML#

Oracle DDL不可以直接在数据字典上的场景

Aug 25, 2025 - Blog post -

Oracle Base Database Service EE

#ACTIONS#
#SELECTION#

#ICON_HTML#

当MySQL的int不够用了

Aug 25, 2025 - Blog post -

MySQL 8

#ACTIONS#
#SELECTION#

#ICON_HTML#

当varchar和Nvarchar关联

Aug 11, 2025 - Blog post -

Oracle SQL

#ACTIONS#
#SELECTION#

#ICON_HTML#

从一次Oracle宕机看成熟IT系统的韧性

Aug 10, 2025 - Blog post -

Oracle Database (EE)

#ACTIONS#
#SELECTION#

#ICON_HTML#

In-memory不要全加载怎么做？

Aug 06, 2025 - Blog post -

In-Memory

#ACTIONS#
#SELECTION#

#ICON_HTML#

Oracle MCP本地部署测试

Jul 25, 2025 - Blog post -

Artificial Intelligence (AI)

#ACTIONS#
#SELECTION#

#ICON_HTML#

一次意想不到的ADG中断

Jul 07, 2025 - Blog post -

Active Data Guard (ADG)

#ACTIONS#
#SELECTION#

#ICON_HTML#

Thanks Oracle!

Jun 25, 2025 - Blog post -

Database

#ACTIONS#
#SELECTION#

#ICON_HTML#

flash back 导致OGG failure

Jun 17, 2025 - Blog post -

Oracle Database (EE)

Oracle GoldenGate Service

#ACTIONS#

1 - 15

ACE

Top Level Details

About Xiaogang

Latest Contributions