{"id":7029,"date":"2009-12-23T03:48:44","date_gmt":"2009-12-23T03:48:44","guid":{"rendered":"https:\/\/wordpress.org\/plugins-wp\/shardb\/"},"modified":"2014-06-29T13:32:58","modified_gmt":"2014-06-29T13:32:58","slug":"shardb","status":"publish","type":"plugin","link":"https:\/\/es.wordpress.org\/plugins\/shardb\/","author":3023607,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_crdt_document":"","version":"2.7.7","stable_tag":"2.8.1","tested":"4.8.28","requires":"4.7","requires_php":"","requires_plugins":"","header_name":"SharDB site admin utilities","header_author":"Ron Rennick","header_description":"","assets_banners_color":"","last_updated":"2014-06-29 13:32:58","external_support_url":"","external_repository_url":"","donate_link":"","header_plugin_uri":"http:\/\/wpmututorials.com\/plugins\/shardb\/","header_author_uri":"http:\/\/ronandandrea.com\/","rating":4,"author_block_rating":0,"active_installs":10,"downloads":8468,"num_ratings":4,"support_threads":0,"support_threads_resolved":0,"author_block_count":0,"sections":["description","installation","changelog","faq"],"tags":[],"upgrade_notice":[],"ratings":{"1":"1","2":0,"3":0,"4":0,"5":"3"},"assets_icons":[],"assets_banners":[],"assets_blueprints":{},"all_blocks":[],"tagged_versions":["2.7.3","2.7.4","2.7.5","2.7.6","2.7.7","2.8","2.8.1"],"block_files":[],"assets_screenshots":{"screenshot-1.png":{"filename":"screenshot-1.png","revision":"1708941","resolution":"1","location":"plugin"}},"screenshots":{"1":"Site admin blogs screen showing dataset \/ partition for each blog."},"jetpack_post_was_ever_published":false},"plugin_section":[],"plugin_tags":[153,1570,441,55776],"plugin_category":[51,59],"plugin_contributors":[77851],"plugin_business_model":[],"class_list":["post-7029","plugin","type-plugin","status-publish","hentry","plugin_tags-database","plugin_tags-multiple","plugin_tags-multisite","plugin_tags-sharding","plugin_category-multisite","plugin_category-utilities-and-tools","plugin_contributors-wpmuguru","plugin_committers-wpmuguru"],"banners":[],"icons":{"svg":false,"icon":"https:\/\/s.w.org\/plugins\/geopattern-icon\/shardb.svg","icon_2x":false,"generated":true},"screenshots":[{"src":"https:\/\/ps.w.org\/shardb\/trunk\/screenshot-1.png?rev=1708941","caption":"Site admin blogs screen showing dataset \/ partition for each blog."}],"raw_content":"\n

This is intended for larger WordPress Network installs using an existing 1-3 character MD5 hash (by blog id) based multi-DB sharding structure. It supports 16, 256 or 4096 database shards. It also supports a separate database for blog id 1 and multiple VIP databases (home & VIP code contribution by Luke Poland).<\/p>\n\n

It should support any plugin that works with (and accesses all data via) the regular WordPress database code.<\/p>\n\n

It has been used to power MU version 2.7.1 through WordPress 4.8 sites and upgrade sites from 2.7.1 through to the WordPress 4.8.<\/p>\n\n

A detailed installation guide<\/a> can be purchased for a nominal fee.<\/p>\n\n

This plugin is based on HyperDB<\/a> which is the database plugin used by WordPress.com<\/a>. Like HyperDB, this plugin autodetects whether a query is requesting a global or blog table.<\/p>\n\n\n

    \n
  1. The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that:\n\n
      \n
    1. your databases all have the same database server, user & password. <\/li>\n
    2. your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX.<\/li>\n<\/ol><\/li>\n
    3. Instructions for adding VIP databases are at the bottom of db-settings.php.<\/li>\n
    4. Once finished editing db-setting.php upload it to the same folder as wp-config.php for your WordPress install.<\/li>\n
    5. Edit your wp-config.php and add the following line after the database settings are defined:\nrequire_once('db-settings.php');<\/li>\n
    6. upload shardb-admin.php to \/wp-content\/plugins\/.<\/li>\n
    7. Network activate the SharDB admin tools in Network Admin -> Plugins.<\/li>\n
    8. Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site. <\/li>\n
    9. upload db.php to \/wp-content\/.<\/li>\n<\/ol>\n\n\n

      2.8.1<\/h4>\n\n
        \n
      • Fix MySQL FOUND_ROWS() support used for pagination.<\/li>\n
      • Fix warnings.<\/li>\n<\/ul>\n\n

        2.8<\/h4>\n\n
          \n
        • Add PHP7 support.<\/li>\n
        • Fix warnings.<\/li>\n
        • Test with WP 4.8<\/li>\n<\/ul>\n\n

          2.7.7<\/h4>\n\n
            \n
          • Fixed button URLs in the migration screen.<\/li>\n
          • Test with WP 3.6<\/li>\n<\/ul>\n\n

            2.7.6<\/h4>\n\n
              \n
            • Fixed notices issued by PHP 5.4.<\/li>\n
            • Added 3.3.X support.<\/li>\n
            • Added support for BuddyPress 1.5 forums.<\/li>\n
            • Dropped support for pre 3.2 WordPress.<\/li>\n<\/ul>\n\n

              2.7.5<\/h4>\n\n
                \n
              • Added 3.1.X support.<\/li>\n
              • Migration script.<\/li>\n<\/ul>\n\n

                2.7.4<\/h4>\n\n
                  \n
                • Added 3.0.X support.<\/li>\n
                • Fixed warning.<\/li>\n<\/ul>\n\n

                  2.7.3<\/h4>\n\n
                    \n
                  • Added 2.9.1.1 comment meta support.<\/li>\n<\/ul>\n\n

                    2.7.2<\/h4>\n\n
                      \n
                    • Added dataset \/ partition to site admin blogs screen.<\/li>\n<\/ul>\n\n

                      2.7.1<\/h4>\n\n
                        \n
                      • Original version.<\/li>\n<\/ul>\n\n\n
                        \n
                        Installation Instructions<\/dt>\n
                          \n
                        1. The database configuration instructions are at the top of db-settings.php. The configuration instructions assume that:\n\n
                            \n
                          1. your databases all have the same database server, user & password. <\/li>\n
                          2. your blog shard databases are named according to the same prefix and a suffix of md5 hash, global, home or vipX.<\/li>\n<\/ol><\/li>\n
                          3. Instructions for adding VIP databases are at the bottom of db-settings.php.<\/li>\n
                          4. Once finished editing db-setting.php upload it to the same folder as wp-config.php for your WordPress install.<\/li>\n
                          5. Edit your wp-config.php and add the following line after the database settings are defined:\nrequire_once('db-settings.php');<\/li>\n
                          6. upload shardb-admin.php to \/wp-content\/plugins\/.<\/li>\n
                          7. Network activate the SharDB admin tools in Network Admin -> Plugins.<\/li>\n
                          8. Migrate your data to your DB shards using the SharDB migration screen under Network Admin -> Settings on the main site. <\/li>\n
                          9. upload db.php to \/wp-content\/.<\/li>\n<\/ol><\/dd>\n\n<\/dl>","raw_excerpt":"Implements a MD5 hash based multiple database sharding structure for WordPress network blog tables.","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin\/7029","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin"}],"about":[{"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/types\/plugin"}],"replies":[{"embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/comments?post=7029"}],"author":[{"embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wporg\/v1\/users\/wpmuguru"}],"wp:attachment":[{"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/media?parent=7029"}],"wp:term":[{"taxonomy":"plugin_section","embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_section?post=7029"},{"taxonomy":"plugin_tags","embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_tags?post=7029"},{"taxonomy":"plugin_category","embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_category?post=7029"},{"taxonomy":"plugin_contributors","embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_contributors?post=7029"},{"taxonomy":"plugin_business_model","embeddable":true,"href":"https:\/\/es.wordpress.org\/plugins\/wp-json\/wp\/v2\/plugin_business_model?post=7029"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}