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

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

photos

actions

Email Email-Owner SMS and