(public).sospep.subjects ~ view article ~ using-triggers-to-unshatter-a-schema

ID/Title: 2525,using-triggers-to-unshatter-a-schema

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

Library: technology-developer-db/strategy/index

Photo FileName:

Author: View Author

Created:2014-03-09-08:15:46

<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>

It appears there are no photos associated with this record

~ view article ~ Chapter] index FROM [ Book] strategy IN [ libraries] technology-developer-db