Reddit Architecture 2 - Web Development Udacity English (auto-generated) Japanese

Reddit Architecture 2 - Web DevelopmentYouTube↗ IA↗(long shot)
Education 11.1K views 88 likes 2 dislikes 27 May 2012

Udacity 651K subscribers United States YouTube↗

so the next thing we did to increase the speed of the site was we added another

速度を上げるため次はデータベースを足しました

database and this was using a piece of tool piece of software called Sloane II I believe to replicate our database we

データベースのレプリケーションに使ったのは[br]確かSlony-Iというソフトでした

still only had one app server at this

APサーバが1つだったのでリクエストの数が膨大でした

time and we made lots of database requests our caching wasn't nearly as

キャッシングは最先端からほど遠く

advanced we had some basic caching it was just at the application level this

ほんのアプリケーションレベルでした

machine was hitting both of these

これが2台のマシンにヒットするのです

postgrads machines this is the first time we ran into the notion of

この時最初のタイムラグが発生しました

replication lag because we had these two separate machines and Salone would

Slonyが常に2台を同期させようとしますが

normally keep them in sync but sometimes the slave machine could lag by about

スレーブマシンが時々5秒ほど遅れるのです

five seconds or so and if you had just submitted a link and then we redirect

投稿があったらパーマリンクにリダイレクトして

you to the permalink and then we'd hit the slave machine that didn't have the permalink we'd send the user a 404 which

スレーブマシンにヒットして[br]ユーザに404エラーを出します

is really annoying

投稿の処理はとても面倒でした

right after you submitted a piece of content that's when we started thinking

この時キャッシュとデータベースへの

about keeping our cache writing to our

書き込みを思い立ちましたが

cache at the same time he's writing to our database and we also had the issue with these two processes of keeping

キャッシュの同期の問題が残っていました

these caches in sync we weren't using memcache yet the way we kept our caches

当時はまだmemcachedは使っておらず

in sync was we used a library called spread and spread is this kind of network library that basically you say

1つのホストにメッセージを送ったら[br]それを他のすべてのホストに送ってくれる

if you send a message to one host it'll

Spreadというライブラリを使っていました

send it to all these other hosts and so around this time is when we added our

この頃Pythonを動かすAPサーバを追加し

second app server that was running Python on it as well and we used spread to keep the two hash tables that we were

キャッシュとして使っていた2つのハッシュテーブルを

using as our cache kind of in sync this

Spreadで同期していました

worked sort of okay in terms of keeping

キャッシュの同期はこれでうまくいきましたが

these two caches in sync but it wasn't going to scale very well because

スケーリングが難しかったので

eventually we would add a couple more app servers to deal with more load and

APサーバを更に2台増やしました

spread like every time one of these app

キャッシュをアップデートする度に

servers would update its cache you would have to tell all of the other app servers about it and so turned into this

他のすべてのサーバに知らせる必要があったので

huge mess a lot of network traffic keeping all these caches in sync it was

膨大なアクセスのキャッシュを同期させるのは[br]本当に大変でした

a total mess and so eventually we would

その結果memcachedに変更したのですが

switch the memcache but that was not before we rewrote our database shortly

それはデータベースを書き換えたあとでした

after we switched to a couple machines in a couple databases we added comments

マシンとデータベースの変更後コメントを足しました

and the first version of comments it was

最初のバージョンはデータベーステーブルでした

just another database table there's nothing complicated about it it had a link ID of what link it was on and it

複雑なことは何もありませんでした[br]テーブルにはリンクIDと

had you know some contents author ID some kind of guest the columns that

コンテンツと作成者IDがありました[br]どんな行か想像がつくでしょう?

would have and we still did lots of joins it was relational database we

結合もたくさんしました[br]リレーショナルデータベースです

changed around this time to a more

この時データベースをもっと柔軟な構造にしました

flexible database architecture or at least a more flexible table design

なぜなら問題にぶつかった時は必ず

because the challenge we had was every time we added a new feature you might

どこかのテーブルに新しいテーブルや

have to add a new table or we might add a new column to one of these tables

行を足す必要があったからです

adding the column would take time and two we might have to do with data

それは時間のかかる作業でした　データの移行や

migration or update an index and then add all this load it was just a total

インデックスのアップデートは本当に苦痛でした

pain we felt like the rate at which we

当時の私たちの能力ではアップデートや

could add features was limited by our ability to update our database and to do these big migrations

大規模な移行作業はなかなかはかどりませんでした

Similar videos:

Memcached - Web Development
Udacity
13.5K views 115 likes 3 dislikes 23 Feb 2015100% match

Port - Web Development
Udacity
15.8K views 18 likes 0 dislikes 23 Feb 2015100% match

Italics
Udacity
49.1K views 16 likes 2 dislikes 23 Feb 2015100% match

HTML Basics
Udacity
16.5K views 75 likes 2 dislikes 16 Jul 2014100% match

Code Organization - Web Development
Udacity
7.2K views 25 likes 1 dislikes 27 May 2012100% match

Cache Architecture - Web Development
Udacity
7.2K views 16 likes 1 dislikes 27 May 2012100% match

Components of the Web Solution - Web Development
Udacity
9.6K views 19 likes 0 dislikes 23 Feb 2015100% match

Web Applications - Web Development
Udacity
19.5K views 59 likes 4 dislikes 02 Jun 2014100% match

Most Common Method - Web Development
Udacity
9.7K views 5 likes 0 dislikes 23 Feb 2015100% match

Shopping List Take 1 - Web Development
Udacity
841 views 1 likes 0 dislikes 23 Feb 2015100% match

Reddit Architecture - Web Development
Udacity
27.7K views 397 likes 3 dislikes 27 May 2012100% match

Components of the Web
Udacity
28K views 54 likes 0 dislikes 23 Feb 2015100% match

Adding Images
Udacity
12.9K views 36 likes 0 dislikes 23 Feb 2015100% match

Types of Databases - Web Development
Udacity
8.5K views 43 likes 4 dislikes 25 Apr 2012100% match

World Wide Web - Web Development
Udacity
37.9K views 40 likes 1 dislikes 23 Feb 2015100% match

File Types
Udacity
34.4K views 11 likes 3 dislikes 23 Feb 2015100% match

User Agent Header - Web Development
Udacity
11.6K views 24 likes 7 dislikes 23 Feb 2015100% match

Introduction - Web Development
Udacity
23.3K views 107 likes 0 dislikes 23 Feb 2015100% match

Missing End Tag Solution - Web Development
Udacity
22.8K views 7 likes 0 dislikes 23 Feb 2015100% match

Ad Networks - Web Development
Udacity
6.7K views 27 likes 3 dislikes 23 Feb 2015100% match

Part 2 - Web Development
Udacity
643 views 2 likes 0 dislikes 07 May 2012100% match

Rot13 - Web Development
Udacity
9.3K views 46 likes 8 dislikes 23 Apr 2012100% match

Datastore Types Solution - Web Development
Udacity
656 views 1 likes 0 dislikes 25 Apr 2012100% match

Growing Reddit - Web Development
Udacity
82.7K views 484 likes 27 dislikes 27 May 201282% match

App Server Architecture - Web Development
Udacity
14K views 52 likes 5 dislikes 27 May 201275% match

Frameworks - Web Development
Udacity
28.7K views 154 likes 25 dislikes 23 Feb 201573% match

Whitespace Solution - Web Development
Udacity
15.7K views 10 likes 1 dislikes 23 Feb 201567% match

Scaling Databases - Web Development
Udacity
64.3K views 795 likes 7 dislikes 25 Apr 201267% match

Course Outline - Web Development
Udacity
46.2K views 169 likes 0 dislikes 23 Feb 201567% match

Bold Tag - Web Development
Udacity
53K views 29 likes 0 dislikes 23 Feb 201567% match