Smart Database Replication for Netezza is a managed service offering provided by Smart Associates which utilises the database replication features of our Smart Management Frameworks (SMF) product. It is designed to improve the performance, availability and recoverability of one or more of IBM®’s Pure Data™ for Analytics (aka Netezza) or Netezza Performance Server for IBM Cloud Pak for Data appliances.
Smart Database Replication allows customers to replicate their Netezza databases in near real-time (you choose how frequently you want to replicate changes between systems, according to workload, data volatility, bandwidth, and Recovery Point Objectives (RPO) considerations). Mean Time to Recovery (MTTR) can be measured in the minutes it will take to repoint your DNS servers to the DR system; but even without a disaster, database replication potentially enables customers to divide their data, users, and workloads between multiple appliances for improved performance, concurrency and throughput.
If you're upgrading your existing Netezza appliances to IBM NPS for Cloud Pak for Data, the migration process is substantial and not without risk. The recommended approach often requires engaging costly professional services to undertake this task, which you can avoid by using Smart Database Replication.
Smart Database Replication allows you to undertake an effortless and virtually risk-free migration to your new platform as part of the service. In a nutshell, you run your old and new Netezza systems in parallel, replicating the databases.
So no drawn out migration plan with rehearsals and outages - when you are satisfied that the new solution is fully functional, you cut over. You can even migrate your users gradually to the new system.
The IBM recommended approach to migrating to CP4D involves using the nz_migrate command. Even using this approach, planning and executing your migration is a complex task and there are a number of variables that will determine the effort and duration of the migration. We have developed an estimating tool that will show you what you can expect based on your particular system.
Businesses can save more than $1million per downtime event (and often much more) by reducing Mean Time to Recovery (MTTR) to minutes to using Smart Database Replication's database recovery functions.
While the cost of downtime during data recovery will vary for each customer, and each customer should have a good idea of what their own cost is, Gartner have calculated that the average cost is over $300,000 per hour. Other similar methods give a range starting from at least $140,000 per hour even for smaller firms. In our experience getting a 20Tb+ Netezza system back on-line and up to date can take a minimum of eight hours when restoring from a full backup (or significantly longer depending on the number of streams that are used, or if multiple differential and cumulative backups also need to be restored). Smart Database Replication will reduce this to minutes, reducing expensive downtime to a fraction, assuring business continuity and enabling your business user and analytics workloads to continue with the minimum of disruption.
If you would like more information, check out our frequently asked questions or contact us here and we'll get in touch.
To download the Smart Database Replication brochure, click here.
See how Smart Database Replication can guarantee business continuity to Netezza users in the event of a system failure in this video.