subject to change or withdrawal without notice and at IBM’s sole discretion. • Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision. • The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract. • The development, release, and timing of any future features or functionality described for our products remains at our sole discretion. • Performance is based on measurements and projections using standard IBM benchmarks in a controlled environment. The actual throughput or performance that any user will experience will vary depending upon many factors, including considerations such as the amount of multiprogramming in the user’s job stream, the I/O configuration, the storage configuration, and the workload processed. Therefore, no assurance can be given that an individual user will achieve results similar to those stated here. Please note 2
Government Healthcare Insurance Industrial Services IT Services Manufacturing Marketing Media & Entertainment Research Retail / Wholesale Services Telecommunication Transportation Utility Db2 pureScale Industries - World Wide ASEAN ANZ Greater China Group Japan Europe North America South America Middle East & Africa Db2 pureScale Customers - World Wide
Primary CF CF CS Secondary CF CF CS Clients Db2 pureScale Cluster (Instance) Corporate TCP/IP network Single view Shared Storage Database Logs Logs Logs Logs * On selected architecture(s) only 24 Client connect anywhere … see single database • Clients connect into any member • Automatic workload balancing • No change functionally and Db2 setup • Need to setup AWS Transit gateway for inbound traffic outside of current VPC Db2 engine runs on several host computers • Co-operate with each other to provide coherent access to the database from any member Integrated Cluster Services (CS) • Failure detection, recovery automation, cluster FS • In partnership with STG (Spectrum Scale, RSCT) and Tivoli SA MP (TSA) (to be replaced by Pacemaker later) Cluster Interconnect between members and CFs • Special optimizations provide low latency, high speed on RDMA-capable interconnects (e.g. 10/40*/100Gb RoCE) • Vanilla Ethernet also supported • Support Ethernet for now • RDMA equivalent in future release Cluster caching facility (CF) • Efficient global locking and buffer management • Synchronous duplexing to secondary ensures availability Data sharing architecture • Shared access to database • Members write to their own logs • Logs accessible from another host (used during recovery) • Same shared storage via new multi-attach EBS support in AWS • Limited to 16 host and within same region • No support of SCSI-3 PR. (ご参考)コンポーネント (オンプレ/クラウド比較ビュー) 24
Db2 version “Any” Intel H/W Architecture POWER, Intel, Z RHEL or SLES OS Choices AIX, RHEL or SLES Pre-configured size Cluster Topology Customizable TCP/IP Cluster Interconnect RDMA, TCP/IP Majority Node Quorum Disk tiebreaker Disk Leasing I/O Fencing SCSI-3 PR HADR Integrated DR options HADR, GDPC Speed, ease of deployment Strength Full autonomy, customized config. No up-front cost Capital Investment Huge upfront + depreciation cost
32 CPU v 64 Gb RAM v 5000 IOPS v 12.5 GbE MEDIUM (c6i.12xlarge) 3 Member + 2 CFs v 48 CPU v 96 Gb RAM v 7000 IOPS v 18.75 GbE LARGE (c6i.16xlarge) 5 Member + 2 CFs v 64 CPU v 128Gb RAM v 10000 IOPS v 25 GbE Application Read/Write Ratio SQL Statements Per Second 70/30 70,000 125,000 300,000 350,000 90/10 110,000 190,000 440,000 770,000 X-SMALL (c6i.4xlarge) 3 Member + 2 CFs v 16 CPU v 32 Gb RAM v 5000 IOPS v Up to 12.5 GbE R/W = 70/30 - yields 100,000 SQL statements per second On-premises 4 Member + 2 CFs v 20 CPU v 192 Gb RAM v Comparable IOPS v 10 GbE
or QREP for alternate DR sites irrespective of regions AZ1 AZ2 Region A (Primary) DR via Db2 HADR AZ Region B Goal: Leverage on-premises architecture as much as possible, preserve HA characteristics. AZ Region A DR via Db2 HADR AZ Region B AZ Region N Leverage storage replication or QREP for alternate DR sites irrespective of regions … AZ Region 1 2 3
this document may be reproduced or transmitted in any form without written permission from IBM. • U.S. Government Users Restricted Rights — use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM. • Information in these presentations (including information relating to products that have not yet been announced by IBM) has been reviewed for accuracy as of the date of initial publication and could include unintentional technical or typographical errors. IBM shall have no responsibility to update this information. This document is distributed “as is” without any warranty, either express or implied. In no event, shall IBM be liable for any damage arising from the use of this information, including but not limited to, loss of data, business interruption, loss of profit or loss of opportunity. IBM products and services are warranted per the terms and conditions of the agreements under which they are provided. • IBM products are manufactured from new parts or new and used parts. In some cases, a product may not be new and may have been previously installed. Regardless, our warranty terms apply.” • Any statements regarding IBM's future direction, intent or product plans are subject to change or withdrawal without notice. • Performance data contained herein was generally obtained in a controlled, isolated environments. Customer examples are presented as illustrations of how those customers have used IBM products and the results they may have achieved. Actual performance, cost, savings or other results in other operating environments may vary. • References in this document to IBM products, programs, or services does not imply that IBM intends to make such products, programs or services available in all countries in which IBM operates or does business. • Workshops, sessions and associated materials may have been prepared by independent session speakers, and do not necessarily reflect the views of IBM. All materials and discussions are provided for informational purposes only, and are neither intended to, nor shall constitute legal or other guidance or advice to any individual participant or their specific situation. • It is the customer’s responsibility to insure its own compliance with legal requirements and to obtain advice of competent legal counsel as to the identification and interpretation of any relevant laws and regulatory requirements that may affect the customer’s business and any actions the customer may need to take to comply with such laws. IBM does not provide legal advice or represent or warrant that its services or products will ensure that the customer follows any law. NOTICE AND DISCLAIMER 32
mayumihirano
miyatakoji
sheharyar
recerqainc
syuchimu
mot_techtalk
line_developers_tw
watany
subroh0508
otanet
ynt0485
cyberagentdevelopers
r4ynode
kimpetersen
soysaucechin
kastner
chriscoyier
skipperchong
reverentgeek
michielstock
tammyeverts
seathinner
caitiem20
chrisshort
matthewcrist
