Cpvr
Very Active Member
- Joined
- Jun 14, 2024
- Messages
- 588
- Reaction score
- 288
What are some tactics that you use to scale and optimize your databases?
Join Another Admin Forum Today for Free!
Join a Forum of Forum and Blog Admins from Around the World. Learn how to create the Best Forum or Blog from Seasoned Experts. Find out how to Promote Your Forum or Blog and Earn Money. Become a Better Admin by joining in on the discussions on Another Admin Forum. Join Today, it’s Free!
Database scaling techniques
- Thread starter Cpvr
- Start date
- Admin
- #2
- Joined
- Sep 7, 2023
- Messages
- 5,359
- Reaction score
- 563
How could we apply this to a forum?
Is it something we can do as individual forum owners? Or is it something that the platform developers would need to do on the backend?
Is it something we can do as individual forum owners? Or is it something that the platform developers would need to do on the backend?
- Thread starter
- #3
Cpvr
Very Active Member
- Joined
- Jun 14, 2024
- Messages
- 588
- Reaction score
- 288
Caching can be done via a forum owner. You can either install cloudflare or do caching via .htaccess.
Implementing redis or memcache on your server itself can help boast performance on the caching side as well.
Query optimization can be implementing by editing your database and adding “*indexes” to major queries. Such as, anything that pulls up a member id or post.
Last edited:
- Admin
- #4
- Joined
- Sep 7, 2023
- Messages
- 5,359
- Reaction score
- 563
Now is there any risk of doing any of this at all?
Should we be really backing up our DBs each time we do any of this? Is there a potential for a crash or corruption?
Should we be really backing up our DBs each time we do any of this? Is there a potential for a crash or corruption?
- Thread starter
- #5
Tracy
Senior Member
- Joined
- Oct 14, 2024
- Messages
- 304
- Reaction score
- 135
Generally XF (and most decent scripts) already utilize the necessary indexes.
As for anytime you "tweak/touch" your database... you BETTER back it before you do. And I even suggest taking the site offline so that the DB cannot be written to during the time you may be tweaking it.
I personally use Redis cache on the server as well as the OpCache for PHP.
Then I push the utilization as much as I can of CloudFlare's free service for edge-caching of the content.
I could do a lot better on cached content if I was on the paid plan and spent some time tweaking it. But the issue with any dynamic site (which a forum is) consists of there is only a limited amount of static data to cache. And let's not mention that several of my "data served" are physical files that are not typically cached on the CloudFlare free level.
As for anytime you "tweak/touch" your database... you BETTER back it before you do. And I even suggest taking the site offline so that the DB cannot be written to during the time you may be tweaking it.
I personally use Redis cache on the server as well as the OpCache for PHP.
Then I push the utilization as much as I can of CloudFlare's free service for edge-caching of the content.
I could do a lot better on cached content if I was on the paid plan and spent some time tweaking it. But the issue with any dynamic site (which a forum is) consists of there is only a limited amount of static data to cache. And let's not mention that several of my "data served" are physical files that are not typically cached on the CloudFlare free level.