Custom Post type in separate database table for syncing

Based on the details above, I can think of the following suggestions:

  1. Create a setup in which you have two servers using the same database. This can work if both your setups are identical to each other

  2. Sync the data (option 1). Write a plugin that you install on both servers, and this plugin will periodically read data from the other database and update its own records

  3. Sync the data (option 2). Write functionality that, when you update a record in database 1, it will trigger a REST API call that is sent to the second installation. Then that second installation will receive the updated data from the first installation via that call, and update its own records.

  4. Create a central database that both installation have access to, and this central database will contain shared data for both installations

  5. Have you thought of WordPress network setup (not sure if this works in this environment, you have to decide if this fits your requirements)

Personally, I like options 3, and 4 based on my understanding of the problem, but again, I do not have the full picture as you do.

Related Posts:

  1. How to sync tags between posts that are linked through Posts 2 Posts?
  2. Remove Custom Taxonomy Metabox from Custom Post Type Screen
  3. Get terms by taxonomy AND post_type
  4. Permalink Structure for Multiple Post Type Archives by Taxonomy
  5. Get Custom Taxonomy ID within loop
  6. Custom Post Types not showing on Custom Taxonomy archive page
  7. custom post type or taxonomy
  8. Is there a way to use regular categories with custom post types?
  9. Get page by template?
  10. Get custom post type by category in a page template
  11. Associating an “author” with a custom taxonomy
  12. Site Structure Regarding Custom Post Types and Taxonomies
  13. Custom SQL Query on Custom Post Type. Order by Taxonomy?
  14. How to Programically add to the new WordPress menus
  15. Including two taxonomies in a permalink structure
  16. WP Rewrite Rules – Custom post type & taxonomy
  17. Sorting a list of posts displayed under a list of associated terms (which should be sorted without initial articles)
  18. What order? register_taxonomy() register_taxonomy_for_object_type() register_post_type()
  19. Website bookmarks as a custom post type
  20. Custom post type permalinks giving 404s
  21. Custom Taxonomies: Multiple Hierarchical Permailnks For A Single Post + Prev/Next Links
  22. Custom Taxonomy and tax_query Issue?
  23. Get list of terms of current taxonomy archive for another taxonomy
  24. Function like in_category for custom taxonomies
  25. What is better: Custom Fields vs Custom Taxonomies with Terms for perfomance, scalability and better user experience
  26. RSS feed for dynamic set of custom taxonomies terms
  27. 404 Error with Custom Post Types and Taxonomy
  28. Making pages also serve as taxonomies? Or give full pages to taxonomies?
  29. Show Post Count of a Category
  30. Display custom post type category taxonomy
  31. How to make a custom taxonomy selectable in post publish area?
  32. Only show posts from a certain category?
  33. Remove standard meta boxes from custom taxonomy
  34. List Post Title by Last Word Then Second Last
  35. Custom Post Type / Two level deep taxonomy (cat. and subcat.) uri problem (error 404)
  36. Customize Query for post
  37. Correct classes for WordPress menu items
  38. How can I see a list of my Custom Post Types of the last term I was in?
  39. Tax query not producing any results
  40. Display post as term id
  41. How to filter wp_list_categories output with some custom post type meta query?
  42. Removing custom post type slug from URL
  43. Custom post type editor with dynamic selects, one drop down populating a second second drop down not working
  44. Sitemap generation
  45. Advanced search form with filters for custom taxonomies
  46. Why cant I add a custom post type to a custom taxonomy?
  47. Show Custom Taxonomy title in loop
  48. WP the_posts() on single-cars.php get category link
  49. tax_query not working in template
  50. Custom Post Type Dilema – How do I categorise by country?
  51. Custom post type’s extra fields – how to handle?
  52. Main query not querying any posts in custom taxonomy template
  53. Filter posts by tax (dropdown) and meta value
  54. Display custom taxonomy on my custom post type
  55. List Categories (wp_terms) and count posts
  56. Not able to export large no. of posts in csv
  57. Can I query posts by taxonomy conditionally based on post type?
  58. Which file/template is in charge of taxonomies for custom post types?
  59. Custom Post Types not queried in Custom Taxonomy archives or Native archives
  60. Show current custom taxonomy
  61. How to get dropdown instance value in WordPress custom Widget
  62. Include custom post type custom taxonomies in Categories widget
  63. Changing CPT slug and taxonomy already registered in parent theme
  64. Show post count number assigned to custom taxonomy
  65. Get Terms from Custom Taxonomy and Current Post
  66. Check when the post type changes, and display content
  67. Loop and add Specific Categories and Products Images
  68. custom post archive URL is wrong
  69. custom post type or taxonomy, which approach is better?
  70. Custom Post Type with Different Sets of Post Content?
  71. Add a class to a div if custom post type has specific terms?
  72. Custom post type paging return home page
  73. In child theme, add CPT to custom taxonomy registered in parent theme
  74. Custom taxonomies not displaying in some custom posts
  75. Custom taxonomy returns 404 even with saving permalinks
  76. Static Front Page not working for custom theme
  77. WP_Query to display number of custom post type filtered (order by) taxonomy
  78. Custom post type shortcode with taxonomy attribute not working and no errors
  79. Live search by custom tag
  80. Set a Default CPT taxonomy by taxonomy id
  81. Custom taxonomy terms registered not showing when added in child theme
  82. Redirect Custom Post Type from Child Taxonomies
  83. Custom post edit page permalink links to edit page rather than the post
  84. Not Able to List CPT Based on Taxonomy Term
  85. Show tags of custom post types in WordPress
  86. Show posts for current taxonomy
  87. Display all Custom taxonomy terms and their relevant custom posts
  88. WordPress get all post with like in terms [duplicate]
  89. Best way to group posts based on custom post type terms
  90. Query Pulling the same post twice
  91. Render custom taxonomy query as single template
  92. Custom meta-box for all custom post types
  93. Loop multiple taxonomy in custom post
  94. Remove custom taxonomy ‘post-type’ from post URL
  95. Custom My account page and custom page for editing posts
  96. Listing all custom post types using a specific term on the said term’s template page, in groups
  97. Require Custom Taxonomy for Custom Type
  98. Get all active posts that are tied to a custom taxonomy for a custom post type
  99. Rewrite Rule for custom post type link with or without taxonomy terms
  100. How to add to taxonomies to a post type

Leave a Comment