Solutioning Mountkirk Games - Professional Cloud Architect

[@CloudAdvocate]

Pause the video and think how you can solve it and compare :).

[@ilarums]

1. Need to use Datastore or Firestore to store userprofile/game state 2. GCE with Shielded VMs for hardened Linux Distro

[@bhilarevishal14]

Please solve few more questions on case studies it would be great help to others

[@DamienMalakay]

this is old, i mean rightfully so as it was created 4 yrs ago but Google has updated the whole case study everyone :) i wouldn't rely on this but very good details

[@CloudAdvocate]

Will upload new one soon.

[@abhinavpk3985]

@@CloudAdvocate Is the new updated series coming soon? Looking forward to it

[@crikxouba]

7:44 I believe you got it wrong here. They mean that your data doesn't get lost while processing (for example an instance getting overwhelmed by requests), nothing to do with storage, so in this case you would send to pubsub.

[@CloudAdvocate]

Thank you!

[@crikxouba]

11:43 also not sure about this. Pub sub retains messages for up to a week, I think when we define "slow arriving data" we wouldn't expect it to arrive a week later. Storing directly to a bucket may slow processing down.

[@CloudAdvocate]

It better to store it in gcs and process it later than storing it on queue..coz of cost and also you don't have to worry about 1 week retention.

[@Edwinn100]

Actually, according to the Solution Concept, "Mountkirk Games is building a new multiplayer game that they expect to be very popular. They plan to deploy the game’s backend on Google Kubernetes Engine so they can scale rapidly and use Google’s global load balancer" therefore, I don't think MIG's are the right solution.

[@veeraraghavareddy7625]

great analysis GK ! Thank u very much.

[@sravyasambaturu5805]

Hey GK, Since the Cloud Datastore is been upgraded with firestore. Can we replace it here for the same. Btw great content :)

[@MrIsotoxin]

I think you got the final answer wrong. The business case mentions explicitly that they opt for a managed NoSQL environment. Given that Spanner is a MySQL database, I do think the answer should be C. What's your take on this? Got the exam tomorrow, but this is probably the reason why I hate multiple choice questions.

[@cieronek]

For me answer C is better then D

[@cbara568]

Why would we put the "late data" into GCS instead of following the standard Pub/Sub -> DataFlow path?

[@KOBRA1231991]

One doubt GK - During Problem discussions you said HTTPS LB and during Solution discussion HTTP LB, Could you please elaborate which LB to use. (To increase global footprints)

[@CloudAdvocate]

I am sorry for the confusion and good catch its External HTTP(S) LB.

[@pjlionel]

@CloudAdvocate - I like your analysis and break down. I wonder if you want to redo this video as MountKirk games case study has changed. This is true for some of other case studies that you created too. Just a heads up!

[@CloudAdvocate]

kzbin.info/www/bejne/qYW6ep-pm8iIg6c

[@JayRedfern1]

Nice video. But you state to use Datastore as the DB, which makes sense for the game state use case, but time-series is specifically mentioned, which should be BigTable. So, I'd say BigTable overrides Datastore in many aspects and should be the main DB of choice?

[@CloudAdvocate]

Actually depends on the type of the data and requirement. If in the exam the question is around the huge amount of data with less latency then BigTable makes sense. If you are just looking for NoSQL then Datastore should be sufficient.

[@cbara568]

Game state and user profile must be stored in a transactional database (kind of makes sense) and BigTable is not transactional.

[@shibusebastian3764]

Please do a case study with AWS... Would be of much help...

[@bhilarevishal14]

Please try to solve few more questions on case studies available openly

[@pablohadjinian3668]

Great job! Thanks very much for the video!

[@CloudAdvocate]

Glad you liked it!

[@reshmanair6164]

For hardened Linux , we should use Shielded VMs

[@123lightblue]

Could you update this with updated mountkirk usecase

[@CloudAdvocate]

kzbin.info/www/bejne/qYW6ep-pm8iIg6c

[@shashank2509]

will the exam questions be limited to the case studies on google site or it can be new case studies in the exam?

[@saranshdhyani3164]

Please upload TerramEarth case study

[@CloudAdvocate]

Sure 👍 I will.

[@ovnigaz]

When they say that they want to get rid of mysql is that mean that they need to get rid of sql database ? because cloud spanner is sql . Or they just want to get rid of it because it not scaling well ? Additionnally, sql database are not good for transactional processing, it is more for olap, or this rule juste apply for bigquery and bigtable ? When we speak about time series data, that mean streaming data ?

[@CloudAdvocate]

Yes for their workload its better to use NoSQL than SQL based database for better scalability. Bigquery is good for OLAP.

[@MrPriyabrataM]

6:38 --> Do you really need a Cloud SQL, it says transactional not transactional + relational. So I think datastore would be only appropriate.

[@CloudAdvocate]

Agreed

[@MrPriyabrataM]

@@CloudAdvocate Hey GK, I want to say a big thank you as I have become a fan of your videos today. I am new to Google cloud and your sessions are the coolest yet informative.

[@CloudAdvocate]

Thank you...for taking time and giving me the feedback. I appreciate it a lot.

[@alokmaheshwari8755]

new case studies applicable from 1st may. so these case studies are now deprecated - can you make video on new case studies - Helicopter racing, EHR, Mountkirk game and terramearth

[@CloudAdvocate]

Uploading Helicopter racing today :)

[@ankitmathur4u]

The sample question used was very simple and generic one, can you pick up some more specific questions which are more difficult

[@SalvatoreZagarella]

Hi, thanks for the video. What about TerramEarth? Tks

[@CloudAdvocate]

Will work on that..thank you.

[@venkatasanthoshtarugu8539]

Hi .. do you provide Azure training?

[@CloudAdvocate]

Nope

[@HenryPan]

Cool