0

I am trying to configure a WordPress site using a server cluster and independent file systems. The problem is keeping the wp_content/uploads folder synchronized across all the server instances. My preferred solution is to "write" and "read" these files to/from a shared database.

So my basic question is whether this is possible to code in a plugin, or would require WordPress core modifications (which I'd rather avoid).

2

Yes, you should have quite reasonable options to customize upload, there are plenty of existing solutions around.

As for specifics I am not sure on "database" as image storage option. They typical solutions that I've heard of are:

  • dedicated location behind CDN (or some variation of);
  • dedicated image storage service, such as Amazon S3.
0

Yes, this is an interesting option. But what do you mean when you say database, for sure not MySQL database, and I will remove this from any consideration.

MySQL should not grow in size, and should be easy for import export this is why.

Considering that currently, WordPress can work on MySQL and MariaDB mostly I would say you are asking about S3 and CDN like databases, like CloudFlare, that can do that automatic for you btw.

OK, I posted this just to say you may consider GitHub as your CDN.

  • You seem to have very strong opinions about MySQL. – Mike Godin Feb 6 '17 at 14:27
  • GitHub is explicitly not a CDN and should not be used as such both technically and by terms of service. There are specialized CDNs that proxy assets hosted on GitHub exactly for that reason. – Rarst Feb 6 '17 at 17:01
  • I don't know about TOS, all I know you can host your website for free on GitHub. If your website also has images I don't see how is this wrong @Rarst. – prosti Feb 6 '17 at 17:10
  • @MikeGodin, I saw 3-10TB databases, however storing the binary images in MySQL doesn't sound as a smart choice, I guess you haven't thought of SVG images. – prosti Feb 6 '17 at 17:12
  • Even Pages feature has bandwidth limits and that's different from just dumping assets of third party site there. – Rarst Feb 6 '17 at 17:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.