MySQL, Kubernetes, Aurora Databases

Oracle E-Business Suite scripts: AutoConfig Scope and Components: 1. In Release 12.2 application tier is AutoConfig-enabled. 2. Applications context file location - INST_TOP as <INST_TOP>/appl/admin/<CONTEXT_NAME>.xml 3. The Release 12.2 database tier created via Rapid Install is also AutoConfig-enabled. 4. Database context file location - RDBMS ORACLE_HOME as <RDBMS_ORACLE_HOME>/appsutil/<CONTEXT_NAME>.xml AutoConfig components: Applications context - An XML repository located in the INST_TOP that contains information specific to the APPL_TOP.  Database context - An XML repository located in the RDBMS ORACLE_HOME that contains information specific to that database tier.  AutoConfig template files - Files containing named tags that are replaced with instance-specific information from the appropriate context, in the process of instantiation.  AutoConfig driver files - Every Oracle E-Business Suite product maintains ...

Data Modeling for BigData: http://www.dbta.com/Columns/Database-Elaborations/Creating-Analytical-Data-Models-60919.aspx http://www.b-eye-network.com/view/16027 https://tdwi.org/articles/2017/04/12/dimensional-models-in-the-big-data-era.aspx https://tdwi.org/articles/2017/03/22/data-modeling-for-big-data-and-nosql.aspx

Sharding: Sharding means scale out. Each node runs MySQL instance. Data is partitioned across all nodes. Sharding key is used to distribute data across nodes.   Example of sharding: Each customer store data in their own schema MySQL instance per customer OS instance / container per customer Environment per customer includes database server Application server and required components Ref: MySQL Proxy SQL - http://www.proxysql.com/blog MariaDB MaxScale - https://mariadb.com/products/technology/maxscale ScaleArc - http://www.scalearc.com/how-it-works/performance-features/query-routing MySQL Router - https://www.mysql.com/products/enterprise/router.html MySQL Fabric - https://www.percona.com/blog/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/ https://downloads.mysql.com/docs/fabric-1.5-en.pdf Explore Sharding and commonly used solution for MySQL sharding: https://severalnines.com/blog/database-sharding-how-does-it-work https://www.clustrix.com/bettersql/challenges-shardin...

Following description about Oracle E-Business Suite is high level and from documentation https://docs.oracle.com/cd/E26401_01/doc.122/e22954/T202991T531062.htm#5281339 for in depth and detail description refer it. The online patching cycle phases: Prepare Apply Finalize Cutover Cleanup Prepare phase: Start a new online patching cycle, Prepares the environment for patching. $ adop phase=prepare Apply phase: Applies the specified patches to the environment. Apply one or more patches to the patch edition. $ adop phase=apply patches=123456,789101 workers=8 Finalize phase: Performs any final steps required to make the system ready for cutover. Perform the final patching operations that can be executed while the application is still online. $ adop phase=finalize Cutover phase: Shuts down application tier services, makes the patch edition the new run edition, and then restarts application tier services. This is the only phase that involves a brief ...

Oracle E-Business Suite technology layer include: Oracle Applications DBA (AD) Oracle Application Object Library (FND) Oracle Applications Utilities (AU) Oracle Common Modules (AK) Oracle Workflow (WF) Oracle Alert (ALR) Oracle Application Framework (FWK) Oracle XML Publisher (XDO) E-Business Suite Services - Concurrent Managers and Workflow Mailers. Services are composed of one or more processes that must be kept running for the proper functioning of the applications. With Service Management , the Internal Concurrent Manager (ICM) manages the various service processes across multiple hosts. Service processes are very much like concurrent manager and transaction manager processes. Oracle Applications Manager can be used for a wide variety of tasks such as administering services including concurrent managers, examining system configuration, managing Oracle workflow, examining applied patches, and measuring system usage. E-business suite Concurrent programs: 01. Executes programs in b...