Database Architecture - Web DevelopmentYouTube↗  IA↗(long shot)
Education  8.3K views 29 likes 1 dislikes   27 May 2012
Udacity 651K subscribers United States YouTube↗


Please select the problem
You must specify your email and describe the problem in detail
Describe your problem in detail if it's not obvious

Click to Play Video Click to Play Video
Beyond the app servers, we had our database.
Aparte de nuestros servidores de aplicaciones, teníamos nuestra base de datos.
Now, we just talked about how funky a database setup we had, but it was still Postgres,
Hablamos de que teníamos una configuración muy loca de base de datos, pero igual era PostgreSQL
and we'll still use the industry-standard cylinders for representing our databases,
y seguiremos usando los cilindros acostumbrados para representarlas.
and we had a couple of verticals-- I think we stored links on one,
Teníamos un par de verticales---Pienso que guardábamos enlaces en una,
votes on another, comments were on one, and then we had like a miscellaneous one.
votos en otra, en una estaban los comentarios, y teníamos una para miscelánea.
Did we store subreddits and users on the same one or something like that?
¿Guardamos "subreddits" y usuarios [br]en la misma o algo por el estilo?
Subreddits were with comments, users were with links.
-"Los Subreddits" estaban con los comentarios, [br]los usuarios con los enlaces.
When we first built the system, it was all on one machine,
Cuando construímos el sistema inicialmente, [br]todo estaba en una máquina
and we had different tables for each data type.
y teníamos tablas diferentes [br]para cada tipo de datos;
And so a natural way to grow was to split apart the data types,
así que una forma natural de crecer [br]era separar los tipos de datos,
because remember, I talked about how if you don't do joins, scaling is a lot easier--
porque recuerden, mencioné que escalar[br]es mucho más fácil si no se usan "joins".
This is an example of that.
Este es un ejemplo de ello.
You have to think a little bit harder about what your queries are going to be,
Tienen que pensar un poco más [br]sobre cuáles serán las consultas,
but you can start splitting things apart.
pero puedes comenzar a poner las cosas [br]por separado.
You know how many comments are in the comment's database now?
¿Sabes cuántos comentarios hay [br]en la base de datos?
Something in the order of like 250 million. >>250 million comments.
-Algo por el orden de 250 millones de comentarios.[br]-250 millones de comentarios.
When I left, I don't remember how many.
Cuando me fui, no sé cuántos había.
There was a lot and it wasn't fitting on one machine with links.
Había un montón, y no cabían[br]en una máquina con los enlaces.
All these databases were replicated. We used Londiste, I think.
Todas estas bases de datos fueron replicadas.[br]Usamos Londiste, creo.
Do you guys still use Londiste? Yes we do. Londiste is a third-party tool made by Skype.
-¿Ustedes aún usan Londiste?-Sí, aún. [br]Londiste es una herramienta hecha por--- Skype.
Basically what this does is-- I think it is a log shipping right?
Básicamente lo que esta hace es---[br]un "log shipping", ¿verdad?
No, so when you write to the master, it hits a trigger, which then inserts the same query
-No, cuando escribes en la copia maestra, se activa, luego introduce la misma consulta
into a queue and that's replicated to all the slaves. The same inserts will run all the slaves.
a la lista que luego es reproducida a las esclavas. Las mismas inserciones ejecutarán todas las esclavas.
Okay. So, it just actually replays the exact commands
OK, ¿entonces repite los comandos exactos?
Yes. Obviously, things like random get precalculated.
-Sí. Obviamente cosas como el "random" se precalculan.
Okay. So all these machines were replicated using Londiste, and Londiste is really cool,
OK, así que estas máquinas fueron replicadas usando Londiste, y Londiste es genial.
and it might be a Londis-te, I don't know.
Puede que se pronuncie de otra forma, no lo sé.
It's a problem with web technologies is right, you read about the technology, like I don't know.
Ese es un problema con la tecnología web, ¿no?[br]Lees sobre algo de tecnología--- Por ejemplo,
Some people I think called this HAProxy, but it's the first guy in the office
algunos dicen que esto se pronuncia JAproxy, [br]pero es la primera persona en la oficina
who discovers the piece of technology, he gets this is how it pronounced for the rest of the company.
que descubre una pieza de tecnología quien le dice al resto de la compañia cómo se pronuncia!
We replicate all of this machines both for durability,
Replicamos todas estas máquinas, [br]tanto por durabilidad
and also if we lost the machine, we wouldn't lose our data.
como por no perder datos en caso [br]de que se dañara la máquina.
In Reddit, if we lost your comment history, you'd be mad.
En Reddit, si perdemos tu historial de comentarios, te pondrías furioso.
And for load, which spread our reads across all these machines.
También por carga, lo que distribuye todo [br]entre estas máquinas.
Now, remember we talked about replication lag, and I learned this lesson the hard way
Recuerden que hablamos sobre el retraso en replicación, y esta lección la aprendí a la fuerza;
and it was really hard for me to figure out the first time because I've never heard
fue muy difícil para mí descubrirlo [br]porque nunca lo había escuchado antes
of replication lag, and we had to really subtle bugs as a result.
y como resultado tuvimos muchos errores que solucionar.
Similar videos:

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

Dynamic Content - Web Development
Udacity
6.1K views 2 likes 0 dislikes 23 Feb 2015100% match

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

Inline Vs Block
Udacity
17.3K views 139 likes 5 dislikes 23 Feb 2015100% match

The Method Attribute - Web Development
Udacity
9.6K views 14 likes 8 dislikes 22 Apr 2012100% match

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

Whitespace
Udacity
47.8K views 26 likes 4 dislikes 23 Feb 2015100% match

Scaling Databases - Web Development
Udacity
64.3K views 795 likes 7 dislikes 25 Apr 2012100% 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

Paragraph Tag - Web Development
Udacity
8.6K views 4 likes 0 dislikes 23 Feb 2015100% match

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

Overview - Web Development
Udacity
10.4K views 26 likes 0 dislikes 27 May 2012100% match

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

Caching - Web Development
Udacity
12.1K views 102 likes 0 dislikes 23 Feb 2015100% match

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

Missing End Tag
Udacity
43K views 15 likes 1 dislikes 23 Feb 2015100% match

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

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

Caching Techniques - Web Development
Udacity
34.4K views 216 likes 7 dislikes 23 Feb 2015100% match

Span and Div
Udacity
50.3K views 27 likes 1 dislikes 23 Feb 2015100% match

Stateless - Web Development
Udacity
9.2K views 35 likes 8 dislikes 23 Feb 2015100% match

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

File Types Solution - Web Development
Udacity
9.9K views 9 likes 0 dislikes 23 Feb 2015100% match

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

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

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

Reddit Architecture 2 - Web Development
Udacity
11.1K views 88 likes 2 dislikes 27 May 201282% match

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

Best Browser - Web Development
Udacity
14.9K views 7 likes 0 dislikes 23 Feb 201567% match


Settings Privacy About Contact Donate