Ideas: solution for 502 gateway

nagamerahJun 2012

i have a suggestion, why don't adfoc separate 3 "connected" databases? as example, there will be 1 database for short url and another one is for user/publisher/advertiser database.. this way when there's maintenance on the user database, those shrink-ed link wont goes down as the user database, and the 3rd database will do its work when the user/publisher/advertiser is down, they will store the amount of clicks when its down

Link3 repliesFrom our old forum (2011-2012)

This topic is from our old forum and is kept as it was. Start a new topic to ask about it.

3 replies

AdFoc.usStaffJun 2012
Thanks for the suggestion.

Our database is big in size and has lots of data. We've been working hard making optimizations and re-structuring the database so there is less load on MySQL. The main thing is avoiding queries that evaluate LOTS of data. This has been a problem with our backup tool and our payment tool. To fix this we've been aggregating and caching the data 24/7 so this problem is avoided.
0
Link
nagamerahJun 2012
yeah.. i kindda figure that out when we really can get lots of money from adfoc, i figure that you guys have LOTS of users and advertiser so ofcourse the database size will be HUGEEEE right.. im rooting for you guys, may you guys have a great coder to fix this issues
0
Link
AdFoc.usStaffJun 2012
Thanks! 🙂

We have a very talented developer who has been working with us the last few months and everything is going very well so far.
0
Link