Ujang Jaenudin
DBA at Self Employed
I'm an experienced oracle DBA since 2004, starting 9i ~ 12c.
Starting as PostgreSQL DBA since 2010: - create a small module to communicate to core banking system (plpgsql + php) - Manage own replication from oracle to PostgreSQL - Manage database maintenance (280+ databases) - Manage multimaster replication (BDR) - consolidation from 280+ database/servers into single server - Troubleshoot performance problem for ETL processes - Benchmark Postgresql BDR to choose the better linux kernel for mutex overhead issues
Upcoming presentations
No upcoming presentations...
Past presentations
Database Migration from Oracle Exadata to PostgreSQL
Tune converted pl/pgsql core Function
Migrate Database from Exadata X7 1/8 2 Nodes RAC to PostgreSQL 12.4:
Critical OLTP System Peak Transaction around 400 TPS System accessed from million of Mobile devices Critical part: Searching available seats on the route
Current workload most likely 80% READ, 20% WRITE PostgresQL able to scale well for READS We plan to have some slaves (Synchronous SR) HA-proxy in front of them
Nov 19 2020