Jaime is the Senior DBA of the Wikimedia Foundation, managing Wikipedia databases.
In the last few years there have been several examples of major service problems affecting businesses data: outages causing data inconsistencies; unavailability or data loss, and worldwide cyberattack...
Article
For Percona Live Europe this year, I got accepted a workshop on query optimization and a 50-minute talk covering TLS for MySQL at Large Scale, talking about our experiences at the Wikimedia Foundati...
%7D.f%7Bfill:url(%23c)%7D.g%7Bfill:none%7D.h%7Bfill:%23fff%7D.i%7Bclip-path:url(%23b)%7D%3C/style%3E%3CclipPath id=%22b%22%3E%3Crect class=%22g%22 width=%22181.54%22 height=%2222%22/%3E%3C/clipPath%3E%3ClinearGradient id=%22c%22 x1=%222.79%22 y1=%22157.57%22 x2=%2223.29%22 y2=%22178.07%22 gradientTransform=%22translate(0 184.15) scale(1 -1)%22 gradientUnits=%22userSpaceOnUse%22%3E%3Cstop offset=%220%22 stop-color=%22%23fc3519%22/%3E%3Cstop offset=%221%22 stop-color=%22%23f0d136%22/%3E%3C/linearGradient%3E%3ClinearGradient id=%22d%22 x1=%225.13%22 y1=%22159.94%22 x2=%2223.63%22 y2=%22178.43%22 gradientTransform=%22translate(0 184.15) scale(1 -1)%22 gradientUnits=%22userSpaceOnUse%22%3E%3Cstop offset=%220%22 stop-color=%22%23fc3519%22/%3E%3Cstop offset=%221%22 stop-color=%22%23f0d136%22/%3E%3C/linearGradient%3E%3C/defs%3E%3Cg class=%22i%22%3E%3Cg%3E%3Cpath class=%22f%22 d=%22M20.3 13.47c2.66-1.74 3.53-5.28 1.92-8.07-.81-1.4-2.11-2.4-3.67-2.82-1.44-.39-2.95-.23-4.28.44L12.46-.11 8.7 6.41.0 21.47H24.92l-4.62-8zm-2.18-9.29c1.13.3 2.08 1.03 2.66 2.04 1.15 2 .55 4.53-1.32 5.81l-4.37-7.57c.94-.45 2-.55 3.03-.28zm-5.67-.99 9.6 16.62h-5.61L9.65 8.05l2.81-4.86h0zM2.86 19.81l5.83-10.1 5.83 10.1H2.86z%22/%3E%3Cpath class=%22e%22 d=%22M20.32 13.43c2.66-1.74 3.53-5.28 1.92-8.07-.81-1.4-2.11-2.4-3.67-2.82-1.44-.39-2.95-.23-4.28.44L12.48-.15 8.72 6.37.02 21.43H24.94l-4.62-8zm-2.17-9.29c1.13.3 2.08 1.03 2.66 2.04 1.15 2 .55 4.53-1.32 5.81l-4.37-7.57c.94-.45 2-.55 3.03-.28zm-5.67-.99 9.6 16.62h-5.61L9.68 8.01l2.81-4.86h0zM2.88 19.77l5.83-10.1 5.83 10.1H2.88z%22/%3E%3Cpath class=%22h%22 d=%22M41.46 15.15h-3.51v6.28h-4.62V.48h8.59c5.01.0 8.05 2.96 8.05 7.24v.06c0 4.85-3.78 7.36-8.5 7.36h0zm3.81-7.33c0-2.07-1.44-3.17-3.75-3.17h-3.57v6.4h3.66c2.31.0 3.66-1.38 3.66-3.17v-.06h0z%22/%3E%3Cpath class=%22h%22 d=%22M52.54 21.44V.48h15.85V4.59H57.13v4.25h9.91v4.1h-9.91v4.4h11.41v4.1h-16z%22/%3E%3Cpath class=%22h%22 d=%22M84.92 21.44l-4.5-6.7h-3.63v6.7h-4.62V.48h9.61c4.96.0 7.93 2.61 7.93 6.92v.06c0 3.38-1.83 5.51-4.5 6.5l5.13 7.48h-5.41zm.09-13.8c0-1.97-1.38-3-3.63-3h-4.59v6.02h4.69c2.25.0 3.54-1.2 3.54-2.96v-.06h0z%22/%3E%3Cpath class=%22h%22 d=%22M102.95 22c-6.27.0-10.92-4.82-10.92-10.92v-.06C92.03 4.98 96.59.04 103.14.04c4.01.0 6.42 1.33 8.4 3.27l-2.98 3.43c-1.64-1.49-3.31-2.4-5.45-2.4-3.59.0-6.18 2.97-6.18 6.61v.06c0 3.64 2.53 6.67 6.18 6.67 2.43.0 3.93-.97 5.6-2.49l2.98 3c-2.19 2.34-4.63 3.79-8.73 3.79h0z%22/%3E%3Cpath class=%22h%22 d=%22M124.05 22c-6.57.0-11.29-4.88-11.29-10.92v-.06C112.77 4.98 117.54.04 124.11.04s11.29 4.88 11.29 10.92v.06c0 6.04-4.78 10.98-11.35 10.98zm6.45-10.98c0-3.64-2.68-6.67-6.45-6.67s-6.39 2.97-6.39 6.61v.06c0 3.64 2.68 6.67 6.45 6.67s6.39-2.97 6.39-6.61v-.06z%22/%3E%3Cpath class=%22h%22 d=%22M160.85 21.45 171.2.04l10.34 21.42h-5.19l-5.16-10.66-5.14 10.66h-5.21z%22/%3E%3Cpath class=%22h%22 d=%22M158.94.49V22L143.17 9.26v12.16h-4.91V.04l15.77 12.69V.49h4.91z%22/%3E%3C/g%3E%3C/g%3E%3Cg%3E%3Cpath class=%22h%22 d=%22M209.73 6.66c.71-1.28 1.67-2.27 2.89-2.99s2.59-1.07 4.09-1.07c1.83.0 3.41.44 4.71 1.31 1.31.87 2.26 2.1 2.86 3.68h-1.93c-.47-1.11-1.19-1.98-2.15-2.61-.96-.63-2.13-.94-3.49-.94-1.21.0-2.29.28-3.26.85s-1.72 1.38-2.27 2.43-.82 2.29-.82 3.68.27 2.62.82 3.67 1.31 1.86 2.27 2.42 2.05.85 3.26.85c1.36.0 2.53-.31 3.49-.93s1.68-1.48 2.15-2.58h1.93c-.6 1.57-1.55 2.78-2.87 3.64s-2.88 1.29-4.7 1.29c-1.5.0-2.87-.36-4.09-1.07s-2.19-1.7-2.89-2.97c-.71-1.27-1.06-2.71-1.06-4.33s.35-3.06 1.06-4.34z%22/%3E%3Cpath class=%22h%22 d=%22M230.8 18.32c-1.24-.71-2.21-1.71-2.93-2.99-.71-1.28-1.07-2.72-1.07-4.34s.36-3.06 1.07-4.34c.71-1.28 1.69-2.27 2.93-2.99s2.62-1.07 4.14-1.07 2.92.36 4.16 1.07 2.21 1.71 2.92 2.99c.71 1.28 1.06 2.72 1.06 4.34s-.35 3.06-1.06 4.34-1.68 2.27-2.92 2.99c-1.24.71-2.63 1.07-4.16 1.07s-2.9-.36-4.14-1.07zm7.43-1.21c.97-.56 1.74-1.38 2.3-2.43s.85-2.28.85-3.68-.28-2.62-.85-3.67c-.56-1.05-1.33-1.86-2.3-2.42-.97-.56-2.07-.85-3.29-.85s-2.32.28-3.29.85-1.74 1.37-2.3 2.42c-.56 1.05-.85 2.27-.85 3.67s.28 2.62.85 3.68c.56 1.06 1.33 1.87 2.3 2.43s2.07.85 3.29.85 2.32-.28 3.29-.85z%22/%3E%3Cpath class=%22h%22 d=%22M262.15 3V19.23h-1.65V6.27l-5.78 12.96h-1.2l-5.79-12.91v12.91h-1.65V3h1.74l6.28 14.06L260.38 3h1.76z%22/%3E%3Cpath class=%22h%22 d=%22M281.95 3V19.23h-1.65V6.27l-5.78 12.96h-1.2l-5.79-12.91v12.91h-1.65V3h1.74l6.28 14.06L280.18 3h1.76z%22/%3E%3Cpath class=%22h%22 d=%22M287.26 2.79V13.14c0 1.63.39 2.84 1.16 3.62.78.78 1.84 1.18 3.19 1.18s2.4-.39 3.16-1.16c.76-.78 1.14-1.99 1.14-3.63V2.79h1.65V13.12c0 2.08-.55 3.65-1.66 4.7s-2.54 1.58-4.32 1.58-3.21-.53-4.31-1.58c-1.11-1.05-1.66-2.62-1.66-4.7V2.79h1.65z%22/%3E%3Cpath class=%22h%22 d=%22M313.62 19.23h-1.65l-9.1-13.83v13.83h-1.65V2.79h1.65l9.1 13.8V2.79h1.65V19.23z%22/%3E%3Cpath class=%22h%22 d=%22M319.01 2.79V19.23h-1.65V2.79h1.65z%22/%3E%3Cpath class=%22h%22 d=%22M332.37 2.79v1.36h-4.56v15.07h-1.65V4.16h-4.59V2.8h10.79z%22/%3E%3Cpath class=%22h%22 d=%22M345.84 2.79l-5.27 10.04v6.4h-1.65v-6.4l-5.31-10.04h1.86l4.28 8.54 4.26-8.54h1.83z%22/%3E%3C/g%3E%3C/svg%3E)
Comments