horizontal scale out

hi,

Do DB2 support horizontal scale out ? like DB sharding across all servers so all DB2 nodes has a copy of the same database, and transcation commiteed on primary nodes will sync, quickly to other Db2 nodes.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> like DB sharding across all servers so all DB2 nodes has a copy of the same database, and transcation commiteed on primary nodes will sync, quickly to other Db2 nodes

I hope you are referring to Replication and this is not actually horizontal Scaling out.. And yes, DB2 have Replication available.
Horizontal scaling refers to adding more and more machines to the existing one for load sharing and better performance.
Kindly let me know what exactly you are looking out for so that I can clarify accordingly.
marrowyungSenior Technical architecture (Data)Author Commented:
Raja,


"I hope you are referring to Replication and this is not actually horizontal Scaling out.. And yes, DB2 have Replication available."

not replication, replication is sth else

"Horizontal scaling refers to adding more and more machines to the existing one for load sharing and better performance."

I am comparing DB and this is exactly I want to know about it, just like SQL server AOG, read only scale out and it also referring to have exactly the same copy of DB across ALL replica.


Tomas ,

from here: https://www.ibm.com/support/knowledgecenter/en/SSEPGG_11.1.0/com.ibm.db2.luw.licensing.doc/doc/c0057442.html

"Continuous availability
Whether it is planned system maintenance or an extreme circumstance, such as when multiple components fail simultaneously, the IBM Db2 pureScale Feature is designed to continue processing incoming database requests without interruption. Automatic load balancing across all active members means optimal resource utilization at all times, which helps to keep application response times low."

do you know if it is load balancing read only or read write ?

" DB2 pureScale is an active/active failover solution requiring no intervention if a member or caching facility (CF) encounters a software failure"

that one is active/active, not multi master. so only one single write.

"ach DB2 member has access to the database and any data therein; however, each member has its own local memory containing things like bufferpools, package cache, utility heap, sortheap, and locklists. Regardless of the data being accessed, transactions can run on any member in the cluster. Each member has its own transaction log stream that resides on the shared filesystem.
"

oh, still using single share files storage/file system?  but horizontal scale out also means all DB do not share the SAME file storage. so one storage failed, all other survived.

so if this is true, then that one is not even active/active, is multi master on write too ! as this is all what Oracle RAC's model, single SHARED storage. If there are more than one storage and all about the same data set, oracle RAC doesn't work across ALL storage.
Need More Insight Into What’s Killing Your Network

Flow data analysis from SolarWinds NetFlow Traffic Analyzer (NTA), along with Network Performance Monitor (NPM), can give you deeper visibility into your network’s traffic.

Tomas Helgi JohannssonCommented:
Hi!

pureScale is an active/active a.k.a. multi-master solution as I told you here and here almost a year ago allowing both read and write queries to run on and be load balanced on the primary cluster

Depending on how you set up your system and DB2 pureScale you can identify and route all read-only queries to a sertain part of the  pureScale cluster say node 1 and 2 of a 4 node cluster while node 3 and 4 are working with write queries.
This can be done through the pureScale WLM configuration. See here and  here for more detail.

Regards,
    Tomas Helgi

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

is DB2 pureScale also support read only scale out, any limitation on number of scale out nodes ?
Tomas Helgi JohannssonCommented:
Hi,

You can have up to 128 members (nodes ) in the pureScale cluster but in regards to HADR then you can only have one standby cluster (with up to 128 members as well). :)

Regards,
    Tomas Helgi
marrowyungSenior Technical architecture (Data)Author Commented:
" 128 members (nodes ) "

all 128 nodes for read-only scale out ?  and all 128 nodes also for read write operation ?

" but in regards to HADR"

what you mean by this ? when HADR working with purescale ?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
With Purescale, you can have up to 100 Members in the cluster.
And you can configure members to be either Read only or Read\write as required.
marrowyungSenior Technical architecture (Data)Author Commented:
"With Purescale, you can have up to 100 Members in the cluster."

someone else told me it is 128, what is the reference URL for it ?
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
Sorry, I intended to type 128 but typed 100 as I was working on another one..
Here is your reference..
https://www.ibm.com/developerworks/data/library/dmmag/DBMag_2010_Issue1/DBMag_Issue109_pureScale/index.html
marrowyungSenior Technical architecture (Data)Author Commented:
tks anyway,
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Databases

From novice to tech pro — start learning today.