article

Using triggers to unshatter a schema

[WHAT]

  1. ] article outlines how the freshbooks team using a multitenant database application used triggers to migrate their db from "shattered" to "sharded"

[WHY]

  1. ] db are designed to handle a few thousand tables with millions of rows each ...
    1. ] NOT - a few million tables with a few rows each
    2. *] myisam - stores each table as 3 files, big burden on disk file system, example
    3. ] PRB-example - DB backup was taking 18 hours 
    4. ] massive number of db tables

[WHERE]

  1. http://developers.freshbooks.com/blog/2013/04/12/using-triggers-to-un-shatter-a-schema/ 

[WHEN]

  1. ]

[EXAMPLE]

  1. ]

[HOW-TO]

  1. ]

[REFERENCE]

  1. ]

 

Details Photos Edit more

Details

ID: 2525

NAME: using-triggers-to-unshatter-a-schema

DESCRIPTION: by Taavi @Freshbooks.com - An article on MULTI TENANT application problems and how they resolved them by using triggers

AUTHOR: article.author/s

EDITOR: article.editor/s

PUBLISHER: article.publisher/s

STATUS: Write

PRIORITY: 0

OWNER ID: 75

Content Photos Edit more

photos

page_photo

actions

Email Email-Owner SMS and