share DB

  • Resolved kklo

    (@kklo)


    4 years, 3 months ago

    Hi

    I’m thinking of creating a virtual store and all administrative and customer support parts.

    I thought of creating a store in an “X” domain and creating the support part in another “Y” domain, being two wordpress installations.

    I want all store orders to be managed, accounted for by the “Y” domain, installing CRM plugins, Helpdesk, customer document manager, commissions, etc.

    I have doubts about whether the wp database “X” can synchronize with the “Y”. The purpose of this is to prevent WP from being in a single domain and being heavy with many plugins and product images.

    NOTE: Virtual store doesn’t use anything from woocommerce, it uses a theme and only finishes the checkout with woocommerce.

    Is this viable? It is worth it? I heard about hyperdb. What is your opinion?

    Thanks

    • This topic was modified 4 years, 3 months ago by Yui.
    • This topic was modified 4 years, 3 months ago by Jan Dembowski. Reason: Moved to Fixing WordPress, this is not an Developing with WordPress topic
Viewing 4 replies - 1 through 4 (of 4 total)
  • Moderator bcworkz

    (@bcworkz)

    4 years, 3 months ago

    I would avoid the need to sync anything. Redundant data IMO is bad data management. I know things are sync’d all the time, I don’t have to like it 🙂 It’s better to keep data in one place or the other and request what’s needed when it’s needed. The REST API is useful for this.

    If the only reason to do this is to distribute hardware resource usage, I don’t think different domains and sites are the solution. I’d rather keep it all in one domain and bring in enough hardware resource to manage the need. Let any load spreading happen at a lower level below the single domain.

    I’m sure there are contrary opinions out there, that’s fine, this one is mine.

    Thread Starter kklo

    (@kklo)

    4 years, 3 months ago

    Hi, @bcworkz

    Thanks for the tip

    My concern is that many people comment that WP is too slow when there are too many plugins.

    The site is for Tourism, and we know that there are a lot of images even in webp, it starts to slow down.

    The administrative part with CRM inside wp, I think it would overload the system.

    I thought about using an external CRM and making an API, but I think it’s a difficult task and I don’t know about security. What’s your opinion?

    Moderator bcworkz

    (@bcworkz)

    4 years, 3 months ago

    It’s difficult to say which would be more performative, it depends on the individual installation. Yes, a lot of plugins can slow down a site, but so can needing to fetch data from another resource. Sync’d data can solve that problem, but carries with it its own set of potential problems in maintaining sync. At least the large amount of plugins can in part be mitigated by providing adequate hardware resource. It’s more difficult to mitigate the inherent issues introduced by the other approaches.

    The existing API should work for any sort of WP data, but if you have custom tables, developing an API to access such data isn’t trivial. If the need isn’t too complex, it’s not that hard for an experienced coder. It’s even conceivable a novice coder could develop a simple API. They’d struggle to do so, but it’s achievable. Proper security measures are much easier to implement since application passwords were introduced. You cannot ignore security obviously, but it’s not difficult to implement in an API.

    Thread Starter kklo

    (@kklo)

    4 years, 3 months ago

    Hi, @bcworkz

    Thank you very much for the information, I will study better, but your information was decisive

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘share DB’ is closed to new replies.