https://engineering.fb.com/2024/03/06/security/whatsapp-mess...
It wasn’t the top selling car. That seems to be something Elon made up: https://www.autoweek.com/news/industry-news/a44600661/is-tes...
The big tech companies (ie. FANG) all have huge demand for principal+ engineers and know how to scope and support them properly. The size means they have lots of them which reduces the snowflake nature of the role and…
Direct source is available at: https://github.com/facebook/mysql-5.6 The social graph is indeed stored in MySQL via TAO. A recent white paper about MyRocks is:…
The code is open source: https://github.com/facebook/mysql-5.6
Facebook doesn't have engineering titles for exactly this reason.
If you find this book interesting, a good video which talks about Production Engineering at Facebook and talks a bit about Google SRE: https://www.youtube.com/watch?v=ugkkza3vKbc
There is nothing that prevents these from being implemented for PostgreSQL. In fact, they have already done a lot of optimizations that close the gap, such as covering indexes. Before covering indexes, InnoDB was even…
(I am a manager of the Data-Perf team at FB which deals with lots of different DB technologies) MySQL (specifically InnoDB) is extremely efficient as a storage backend compared to PostgreSQL. There are a few features…
Yes, we are still very active users of MySQL. Most of the primary portions of facebook.com are still served from a backend MySQL system (with lots of caching and many other services involved). Some data is not stored in…
Doing compression on the ZFS level is significantly worse than InnoDB compression. InnoDB has a lot of really smart optimizations which make it much better than just zipping things up. Included are the modification log…
In addition, when you are dealing with many thousand application servers and many hundred database connections, the database will not end up happy having to maintain > 10k connections. So you will end up needing to add…
Why would the license matter for a kernel module? You know that the linux kernel is also GPL v2 right?
When you delete your account, the data is actually removed. As part of the recent privacy audit, the Irish DPC reviewed the account deletion framework and verified that it does indeed work:…
Facebook does not sell user data regardless of what you may have heard. See: https://www.facebook.com/help/152637448140583/
jemalloc is the new hotness for MySQL. We are using it at Facebook (and I know percona/oracle use it for benchmarks and testing as well). Good benchmark showing the impact of the different options:…
You quote version 3.23, yet talk about subqueries which didn't get added until version 4.1. ONLY_FULL_GROUP_BY was added in 4.0 but only applied to select list columns, the 5.0.23 mentioned above applies to the HAVING…
http://techcrunch.com/2013/01/09/facebook-app-users/
Looking at the benchmarks, something looks wrong in the graphs. For example, for one it looks like they were doing from 0-2M ops for the test. Some of the engines were claimed to do 1M ops per second. That would result…
Then your slaves will lag really badly while the replication thread keeps stalling on table level locks. InnoDB is faster at reads for most workloads on modern hardware. MyISAM has horrible scalability across multiple…
I wonder why they picked MyISAM for MySQL, since basically no one sane is using that anymore. It isn't even the default anymore, so that can't be the excuse. "MyISAM caches index blocks but not data blocks."
The primary settings are: sync_binlog=1 innodb_flush_log_at_trx_commit=1 (which is default, but we add it to our configs since we run with =2 on the slaves since they don't need full durability) We do use some…
HPHP has a built in multi-threaded webserver.
Quora question about that: http://www.quora.com/How-does-Facebook-implement-feature-swi...
It's a bit funny that you use Facebook as an example since they use sharded MySQL as their primary data store.
https://engineering.fb.com/2024/03/06/security/whatsapp-mess...
It wasn’t the top selling car. That seems to be something Elon made up: https://www.autoweek.com/news/industry-news/a44600661/is-tes...
The big tech companies (ie. FANG) all have huge demand for principal+ engineers and know how to scope and support them properly. The size means they have lots of them which reduces the snowflake nature of the role and…
Direct source is available at: https://github.com/facebook/mysql-5.6 The social graph is indeed stored in MySQL via TAO. A recent white paper about MyRocks is:…
The code is open source: https://github.com/facebook/mysql-5.6
Facebook doesn't have engineering titles for exactly this reason.
If you find this book interesting, a good video which talks about Production Engineering at Facebook and talks a bit about Google SRE: https://www.youtube.com/watch?v=ugkkza3vKbc
There is nothing that prevents these from being implemented for PostgreSQL. In fact, they have already done a lot of optimizations that close the gap, such as covering indexes. Before covering indexes, InnoDB was even…
(I am a manager of the Data-Perf team at FB which deals with lots of different DB technologies) MySQL (specifically InnoDB) is extremely efficient as a storage backend compared to PostgreSQL. There are a few features…
Yes, we are still very active users of MySQL. Most of the primary portions of facebook.com are still served from a backend MySQL system (with lots of caching and many other services involved). Some data is not stored in…
Doing compression on the ZFS level is significantly worse than InnoDB compression. InnoDB has a lot of really smart optimizations which make it much better than just zipping things up. Included are the modification log…
In addition, when you are dealing with many thousand application servers and many hundred database connections, the database will not end up happy having to maintain > 10k connections. So you will end up needing to add…
Why would the license matter for a kernel module? You know that the linux kernel is also GPL v2 right?
When you delete your account, the data is actually removed. As part of the recent privacy audit, the Irish DPC reviewed the account deletion framework and verified that it does indeed work:…
Facebook does not sell user data regardless of what you may have heard. See: https://www.facebook.com/help/152637448140583/
jemalloc is the new hotness for MySQL. We are using it at Facebook (and I know percona/oracle use it for benchmarks and testing as well). Good benchmark showing the impact of the different options:…
You quote version 3.23, yet talk about subqueries which didn't get added until version 4.1. ONLY_FULL_GROUP_BY was added in 4.0 but only applied to select list columns, the 5.0.23 mentioned above applies to the HAVING…
http://techcrunch.com/2013/01/09/facebook-app-users/
Looking at the benchmarks, something looks wrong in the graphs. For example, for one it looks like they were doing from 0-2M ops for the test. Some of the engines were claimed to do 1M ops per second. That would result…
Then your slaves will lag really badly while the replication thread keeps stalling on table level locks. InnoDB is faster at reads for most workloads on modern hardware. MyISAM has horrible scalability across multiple…
I wonder why they picked MyISAM for MySQL, since basically no one sane is using that anymore. It isn't even the default anymore, so that can't be the excuse. "MyISAM caches index blocks but not data blocks."
The primary settings are: sync_binlog=1 innodb_flush_log_at_trx_commit=1 (which is default, but we add it to our configs since we run with =2 on the slaves since they don't need full durability) We do use some…
HPHP has a built in multi-threaded webserver.
Quora question about that: http://www.quora.com/How-does-Facebook-implement-feature-swi...
It's a bit funny that you use Facebook as an example since they use sharded MySQL as their primary data store.