{"id":11745,"date":"2024-03-14T14:40:29","date_gmt":"2024-03-14T14:40:29","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/"},"modified":"2025-08-04T16:24:55","modified_gmt":"2025-08-04T16:24:55","slug":"what-is-the-method-for-sharding-and-partitioning-in-sqlsugar","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/","title":{"rendered":"SQLSugar Sharding &#038; Partitioning Guide"},"content":{"rendered":"<p>SQLSugar is an ORM framework that assists developers in conveniently managing databases. To implement sharding in SQLSugar, you can follow these steps.<\/p>\n<ol>\n<li>Create multiple databases: First, you need to create multiple databases on the database server, with each database corresponding to a separate shard.<\/li>\n<li>Configure database connection: In the configuration file of SQLSugar, set up multiple database connection information, with each database connection corresponding to a separate database.<\/li>\n<li>Creating table partitioning rules: In SQLSugar, you can define table partitioning rules by customizing entity classes with attributes. For example, you can use the Table attribute to specify the table name or use the DbBind attribute to specify the database connection.<\/li>\n<li>Using sharding: When performing database operations, specify the sharding table in SQLSugar according to the sharding rule, so that sharding operations can be implemented.<\/li>\n<\/ol>\n<p>In general, by creating multiple database connections, defining sharding rules, and specifying sharding operations, it is possible to achieve sharding functionality in SQLSugar.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQLSugar is an ORM framework that assists developers in conveniently managing databases. To implement sharding in SQLSugar, you can follow these steps. Create multiple databases: First, you need to create multiple databases on the database server, with each database corresponding to a separate shard. Configure database connection: In the configuration file of SQLSugar, set up [&hellip;]<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[494,2741,1426,2322,10451],"class_list":["post-11745","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-database-optimization","tag-orm-framework","tag-partitioning","tag-sharding","tag-sqlsugar"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQLSugar Sharding &amp; Partitioning Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLSugar Sharding &amp; Partitioning Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-14T14:40:29+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-08-04T16:24:55+00:00\" \/>\n<meta name=\"author\" content=\"Jackson Davis\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jackson Davis\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\"},\"author\":{\"name\":\"Jackson Davis\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\"},\"headline\":\"SQLSugar Sharding &#038; Partitioning Guide\",\"datePublished\":\"2024-03-14T14:40:29+00:00\",\"dateModified\":\"2025-08-04T16:24:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\"},\"wordCount\":160,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"database optimization\",\"ORM framework\",\"Partitioning\",\"sharding\",\"SQLSugar\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\",\"name\":\"SQLSugar Sharding & Partitioning Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T14:40:29+00:00\",\"dateModified\":\"2025-08-04T16:24:55+00:00\",\"description\":\"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLSugar Sharding &#038; Partitioning Guide\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350\",\"name\":\"Jackson Davis\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g\",\"caption\":\"Jackson Davis\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQLSugar Sharding & Partitioning Guide - Blog - Silicon Cloud","description":"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/","og_locale":"en_US","og_type":"article","og_title":"SQLSugar Sharding & Partitioning Guide","og_description":"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.","og_url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T14:40:29+00:00","article_modified_time":"2025-08-04T16:24:55+00:00","author":"Jackson Davis","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Jackson Davis","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/"},"author":{"name":"Jackson Davis","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350"},"headline":"SQLSugar Sharding &#038; Partitioning Guide","datePublished":"2024-03-14T14:40:29+00:00","dateModified":"2025-08-04T16:24:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/"},"wordCount":160,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["database optimization","ORM framework","Partitioning","sharding","SQLSugar"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/","url":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/","name":"SQLSugar Sharding & Partitioning Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T14:40:29+00:00","dateModified":"2025-08-04T16:24:55+00:00","description":"Learn to implement sharding and partitioning in SQLSugar ORM. Create multiple databases and configure connections for scalability.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/what-is-the-method-for-sharding-and-partitioning-in-sqlsugar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"SQLSugar Sharding &#038; Partitioning Guide"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/55a10b8b0457c35884c25677889ad350","name":"Jackson Davis","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/2fdb47d6df1226e92380d96973782572a97b0675d098bb914410dec348eb5d29?s=96&d=mm&r=g","caption":"Jackson Davis"},"url":"https:\/\/www.silicloud.com\/blog\/author\/jacksondavis\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11745","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=11745"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11745\/revisions"}],"predecessor-version":[{"id":155534,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/11745\/revisions\/155534"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=11745"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=11745"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=11745"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}