aboutsummaryrefslogtreecommitdiffhomepage
diff options
context:
space:
mode:
authorChocobozzz <florian.bigard@gmail.com>2016-12-25 09:42:01 +0100
committerChocobozzz <florian.bigard@gmail.com>2016-12-25 09:42:01 +0100
commit55e0591c8e773b27cecec39d18da6ade898c89ed (patch)
tree6ac76d5e662c7e93da14c630d2ced7d2d1b3644b
parent01735eb0170ba421c1a979f3c724608ade176c6e (diff)
downloadPeerTube-55e0591c8e773b27cecec39d18da6ade898c89ed.tar.gz
PeerTube-55e0591c8e773b27cecec39d18da6ade898c89ed.tar.zst
PeerTube-55e0591c8e773b27cecec39d18da6ade898c89ed.zip
Update architecture document with postgresql measurements
-rw-r--r--ARCHITECTURE.md11
1 files changed, 10 insertions, 1 deletions
diff --git a/ARCHITECTURE.md b/ARCHITECTURE.md
index cc6864fac..ebcffd6cb 100644
--- a/ARCHITECTURE.md
+++ b/ARCHITECTURE.md
@@ -54,7 +54,16 @@
54 * A pod is a websocket tracker which is responsible for all the video uploaded in it 54 * A pod is a websocket tracker which is responsible for all the video uploaded in it
55 * A pod has an administrator that can add/remove users, make friends and quit friends 55 * A pod has an administrator that can add/remove users, make friends and quit friends
56 * A pod has different user accounts that can upload videos 56 * A pod has different user accounts that can upload videos
57 * All pods have an index of all videos of the network (name, origin pod url, small description, uploader username, magnet Uri, thumbnail name, created date and the thumbnail file). For example, a test with 1000000 videos with alphanum characters and the following lengths: name = 50, author = 50, url = 25, description = 250, magnerUri = 200, thumbnail name = 50 has a mongodb size of ~ 4GB. To this, we add 1 000 000 thumbnails of 5-15 KB so 15GB maximum 57 * All pods have an index of all videos of the network (name, origin pod url, small description, uploader username, magnet Uri, thumbnail name, created date and the thumbnail file). For example, a test with 1000000 videos (3 tags each) with alphanum characters and the following lengths: name = 50, author = 50, podHost = 25, description = 250, videoExtension = 4, remoteId = 50, infoHash = 50 and tag = 10 has a PostgreSQL size of ~ 2GB with all the useful indexes. To this, we add 1 000 000 thumbnails of 5-15 KB so 15GB maximum
58
59 table_name | row_estimate | index | toast | table
60 pod | 983416 | 140 MB | 83 MB | 57 MB
61 author | 1e+06 | 229 MB | 140 MB | 89 MB
62 tag | 2.96758e+06 | 309 MB | 182 MB | 127 MB
63 video | 1e+06 | 723 MB | 263 MB | 460 MB
64 video_tag | 3e+06 | 316 MB | 212 MB | 104 MB
65
66
58 * After having uploaded a video, the server seeds it (WebSeed protocol), adds the meta data in its database and makes a secure request to all of its friends 67 * After having uploaded a video, the server seeds it (WebSeed protocol), adds the meta data in its database and makes a secure request to all of its friends
59 * If a user wants to watch a video, he asks its pod the magnetUri and the frontend adds the torrent (with WebTorrent), creates the HTML5 video tag and streams the file into it 68 * If a user wants to watch a video, he asks its pod the magnetUri and the frontend adds the torrent (with WebTorrent), creates the HTML5 video tag and streams the file into it
60 * A user watching a video seeds it too (BitTorrent) so another user who is watching the same video can get the data from the origin server and the user 1 (etc) 69 * A user watching a video seeds it too (BitTorrent) so another user who is watching the same video can get the data from the origin server and the user 1 (etc)