Tuesday Aug 18, 2015

MySQL Sharding at Pinterest

A few months ago, I pointed to a very interesting blog by Marty Weiner, Engineering Manager at Pinterest.

Marty posted another great blog "Sharding Pinterest: How we scaled our MySQL fleet":

"This is a technical dive into how we split our data across many MySQL servers. We finished launching this sharding approach in early 2012, and it’s still the system we use today to store our core data. 

...Pinterest is a discovery engine for everything that interests you. From a data perspective, Pinterest is the largest human curated interest graph in the world. There are more than 50 billion Pins that have been saved by Pinners onto one billion boards. People repin and like other Pins (roughly a shallow copy), follow other Pinners, boards and interests, and view a home feed of all the Pinners, boards and interests they follow. Great! Now make it scale!"

…Read Marty’s blog to find out about their experience and recommendations.

data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAASwAAABNCAYAAAAcolk+AAAABmJLR0QA/wD/AP+gvaeTAAAgAElEQVR4nO2de3ycVZ3/P98zM0lpUu5QKG0yk6QzE9KWy2RSqFwCwiqXVW6iiCAuu4AriiIsXva3uCsorKuIgOAuCojuagUFBZSLtAiUNjMpFAnNpGkyqeVSpBRo2uYyz/n8/phJSObynDOTCS0y79dLX/R5znPOycw833PO9wpUqFChwnsEme4B4sHgvhxRC0A2QKFBAD+JKgCzQPGmZ8ERANtE8FdorqfIek08v3gg0T/d86tQoUJxLAU8gfqmRRBvG8AAgXkC+MYbCN4WYh2oXxhxqp5ZsrHrjXKNXXaBtczvn1HDGScrxQ+SPBaQg0sfh5sAWSXC3zkj6jeLX+reXNbJVqhQwYpl7e3eWcmXT9WQjwlwCoA9LB8lgBhFfqV8+s7Wnp7XpzKPsgmsDn/4WAE/DeAM2P8x9hApCB4Sxe+09vU8Vfb+K1SokEM8EvHpzYP/LMCXAcybYndDEPlxlRr9j0PWr3+tlA6mJLCWtbd7a5MvnwWRK0BEptJXURBPiYdfrQiuChWmj46GYFS03AWgucxdv0nB59v6Ez8r9sGSBVZHYP4xotUtECwotY8pQ9zj+JwvHdHbu3GnzaFChb9BYoHwpSC/h4m6qXIjckt/f/dlZwOO9SPFjvGs379nCjNuBHheKc9PA1tEcHFrf+JXO3siFSr8LRD3B79FyFctmm4BsBHgq4C8CaAWwFwQzRB4LYf7ZX8yca6t0CpK4HTUh5co4c8J+It57l3i+63JxJcF0Dt7IhUqvFeJ+8P/TvDfXJq8AchdBO5PJrufyidoulpaarcPjh4DwRcBOdFi2B9Fk4lLbOZnLbBi9aELAdxWhOTM5g1A1oFcB+H2rGkcAKIBgiCAqhL7BwT37ulxzp3f2ztcch8VKrxP6agPnyHCewvcHqHwphlO9bWLNvx5i22fnQ3hU7Xmz2AwxBH4h7Zk4g5Tf1YCK+YPfRHA92zbZ2aQgpKHCX0/RT2xuK+7x/RIV0tL1Y5tI4eR6gQonF6iIv++Qf+BHztu+fJUCc9WqPC+ZE1j4/4jjnctgL3z3N5KzdPbNvT8sZS+O+oObhHlrACwu0uzNx3xhY/of2GTW19GAdThD10mwPeLmN+bAvmBzzN6S6mmyzFi9U2HAZ7LIfgkAGX7HMG72pI9F0xl7AoV3k/E/KEfA/iHPLe2KS3HRjZ0d06l/7g/eBohv3FrQ+AHbcnEZW5tXAVWvD78SQrvhp2wcAjc4sPw1Yclk29atLcmVt90mIjnDgKH2D5DkSvb+rv/q5zzqFDhb5FYXbABSnoAeHJuilwc7e/+77KM4w8tA9Du0mSHF8Nz3ORHQUHU0RCMUniHW5sxBFintCxuSyYuK7ewAoDoQO+zu9V420jcbvuMkNd1BoJHl3suFSr8zaHk88gnrCiPlUtYAQAENxha7JaSGWe7NcgrjOINDXuIll/ATgH+25TXaZ3qltFES1fXSNtA4p8Iuc7yEY+m/KirpaV0JX6FCn/jLGtv9wI4N+9Nj76+nGPJcO1jAEwGsY+43cwrsKh9NwBoME4AvHPQf+CZR/T2vm1qWy7akt1fheDHls2bd2xLfWlaJ1ShwnuYmf2vRgHsl31dgHWtfaUp2QvR+nLndgBrXRuRbW63cwRWvCF4FIALjKOLPNiX7PnHnWGNGx3d9nkQL9i0JfAvK5ua3KwTeVkZWDA7Xt98eHxeU2PxM6xQ4b2BEuZVm5B8WNKBy2WFgKsVEMB+z9ct3KvQzUk+VQQkruUmmK2HieEqnlOMS305WbJx445YXegSCJ6Eea57e0Y9nwdwralfAtLpD58P8Evk6CEUAB4P4v5QEpBvtCa775r67Hc9CEjnvKYGej2HATwMlEMB7AY6X44O9D67s+dXYfoQIJJXKgmenpbxiK2mN3a7N7Uv0l70OUwSWJ31808GcKhhzBGl5dyjEt1bbSe5FPCE6xbuvnDDn98sl9SObkg8HfOHHgDw98bGgosIfNvNC37N7EU18ZkjvwR5Sva9tGc/74zXh/dtHej+7pQmvouQCbH6IsHj42nr6+7pb2bCr0k8FwH47M6ZYYV3AwJN+a47Wj8/LQOKqy8WAMCrnVwDQIZJR0KK518shrzBRsEej0R8MX/44rg/9FygPjQ0rEbeiPtDQzF/6MFYXegDFuMYoeaNlk3r4oHmDxbsB1Ajuw39Jp+wmtROeO3Kpqa5RU1yF2UUVb8HeLUAR6OAQx9F1r/L06rw7jMn30WlqsuWdC+L/U0NRlK+gv6b4wIrFgiFAB7j3hU3zazxXmMaMFYXbODmwacB3kbgkAnhPFUATobCkx31wX829WMiuaFnOYBXrRprp6D1IV4f/KxlzFO1N+Ux7+h2ceL1zYcL5AhTOwqXvwvTqbBzqcl7sQZlF1gEBMy/o5vA8JEbuwqG/kzcYZ1nHlFuaunqGnRr0tHYOA9KlgGIujQTEflBLBB0tQiYOBtwCD5s1Vgk7w6LgEDkStsxKXzP77C04vEWzd4a6EtU9FfvU17bts06ssSWVU1NB0FQa2i2yU1t9M6kiDMMHY3olNzm1mAp4BHHey+AOkNfAOABcZVFO1dE1ArLps35rA/xxuYWAPXWAxJTSvG6S6D1saYmJJ/cWUaVCu8qeX/Pe3i9s8o9kMfxGHf1ALrcbioAWD0vNAfmrIIPm3KqN/hDn4P7zioL+VDGca10CGNQ9RhDMprzN1IzUNRwCu/pLKdLAY+IGCMAFNTyd2E6FXYyBPO6GYxqj/0ibj+YWXctWO12WwFAypPfF2PyWDAFLioClxsnNJmaWes3TumDESf1F/vGCOZcc/T2PC0LdfBsW19PzL79rkdjXfhQWOTcF2L59M+mws5GROU1oHm0tEzDcEaBpTVdDXoq/X/qYFNHHo/3Sbf7GStc0cJHvJ68Sj9bUt4Zrjq1SWNB5xwJdZWOARgyPkykSFxa3Ox2PSiuwadjvLl+Q/dz0z2XCrsALORvpdvLOcya2YtqQBxmaideJ+52XwEAwZChnzcj67t6XVtQF3QbcH1MvGUPlnYhx3x/RG/v20LcbHiOAC5pG+i21ZftslBo1F8BqOiv3id4vKnHAIxmX9eQk+ORSNnyuY/MGDrGIvnn+rb1611PTBmBlRtLNAnCXVgBAORIc5schrfW7fdyCc9NGNaxDrthAevDbrXer4vg5wUe6ydwcnQgYRu/uMuyNB2Rbzz+CyvuDO8XDu/t/SuAP2RfF2B//cbg6eUaR5ScampDYpmpjQIAAdwtAgJjVRoBbSyD2Q+9MNVYRIG2roEoIjvyXW/p6hpp7U98ioptAL8B8L8JuQ7kyYP+A4NtyUTOF/pepKG++RAAe5pbepZP91wq7FLkXYyF+Pdy7bJIuDplA4CCGAXW2BatoCs8AIhgm3FCwD6mNnl6fqL4ZybjdbC7tk7cnF9gjZFRqE9Wqg9YGyF3ebTi8WIKjCJejwysreiv3kdEk4n7Y/7QMwCyT0lhvjF4NYB/nUr/Hf75h8Ks36bPO/qYqa+MwJJBtxA/6vJHbQMAtDZO0IQD2VNsp0e9S/tQLWtv99b2b1wI5ZknQDU1t4lw8241Vc+2dHWNTLV/odkaDMGK6ag81NXSUrXj7eF52uOdK8I9BKgWkR06xS1C59XWv/Tu1DCgZX7/jBrOOJzQswFAUV6TGUxMtbR6IeJzIjOd6q3zFcUvks47R81BEb6hUTXQluyyi+AokhVzW/au8jmtIA7Ugv2E3DdzK39ssMZVsfrgiuhAz0Olj+o5ySKEOGGTUj0tsARbXfuTvInps5pgM01Hy8mMzKz1uVoerRCYDAbjKMFL2dfi/uBpGnKcgDNyuhZJUcvj0YHuQpVEJrEU8ATqQ58GeBgkT/JDYpiK97T1r/vTO5egYoHQWUJ8EslXToB4asaVbSIgBNu3pXbE/KFlFH39xGfzEfOHPgrgawD2zXPbxkv/2Jg/VEh4DOhR+ZjJH2+MVYHgIUL1CSFP2L4tdRg8Ho9k/jgCIAkogPAg5g9tAPBHIe5uHUgYjwbZdARCnxLNNgiqs++JSIrAsmh/4p6J1wnI6obwKVrzIgAnQjhDxoK/BeCIOLFAaKWQ/9Wa7Lmv2DlNJF1gZfRkQp0u4JHEYKOipHXIY+9e5vsWpBDzB7sA9Qg88pPo+rVWqZQKEWtsXkBH/7OQJ0JSTWPjGXfbANKKclna0RA8zs2lZ3Wgud6h8z8C8TP7xEbub1G+pq7Q707S6defjCYTFwoAxPyhWwG41QWLRZMJ1zCaWH0oBkGrcVrv8EQ0mWgvon1e4oHQz8gCGROz0ETD4oFE//izDcGjqMVdaBIp2bd2ZmtnZ44lJWcu/tBnCfzQ0CwRTSbCQKZ6NtWPAIQtpj82of8brpaLj0ok8q6IMX8oiRLcS2xRwmMi/T0FPzMCqjMQOpPElSjKifgdBFhDxSuifT1WO/BYQ/AEaHnUtRGR6h9IzBizfnbWhSNa4RaAi60mRdwzKMPnHZdMml1gJrDqoPA+youLIbwUwIHFPDs+MviYAF9oTfZ0F/Pgyrqmgz3ivRHCE0oYN5stEH442t/Tke9mLBC+GeTnyjBOfohU60Ciekzp7p4FEFi0Yu7c3VxbCIpKR2FyRLXuh1hk2XT7wEBiw+RnldkKInjZRlgBgAY+au5PeuNzIjNj9cGbhGoZihJWACDnVA/hoXzK0JUNzfMxjcIKRGrGTF/B+MLOQPDouD/0LImlKFFYpYfBIdDycIc//G3alJajOs3YRjAwJqzi9cHLteIz1sIq/fxZtaj+NS2rN2V2zlcqHzdAeC1KE1bpkSEnEhKP+8OfthxbYoHQlR7l6SyTsAKAvUB5tGCmFZZtnPzdC+MCaAUAWtM1fgdAtddbawhUlryStxDKcR4opn0+Mi9trvd6PgRrc3yLaA4CFvBxm+67WlqqBDjK2B/1U6wafAgil6KI0mVZkzqKm7d9PfuyotNeUn+WUBjPF/wej0R8Hf7QjZryBGC9gJhQAn6l0x8yFS6AEMeZ28jjBCTuD32fIt8FUIr166R4IGzMMvKMP+yP+8PLQPwngJkljJOPGoJ3mIQWAekMhG7OjJ2j5pgiu0Ph96vqw5OU8/H65gMBe9VMKUjGQJcOzdHbVwBwtaAJ9Cfd7tMz+hCslbXsKoeSVW/etgTI1VnkH3LyDjAeDO4Li5eLAiuBtWPHaBsKpOqYPA35LAAb501TT5c9FQpN1hlS2qfeb2Ekj1U33tCwBzcPPirAF1BMoV1LCFzm9pJ2+FsOIGiKgwVFP97pD3+DgGvdO/OEeMVSF6t6vCG80AOuMqdqKgkheXu6Xmd+Yv7wt0hMOXWTC7OU8NcTEwlQ2D6N46XHQDpUTAHplMMADApwOb/D33JAobsZD1VXhfB4T8BvLefp3o+4V9iYBCcHLXNU2mGxw/GkxC4RP8W4ymco3l8tP3tWjeCkiReEmI6XZJyxH80Yz9ct3IuO7zGURQC7jauvzxHOGQSj7TALShIym+C/lWE69f6G4OH5bqwKBA+h5h/FIkldyQi8FE/exJWdgdAiIa+YtrHf4YAhNTIh5bhV9MRUGK2p8T4FTHhhhWLKVz5DkLrV0MZuhVWYgol0AuSZtk1Hncl5s0jY5ITqPvwvCStPfMv+yopAjsm6YKVrKwniBbVP7bjwjs+JzBz2jPyuSEMLALwNoMhwLJldPYSPFbhps1AMCvDNAvf6BFhT1JycXP1cR2PjPEV5FKaokVy2AGY/x4kIcPSqQDCnqLAmvmMMfyEGAVxP0cc6SgWrddXe1bpqb3GcJpCnELwagNEPT4BPvNMnp+xy4w7vGFNFjP9xe/hS925JeW4wrA6ndfjDF7Qlu+/MvtHV0lK1fVvKRtG6FXvNWlX0nLOINTYvgKNtFcyJJRt7Jrk0CCwEjNjtrjIGCZtcPxMZFeA3oNxPckCLaFF6gVAuhb0eyD/xH47XOdQzonLdGUTughj1a7+FZsGSaLLfrL9MND7QN3ibVboQIkXhzxV461aMrhmzssXrmw+E6Ktsj2gETwfwk5x5QY6zsM5n784ckLdqyPfGrMbxSMTHzYPXADCmCReZLJQyz/4SdsJqCMCdSnAr965d29rZOUpAOuubD6PomwAssegDKm0wWjP279XzQnMcwKT4fgsKi6P9iUSee1sArAfw0KqG8C+U5otwdyjfIx6J+Fo7O0cHA3Mur+17+fvZDUTh/xFygduEBPIitS6YxVe8vlRrX9e4sWxcYM3v7R2OBUL/lVHWuQzAW1Y3NT2YiUEaZ2ibPhx2CsZltlY3V1LORRBblYn8YuK/VswNHgQLJSG1nf7Kq2YuQREKTgKPezzei/MElD8Tj0Tu5ObBR+Be0jvTESf5x2XqQ06qEbmsvd1bm3wlZzXORoA/tG7o6SvYYIJ9tcMf/DhsMtSCmyDqE23JxPLsO60Da18B8MV4IOSz0bmISI5xpaOxcR4dzDfPYxJbFXFaZKBn0nfb2tk5uqy9/eu1yVc+AdOxnTIpnEy/sfXbYhdLu0ErnLm4L5HOSJBxsBGAGFi7esXcuSf4PDUdECwwd6UnfR6OV84A6ariIOTWtv7ufMJqEov7uns6/KFbMnrJAp2xb+w9zoTX5fx2Yv7wISaHUVI/HnX73WUx6Q+cOdN7IwCTr8dMrb05uiwt2qosvIhM2bv9+bqFe0HcJfcEqDyen0284PNZHd90yrGLqROPtf4KAt65zX/ghwplv2jt7BxVYqdrocFQAgCzki9FYOHQK9TLbcZ81u/fUwCb4h9bFHlcNNnt2q8jYltIJCf0S7TH+nPPMCTERyMDibwLUebFW5Pv3qRx5Z1853F/MCxabHaJL4vyHj0urPKQ0SUbraKZWUz+PEhj/ioRbXJfGkftU3sF6PKuKuX6va06KLwPQONCiSITRU4SWC1dXSMK6jNwexGIQexVkyvUaDbpZzBKeBNDMnI5LL3qCSzLFg5io28SPLtkY5ddIn57/dUftvrn/JMp4Ht4dLtrTqAJWIRvqHZzG246fGCdlVNiCjP+DZDZ5i55bmRgnfEFGejrXg9z+XIAyEm0aOPOMPkBnGfyoqeNpVdx3dh/W+qNUlrhoxOPNoWnqKziOAWSrffKW/0m6xlrg09rZ+fonr7UqQD+E5PlAQH8qL+/21Wfrap4HMxGLXp8KStD3Xi/2RciybUrSfkUCrkoCJ7KPtJlnPusBJYWXbAihg2rA831AnzRtr2i/l72NULMAoaw0l9lrFc2iue3R1O0rJS9h7uTbgYhXjS10VZKaVluUy8y7W9Dt4iINMQ90YGe35vHTRcSAW2MBZJj/CDsd7Yg7skOzRlj9bzQnM66cCTW2LxATN8lkXKU7gCATn/zESLmtCkQucltZzWpe6WtFPCkzg4zMy/gxCWrm5qsjQLze3uHo8nEVcPVmK2ID0LxRI+oQDSZuMSYL40w58cjurJVSybyrgxtA92/7mwIf1Rr/gy56XRzVqhY3cEHCxxjvCEACKVUj9+0By/1j8RceSM9FuTFyMC6SRbJlQ3N86G1caVRECv9VfUQj4KIhRMiv5et+C+Er2r0cFikoBBo19U4Hon4+PrgB0y2W4FdOmQq51JQTMKU8Kp/t+kPSPtRASnj9ymYfJyJ1QUbYO/V/6ZA5ehjVs8LzXE8vNMBTgSYjlgzobAqoyuEA/15Cy3qNj1qrjo+hmjdlAkxdG8nkuXsLZuM+iLgICfleWJVIHjO4v4e49F3jEwYmNX7MAGLU0fxedcKfjKRvu4HIFiMLAGlJDfZl1KOlf4KAKBLd+HvDIS+LsCHrB+g8y/ZOwePtipxNeLdUWVVbEJsdmvAUJXHMbmEvNOnttqxaSflWena4PVtUYuySrD54Sxrb/eC8hmLeT1RTLCuiHOWTTtK1kIpRekNr88o+d/pD1CORx6AXT3KiRNxYvXBk+MN4YUC2Mz9bttg8fRkxerzgONMip0kkLQcoVlROmP+0P2xQPOJVqFPRdLR2DgPVhEoxRc6cRXl0f5EIppMHK8gHwZxt4h8IdKfyI0ZNJvMJ7SVc9c0NhbtWNcRCH2KhPXKDfDR1oF1D+YMDxuBJSsP2fS83dZcWelRHrFJnTHep10c3nOmF0FsLI3Aq5Fkj1GvOGvg1eNhEQ9HwDqrwZrGxv1J/j+LpkNejkxyNha7zx0ANg9Vyy3ZFzsbgksAGnOM58JjIPIgNZ8H8mTkyEIRv7LtORYIthFiYX2VVTmRIsTvbMdB2l3hI6B+JO4PrYv5g1dndqxlQTk+m0W8aP0VYBnLFkl2PxwdSJzf2t99U96RaU67O4G9RxzvnV0tLcYve4y4P/QF0bgD9rF3W6Fzs08wnVHD4oeurba/z9ct3MsmsT6I+236SzeFAOYyXFY6NrEpJGCnv9KkOcAYgCd7J1SA+LymxhHH87iNVziBOw5LJic5dtJW4U7ckC+zhaaxrF05GJpR67XaqXcE5h8DykMwJNMEABDfyb4UHeh+BqUZtBoB+QaU9Mb84SdigeB5xkQHpumRNvUdXihWfwWUGnw7gdWB5noUH25y0vZB58GMP1RBYnXBhpg/9CCBGy0S2I9D4LJ8vh2dDeEFsHLuU1aZUEfU8LGw+AzF47V25bCdoynGMb0giNGxk2InnMVyUXIo58TqgyfFGxpyUlcvBTwddQe3xOpD/0mP53nAopQU8Xq1J/WNiZdigVAIFlYxAEOjjjf/UVwr+2Na6ezYsW308s5A8Ohlfn+On15XS0tVrC70gZg/fFcmc4cxay+Bh/PlZxOAIlLYb8qMADwGlJ/6vDUvxwLhmzvr55ck1EXM+ispXicGoIDSvRhSWh9l7b85EeEJPq+s7fCH7hBRD4ioxMgIBn2+1H6iJULB3wM8E0VG1RO4tS2ZuCPvPVrFvA0NYshVNzShv+MtNADrbczZ42ja7BxGqndUu8Z+poOxxejIq1JmgZVZca3S4Aj4FYh8hdqHWH1oEIKXIBgEMQvAPMApZvV2oHBh9nFaCBvvdojg3kKuKSln8Pc+b00/gKIK6RbJXoR8mwRqUY2YP7RZIJso3AFi7+2DqXlQ8FpscMfYkErxwkI3W/u7H+kIBL8rlC9Pcd57gvycFnVJ3B+8OyVVXzmi/4W8BVezWdUQDlLTdSMC2CcVyGbKOywpRn+VyywBvgDqR6hTAz5vajOIbgp/DvATKDYFiMiD2/wHuqwyVlHlK+2TtJkVvzaVQCa1t4uNe8aoY7PL3LDBJmuGzzdzYTE73HHSCv8QiAjSSthihNUIIOdF+xM5gfK0skABpNxe6N6SjRt3KOpTANfK4dsBfJ+UMwm5DsDyTCxeqexD8ODM5xEo5jMVYJ04zvEmS3O0v+dKkHlVNyXgIeQCxdHnY/XBk8zNAeXQLA+IlMhoSfUcprzDwjRH6tsiwNLdZnrOixbwcyIgcatsBnaFMVYGFswGR41HGptKIGMQUHGY5yhi1l9p4jjT5s821xeoDitiFzBlBFhD4UXR/kROjrV1TU3Vb6asBFZfa7Lb9buMDKxb29XSsnD79tGPA3IsmKlbKfIaNFd7ZfjXE3RnvwbSx1q/P/RTAVzTLZURQvCTKqfqykV/+bPRhzEd5tPzhQ5/8Gmh3AzJmyq7KNJ6RvltRyB0blt/YqmhsUU5euls7et7q5S5TElgZdzvjUcFofwPwXPsTOwlIPjx1voDL2l1ccqMNza3wNE2TnPLbYb06NFTITYmYXuB1REILlQ05893tHt404q5c3eT3AooOdhuy4WIsOzG77z8RSg3bg0ccGMhB9stKXWa2FVo+pWNMSFT3OPuzP+MnA04MZi/ozJAQJ4Upb/e2tdjpbifSFuy55fxhoY/kL4rkY7VzKl6XhQCr2j8vKMh2O+W2x02SSwtjVr5mJLAUlX8AGh+abVH/w+ofifkvSgt02MhdoC4NJpM/AT9BgOJtjoOWuuvIBbpkIHubP8fN5TGURYi8K3tgQNiGCgcSVPl2e14Why/HI+2EqYU61TCj5AcEZGjketwnHcKINZC8DQh/xdNdj8pgC70t6V3oHb6Ga2Q16u9TNgo/EHgcSF2zwQzm4PjiUEIOkF5xKPk54f3rx0wPbJ6XmiOVvwERfYH5W2K81Bbct1zAJDZxfxrfE7kW/QNngORz5XmypFB4FVa3bkUWJTP031NY+P+IxbB6FSl6a+AKQos0TjaYuV9M9nXs/pswOn0h/9eg7+AVTFPI/dB88vWkd6ax5qFgXTY6K8yqTw+bGrHPFEB7sNbbKeB5abwHi3qFOOfSvYe0dtrLJCbiQywTXfzXNtAz1VAOk2wV/MgUdyPULMF3FOLOAK8LeAWDb2pZmbV6nwplwvR6Q9dDAsfNQGSbX2JTtt+S8AYbwgAIrg1mkzcs6y93bt7/0vzHfHsD+FsgewvZA2BYRBvQ+FtEUn09XW/aAx5mUCHP3yBA/4QyEQfCCFQ18T9wetakz1fG2vX+nLndqSLpf54VUOoVbScKel0PUWnNSZ4sL8u2I4NPTlqieGU7ygRo0QYGR3Z/nSx444xJYGlhUdZnIr+NPYlRJLdD6+YG1zg8+I7gHwcxSv9RwHcJ4o/KGabTEDiYta1UbTbVncc7ZGLARp3isrSJ+kdxMaAscLt5rL2dq8kXzH6TFFg9aPx0LnA1hmaE46zRya7k7D3vjYSC4RCJL5tNQ+RB22Og6UigMeqc53eZWYWmLUwF3uxprM+dLwGb0eu35YQ8tW4P9iRrzRZJqYxDuCrmZxyFwI4H0Ucc5VHzgBy9aii8AGLT/25TFaKgsQjER+2bF3MzK6Umq+P7RpLthLG50RmCiRiascsf4slG3teiiZ7PukoFabwu5iUaSkvbwJ4RIDPEt66aDJxdrFn+o6G8HzY+F8RRoG1Ym7L3gRt/F2oPM5yi3YAxv3Z5hk71XTdOdQMvHoSLDzSBeoZU5NxowAAAArlSURBVJtn/f49QbEu3SQCi3QixbNibsvekvbktjlmAuAj0zGP8d4Ju+KqSg6erjlowa1wcTIlYLTqRdevfSGaTHxpEMMHEfiirQWURFOBG8YFl4BR5cLNg3dTy5PQ8ii0PCpQz2aqR09hh+UbXAwLfZRS+YOIj+hbuw7AFQCuiDe01AmcRSTTW1utt2vxDKZSutc2YNgNj4NWK6Wx9hpj4Ko8qa/S7khblCdvCnqx1RSrtKuyTkg7HQ/NZdlSqL4a1kICAHDIU6HQrEI1E0shXdcv9TvCOlHf6HBVsTvbIlGy6Z3qpy5YvMClkCm15RqrR9rp2QAgowa5MVbf9CfAsxzIWEsLk5MPL5N11Zwo0vC7WxlYMBt69MxJm3pisHpot3XAFAQWRY612HW/GunrNgqBjGOlvXNlkVBoVSNPeYdcdTod9eEllMJphCeNWaz+SmOBzclrVnV1wZjE9DHBzs3EcbTr5x0LBNtAfN6mrwlUVQ/xfAA5sXulEKsLNkDxIRSla5Fnjkp0l01g5oXoAXCKRctoR93BLW0bXjSV0bMmk+31NmNDUUVXi44O9D4bC4RuApFTQi6r85z893rz2y0CZa5gpZTr786rR86lyCS5JAr3j/kdlu44KjarB5dNpy7BGsFCm2YppQrONd7QUifC/4VNrBcABRYlsETB6viQGhrKu7uLRyI+ilg7DIpXFdwdx+ubD4SWe2H5t07uWK6aWAKqFAhIrD50IZTEUaRimNB2VY6mAO2PnCIq9R/lGHNlU9PuMX/4Lkmn+zbt8F/xOiU7jxrrixLMs7ArK+uj6FTBGOJn/f49Kbk59YUy7nJSksCKRyI+0Fx0ISclyM6CmGvTzDPiySvYVjWEg3RG/wj7/Et6JOUrLhKddpWBU/TlFLQlIHxj8FaC1joTH/MXO4g3tNRR9MMQu88sD/OGZPin+WLnbOhoCEbj/tDjENyOEnyH1BRM5rakUtuegEV66jRyRtwfuqrUseKRiC8WCF/kSXkSAM+3GhEYhsuC5AZp9nETyVNVh7DK9kAleX93y9rbvSlU35knm+3qw5Pd4wtESQKLr7+1ABamXS12OdHfBQrWU5yEwje7WlrGnVvXNTVVx/2hzyrNOETyKxrz85x1euV3sHo5tea1mSKwANIZT+P+8J0gCsaY5UV4bdwfHHf6jUcivlh96ELq0Q4g3450ciEP165FTq1F9Z/ylaLKx5rZi2pigdBZsfrQk6KlA3ZpcXIhBstRkcnEko0bd4ggb7xqPghcFwuEbi8m2+fqQHN9rD78Nb4+2AfyR7D9DafH8zvUq2OB8EUs4h3vammptcjmS61zfdxELHVmlMs6/OFJaouVdU0H1/a/+nsg17eRIt+YeEoryX85Vh+6MLMCFkSAZGsyMZ2BpdbE/KHXYF8v7mUAnQSqBDzUKn95FhR+t62/p6iClnF/6DnC2sq2DYJuAG9m0tuU6nk9BEEXgCEQLSh41JCfDvoPuLC2/+W1RQpuTfIhBSyjB88z5X1FeznihTObWs0D2QDBB5EubeWm/9gKYtgizOT30WTi5CLmVzLx+uYDKboXxZWi3wbi1xB5muKsFahNcDgq4tmTcA4QpRpJvQCQI5BeNMoQX8AugdyiPakHMsWOc1gxd+5uVd6ZHyJwjUUGjSeiyUR79sVYIHwzSFuLsgbwAgR/BVEw2R+Bh6PJxEkTBVZJSncRLDQppjRYUnDj9MDXALEVWHMAzEn/Ukr7vShdnP4KAAi8BHuBVZMJoJ0qM4z9EC/MrPV8Lrp8eaqzPnSxBh6F/aqtRORUAqdCA6IceDQywRHWuS63EHK6CHMy3eZMVezSWpeD1oG1r3T4w9cI+K0iHquB4DyA58lYRS4lIDQAAUlYfihbBbyZkCtgtNRLC4EfiuP9Ycwf+iuBbgE2g0hBZH+A+wNooEUyQgCjoiS/IUbj5SJeFwVgkUG7vSWV4oXZOvDSjoQWq6wqIvPktENZXaaezHoLIpXy0TX1S97HiHJ5ZlvqVqx4RbRz2pg3emQg8bgIri5j/wbYpZUc4SE9sAhtUfrdE1gAEE12XwfYZxQtC8RT0Dy0NdnztUzdwGKMWvsJcDSA0yA4C+AxSKcNskqmSfCa1r7uP+e7p5Qu+jfvggPBBflcmkq0EtJ0nn5jtxpfecrRlwEN/maqfRD4XwBm65Bg9ViRgmJQHinHD381oZegiPCOwnCTo50TstPPtPYnrsk4/E4nBPCTmTW+Ixb3dfdoZZWdYXNkYK1ViaxyIQCrdlR/BobogzIxLMBX+gcS7WPhaK3JxG1IJ+3LX+GqrMgNbcmeghbP9f09K0DmrbVZJCTwT/nSCgGlCiwNk17nvkwU/C6BZ99ZD6D0sAgCckMymTgfNqXZi/W/ypBZuaYitDqqddUJbcl1z5H2CuF8EFxJjxM9YkNv3jJibf09VzCtnJ2O77hHQU6KJhMXjscZ2tWRXC7vyos7mUM2Pb9tNLXthGKMEkUjuFcTza3JxPXZsYbR/u6bFXGipFUK08EwKF+PJrsvd2t0dnpXZJOf342tEH66UAJOoFSBJa4WQlJ7cmoB7kxaOztHtcL5AIrLwUP2CvHBaLL78vqGcKNVbiHFkitbe7zO51B8Xm4N8qZBDB+7aEM6X9LIDFwOmD3Z87AdxL/W1PiOLaSgHaMtmbhRqI4EUC5d5VpCPjPoP7Alkux+eOxixoXGHPBMTLmieKks2bhxRzTZfQ6E5wOwzs5hYFjAO7Xw0Gh/4qzFA4n+Qg0jA4nHh6rRTOKbAKyKp1hBPOVo5/DoQLeVni6a7PnFFHbfy6F5aLS/xzXNT2lWQn9oEAXdGvhoNNnzd6X0O9101B3cIsr5byC/D9I4xOuA3DDqDN4wFqi5Ym7L3lVe50mCbv5Sf+pPJs4sJuI+Z47+lgMEqR8A+JihqQZ4n9BzbevA2hwdXbyhYQ/QdwuJT8L8Pb9MyE+9IrfZpDTJprM+dDwFFxP4CGzSqGQQIEngD6Tc3TbQnfdYRUDF/aEnUfg7I4Dlw9X4aDlDgkolPicyk9XbPgXyH2FX/Wgi2wg8JcTSrOSB1qxsatpdpbxnCPhxpN1DivWH20LgF4rq9ny/Kxs6AqFPCfEtmGNjHQKPAfLtNkOyxTFKFVg7UOiD0DgquiFRcvqId4POQPBoDXwYlIWA7E9oCuQ1Ql4U6j/NrPX9cWcfaVc1hIMeR59KyKEQ1EFQC2IzgD4RdqZQ9TubPNurGsJBIT4iZGvGGXQGibcE8pqAz2nFx8fS/0x1zs/6/XumWHUkoA6jsAXAPkLsA4EG8IYINpPSS+i1IvJctD9RSpWX9wzxeU2N2us5UoiFAOcBcgAkHadH4i2Q20WpHhA9mnh+e+CAmF1lcDvWzF5Uk6oZOY5aLwBVA4XzCNSIpF0x0r8DbBVwCyAdUPJUpK+7qxxH63VNTdVbHO/fgTxBRBqhORvAEBQ2kXhJCZ6qcqoeGzsV2FKqwHoL+QMk74smE6eX0meFChUqmCjNrQHIl+Ru1NGOIWiyQoUKFUqnJIElQE7YCYnrC1mVKlSoUKEclLrDmpznieytHqq+riwzqlChQoUClLbDEkzMyTQi8HzcWCevQoUKFaZIaTssviOwSFxfqvmzQoUKFYqhJIGlgDFfnQ61b+03yzifChUqVChISQLLIXsAvAXNc1o7O0fLPKcKFSpUKB9LAc/EJHIVKlSo8G7w/wFAyLXDhY0eLQAAAABJRU5ErkJggg==


Want to learn more about MySQL at Pinterest? Join us for the MySQL Central @ OpenWorld keynote! You’ll get the chance to hear them present, along with other customers. Register now if you haven’t yet.

Monday Jul 13, 2015

MySQL Enterprise Monitor Query Analyzer Identifies Problem Queries

The MySQL Enterprise Monitor Query Analyzer module allows you to identify problem queries in graphical format without having to wade through lengthy log files. Among other topics, the MySQL Performance Tuning course provides an introduction to MySQL Enterprise Monitor capabilities and a walkthrough of the Query Analyzer module.

You can take this course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lectures at your own pace through streaming video and booking time to do hands-on exercises when suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk - no travel required. Choose from a selection of events on the schedule to suit different time-zones. Events on the schedule include the following start dates: 11 August and 22 September 2015 in English and 2 November 2015 in German.
  • In-Class Event: Travel to an education center to take this class. In-class events already on the schedule include:
 Location  Date  Delivery Language
Sao Paolo, Brazil
27 July 2015 Brazilian Portuguese
Ballerup, Denmark
16 November 2015 English
Helsinki, Finland
16 November 2015 English
Jakarta, Indonesia
27 July 2015 English
Milan, Italy
12 October 2015 Italian
Turin, Italy
30 November 2015 Italian
Causeway Bay, Hong Kong
22 September 2015 English
Riga, Latvia
18 August 2015 Latvian
Petaling Jaya, Malaysia
12 September 2015 English
Oslo, Norway
21 September 2015 English
Singapore
13 July 2015 English
Kista, Sweden
16 November 2015 English
Bangkok, Thailand
24 August 2015 English
To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 13, 2015

Is The Performance of Your MySQL Database Important?

How important is the performance of your MySQL database? If you want to learn more about tuning the performance of MySQL servers, consider taking the MySQL Performance Tuning training course. In this course you learn to:

  • Understand performance tuning concepts
  • Benchmark your MySQL server
  • Tune MySQL server settings
  • Investigate performance metrics with a range of system databases, command-line and graphic tools
  • Design your database for optimal performance
  • Optimize slow queries
  • Troubleshoot common performance problems
  • Scale your hardware and application environment as your database grows

You can take the MySQL Performance Tuning course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material at your own pace through streaming video and getting hands-on experience at a time that suits your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on schedule to suit different timezones including 19 May, 23 June, and 11 August 2015 in English,  2 November 2015 in German, and 27 April 2015 in Spanish.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule.
 Location  Date  Delivery Language
 Sao Paulo, Brazil
 25 May 2015  Brazilian Portuguese
 Hvidovre, Denmark
 15 June 2015  English
 Espoo, Finland
 15 June 2015  English
 Causeway Bay, Hong Kong   27 April 2015  English
 Jakarta, Indonesia
 27 April 2015  English
 Utrecht, Netherlands
 19 May 2015  English
 Pasig City, Philippines
 27 April 2015  English
 Kista, Sweden
 20 April 2015  English
 Taipei, Taiwan
 4 May 2015  Traditional Chinese
To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Mar 02, 2015

Upcoming MySQL Tech Tours in USA and Canada

Oracle's MySQL Team is busy in March. We're traveling to many places to bring the latest MySQL news and product development to a city near You!


Do you want to learn more about building a security enterprise platform with MySQL? Want to hear what's new in MySQL 5.7 and MySQL Enterprise Monitor 3.0? Get ready to discover which of the MySQL high availability solutions is the best fit for your infrastructure?


Plan to join one of the following MySQL events:

For more details and additional events, check MySQL Events page.

The Tech Tours offer you a unique chance to meet with the MySQL team, learn how MySQL solutions can help you achieve your goals and get all your questions answered.

Space is limited so register today. We look forward to seeing you there!

Optimize MySQL Database Performance

MySQL development engineers and support personnel, drawing on their extensive experience working with database loads and customer use cases, have identified the key areas that will enable you to optimize database performance. This information is available in the MySQL Performance Tuning training course.

As users continue to demand better performance and more functionality from web applications, you need to make sure that your database can keep up. The MySQL Performance Tuning course will teach you how to use the vast array of configuration options, monitoring tools, and techniques employed by MySQL database professionals to keep your applications fast, efficient, and safe.

You can take MySQL Performance Tuning training in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture material through streaming video at your own base and booking time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time zones. Start dates of events currently on the schedule include: 24 March, 7 April, 18 May, 23 June and 11 August 2015.
  • In-Class Events: Travel to an education center to take this class. Events on the schedule include:

 Location  Date  Delivery Language
Brussels, Belgium 24 March 2015 English
Munich, Germany 8 June 2015 German
Utrecht, Netherlands 24 March 2015 English
Valencia, Spain 2 March 2015 Spanish
Kista, Sweden 20 April 2015 English
You can also take MySQL Performance Tuning training in Japanese.

To register for an event or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

Wednesday Jan 07, 2015

Learn MySQL Performance Tuning From the Experts

Hot off the press - the popular MySQL Performance Tuning training course has just got even better thanks to Oracle's MySQL support and engineering experts sharing their years of experience. This much improved course is currently being released, bringing you more real-life hands-on experience as well as hints and tips from the people with the most knowledge on tuning MySQL performance.

The MySQL Performance Tuning course teaches you how to tune MySQL for optimal performance. You will learn best practices for configuring, monitoring and troubleshooting your server, databases and queries using a range of tools.

As users continue to demand better performance and more functionality from web applications, you need to make sure that your database can keep up. The MySQL Performance Tuning course teaches you how to use the vast array of configuration options, monitoring tools and techniques employed by MySQL database professionals to keep applications fast, efficient, and safe. 

You can take this 4-day instructor-led course as an in-class or live-virtual offering.

To request that events are added to the schedule for this course, register your interest on the Oracle University site or contact your local Oracle University rep.

To learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql

Monday Nov 17, 2014

Gather and Query Metrics with MySQL Performance Schema

The Performance Schema is a system database which makes it easy to gather performance metrics and query them using SQL. The data is stored in temporary tables and views, with little or no persistent disk storage.

To learn more about tuning MySQL performance, you can take the MySQL Performance Tuning course. This 4-day course is available in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming video and book time on a lab environment to suit your own schedule.
  • Live Virtual Event: You can attend a live event from your own desk, no travel required. There are events on the schedule to suit different timezones including the following start dates in 2015: 6 and 13 January, 25 February, 24 March, 7 April, and 19 May.
  • In-Class Event: Travel to an education center to attend a class. Below is a selection of the events already on the schedule:

 Location

 Date

 Delivery Language

 Brussels, Belgium

 24 March 2015

 English

 Sao Paulo, Brazil

 8 December 2014

 Brazilian Portuguese

 Causeway Bay, Hong Kong

 13 January 2015

 English

 Karnataka, India

 26 November 2014

 English

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 25 May 2015

 Lavian

 Utrecht, Netherlands

 24 March 2015

 English

To register for an event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Oct 06, 2014

Areas to Tune When Improving MySQL Database Performance

When looking to improve the performance of a MySQL Database, remember that the database is not the only factor that affects performance. Applications or the infrastructure that support them can cause significant bottlenecks which are independent of the database. Therefore, start by taking a big picture view of performance and as well as tuning the MySQL server instance, consider application tuning or operating system tuning.

To learn more about this and other key performance tuning topics, take the MySQL Performance Tuning training course. You can take this 4-day course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering, following lecture material at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, choosing from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of the events already on the schedule.

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 8 December 2014

 Brazilian Portuguese

 Brussels, Beligum

 10 November 2014

 English

 Milan, Italy

 20 October 2014

 Italian

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 25 May 2015

 Latvian

 Utrecht, Netherlands

 10 November 2014

 English

 Weillington, New Zeland

 28 October 2014

 English

To register for an event, register your interest in an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Aug 18, 2014

Items Affecting Performance of the MySQL Database

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

  • How your hardware and operating system can affect performance
  • How to set up and logging to improve performance
  • Best practices for backup and recovery
  • And much more

You can take this 4-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering for training, following lectures at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live event from your own desk, no travel required. Choose from a selection of events on the schedule to suit different time-zones.
  • In-Class Event: Travel to an education center to attend this course. Below is a selection of events already on the schedule.

 Location

 Date

 Delivery Language

 Brussels, Beligum

 10 November 2014

 English

 Sao Paolo, Brazil

 25 August 2014

 Brazilian Portuguese

 London, England

 20 October 2014

 English

 Milan, Italy

 20 October 2014

 Italian

 Rome, Italy

 1 December 2014

 Italian

 Riga, Latvia

 29 September 2014

 Latvian

 Petaling Jaya, Malaysia

 22 September 2014

 English

 Utrecht, Netherlands

 10 November 2014

 English

 Warsaw, Poland

 1 September 2014

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

To register for an event, request an additional event, or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

Monday Jun 23, 2014

InnoDB, The Choice for High Concurrency Database Systems

InnoDB has proven to be a reliable data storage engine for modern, high concurrency database systems. It is fully ACID compliant, and supports a wide range of isolation modes, from READ-UNCOMMITEED to SERIALIZABLE.

InnoDB multiversion concurrency control (MVCC) enables records and tables to be updated without the overhead associated with row-level locking mechanisms. The MVCC implementation in InnoDB largely eliminates the need to lock tables or rows during updates, and enables good performance for high concurrency workloads.

To learn more about this subject and related performance tuning topics tuning, take the MySQL Performance Tuning training course. This 4-day, instructor-led course is available as:

  • Training-on-Demand: Start training within 24 hours of registration. You will follow lecture material at your own pace through streaming video and you can book time on a lab environment to suit your schedule.
  • Live-Virtual Events: Attend a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to take this class. Below is a selection of the in-class events already on the schedule.

 Location

 Date

 Delivery Language

 Sao Paulo, Brazil

 24 June 2014

Brazilian Portuguese 

 Brussels, Belgium

 4 August 2014

English 

 Shanghai, China

 5 August 2014

Simplified Chinese 

 London, England

 20 October 2014

English 

Milan, Italy 

 28 July 2014

Italian 

 Riga, Latvia

 29 September 2014

 Latvian

Petaling Jaya, Malaysia 

22 September 2014  

 English

 Utrecht, Netherlands

4 August 2014  

 English 

 Warsaw, Poland

 14 July 2014 

 Polish

 Barcelona, Spain

 14 October 2014

 Spanish

 Istanbul, Turkey

 4 August 2014

 Turkish

To register for this class, request an additional event or learn more about the authentic MySQL Curriculum, go to http://education.oracle.com/mysql.

Monday Jun 09, 2014

Optimizing MySQL, Improving Performance of Database Servers

Optimization involves improving the performance of a database server and queries that run against it. Optimization reduces query execution time and optimized queries benefit everyone that uses the server. When the server runs more smoothly and processes more queries with less, it performs better as a whole. To learn more about how a MySQL developer can make a difference with optimization, take the MySQL Developers training course.

This 5-day instructor-led course is available as:

  • Live-Virtual Event: Attend a live class from your own desk - no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to attend an event. Below is a selection of the events on the schedule.

 Location

 Date

 Delivery Language

 Vienna, Austria

 17 November 2014

 German

 Brussels, Belgium

 8 December 2014

 English

 Sao Paulo, Brazil

 14 July 2014

 Brazilian Portuguese

London, English

 29 September 2014

 English

  Belfast, Ireland

 6 October 2014

 English

 Dublin, Ireland

 27 October 2014

 English

 Milan, Italy

 10 November 2014

 Italian

 Rome, Italy

 21 July 2014

 Italian

 Nairobi, Kenya

 14 July 2014

 English

 Petaling Jaya, Malaysia

 25 August 2014

 English

 Utrecht, Netherlands

 21 July 2014

 English

 Makati City, Philippines

 29 September 2014

 English

 Warsaw, Poland

 25 August 2014

 Polish

 Lisbon, Portugal

 13 October 2014

 European Portuguese

 Porto, Portugal

 13 October 2014

 European Portuguese

 Barcelona, Spain

 7 July 2014

 Spanish

 Madrid, Spain

 3 November 2014

 Spanish

 Valencia, Spain

 24 November 2014

 Spanish

 Basel, Switzerland

 4 August 2014

 German

 Bern, Switzerland

 4 August 2014

 German

 Zurich, Switzerland

 4 August 2014

 German

The MySQL for Developers course helps prepare you for the MySQL 5.6 Developers OCP certification exam.

To register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Apr 28, 2014

Benchmarking MySQL Performance

Benchmarking lets you test how a system responds when it is given work to do, and removes the guesswork from your performance tuning efforts. The workloads you use when benchmarking are very different from real life deployments, which can be extremely variable. If you remember this, benchmarking is extremely useful, enabling you to measure current performance and determine the performance impact of any changes. Such changes could be the addition of new hardware or opening up your application to more users.

Benchmarking is one of the topics that you can learn more about by taking the MySQL Performance Tuning course. You can take this course in the following formats:

  • Training-on-Demand: Start training within 24 hours of registration, following lecture delivery at your own pace and scheduling time on a lab environment at your convenience.
  • Live-Virtual Events: Attend a live event from your own desk, no travel required. You can choose from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to take this course. Below is a selection of the events already on the schedule.

 Location

 Date

 Delivery Language

Brussels, Belgium

 10 June 2014

 English

Sao Paolo, Brazil

 26 May 2014

 Brazilian Portuguese

London, England

 20 October 2014

 English

Milan, Italy

 28 July 2014

 Italian

Rome, Italy

 23 June 2014

 Italian

Riga, Latvia

 29 September 2014

 Latvian

Petaling Jaya, Malaysia

 5 May 2014

 English

Utrecht, Netherlands

 10 June 2014

 English

Warsaw, Poland

 20 May 2014

 Polish

To register for an event or to learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

To read an expert writing about MySQL benchmarks and other topics related to MySQL performance, have a look at http://dimitrik.free.fr/blog.

Monday Mar 17, 2014

Improve MySQL Performance And Maximise System Usage

Some people think that performance tuning is all about reducing CPU or memory utilization. However CPU and memory are designed to be used. You should concentrate your efforts on improving the user experience by reducing response times. You can do this by optimizing your queries and by enabling your system to serve more requests.

To learn more about improving the performance of the MySQL database, consider taking the MySQL Performance Tuning course.

You can take this 4-day instructor-led course through the following delivery methods:

  • Training-on-Demand: Start training within 24-hours of registering, following lectures at your own pace via streaming video and booking time on a lab environment at a time that suits you.
  • Live-Virtual Class: Attend a live event from your own desk - no travel required. Choose from a selection of events on the schedule to suit different time zones.
  • In-Class Events: Travel to an education center to take this class. Events already on the schedule include the following:

 Location

 Date

 Delivery Language

 Brussels, Belgium

 10 June 2014

 English

 Sao Paolo, Brazil

 14 April 2014

 Brazilian Portuguese

 London, England

 14 April 2014

 English

Rome, Italy 

 23 June 2014

Italian 

 Riga, Latvia

 29 September 2014

Latvian 

 Petaling Jaya, Malaysia

 5 May 2014

 English

 Mexico City, Mexico

 24 May 2014

 English 

 Utrecht, Netherlands

 10 June 2014

 English

 Warsaw, Poland

  20 May 2014 

Polish 

 Singapore

 11 April 2014

 English

To register for this course, request an additional event, or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Mar 10, 2014

DBAs, Learn about MySQL Where You Want, When You Want

If you have a busy schedule or too much going on to attend a live training session, Training-on-Demand is for you. With Training-on-Demand, you can watch recorded classroom sessions taught by top Oracle instructors and gain hands-on experience with a dedicated lab environment.

In viewing the classroom sessions, you access streaming lectures on your desktop or tablet, with the ability to fast-forward, pause, rewind and search.

MySQL for Database Administrators is available as training-on-demand. This course is designed for DBAs and other database professionals. Learn to configure the MySQL Server, set up replication and security, perform database backups and performance tuning and protect MySQL Databases. This class also helps prepare you for the MySQL 5.6 Database Administrator certification exam.

To see other MySQL courses available in the training-on-demand format, go to Training-on-Demand, click the Courses tab and choose the Database product area and the MySQL curriculum category.

You can also take MySQL courses as live-virtual events and in-class events. To learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Monday Feb 03, 2014

How Important is the Performance of Your Database

Whether you are a database administrator, database application developer, web developer, system administrator or system architect, if you are working with a database system such as the MySQL Server, you will want to ensure the best possible performance. 

To learn about the great performance you can get from a MySQL Database, visit Dimitri's blog.

If you have experience maintaining a database server, can use MySQL tools and have knowledge of general SQL statements and SQL tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day instructor-led course, you will learn about:

  • What to tune and why
  • Monitoring, benchmarking and stress tools
  • Problem and pitfall identification
  • Evaluating and improving performance
  • Improving query cache results
  • InnoDB's role in MySQL performance
  • Designing for performance
  • MySQL Optimizer
  • Performance impact of choices in hardware, OS, logging and backup

You can take this course through the following three delivery methods:

  • Training-on-Demand: Train at your own pace, starting within 24 hours of registration with streaming-video of classroom delivery and full access to lab environments.
  • Live-Virtual Events: Follow a live class from your own desk, no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Events: Travel to an education center to take this course. Below is a selection of the events already on the schedule.

Location Date Delivery Language
 Brussels, Belgium
 10 June 2014
 English
 London, England
 14 April 2014
 English
 Rome, Italy
 1 April 2014
 Italian
 Tokyo, Japan
 17 March 2014
 Japanese
 Riga Latvia
 29 September 2014
 Latvian
 Petaling Jaya, Malaysia
 5 May 2014
 English
 Utrecht, Netherlands
 10 June 2014
 English
Warsaw, Poland
24 February 2014
 Polish
 Barcelona, Spain
 3 March 2014
 Spanish
 Istanbul, Turkey
 3 March 2014
 Turkish
To learn more about this course, register for an event, request an additional event or learn more about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.
About

Get the latest updates on products, technology, news, events, webcasts, customers and more.

Twitter


Facebook

Search

Archives
« August 2015
SunMonTueWedThuFriSat
      
1
2
3
4
5
7
8
9
10
11
13
14
15
16
17
19
21
22
23
24
25
27
28
29
30
31
     
Today