global database services
TRANSCRIPT
![Page 1: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/1.jpg)
CORPORATE IT
Global Database Services
Oracle Global Data Services Al Fischer Manager IT – Database Services
![Page 2: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/2.jpg)
2 C O R P O R A T E I T
![Page 3: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/3.jpg)
3 C O R P O R A T E I T 3
Regional DBA Team Members Global DBA Team
Australia/New Zealand
North America
Latin America
Russia Europe
South Africa
Japan Korea
India
China
AITS Malaysia SE Asia
Global and Regional Database Teams
![Page 4: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/4.jpg)
4 C O R P O R A T E I T
MAGIC - Managing Awards Growth Income and Compensation
Bonus Value / Points Value (BV/PV) on sales
Monthly rewards based on sales that month
Multi-level Marketing For downline sales, they get their full benefit, but the upline also accumulates BV/VP
Achievement level based on number sales that month
Multiple months at higher levels lead to greater rewards
Crucial for business that ABO’s can see current BV/PV near or at real-time
Read only operation
Outage of BV/PV has direct consequence on sales
Outage of BV/PV has significant business cost.
How we pay our Amway Business Owners
![Page 5: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/5.jpg)
5 C O R P O R A T E I T
Business Challenge How many 9’s at what cost?
99.9 is 8.76 hours a year 99.99 is 52 minutes a year 99.999 is 5 minutes a year
BV/PV inquiry time Traverse the line of sponsorship Up to the minute level information
Proactive patching and security PCI compliance
Amway crown jewels
Total Cost Hardware / storage Resources to manage
Uptime
Response time
Security
TCO
![Page 6: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/6.jpg)
6 C O R P O R A T E I T
Existing Architectural overview
Active Data Guard for: DR Backups Read workloads
![Page 7: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/7.jpg)
7 C O R P O R A T E I T
GDS advantages Leverage existing infrastructure resource utilization Primary database DR database Data Guard Broker Existing services
No application change except for TNS connectivity
Already separated for read-only and OLTP operations
Minimal set-up (DBA time) Quick deployment Adaptable for maintenance 2-3 hours after delivery of
servers
UpTime Read only transactions can get
another ‘9’ without major infrastructure changes
![Page 8: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/8.jpg)
8 C O R P O R A T E I T 8 C O R P O R A T E I T 8 C O R P O R A T E I T
GDS POC
![Page 9: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/9.jpg)
9 C O R P O R A T E I T 9 C O R P O R A T E I T 9 C O R P O R A T E I T 9 C O R P O R A T E I T
High level Steps Amway tested GDS on Oracle Multitenant Databases Install GSM software on multiple nodes
Download / unzip ./runInstaller -> root.sh
Set up GDS Admin accounts and priv’s alter user gsmuser account unlock :
Configure GDS Create GDS catalog Add GSMs
GDSCTL>start gsm –gsm <gsmname> Add Services
Set up Client connectivity
![Page 10: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/10.jpg)
10 C O R P O R A T E I T
Test Case Result
Crash Primary / Standby
Services failover as expected
Crash GDS Catalog
All services remain available
Active Data Guard Switchover
Services restart on expected nodes
Lag Tolerance
Service stops / restarts on other node if lag exceeds threshold
Amway Test Cases
![Page 11: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/11.jpg)
11 C O R P O R A T E I T
Test Case Benefit
Load Balancing
Faster return for query
RAC database
Higher availability
Moving from one container database to another
Higher availability Ease of upgrade
Amway Future Steps
![Page 12: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/12.jpg)
12 C O R P O R A T E I T
Next Steps for Amway • Demo to Business User • Include in Oracle Database 12c upgrade plans • Procure GSM servers and Catalog
QA and Production • Verify in our QA environment
• We have ADG in both Production and QA • Include GDS as part of our High Availability offerings to
other programs/projects • Global Datawarehouse?
• Enjoy the benefits
![Page 13: Global Database Services](https://reader034.vdocuments.us/reader034/viewer/2022042707/58689b171a28ab4d568b9667/html5/thumbnails/13.jpg)
13 C O R P O R A T E I T
Contact Information Al Fischer
Database Services Manager 616-787-1807 - Work [email protected]
Ron Swanson Principal Oracle DBA 616-787-5387 – Work [email protected]