Jump to content

Web Servers and Database Structures Design


itsliamoco

Recommended Posts

I have spent lots of time trying to design a nice structure for my project and I would like some feedback to what you guys think, please note this is the first time I've ever done anything like this.


 


About My Project


I am creating a service where advertisers can search through a catalog of websites they want to directly advertise on. Once they have found a website, they can upload an image, pay the fees and start advertising on that website instantly.


 


I have designed an image of how I think the structure should look, I have designed it this way for efficiency but I am pretty sure I could improve with some help. If you need more info or have any questions, please ask.


 


Project Structure Design Image


 


Thanks for reading, what do you think about this structure? Can I improve it?


Link to post
Share on other sites
  • 1 year later...

Server 1:

frontend website with user accounts and browsing available websites

Server 2:

api access storing image locations in a db with a from/to

Server 3:

solely storing images and other files as you said

 

Your biggest issue would be any mysql queries if saving the from/to associating the images with that account.

Should try to cache those results to do less mysql calls, don't rely on the internal mysql query cache, it wipes out every new insert.

Link to post
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.