Welcome!

Recurring Revenue Authors: Yeshim Deniz, Elizabeth White, Xenia von Wedel, Liz McMillan, Carmen Gonzalez

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
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing smart devices with AI and BlockChain capabilities prepare to refine compliance and regulatory capabilities in 2018. Volumes of health, financial, technical and privacy data, along with tightening compliance requirements by...
We are seeing a major migration of enterprises applications to the cloud. As cloud and business use of real time applications accelerate, legacy networks are no longer able to architecturally support cloud adoption and deliver the performance and security required by highly distributed enterprises. These outdated solutions have become more costly and complicated to implement, install, manage, and maintain.SD-WAN offers unlimited capabilities for accessing the benefits of the cloud and Internet. ...
Discussions of cloud computing have evolved in recent years from a focus on specific types of cloud, to a world of hybrid cloud, and to a world dominated by the APIs that make today's multi-cloud environments and hybrid clouds possible. In this Power Panel at 17th Cloud Expo, moderated by Conference Chair Roger Strukhoff, panelists addressed the importance of customers being able to use the specific technologies they need, through environments and ecosystems that expose their APIs to make true ...
Business professionals no longer wonder if they'll migrate to the cloud; it's now a matter of when. The cloud environment has proved to be a major force in transitioning to an agile business model that enables quick decisions and fast implementation that solidify customer relationships. And when the cloud is combined with the power of cognitive computing, it drives innovation and transformation that achieves astounding competitive advantage.
DXWorldEXPO LLC announced today that "IoT Now" was named media sponsor of CloudEXPO | DXWorldEXPO 2018 New York, which will take place on November 11-13, 2018 in New York City, NY. IoT Now explores the evolving opportunities and challenges facing CSPs, and it passes on some lessons learned from those who have taken the first steps in next-gen IoT services.
"Space Monkey by Vivent Smart Home is a product that is a distributed cloud-based edge storage network. Vivent Smart Home, our parent company, is a smart home provider that places a lot of hard drives across homes in North America," explained JT Olds, Director of Engineering, and Brandon Crowfeather, Product Manager, at Vivint Smart Home, in this SYS-CON.tv interview at @ThingsExpo, held Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA.
In an era of historic innovation fueled by unprecedented access to data and technology, the low cost and risk of entering new markets has leveled the playing field for business. Today, any ambitious innovator can easily introduce a new application or product that can reinvent business models and transform the client experience. In their Day 2 Keynote at 19th Cloud Expo, Mercer Rowe, IBM Vice President of Strategic Alliances, and Raejeanne Skillern, Intel Vice President of Data Center Group and G...
The current age of digital transformation means that IT organizations must adapt their toolset to cover all digital experiences, beyond just the end users’. Today’s businesses can no longer focus solely on the digital interactions they manage with employees or customers; they must now contend with non-traditional factors. Whether it's the power of brand to make or break a company, the need to monitor across all locations 24/7, or the ability to proactively resolve issues, companies must adapt to...
DXWorldEXPO LLC announced today that ICC-USA, a computer systems integrator and server manufacturing company focused on developing products and product appliances, will exhibit at the 22nd International CloudEXPO | DXWorldEXPO. DXWordEXPO New York 2018, colocated with CloudEXPO New York 2018 will be held November 11-13, 2018, in New York City. ICC is a computer systems integrator and server manufacturing company focused on developing products and product appliances to meet a wide range of ...
René Bostic is the Technical VP of the IBM Cloud Unit in North America. Enjoying her career with IBM during the modern millennial technological era, she is an expert in cloud computing, DevOps and emerging cloud technologies such as Blockchain. Her strengths and core competencies include a proven record of accomplishments in consensus building at all levels to assess, plan, and implement enterprise and cloud computing solutions. René is a member of the Society of Women Engineers (SWE) and a m...