×
Copy
Open
Link
Embed
Share
Beginning
This slide
Copy link URL
Copy link URL
Copy iframe embed code
Copy iframe embed code
Copy javascript embed code
Copy javascript embed code
Share
Tweet
Share
Tweet
Slide 1
Slide 1 text
To 1000 servers and beyond Nikolay Bachiyski PHPUK 2012
Slide 2
Slide 2 text
http://extrapolate.me/ @nikolayb
Slide 3
Slide 3 text
No content
Slide 4
Slide 4 text
No content
Slide 5
Slide 5 text
No content
Slide 6
Slide 6 text
Stinson Beach, July 2007
Slide 7
Slide 7 text
Budapest, Oct 2011
Slide 8
Slide 8 text
Jul, 2007 65MM Feb, 2011 800MM PV
Slide 9
Slide 9 text
2 stories
Slide 10
Slide 10 text
Story #1
Slide 11
Slide 11 text
Deep Pink Meet
Slide 12
Slide 12 text
Don’t like?
Slide 13
Slide 13 text
Beer Beheader =
Slide 14
Slide 14 text
No content
Slide 15
Slide 15 text
No content
Slide 16
Slide 16 text
Abstraction
Slide 17
Slide 17 text
No content
Slide 18
Slide 18 text
Beer Theory
Slide 19
Slide 19 text
No content
Slide 20
Slide 20 text
Want to be better?
Slide 21
Slide 21 text
Get to know the abstraction below
Slide 22
Slide 22 text
Servers are below
Slide 23
Slide 23 text
Story #2 Scaling WordPress.com
Slide 24
Slide 24 text
No content
Slide 25
Slide 25 text
X
Slide 26
Slide 26 text
Deep Pink SAD
Slide 27
Slide 27 text
No content
Slide 28
Slide 28 text
X
Slide 29
Slide 29 text
Deep Pink SAD
Slide 30
Slide 30 text
No content
Slide 31
Slide 31 text
No content
Slide 32
Slide 32 text
Users Blogs Blogs
Slide 33
Slide 33 text
No joins :(
Slide 34
Slide 34 text
No content
Slide 35
Slide 35 text
SELECT * FROM wp_users WHERE id=43315 SELECT * FROM wp_posts LIMIT 10
Slide 36
Slide 36 text
HyperDB
Slide 37
Slide 37 text
No content
Slide 38
Slide 38 text
SELECT * FROM wp_users WHERE id=43315
Slide 39
Slide 39 text
Query parsing
Slide 40
Slide 40 text
add_db_table('user', 'wp_users') Dataset Table name
Slide 41
Slide 41 text
add_db_server('user', 0, 1, 0, 'db42.wordpress.com',…) Dataset Partition Read Write Slave
Slide 42
Slide 42 text
Failover X
Slide 43
Slide 43 text
Can work without
Slide 44
Slide 44 text
http://wordpress.org/extend/plugins/hyperdb/
Slide 45
Slide 45 text
No content
Slide 46
Slide 46 text
No content
Slide 47
Slide 47 text
C C C C
Slide 48
Slide 48 text
$count = wp_cache_get('posts', 'counts'); if ( false !== $count ) return $count; $count = $wpdb-‐>get_results($complex_query);
Slide 49
Slide 49 text
Output caching
Slide 50
Slide 50 text
10% 90% reads writes
Slide 51
Slide 51 text
C C C C
Slide 52
Slide 52 text
C C C C
Slide 53
Slide 53 text
Deep Pink SAD
Slide 54
Slide 54 text
Datacenter
Slide 55
Slide 55 text
C C sane sane
Slide 56
Slide 56 text
C C crazy sane Update
Slide 57
Slide 57 text
C C crazy sane Stale!
Slide 58
Slide 58 text
C C crazy crazy
Slide 59
Slide 59 text
Deploy
Slide 60
Slide 60 text
trunk/
Slide 61
Slide 61 text
Branch in code
Slide 62
Slide 62 text
~100 commits a day
Slide 63
Slide 63 text
~100 deploys a day
Slide 64
Slide 64 text
to ~1000 servers
Slide 65
Slide 65 text
One-click
Slide 66
Slide 66 text
No content
Slide 67
Slide 67 text
Fast!
Slide 68
Slide 68 text
wpdev@nikolay:~$ deploy wpcom Going to update from 47127 to 47128 Syncing wpcom SVN Mirrors ORD (0s)... LUV (0s)... SAT (0s)... Deploying wpcom revision 47128 ORD (3s)... SAT (5s)... LUV (6s)... Revision 47128 successfully deployed (8s)
Slide 69
Slide 69 text
No content
Slide 70
Slide 70 text
No content
Slide 71
Slide 71 text
Yeah, immediately!
Slide 72
Slide 72 text
Push to twitter
Slide 73
Slide 73 text
Push to Facebok
Slide 74
Slide 74 text
Stats
Slide 75
Slide 75 text
Spam checks
Slide 76
Slide 76 text
Index for search
Slide 77
Slide 77 text
Invalidate caches
Slide 78
Slide 78 text
Publish the post
Slide 79
Slide 79 text
ASYNC JOBS
Slide 80
Slide 80 text
No content
Slide 81
Slide 81 text
$job_id = queue_async_job($data, 'encode_video');
Slide 82
Slide 82 text
Priorities
Slide 83
Slide 83 text
Deferred jobs
Slide 84
Slide 84 text
No content
Slide 85
Slide 85 text
PHP & MySQL
Slide 86
Slide 86 text
http://code.trac.wordpress.org/wiki/JobsDocs http://code.trac.wordpress.org/browser/jobs
Slide 87
Slide 87 text
Integration
Slide 88
Slide 88 text
Hacking
Slide 89
Slide 89 text
No content