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.
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.
Other databases including Redis, MongoDB, elasticsearch, neo4j, HBase, Hive, impala, PostgreSQL, greenplum,influxdb, and familiar with their high availability and tuning.
Participating Oracle projects covering government, business, public security, transportation and finance areas.
Personal Technology Blog Address: http://blog.itpub.net/myarticle/?type=1With nearly 600,000 views.
Lecturer of MySQL OCP: Lecturer Introduction Address: https://enmoedu.com/About/Trained over 500 OCP trainees for MySQL.
Continuously learn from ACEs in China to improve my own capabilities.
Understand the advantages and disadvantages of various databases, using Oracle and MySQL skills to integrate other databases.
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
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.
Mastering the knowledge of TimesTen and promote the use of TimesTen.
Learn about Exadata and gain insight into its hardware advantages. Promote the use of Exadata.