Jump to content

Web Servers and Database Structures Design

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?

Edited by itsliamoco

Share this post

Link to post
Share on other sites

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.

Share this post

Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • 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.