Untitled attachment
https://assets.chaos.social/media_attachments/files/112/892/152/338/045/839/original/c5eb808693bac2b9.png
Availability data now changes so fast and is so large, that we have to implement "CQRS" (which is java architect speak for materialized views)
The AV Queue workers overwhelm MySQL 5.5 with their writes, we need larger redo logs (limited to 4 GB) and the first SSD machines.
In May 2012, we push fastav (the read-view of av) to MySQL 5.6-alpha in production, on SSD hardware. MySQL implements a number of changes for us, based on our experience.
Boom! That works, we do not die in summer 2012.
GNU social JP is a social network, courtesy of GNU social JP管理人. It runs on GNU social, version 2.0.2-dev, available under the GNU Affero General Public License.
All GNU social JP content and data are available under the Creative Commons Attribution 3.0 license.