edit-article

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

Chapter ID/Name:

Status: Write Writing Written

Add Photo:

Owner ID:

Content: use HTML Edit Content <h1 style="text-align: center;">Using triggers to unshatter a schema</h1> <h2>[WHAT]</h2> <ol> <li>]&nbsp;article outlines how the freshbooks team using a multitenant database application used triggers to migrate their db from "shattered" to "sharded"</li> </ol> <h2>[WHY]</h2> <ol> <li><strong>]&nbsp;db are designed to handle a few thousand tables with millions of rows each ...</strong></li> <ol> <li>] NOT - a few million tables with a few rows each</li> <li>*] myisam - stores each table&nbsp;as 3 files, big burden on disk file system, example</li> <li>] PRB-example - DB backup was taking 18 hours&nbsp;</li> <li>] massive number of db tables</li> </ol></ol> <h2>[WHERE]</h2> <ol> <li>]&nbsp;<a href="http://developers.freshbooks.com/blog/2013/04/12/using-triggers-to-un-shatter-a-schema/" target="_blank">http://developers.freshbooks.com/blog/2013/04/12/using-triggers-to-un-shatter-a-schema/</a>&nbsp;</li> </ol> <h2>[WHEN]</h2> <ol> <li>]</li> </ol> <h2>[EXAMPLE]</h2> <ol> <li>]</li> </ol> <h2>[HOW-TO]</h2> <ol> <li>]</li> </ol> <h2>[REFERENCE]</h2> <ol> <li>]</li> </ol> <h1 style="text-align: center;">&nbsp;</h1>