WordPress sharding: which multi-DB plugin to use?

Personally, I use none of them. And an NDB cluster instead. NDB is MySQL’s built-in master-master replication engine.

The only limitation of NDB in practice is the lack of full text index. But you can always use yahoo or google’s API for searches within your site. I found it worth the extra redundancy, especially when considering that no server ends up being a db write bottle neck.

If master-slave replication with a write bottle neck is what you need, hyperdb is developed by automattic, so it’s the safer bet among the plugins you highlighted. That said, note that part of the hyperdb code is actually back ported into wp since 3.0 and the wpmu merge. (See the wp-db.php file in wp-includes, you’ll notice a lot of it can handle multiple db servers out of the box.)

Related Posts:

  1. How to run Two WordPress blogs with different themes and with single database and same content
  2. Using Vagrant for customizable WordPress Multi-sites [closed]
  3. Is the wordpress user-model changed in wpmu?
  4. “Master” WordPress Multisite – Database Sync
  5. Storing Form data in a different database
  6. How to implement data residency in my WordPress site
  7. Managing database tables in WordPress multisite
  8. Show function to super admin
  9. Generate pages from markdown files in github automatically
  10. There is any way to remove post-format filter? [closed]
  11. Install (enable) plugins on multisite, on localhost
  12. How can I perform high-level database merging for WordPress within continues delivery?
  13. Delete query not working in plugin
  14. WordPress multi domain – redirect
  15. How to remove traces from widget during uninstallation
  16. How can I copy all users to newly created site on a multisite network in WordPress?
  17. WordPress wp-admin/network/plugin-install
  18. Create a multisite network for an existing installation
  19. How do I network enable a plugin for a multisite install via the database?
  20. “Micro-Site” Options
  21. External Domain on WordPress Multisite
  22. WordPress Backend HA (Automatic failover)
  23. import posts with dutch/special letters
  24. Automatic switch to backup database on fail
  25. How can I change the meta_key for a particular piece of information?
  26. Migrating to WordPress Recipe Plugin and Some SQL Issues
  27. WordPress Integration with Google Groups
  28. How to create user that has permission to create new sites on WordPress with multisite option enabled?
  29. Configuring Propel to Work with Multisite
  30. Setup page on first login on multisite
  31. Create a table with wordpress plugin boilerplate
  32. Subdomains with almost the same content
  33. wp_editor content in plugin options page
  34. Multiple instance of data in plugin custom database table on plugin activation
  35. Uninstalling plugins across all sites
  36. Multiple domains issue
  37. WordPress and a secondary database?
  38. WordPress plugin creating database in localhost but not on real host
  39. Why this function not working for install database on plugin activation
  40. Custom table naming/access convention for multisite: $table_prefix vs base_prefix or other?
  41. Users are being redirected to main site when trying to register on subsite of my Multisite network
  42. plugin code is pulling information from database in one instance and not in other. What is wrong?
  43. Will these plugins work with wp multisite?
  44. User Signup in Multisite – Need Plugin or Advice
  45. Better ads plugin has 500.000 entries in wp_postmeta
  46. Add custom text color WordPress 3.9 TinyMCE 4 Visual editor
  47. Redirect to another page using contact form 7? [closed]
  48. How to create multiple database tables on plugin activation?
  49. Can I create a table on my DB without creating a plugin?
  50. WordPress : Explain Plugins & Theme string value in database
  51. Is it necessary to auto delete my WP plugin database tables when users deactivate/delete my plugin?
  52. Does deleting a Plugin via the WordPress admin ‘completely’ remove the code?
  53. Creating a CSV with PHP inside the plugin directory
  54. Network activating; if ( !current_user_can( ‘manage_options’ ) ) locks me out…
  55. Certain functions are undefined when called form mu-plugins
  56. Plugins in WP_Options but not Active
  57. after wordpress update to 3.5+ i get many errors in plugin wpdb::prepare()
  58. Multisite for Multisite?
  59. How do i edit the plugin files in DataBase via phpMyAdmin?
  60. WordPress as a data-store?
  61. How to insert and call new data in wordpress website database through a plugin
  62. Gathering and logging data from a plugin: how to do it without race conditions?
  63. How to pass the API key to the client from the database? [closed]
  64. WPDB: Update table
  65. Is there a way to get plugins and themes not built for multisite to work on a network subsite?
  66. Multisite – maximum number of users with specific role
  67. Issue running db create table query from static method
  68. Problem of encoding characters (apostrophes) in my posts publications
  69. Create a single website with 3 theme options in wordpress
  70. Why shortcode always displayed after footer not in body
  71. Understanding State in WordPress Multisites
  72. Separate database for a wordpress plugin
  73. Is there a rule for wordpress plugins developers to not do any database changes upon update?
  74. WordPress Multisite: Programmatically Activate / Deactivate a Plugin of a Specific Blog
  75. How to keep variable `$post` to using in another file
  76. dbDelta not adding additional columns in plugin database update
  77. One sub site is slow while all others load fine, same theme & plugins [closed]
  78. Updating options into the wp database performance
  79. Making my plugin create a page?
  80. Ajax save data to database on document ready, no data being saved
  81. Add some fileds to the wp_posts table
  82. How to display terms and conditions in post area?
  83. How to edit a published post?
  84. Best/Correct way to add an option to a category
  85. How to see which sites use my installed plugins (wordpress multisite)
  86. Plugin has added weird data in wp_options, set to autoload
  87. How to check wp_options’s rewrite_rules if current and existing are the same before flush the rules?
  88. Always get creating a new table with foreign key
  89. How to do database for download stats?
  90. What is the WordPress approach to custom data?
  91. How to integrate together a website currently hosted WordPress.com and a custom web application currently hosted on Azure?
  92. How to create plugin/ page that reads from database
  93. How retreive saved data from gravity forms in my template?
  94. WordPress super admin login issue. (Automatically logout)
  95. DB Query not working in Plugin
  96. Assign all Post in Wp to a specific Category
  97. How do I get the Payzone WooCommerce payment gateway plugin to show up in the settings? [closed]
  98. Managing wordpress Themes & plugins for multisite
  99. External wpdb connections in different plugins on single page
  100. How to remove a CPT Menu from the Root Admin only

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)