Welcome!

Recurring Revenue Authors: Yeshim Deniz, Dana Gardner, Liz McMillan, Carmen Gonzalez, Chander Damodaran

Related Topics: Recurring Revenue

Recurring Revenue: Article

AWS Announced New Scaling and Availability Features for Oracle Databases

Amazon will soon release Multi-AZ deployments and Read Replicas for Oracle databases

Oracle database is offering a rich set of HA options in a non-Amazon world - active/passive clusters based on operating system failover capabilities (for example, IBM HACMP), active/active instances -  Oracle RAC (Real Application Clusters), Oracle Data Guard (physical and logical standby databases located in remote data center). Amazon Web Services RDS (Relational Database Service)  is already offering multi-AZ deployments for MySQL, soon to be released for Oracle databases too.

Multi-AZ deployment means that a simple click will suffice to create an Oracle physical standby database - an exercise which easily takes a day or two if done manually, even by an experienced DBA. Your primary database will thus be instantly protected by a robust standby database. When database is created or modified to run as a Multi-AZ deployment, Amazon RDS will automatically provision and manage physical standby database in a different Availability Zone. Availability Zone is independent infrastructure in a physically separate location. Standby database is not open for user community, the only function it performs is to apply archive log files from primary database. In case of primary database failure or planned outage standby database will automatically become active. It is still not clear if Amazon RDS will perform failover ( an Oracle term meaning physical standby database becomes active, while primary database is trashed and must be rebuilt ), or switchover ( physical standby database becomes active, while primary database now takes standby role ). We think Amazon RDS will probably take failover route.

Read Replica is an AWS feature that addresses one of notoriously difficult problems in RDBMS world - horizontal scaling. Relational databases are roughly classified as either OLTP or OLAP databases i.e. transactional (mostly data updates, i.e., INSERTS, UPDATES or DELETES) or analytical (mostly SELECT, i.e., read activity ). In order to avoid performance problems long running queries are usually not allowed to run on OLTP databases. OLAP databases containing aggregated data or copies of OLTP databases are created for query purposes. Techniques used in non-Amazon world are either custom scripted batch jobs that feed data from OLTP databases, split mirror techniques to quickly produce source database copy ( very useful for Very Large Databases ), logical standby databases etc.

While it is not currently known which of these techniques Amazon RDS will use as foundation of Read Replica feature for Oracle databases, we think that Oracle Active Data Guard feature will be used for this purpose. This feature allows for read-only access to physical standby database for queries while archive logs from primary database are continuously applied.

More Stories By Ranko Mosic

Ranko Mosic, BScEng, is specializing in Big Data/Data Architecture consulting services ( database/data architecture, machine learning ). His clients are in finance, retail, telecommunications industries. Ranko is welcoming inquiries about his availability for consulting engagements and can be reached at 408-757-0053 or [email protected]

IoT & Smart Cities Stories
AI and machine learning disruption for Enterprises started happening in the areas such as IT operations management (ITOPs) and Cloud management and SaaS apps. In 2019 CIOs will see disruptive solutions for Cloud & Devops, AI/ML driven IT Ops and Cloud Ops. Customers want AI-driven multi-cloud operations for monitoring, detection, prevention of disruptions. Disruptions cause revenue loss, unhappy users, impacts brand reputation etc.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
Atmosera delivers modern cloud services that maximize the advantages of cloud-based infrastructures. Offering private, hybrid, and public cloud solutions, Atmosera works closely with customers to engineer, deploy, and operate cloud architectures with advanced services that deliver strategic business outcomes. Atmosera's expertise simplifies the process of cloud transformation and our 20+ years of experience managing complex IT environments provides our customers with the confidence and trust tha...
The Japan External Trade Organization (JETRO) is a non-profit organization that provides business support services to companies expanding to Japan. With the support of JETRO's dedicated staff, clients can incorporate their business; receive visa, immigration, and HR support; find dedicated office space; identify local government subsidies; get tailored market studies; and more.
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
At CloudEXPO Silicon Valley, June 24-26, 2019, Digital Transformation (DX) is a major focus with expanded DevOpsSUMMIT and FinTechEXPO programs within the DXWorldEXPO agenda. Successful transformation requires a laser focus on being data-driven and on using all the tools available that enable transformation if they plan to survive over the long term. A total of 88% of Fortune 500 companies from a generation ago are now out of business. Only 12% still survive. Similar percentages are found throug...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility. As they do so, IT professionals are also embr...
In his general session at 19th Cloud Expo, Manish Dixit, VP of Product and Engineering at Dice, discussed how Dice leverages data insights and tools to help both tech professionals and recruiters better understand how skills relate to each other and which skills are in high demand using interactive visualizations and salary indicator tools to maximize earning potential. Manish Dixit is VP of Product and Engineering at Dice. As the leader of the Product, Engineering and Data Sciences team at D...
As you know, enterprise IT conversation over the past year have often centered upon the open-source Kubernetes container orchestration system. In fact, Kubernetes has emerged as the key technology -- and even primary platform -- of cloud migrations for a wide variety of organizations. Kubernetes is critical to forward-looking enterprises that continue to push their IT infrastructures toward maximum functionality, scalability, and flexibility.
Today's workforce is trading their cubicles and corporate desktops in favor of an any-location, any-device work style. And as digital natives make up more and more of the modern workforce, the appetite for user-friendly, cloud-based services grows. The center of work is shifting to the user and to the cloud. But managing a proliferation of SaaS, web, and mobile apps running on any number of clouds and devices is unwieldy and increases security risks. Steve Wilson, Citrix Vice President of Cloud,...