1
00:00:00,430 --> 00:00:06,360
‫A little bit talk about horizontal partitioning versus sharding, so horizontal partition splits this

2
00:00:06,360 --> 00:00:13,320
‫big table into the same database, but another table or maybe through another schema in the same database.

3
00:00:14,040 --> 00:00:15,800
‫So you kind of share the same database.

4
00:00:15,810 --> 00:00:17,560
‫But now the client has to know this.

5
00:00:17,820 --> 00:00:23,190
‫The other schema that has Davel or the other table table name, it could be customers underscore West

6
00:00:23,370 --> 00:00:25,860
‫or customer's underscore E, right.

7
00:00:25,860 --> 00:00:26,530
‫Something like that.

8
00:00:26,790 --> 00:00:28,800
‫So that's that's the horizontal partition.

9
00:00:28,800 --> 00:00:32,020
‫So you can spread your data into the same database.

10
00:00:32,460 --> 00:00:32,880
‫Right.

11
00:00:32,890 --> 00:00:39,060
‫Sharding the other has the same table across multiple servers.

12
00:00:39,060 --> 00:00:40,830
‫So you keep the same name.

13
00:00:41,220 --> 00:00:44,970
‫But the database server or the database instance change.

14
00:00:44,970 --> 00:00:45,310
‫Right.

15
00:00:45,570 --> 00:00:46,590
‫That's the difference.

16
00:00:46,590 --> 00:00:46,830
‫Right.

17
00:00:47,040 --> 00:00:49,430
‫So as we said, like a horizontal partition.

18
00:00:49,430 --> 00:00:51,060
‫No actually changes the database.

19
00:00:51,060 --> 00:00:53,620
‫Now, as we said, Aldridge's put it in the schema.

20
00:00:53,760 --> 00:00:55,920
‫Well, charting everything is the same.

21
00:00:55,920 --> 00:00:59,160
‫But the server that's like essentially the differences between these two guys.

22
00:00:59,160 --> 00:00:59,370
‫Right?

23
00:00:59,370 --> 00:01:02,850
‫Horizontal portioner, sharding, jarding, multiple databases.

24
00:01:03,180 --> 00:01:03,630
‫Right.

25
00:01:04,290 --> 00:01:08,400
‫And horizontal partitioning, same database, multiple tables.