Bill Holenstein, Senior Manager of Product Delivery, presented on HPE Shadowbase Zero Downtime Migrations & Upgrades Overview at the Thailand NonStop Connect 2018 event held at the ATTA Lake Resort in Khao Yai, two hours north of Bangkok. Prior to this event, Bill presented on HPE Shadowbase Use Case Solutions & Product Update at the Thailand NonStop Partner Conference at the HPE Headquarters in Bangkok.
We recently attended and presented on HPE Shadowbase Use Cases and Product Update at MexTUG (Mexico City). We enjoyed our stay at the Sheraton Maria Isabel Hotel (which, by the way, has an impressive exercise facility and rooftop pool) by the Paseo de la Reforma. We visited some local sights, experienced the culture, and purchased a few Mexico national soccer team jerseys. At MexTUG, we attended several interesting talks, covering the inception of Hewlett Packard to modern day NonStop. We also met with HPE and toured the Santa Fe office, reviewed local sales and regional business development strategies, and ended the trip with a visit to Pinche Gringo to sample some delicious BBQ. We greatly appreciated the opportunity to learn from and interact with our NonStop peers on a more in-depth level. Additionally, we thank the MexTUG board and all of the participants including customers, vendors, consultants, and HPE executives and technical staff for their support. Congratulations to Ulises Castañeda of HPE for winning our Beats earphones prize. Viva Mexico!
Gravic recently published the third and final part of the article series, Switching Replication Engines with Zero Downtime. When it is necessary to change or upgrade to a new data replication engine version, a zero downtime migration imposes no downtime on applications or users, and the databases all remain consistent, complete, and up-to-date during the process. This migration technique is similar to the HPE Shadowbase Zero Downtime Migration (ZDM) technique used to upgrade applications, database schema formats, file and table locations (or indices), and operating systems. The ZDM technique results in greatly reduced risks for error, staff stress levels, and migration costs while still providing continuous availability. This article discusses various methods used to switch replication engines without missing or re-replicating any data (solving the so-called jagged edge problem). For reference, the Version Independence approach discussed in Part 1 avoids interoperating between different software versions; Part 2 discusses an improved method that utilizes three nodes for partial hardware migrations or utilizes four nodes for a full hardware refresh, as well as bi-directional environments that keep all (new and old) nodes synchronized as the migration takes place.
We recently attended and presented on HPE Shadowbase Use Cases at the ATUG Meeting (Atlanta) and CTUG Conference (Toronto). At ATUG, we attended several interesting talks, from a NonStop update to various vendor talks. We toured the HPE office in Alpharetta, stopping by the impressive server room, which contained a physical system running HPE Virtualized NonStop. Afterwards, we adjourned to the Carbernet Steakhouse nearby for a pleasant post-show reception. At CTUG, we attended several interesting talks, from Mission Critical Blockchain, COBOL to Cucumber (from a customer's perspective), and various vendor and customer talks. We greatly enjoyed the opportunity to learn from and interact with our NonStop peers on a more in-depth level at these events. Additionally, we thank all of the participants including customers, vendors, consultants, and HPE executives and technical staff for supporting these wonderful events.
After a twenty-hour flight, we arrived in Sydney on Monday morning and headed to the Pullman Hotel near Hyde Park. We unexpectedly ran into Roland Lemoine of HPE in the hotel dining room. On Tuesday, the meeting was well-attended with about 50 participants. Through several HPE presentations, we learned more information on the Intelligent Edge, SQL/MX, Blockchain/R3 Corda, and NonStop OS Updates. We also enjoyed several vendor talks, and gained insight from a Customer Experience presentation. On Wednesday night, we flew to Melbourne, and arrived at our hotel in the heart of Chinatown. The next day, the Melbourne meeting followed the same format as the Sydney meeting, with 35 attendees, and the Customer Experience was presented by a regional bank employee. We delivered presentations on HPE Shadowbase Use Cases at both meetings.
HPE Shadowbase Repair is a feature in the HPE Shadowbase Compare for SQL NonStop Utility to assist with correcting or repairing SQL/MP or SQL/MX database discrepancies between two tables. Shadowbase Repair works on any two tables in these databases, provided they are both of the same type (MP or MX). It does not require a Shadowbase replication configuration, and can be used in any environment where a source and target table need to be verified. Repair is particularly useful in business continuity data replication environments to provide confidence (or certification) that the source and target data matches, and to repair the discrepancies when it does not. HPE Shadowbase Compare reports the discrepancies between two sets of SQL tables, which would be an error-prone and time-consuming task to correct if even only a handful of differences were found. With HPE Shadowbase Repair, the user can automatically and quickly correct these differences with just a few simple commands. For more information, please read our solution brief.
Many Enscribe users need to replicate their Enscribe data into external systems and environments, usually by converting the Enscribe information into standard SQL data structures and schemas. The HPE Shadowbase Data Definition Language Utility (SBDDLUTL) simplifies this process by providing a powerful interface to convert and map the Enscribe DDL data structures (records, fields) into their SQL equivalents (tables, columns). SBDDLUTL supports a variety of target SQL databases, including NonStop SQL/MP, NonStop SQL/MX, Oracle, Microsoft SQL Server, IBM DB2, Oracle MySQL, SAP HANA, and SAP Sybase. Typically, this manual process takes many hours to complete depending on the size of the Enscribe DDL definition. Instead, SBDDLUTL instantly flattens the definition, eliminating this error-prone effort. The SBDDLUTL feature is available as part of the HPE Shadowbase Data Management Utilities product bundle. For more information, please read our solution brief.
Gravic recently published the second part of the article series, Switching Replication Engines with Zero Downtime. Sometimes it is necessary to change or upgrade to a new data replication engine version. The zero downtime migration approach will impose no downtime on either applications or users. This migration technique is similar to the HPE Shadowbase Zero Downtime Migration (ZDM) technique that customers have been using for decades to upgrade their applications, database schema formats, file and table locations (or indices), operating systems, or perform a hardware refresh. This article discusses how the Version Independence approach discussed in Part 1 of this series can be improved using one or two additional nodes. It also explains how to protect the old production and old standby system(s) while the replication engines are being upgraded or switched.
Gravic published a new Presentations web page on its Publication website pages, featuring the latest HPE Shadowbase data replication software solutions. We hope that you enjoy learning more about these solutions, product updates, use cases, and case study from viewing the following presentations:
Gravic attended the first Latin American NonStop Users Group Meeting (LATUG) at the Renaissance Hotel in picturesque Santiago, Chile. At the welcome cocktail reception, Paul and Paden Holenstein enjoyed watching a performance of the country's national "Cueca" dance while sampling local wine and cheese. They discussed regional opportunities with Alfredo Villarroel, Fabian Manfredi, and Lars Plum from HPE, among others. At the show, they listened to vendor presentations showcasing new solutions and a use case on blockchain. Plum demonstrated significantly scaling-up a Virtualized NonStop server's processing power in under a minute. The Holensteins presented HPE Shadowbase use case solutions and product updates. That evening, the group shuttled to a local restaurant for a concluding reception. Congratulations to Rodrigo Soto from Banco de Credito e Inversiones for winning our Beats earphones!
Gravic attended the N2TUG tradeshow at the Hilton Dallas in Plano, Texas. Paul and Paden Holenstein luckily caught the last two seats on a flight to Dallas Fort Worth, after their original flight was delayed. They were welcomed by Bill Honaker, Diane Funkhouser, and others at a casual evening reception before meeting with regional HPE NonStop users the following day. They listened to interesting talks on blockchain, vendor presentations, and NonStop legend Jimmy Treybig on The Future of Enterprise Markets. Paden presented, HPE Shadowbase Use Case Solutions & Product Update, describing how HPE Shadowbase is used in several solutions. After the show, attendees socialized at a cocktail reception, where Jimmy Treybig was presented a commemorative California license plate, "TNSII" to represent all of his hard work and effort on the Tandem NonStop II, a revolutionary enterprise hardware design. Congratulations to Anthony Bennett from JCPenney for winning our Beats earphones prize!
Gravic recently attended and presented at the NENUG meeting in Andover, Massachusetts, and the NYTUG meeting in Berkeley Heights, New Jersey. We want to thank John Vollers from Hewlett Packard Enterprise and Gabrielle Guerrera and Mandi Nulph of NuWave Technologies for their hard work in organizing both events. We particularly enjoyed John's presentation “NonStop SQL Product Update,” where he gave an overview of the new features in NonStop SQL 3.6 available on NonStop X. At NYTUG, Paden Holenstein of Shadowbase Marketing, presented, “HPE Shadowbase Use Case Solutions & Product Update,” which described new HPE Shadowbase features and how it works in several use cases for these solution categories:
Gravic recently published the article, The Better Backup Method. This article discusses strategies for improving database recovery times after catastrophic failure for companies that use the “tried-and-true” backup and restore approach for data recovery. This method focuses on reducing the amount of data that needs to be backed up, stored, and subsequently retrieved for restoring transactional mission-critical databases to a current, consistent, and complete state in order to continue processing. It also focuses on the so-called online backup problem (where the database is open for processing while the backup occurs), and uses several techniques to reduce the amount of data that must be stored while the backup is taking place as well as for the subsequent changes to the data after the backup completes. Since there is a growing need for an economic and efficient way to back up very large-scale databases, many companies are returning to physical tape to fill this need. The better backup method significantly and efficiently uses backup media and backup/restore processing to improve current techniques.
Gravic enjoyed the vibrant city of Leipzig for this Connect Germany and GTUG event and greatly appreciated the warm welcome that the GTUG board and HPE provided us as well as the other vendors and users. It is always exciting to learn about what is happening in HPE and the region, and to discuss how our solutions can help our collective customers. Paul J. Holenstein, Gravic Executive Vice President, presented: New HPE Shadowbase Success Stories (including Business Continuity, Data Integration, Zero Downtime Migrations). He described numerous HPE Shadowbase success stories in several solution categories. These and other HPE Shadowbase use cases are available on our web site at https://www.shadowbasesoftware.com/use-cases/. Rick Stather, Sr. System Manager and Team Lead for Scandinavia at TCM Solutions, presented: Shadowbase Tricks: A ‘Swiss Army Knife’ Guide to Replication/Recovery. This presentation guided viewers through the HPE Shadowbase tools, SOLV and Compare, and how they were used in a real life data recovery scenario. Paul also presented: New HPE Shadowbase Features that Solve Customers' Challenges (including Zero Data Loss, DB2 as a source, transforming Enscribe data to industry standard DBs). He reviewed the recently released HPE Shadowbase features that are helping our customers solve their business challenges including:
Gravic’s HPE Shadowbase data replication product won the Gold Stevie Award in the category for Best New Product or Service of the Year – Software – Healthcare Technology Solution at the 16th Annual American Business Awards (ABA). The ABAs are the United States’ premier business awards program, and all organizations with U.S. operations are eligible to submit nominations. This year, more than 3,700 submitted nominations in virtually every industry were under consideration in a wide range of categories. Over 200 professionals worldwide participated in the judging process to select the winners. Details regarding the ABAs and the list of winners are available at https://stevieawards.com/aba. Nicknamed the Stevies for the Greek word, “crowned,” the awards will be presented to the winners at a gala ceremony at the Marriott Marquis Hotel in New York on Monday, June 11. The award-winning submission involves HPE Shadowbase data replication software that provides real-time replication from an HPE NonStop-based prescription claims processing system to feed a new environment for fraud decision support. As a result of the project, HPE Shadowbase software enables each agency to perform independent maintenance, analytics, and other necessary healthcare solution functions on individual schedules. This architecture improves the solution’s availability to eliminate failover fault risk and dramatically improve recovery time if a failure occurs at any point. The updated solution now assures the agency’s important healthcare data is fault tolerant, encrypted, reduces overall reimbursement cost, and enables law enforcement to monitor and investigate fraudulent claims activity. For more information regarding this submission, please read Prescription Drug Fraud Prevention – An HPE Shadowbase Data Integration Case Study.
As part of a group of regional partner meetings, Paul Holenstein, Gravic EVP, traveled to Singapore to visit Loreen Teo of Legato Solutions & Services. Paul and Loreen enjoyed crabs over dinner and discussed the Shadowbase presence in the region. Paul also met with HPE NonStop sales and technical teams in Singapore, as well as Bangkok and Jakarta, to discuss HPE Shadowbase customer use cases, product updates, market opportunities, regional sales, and other relevant topics. Paul also found time to enjoy several Southeast Asian attractions.
Gravic recently published the article, Scale-up is Dead, Long Live Scale-out! Keeping up with user demand is a significant challenge for IT departments. The traditional scale-up approach suffers from significant limitations and cost issues that prevent it from satisfying the ever-increasing workloads of a 24x7 online society. The use of massively parallel processing and scale-out architectures is the solution, since they can readily and non-disruptively apply additional compute resources to meet any demand, at a much lower cost, and with improved service availability. The use of a data replication engine, such as HPE Shadowbase, to share and maintain consistent data between multiple systems enables scale-out application and workload distributions across multiple compute nodes, which provides the necessary scalability and availability to meet the highest levels of user demand now and into the future.
The HPE Sales and Presales teams enjoyed our presentation, HPE Shadowbase Use Case Solutions & Product Update, at the HPE APAC MC Boot Camp in Macau. The teams also learned more about the best practices for selling Shadowbase solutions, which are available in the HPE price book. Later, these teams were joined by over 1,200 technical support (TSS) employees from the greater region, who began a week of technical training on product and industry updates. We look forward to participating in the APAC Partner Technical Update in May.
At the SunTUG Sunshine Summit in Tampa, attendees enjoyed our presentation, HPE Shadowbase Use Case Solutions & Product Update, which reviewed new and future HPE Shadowbase product features, including support for DB2 as a source; Enscribe to SQL replication enhancements; further improvements that simplify migrating from RDF or OGG to HPE Shadowbase; and additional BASE24 feature support. We also described how HPE Shadowbase works in several use cases for these solution categories:
Gravic published a new Use Case section on its Publication website pages featuring the most popular enterprise HPE Shadowbase use cases in the following categories: business continuity, data integration, application integration, zero downtime migration, zero data loss, big data, and asymmetric capacity expansion. HPE Shadowbase use cases solve data replication and integration problems for various financial, industrial, healthcare, and telecommunication enterprises, for a variety of environments, including HPE NonStop, Linux, Unix, and Windows platforms, running Enscribe, NonStop SQL, Oracle, SQL Server, Sybase, MySQL, DB2, and other databases. HPE Shadowbase is sold and supported by HPE. Please contact us for additional information.
Gravic recently published the article, Protecting Your Vital Applications written for The Connection (January/February issue) by Mark Pollans, HPE Sr. Worldwide Product Manager. This article is based on the excellent and informative presentation that Mr. Pollans gave at the 2017 Connect Technical Boot Camp on how to design and build advanced business continuity (BC) architectures, a rather important topic to Gravic. It is not a question of IF a disaster will occur; it is a matter of WHEN. A thoroughly planned and tested BC strategy helps assure companies that their applications can survive a disaster. BC is about minimizing or completely mitigating the impact of a catastrophe on business applications. A business impact analysis and overall BC strategies should be reviewed at least every two years to confirm that applications meet mission-critical or business-critical requirements. What was not mission-critical yesterday could be mission-critical today. This article also discusses the Critical Application Continuum, recovery time/point objectives (RTO/RPO), costs and durations of outages, and three fundamental data replication architectures: active/passive (classic disaster recovery), active/almost active (sizzling-hot-takeover), and active/active (continuous availability). HPE Shadowbase solutions are instrumental in assisting customers in deploying and leveraging these advanced BC architectures.
Gravic recently published the white paper, Switching Replication Engines with Zero Downtime and Less Risk. Switching replication engines with zero downtime is a topic with immense complexity. In this paper, we discuss how a data replication engine can be changed or upgraded without taking either the application or the database offline. There are numerous methods to thwart common problems faced during a migration: Version Independence (which avoids interoperating different software versions); the challenges when utilizing two nodes; utilizing three nodes (for partial hardware migrations); utilizing four nodes (for a full hardware refresh); and bi-directional environment (that keeps all nodes synchronized as the migration takes place). Additionally, the so-called jagged edge problem must be resolved, which occurs when performing any replication engine migration. HPE Shadowbase software offers several methods to solve these problems, including HPE Shadowbase Zero Downtime Migration, which can upgrade applications, database schema formats, file and table locations or indices, operating systems, and can refresh hardware. Properly undertaken, a data replication engine migration imposes no downtime on applications or users, and the databases all remain accessible, consistent, complete, and up-to-date during the process.