Gea-Suan Lin's BLOG

Thursday, March 02, 2006

Lyceum

是一套多人修改自 的軟體,以提供多人使用。WordPress and Lyceum 這篇提到關於 對於資料庫的設計:

From my examination of the code, it seems it’s exactly what is except they’ve modified every SQL statement (what a pain!) to use a monolithic table structure. We tested this approach for MU, but found it was too expensive to scale past a certain point. With monolithic structures you hit a wall based on your hardware.

In MU users are divided and can be partitioned easily, for example on we have the users partitioned between 4096 databases, which allows you to scale very cheaply and efficiently to hundreds of thousands and even millions of users and extremely high levels of traffic.

結果 對於 Database 的作法都一樣… (默)