Meeting Title: ABC Home CloudSQL Setup Date: 2026-03-17 Meeting participants: Casie Aviles, Mustafa Raja
WEBVTT
1 00:00:34.380 ⇒ 00:00:36.120 Casie Aviles: Oh, vague, Mustafa.
2 00:00:36.120 ⇒ 00:00:37.129 Mustafa Raja: Hey, how are you?
3 00:00:38.430 ⇒ 00:00:39.550 Casie Aviles: Yeah, they’re encouraged.
4 00:00:39.940 ⇒ 00:00:40.879 Casie Aviles: How about you?
5 00:00:41.160 ⇒ 00:00:43.000 Mustafa Raja: Yeah, I’m also doing good.
6 00:00:45.120 ⇒ 00:00:50.700 Casie Aviles: Okay, cool. Alright, I’ll just… yeah, I’ll share my screen, and then I guess you can…
7 00:00:50.970 ⇒ 00:00:56.669 Mustafa Raja: Yeah, yeah, we can just go through, how, you know, how we can set that up, or…
8 00:00:57.230 ⇒ 00:00:58.960 Mustafa Raja: How we can configure it, you know?
9 00:00:59.930 ⇒ 00:01:01.090 Mustafa Raja: Should be quick.
10 00:01:04.379 ⇒ 00:01:06.839 Mustafa Raja: Okay, this is for development, right?
11 00:01:07.870 ⇒ 00:01:08.910 Casie Aviles: Yes, yes.
12 00:01:09.340 ⇒ 00:01:13.530 Mustafa Raja: Let’s go in some… Yeah.
13 00:01:14.000 ⇒ 00:01:15.649 Casie Aviles: Let’s go to staging, then.
14 00:01:19.890 ⇒ 00:01:24.269 Mustafa Raja: I’m wondering if you’re going to use BigQuery instance
15 00:01:24.780 ⇒ 00:01:30.550 Mustafa Raja: multiple BigQuery instances. I don’t think it makes sense for BigQuery to be in multiple instances.
16 00:01:32.150 ⇒ 00:01:33.100 Casie Aviles: Hmm.
17 00:01:33.470 ⇒ 00:01:42.270 Casie Aviles: Yeah, We don’t… We don’t really need any, like, you know, separation, right?
18 00:01:42.750 ⇒ 00:01:43.650 Mustafa Raja: Yeah.
19 00:01:44.510 ⇒ 00:01:51.019 Mustafa Raja: Okay, now, let’s, let’s ignore this top one, let’s go here. Let’s select this.
20 00:01:53.370 ⇒ 00:01:54.840 Casie Aviles: Okay…
21 00:01:56.930 ⇒ 00:02:06.040 Mustafa Raja: So then… then I believe we would want to work with this… sorry, yeah, work with this, create development institutions.
22 00:02:10.419 ⇒ 00:02:12.069 Casie Aviles: Okay, oh…
23 00:02:14.290 ⇒ 00:02:16.290 Mustafa Raja: Oh, yeah.
24 00:02:16.290 ⇒ 00:02:17.780 Casie Aviles: We just need to enable.
25 00:02:17.780 ⇒ 00:02:21.030 Mustafa Raja: Oh, okay, I thought we knew Tim.
26 00:02:23.250 ⇒ 00:02:25.159 Casie Aviles: Yeah, I think we just need to enable it.
27 00:02:29.050 ⇒ 00:02:34.709 Casie Aviles: I also merged, by the way, the lightweight router now to…
28 00:02:34.710 ⇒ 00:02:35.670 Mustafa Raja: Yeah, I saw that.
29 00:02:35.670 ⇒ 00:02:41.290 Casie Aviles: migration progress, so… So we don’t have, like, two separate branches now.
30 00:02:41.540 ⇒ 00:02:45.360 Mustafa Raja: Yeah, yeah, the router is pretty good.
31 00:02:45.850 ⇒ 00:02:57.219 Mustafa Raja: Okay. It doesn’t give me… yeah, so, so, also, we are now… we are now under 5 seconds, right? Because I don’t see any alerts come in the channel.
32 00:02:58.530 ⇒ 00:03:01.970 Casie Aviles: I think… yeah, I think so, but…
33 00:03:02.210 ⇒ 00:03:05.890 Casie Aviles: What takes time would be the…
34 00:03:06.540 ⇒ 00:03:08.180 Mustafa Raja: DB thing, right?
35 00:03:08.400 ⇒ 00:03:15.160 Casie Aviles: Yeah, and it goes past 5 seconds. I didn’t check why it’s not, like… Showing up.
36 00:03:15.350 ⇒ 00:03:18.399 Casie Aviles: But it is taking more than 5 seconds.
37 00:03:18.740 ⇒ 00:03:22.860 Mustafa Raja: Okay, and the tests are still, configured, right?
38 00:03:23.100 ⇒ 00:03:25.669 Mustafa Raja: So we want Enterprise, not Enterprise Plus?
39 00:03:26.140 ⇒ 00:03:26.870 Casie Aviles: Okay.
40 00:03:28.290 ⇒ 00:03:36.450 Mustafa Raja: And then… wait, yeah, let’s, yeah, let’s do that.
41 00:03:36.780 ⇒ 00:03:43.470 Mustafa Raja: This is preset, we are going to configure it manually, so this doesn’t matter, really. So, we can scroll down.
42 00:03:44.280 ⇒ 00:03:45.100 Casie Aviles: No.
43 00:03:45.250 ⇒ 00:03:55.399 Mustafa Raja: I think we’ll have to set up an instance ID and stuff like that, but, this, yeah, you just have one, and then I think, I think for, for mine.
44 00:03:55.540 ⇒ 00:03:58.709 Mustafa Raja: For the one that we have, I think it’s single zone.
45 00:04:01.950 ⇒ 00:04:05.100 Mustafa Raja: And then… and then scroll down…
46 00:04:05.950 ⇒ 00:04:07.480 Casie Aviles: I think this is… yeah, this is…
47 00:04:07.480 ⇒ 00:04:11.079 Mustafa Raja: So, show configuration of, you know, this…
48 00:04:11.080 ⇒ 00:04:12.590 Casie Aviles: Oh, this one.
49 00:04:13.140 ⇒ 00:04:18.850 Mustafa Raja: Okay… Yeah, this, let’s, let’s take a look at this.
50 00:04:21.220 ⇒ 00:04:24.520 Mustafa Raja: Yes, it’s not general purpose, I think.
51 00:04:26.070 ⇒ 00:04:27.690 Mustafa Raja: Shared one.
52 00:04:28.980 ⇒ 00:04:35.739 Mustafa Raja: Yeah, sure. Yeah, this one, yeah, this is good. Now for storage, I think it’s 10 gigs.
53 00:04:37.940 ⇒ 00:04:39.699 Casie Aviles: Okay, yeah, we don’t need that deep.
54 00:04:41.490 ⇒ 00:04:45.499 Mustafa Raja: And I think I disabled automatic storage increase.
55 00:04:48.450 ⇒ 00:04:54.290 Mustafa Raja: And then, let’s… let’s go… let’s see, let’s… let’s go… keep going.
56 00:04:55.000 ⇒ 00:04:56.460 Casie Aviles: Okay. Action.
57 00:04:56.460 ⇒ 00:04:57.130 Mustafa Raja: you know.
58 00:04:59.030 ⇒ 00:05:00.490 Mustafa Raja: Sweet.
59 00:05:04.310 ⇒ 00:05:07.550 Mustafa Raja: Yeah, this is good. Let’s go into security.
60 00:05:09.110 ⇒ 00:05:12.709 Casie Aviles: Wait, I’m sorry, I paused. Alright, security.
61 00:05:16.400 ⇒ 00:05:19.149 Mustafa Raja: Yeah, this is good, let’s go to the protection.
62 00:05:20.790 ⇒ 00:05:21.910 Casie Aviles: Protection.
63 00:05:23.680 ⇒ 00:05:34.429 Mustafa Raja: Okay… Yeah, I don’t remember what I set up here… Automated daily backups.
64 00:05:35.800 ⇒ 00:05:40.569 Mustafa Raja: Yeah, yeah, let’s take a look at our instance, if we can, like that.
65 00:05:45.590 ⇒ 00:05:47.789 Casie Aviles: Oh, it’s yours? Why am I searching it?
66 00:05:48.680 ⇒ 00:05:49.899 Casie Aviles: Shouldn’t be here.
67 00:05:50.110 ⇒ 00:05:50.870 Mustafa Raja: Yeah.
68 00:05:54.060 ⇒ 00:05:55.270 Casie Aviles: Oh, okay.
69 00:05:55.270 ⇒ 00:05:57.660 Mustafa Raja: Man, yeah…
70 00:06:03.130 ⇒ 00:06:06.970 Mustafa Raja: Let’s try… let’s try Click Edit, see if…
71 00:06:10.580 ⇒ 00:06:13.629 Mustafa Raja: Oh, cool, no, just copy this!
72 00:06:14.080 ⇒ 00:06:14.860 Casie Aviles: Oh, okay.
73 00:06:14.860 ⇒ 00:06:16.159 Mustafa Raja: It’s the same thing.
74 00:06:16.550 ⇒ 00:06:18.929 Casie Aviles: I see, I see, so… okay.
75 00:06:19.140 ⇒ 00:06:22.450 Casie Aviles: I’ll just copy this then. Or where are we again?
76 00:06:22.700 ⇒ 00:06:24.560 Mustafa Raja: We have security.
77 00:06:24.710 ⇒ 00:06:26.560 Mustafa Raja: Oh, yes, I did rotation, yeah.
78 00:06:27.280 ⇒ 00:06:28.859 Mustafa Raja: Yeah, this is the same, I think.
79 00:06:29.510 ⇒ 00:06:31.049 Casie Aviles: Standard worker.
80 00:06:32.280 ⇒ 00:06:34.260 Casie Aviles: Oh, we just changed.
81 00:06:34.670 ⇒ 00:06:36.879 Mustafa Raja: The window is different, but that doesn’t matter, right?
82 00:06:39.820 ⇒ 00:06:41.880 Casie Aviles: GMT plus 8.
83 00:06:43.310 ⇒ 00:06:46.209 Mustafa Raja: I think it’s 12 to 4. Yeah, totally M24.
84 00:06:53.010 ⇒ 00:06:56.559 Casie Aviles: Enable point in time today.
85 00:06:57.620 ⇒ 00:06:59.140 Casie Aviles: It’s the same, okay.
86 00:07:00.680 ⇒ 00:07:03.640 Casie Aviles: 30… Maintenance…
87 00:07:07.110 ⇒ 00:07:11.650 Casie Aviles: Week 2, any window… Logs and parameters…
88 00:07:15.940 ⇒ 00:07:17.710 Casie Aviles: I think it looks the same.
89 00:07:20.080 ⇒ 00:07:21.280 Casie Aviles: Oh, wait.
90 00:07:22.460 ⇒ 00:07:23.730 Casie Aviles: What’s this…
91 00:07:26.990 ⇒ 00:07:29.100 Casie Aviles: But we don’t really need it, so…
92 00:07:29.100 ⇒ 00:07:30.110 Mustafa Raja: Okay. -
93 00:07:31.420 ⇒ 00:07:35.510 Casie Aviles: Query Insights… Seeing.
94 00:07:39.210 ⇒ 00:07:41.589 Mustafa Raja: Okay, so let’s compare the summary now.
95 00:07:43.060 ⇒ 00:07:44.359 Casie Aviles: No, so I’m already okay.
96 00:07:46.190 ⇒ 00:07:47.040 Casie Aviles: Dude.
97 00:07:50.380 ⇒ 00:07:51.150 Casie Aviles: Wait.
98 00:07:52.300 ⇒ 00:07:53.530 Casie Aviles: There’s just so many.
99 00:07:54.660 ⇒ 00:07:55.869 Mustafa Raja: It may be on the top.
100 00:07:56.680 ⇒ 00:08:02.689 Mustafa Raja: Oh, I think it got hidden because of the… Windows hand.
101 00:08:02.690 ⇒ 00:08:03.600 Casie Aviles: Oh…
102 00:08:04.790 ⇒ 00:08:08.169 Mustafa Raja: We’ll have to… manually see it.
103 00:08:09.470 ⇒ 00:08:14.269 Mustafa Raja: Or maybe we could put the screens up and down, rather than left and right.
104 00:08:19.150 ⇒ 00:08:20.150 Mustafa Raja: You know?
105 00:08:27.840 ⇒ 00:08:28.510 Casie Aviles: Hold on.
106 00:08:39.730 ⇒ 00:08:41.500 Casie Aviles: Kind of snapping.
107 00:08:42.419 ⇒ 00:08:47.829 Mustafa Raja: Yeah, this also works. We just need to, just check it, just double.
108 00:08:47.830 ⇒ 00:08:48.290 Casie Aviles: D.
109 00:08:48.290 ⇒ 00:08:48.980 Mustafa Raja: Right.
110 00:08:50.250 ⇒ 00:09:00.289 Mustafa Raja: Okay, so it’s US South 1, Postgres 18, D, B, G, one small, one CPU, 1.5 RAM. Let’s take a look at that.
111 00:09:01.960 ⇒ 00:09:11.140 Mustafa Raja: You know, the cache disabled? The cache is disabled over there also? Or not?
112 00:09:13.010 ⇒ 00:09:17.230 Casie Aviles: Yeah, yeah, it’s disabled. Yeah, I used the other screen that I have, so…
113 00:09:17.230 ⇒ 00:09:23.219 Mustafa Raja: Oh, cool, cool, okay. Yeah, if the summary looks good to you, then… Yes, yes.
114 00:09:23.460 ⇒ 00:09:25.139 Casie Aviles: Yeah, that’s awesome.
115 00:09:27.670 ⇒ 00:09:32.880 Casie Aviles: Great instance… That’s it, right? I just have to create things.
116 00:09:32.880 ⇒ 00:09:39.279 Mustafa Raja: Yeah, so you’ll have to give it a instance ID and password.
117 00:09:39.390 ⇒ 00:09:47.909 Mustafa Raja: I’ve saved the password for prod, sorry, for the development one in the 1Pass, so you might also want to do that.
118 00:09:56.530 ⇒ 00:09:58.129 Casie Aviles: And, okay, so…
119 00:10:13.130 ⇒ 00:10:14.550 Mustafa Raja: What’s this extension?
120 00:10:16.320 ⇒ 00:10:26.210 Casie Aviles: Oh, this is, forgot what this is. Bitwarden, and then I also have one for… 1Password.
121 00:10:26.460 ⇒ 00:10:27.560 Mustafa Raja: Okay, k, okay.
122 00:10:28.680 ⇒ 00:10:32.489 Casie Aviles: Yeah, because I wasn’t using 1Password when I started out.
123 00:10:33.150 ⇒ 00:10:37.460 Mustafa Raja: Oh, okay. Yeah, me neither. I was using Microsoft.
124 00:10:37.630 ⇒ 00:10:38.590 Mustafa Raja: Something.
125 00:10:40.910 ⇒ 00:10:41.490 Casie Aviles: Okay…
126 00:10:41.490 ⇒ 00:10:43.560 Mustafa Raja: But OnePass is good, to be honest.
127 00:10:44.240 ⇒ 00:10:45.439 Casie Aviles: Yeah, it is.
128 00:10:47.720 ⇒ 00:10:49.420 Casie Aviles: Can’t I just copy it?
129 00:10:51.410 ⇒ 00:10:52.850 Casie Aviles: make…
130 00:10:57.770 ⇒ 00:11:00.739 Mustafa Raja: I want to see what I saved it as, you know.
131 00:11:01.770 ⇒ 00:11:06.129 Mustafa Raja: Let me, let me check, What name I gave…
132 00:11:10.030 ⇒ 00:11:12.750 Casie Aviles: I think it’s this one, Cloud SQL grids.
133 00:11:14.590 ⇒ 00:11:20.589 Mustafa Raja: Yeah, it’s Cloud SQL credits. Maybe I should… maybe I should rename it to Dev.
134 00:11:21.070 ⇒ 00:11:22.610 Mustafa Raja: instance, you know.
135 00:11:23.060 ⇒ 00:11:26.080 Casie Aviles: Okay. Yeah, I’ll… I can save it as well here.
136 00:11:26.080 ⇒ 00:11:30.630 Mustafa Raja: Oh, yeah, oh, that, yeah, this is just… this is… this is good.
137 00:11:31.380 ⇒ 00:11:33.819 Mustafa Raja: Yeah, let’s also add instance ID also.
138 00:11:51.330 ⇒ 00:11:51.950 Mustafa Raja: Yeah, dude.
139 00:11:51.950 ⇒ 00:11:53.020 Casie Aviles: Thank goodness.
140 00:11:53.530 ⇒ 00:11:55.679 Casie Aviles: Let me just, have it here.
141 00:12:07.080 ⇒ 00:12:16.429 Mustafa Raja: I think for connecting the Cloud Run with the Cloud SQL, I have that Zoom clip if you want to do that.
142 00:12:18.510 ⇒ 00:12:21.649 Casie Aviles: Oh, sure, sure. Is it the one that you already sent, or is it a different one?
143 00:12:21.650 ⇒ 00:12:26.159 Mustafa Raja: Yeah, yeah, I already sent in the thread yesterday with the timestamp.
144 00:12:27.300 ⇒ 00:12:30.160 Casie Aviles: Okay, so it’s the same zoom clip already.
145 00:12:30.160 ⇒ 00:12:31.680 Mustafa Raja: Yeah, that one, yeah.
146 00:12:34.000 ⇒ 00:12:38.660 Casie Aviles: Okay, so I just have to wait for this, then that should be alright.
147 00:12:39.560 ⇒ 00:12:40.500 Mustafa Raja: Yes…
148 00:12:43.790 ⇒ 00:12:49.960 Casie Aviles: Okay, one last thing, let’s see… Why am I going there?
149 00:13:05.080 ⇒ 00:13:07.940 Casie Aviles: I’ll just go to Cloud Human.
150 00:13:18.010 ⇒ 00:13:18.860 Casie Aviles: Okay.
151 00:13:19.550 ⇒ 00:13:22.420 Casie Aviles: I think we may… This is not…
152 00:13:23.240 ⇒ 00:13:25.979 Casie Aviles: I’m going to switch this off, probably, but…
153 00:13:26.470 ⇒ 00:13:28.760 Casie Aviles: So this will be our main ones still.
154 00:13:40.740 ⇒ 00:13:44.439 Casie Aviles: Oh, okay. It’s this one, right? I just have to connect it here.
155 00:13:47.320 ⇒ 00:13:52.979 Casie Aviles: I mean, for example, so this is for the development cloud run, so if I’m going to add, then I would just…
156 00:13:53.980 ⇒ 00:13:55.440 Casie Aviles: Select, right?
157 00:13:56.120 ⇒ 00:14:05.339 Mustafa Raja: Yes, yes. We should be able to just select this, and then, yeah. But this is the development instance, so…
158 00:14:06.660 ⇒ 00:14:11.220 Casie Aviles: Yeah, let me try it with… Where are we against staging?
159 00:14:17.550 ⇒ 00:14:19.849 Casie Aviles: Oh, this is the chat handler, okay.
160 00:14:23.790 ⇒ 00:14:25.500 Casie Aviles: Deploy a new one.
161 00:14:34.340 ⇒ 00:14:37.170 Casie Aviles: Okay… There you go.
162 00:14:37.840 ⇒ 00:14:38.979 Casie Aviles: It’s this one, right?
163 00:14:43.070 ⇒ 00:14:45.360 Mustafa Raja: Yes.
164 00:14:45.940 ⇒ 00:14:48.340 Mustafa Raja: Yes, yes, yes, this will be it.
165 00:14:49.670 ⇒ 00:14:56.549 Mustafa Raja: And then, and then, you’ll have to have a database URL with the URL for this instance, you know.
166 00:14:57.870 ⇒ 00:14:59.449 Casie Aviles: Oh, database,
167 00:14:59.730 ⇒ 00:15:01.750 Casie Aviles: Where do I get that?
168 00:15:01.750 ⇒ 00:15:06.180 Mustafa Raja: Oh, you’ll have to build that. I explained that in the… in the Zoom clip.
169 00:15:07.670 ⇒ 00:15:11.999 Casie Aviles: Oh, okay. Alright then. I guess I’ll just watch that after this.
170 00:15:12.270 ⇒ 00:15:17.749 Casie Aviles: I’ll revisit that clip, and… Yeah, I think this is it, right?
171 00:15:19.310 ⇒ 00:15:20.090 Mustafa Raja: Yes.
172 00:15:21.280 ⇒ 00:15:25.339 Casie Aviles: Okay, great. Okay, yeah. Thank you, Mustaf, for the time.
173 00:15:28.500 ⇒ 00:15:29.330 Casie Aviles: Mmm.
174 00:15:30.030 ⇒ 00:15:33.410 Casie Aviles: I’m just going to wait for this… And then…
175 00:15:34.780 ⇒ 00:15:41.360 Casie Aviles: set up the Cloud Run and the SQL, and then I’ll follow along your video. And if I have any questions, I’ll just let you know.
176 00:15:43.930 ⇒ 00:15:44.620 Mustafa Raja: Okay.
177 00:15:45.530 ⇒ 00:15:49.340 Casie Aviles: Alright, I guess that’s it, unless we’re missing anything, but yeah.
178 00:15:50.910 ⇒ 00:15:51.770 Mustafa Raja: Yep, okay.
179 00:15:52.110 ⇒ 00:15:53.250 Casie Aviles: Okay, thank you.
180 00:15:54.520 ⇒ 00:15:56.179 Mustafa Raja: Yeah, bye, have a good day.