We've just migrated a forum with 1.8M posts from vbulletin 4 to xenforo. We're hosting on azure and while the beta-phase seemed okay, we only now hit the wall after the search index was fully rebuild. Currently we run our managed mysql on B1ms instance (1vcpu burstable, 2GiB memory, 640 max iops) and with our traffic amounts it works just fine, except using search causes the database to OOM and drop. I know the instance is pretty low-end so it's no wonder it chokes with the mysql fulltext search. Scaling managed instance is pretty costly so I'm wondering what usually is the cut-off point where you just have to move to using ES? The prices of VM with ES is about the same as upgrading to the next tier of database instance, which is 2 vcpu burstable, 4GiB, 1280 max iops.
So the question is, will scaling the database be enough or is 1.8M post amount something that makes move to ES smarter? I suspect ES can get further with lower resources than the database? VM choices are
thoughts?
So the question is, will scaling the database be enough or is 1.8M post amount something that makes move to ES smarter? I suspect ES can get further with lower resources than the database? VM choices are
| B1ms | 1 vCPU, 2 GB |
| B2s | 2 vCPU, 4 GB |
| B2ms | 2 vCPU, 8 GB |
thoughts?
