{"id":476741,"date":"2023-08-09T07:35:16","date_gmt":"2023-08-09T07:35:16","guid":{"rendered":""},"modified":"2023-09-05T11:13:20","modified_gmt":"2023-09-05T11:13:20","slug":"database-sharding","status":"publish","type":"wiki","link":"https:\/\/oneproxy.pro\/ar\/wiki\/database-sharding\/","title":{"rendered":"\u062a\u062c\u0632\u0626\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a"},"content":{"rendered":"<p>\u062a\u0639\u062f \u0639\u0645\u0644\u064a\u0629 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0637\u0631\u064a\u0642\u0629 \u0641\u0639\u0627\u0644\u0629 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639 \u0648\u0627\u0644\u0645\u0648\u062b\u0648\u0642\u064a\u0629 \u0644\u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0633\u0639\u0629 \u0627\u0644\u0646\u0637\u0627\u0642. \u062a\u0642\u0648\u0645 \u0647\u0630\u0647 \u0627\u0644\u062a\u0642\u0646\u064a\u0629 \u0628\u062a\u0642\u0633\u064a\u0645 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0625\u0644\u0649 \u0623\u062c\u0632\u0627\u0621 \u0623\u0635\u063a\u0631 \u0648\u0623\u0633\u0631\u0639 \u0648\u0623\u0643\u062b\u0631 \u0642\u0627\u0628\u0644\u064a\u0629 \u0644\u0644\u0625\u062f\u0627\u0631\u0629\u060c \u0623\u0648 &quot;\u0623\u062c\u0632\u0627\u0621&quot;\u060c \u0648\u0627\u0644\u062a\u064a \u062a\u0646\u062a\u0634\u0631 \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629.<\/p>\n<h2>\u0646\u0634\u0623\u0629 \u0648\u062a\u0637\u0648\u0631 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0646\u0634\u0623 \u0645\u0641\u0647\u0648\u0645 \u062a\u062c\u0632\u0626\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u062a\u062d\u062f\u064a\u0627\u062a \u0625\u062f\u0627\u0631\u0629 \u0643\u0645\u064a\u0627\u062a \u0647\u0627\u0626\u0644\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0641\u064a \u0639\u0635\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0636\u062e\u0645\u0629 \u0648\u0627\u0644\u0625\u0646\u062a\u0631\u0646\u062a \u0639\u0627\u0644\u064a \u0627\u0644\u0633\u0631\u0639\u0629. \u0645\u0639 \u0627\u0644\u062a\u0648\u0633\u0639 \u0627\u0644\u0633\u0631\u064a\u0639 \u0644\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0648\u0627\u0644\u062e\u062f\u0645\u0627\u062a \u0627\u0644\u0645\u0633\u062a\u0646\u062f\u0629 \u0625\u0644\u0649 \u0627\u0644\u0648\u064a\u0628 \u0641\u064a \u0623\u0648\u0627\u0626\u0644 \u0627\u0644\u0639\u0642\u062f \u0627\u0644\u0623\u0648\u0644 \u0645\u0646 \u0627\u0644\u0642\u0631\u0646 \u0627\u0644\u062d\u0627\u062f\u064a \u0648\u0627\u0644\u0639\u0634\u0631\u064a\u0646\u060c \u0643\u0627\u0641\u062d\u062a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0639\u0644\u0627\u0626\u0642\u064a\u0629 \u0627\u0644\u062a\u0642\u0644\u064a\u062f\u064a\u0629 \u0644\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0623\u062d\u062c\u0627\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0647\u0627\u0626\u0644\u0629.<\/p>\n<p>\u062a\u0645 \u0630\u0643\u0631 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u0623\u0648\u0644 \u0645\u0631\u0629 \u0641\u064a \u0633\u064a\u0627\u0642 BigTable \u0645\u0646 Google \u0648Dynamo \u0645\u0646 Amazon. \u062a\u0645 \u062a\u0635\u0645\u064a\u0645 \u0623\u0646\u0638\u0645\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0647\u0630\u0647 \u0644\u062a\u0648\u0632\u064a\u0639 \u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0643\u0628\u064a\u0631\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0628\u0631 \u0627\u0644\u0639\u062f\u064a\u062f \u0645\u0646 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639. \u0645\u0639 \u0645\u0631\u0648\u0631 \u0627\u0644\u0648\u0642\u062a\u060c \u0642\u062f\u0645\u062a \u0623\u0646\u0638\u0645\u0629 \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629\u060c \u0628\u0645\u0627 \u0641\u064a \u0630\u0644\u0643 MySQL \u0648PostgreSQL\u060c \u0625\u0635\u062f\u0627\u0631\u0627\u062a\u0647\u0627 \u0627\u0644\u062e\u0627\u0635\u0629 \u0645\u0646 \u0627\u0644\u062a\u0642\u0633\u064a\u0645\u060c \u0645\u0645\u0627 \u0623\u062f\u0649 \u0625\u0644\u0649 \u062a\u0639\u0632\u064a\u0632 \u0627\u0644\u062a\u0642\u0646\u064a\u0629 \u0648\u062c\u0639\u0644\u0647\u0627 \u0645\u0645\u0627\u0631\u0633\u0629 \u0642\u064a\u0627\u0633\u064a\u0629 \u0641\u064a \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u0629.<\/p>\n<h2>\u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a: \u062a\u0648\u0633\u064a\u0639 \u0627\u0644\u0645\u0648\u0636\u0648\u0639<\/h2>\n<p>\u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0647\u0648 \u0646\u0648\u0639 \u0645\u0646 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u062d\u064a\u062b \u064a\u062a\u0645 \u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0623\u0642\u0633\u0627\u0645 \u0623\u0641\u0642\u064a\u0629\u060c \u0623\u0648 \u0623\u062c\u0632\u0627\u0621\u060c \u0648\u064a\u062a\u0645 \u062a\u0648\u0632\u064a\u0639 \u0647\u0630\u0647 \u0627\u0644\u0623\u062c\u0632\u0627\u0621 \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0642\u0627\u0639\u062f\u0629 \u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646\u0641\u0635\u0644\u0629. \u064a\u0634\u0643\u0644 \u0643\u0644 \u062c\u0632\u0621 \u062c\u0632\u0621\u064b\u0627 \u0645\u0646 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0623\u0643\u0628\u0631 \u0648\u064a\u0639\u0645\u0644 \u0628\u0634\u0643\u0644 \u0645\u0633\u062a\u0642\u0644 \u0639\u0646 \u0627\u0644\u0622\u062e\u0631\u064a\u0646. \u0648\u0647\u0630\u0627 \u064a\u0639\u0646\u064a \u0623\u0646\u0647 \u064a\u0645\u0643\u0646 \u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 \u0643\u0644 \u062c\u0632\u0621 \u0648\u0625\u062f\u0627\u0631\u062a\u0647 \u0648\u062a\u0643\u0648\u064a\u0646\u0647 \u0628\u0634\u0643\u0644 \u0645\u0646\u0641\u0635\u0644 \u0639\u0646 \u0627\u0644\u0628\u0627\u0642\u064a\u060c \u0645\u0645\u0627 \u064a\u0632\u064a\u062f \u0645\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0639\u0627\u0645 \u0644\u0646\u0638\u0627\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<p>\u062a\u0639\u062a\u0628\u0631 \u0647\u0630\u0647 \u0627\u0644\u062a\u0642\u0646\u064a\u0629 \u0645\u0641\u064a\u062f\u0629 \u0628\u0634\u0643\u0644 \u062e\u0627\u0635 \u0644\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u062a\u064a \u064a\u062a\u0639\u064a\u0646 \u0639\u0644\u064a\u0647\u0627 \u0627\u0644\u062a\u0639\u0627\u0645\u0644 \u0645\u0639 \u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0636\u062e\u0645\u0629 \u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0623\u0648 \u0645\u0639\u062f\u0644\u0627\u062a \u0627\u0644\u0645\u0639\u0627\u0645\u0644\u0627\u062a \u0627\u0644\u0645\u0631\u062a\u0641\u0639\u0629\u060c \u0623\u0648 \u0643\u0644\u064a\u0647\u0645\u0627. \u0645\u0646 \u062e\u0644\u0627\u0644 \u062a\u0648\u0632\u064a\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629\u060c \u064a\u0645\u0646\u0639 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0623\u064a \u062e\u0627\u062f\u0645 \u0648\u0627\u062d\u062f \u0645\u0646 \u0623\u0646 \u064a\u0635\u0628\u062d \u0639\u0646\u0642 \u0627\u0644\u0632\u062c\u0627\u062c\u0629\u060c \u0648\u0628\u0627\u0644\u062a\u0627\u0644\u064a \u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0636\u0645\u0627\u0646 \u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639 \u0644\u0646\u0638\u0627\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<h2>\u0627\u0644\u0623\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u062e\u0644\u064a\u0629 \u0644\u062a\u0642\u0627\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u062a\u0639\u0645\u0644 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629 \u0639\u0646 \u0637\u0631\u064a\u0642 \u062a\u0648\u0632\u064a\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0645\u0641\u062a\u0627\u062d \u0645\u0634\u0627\u0631\u0643\u0629 \u0645\u062d\u062f\u062f. \u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0643\u0648\u0646 \u0647\u0630\u0627 \u0627\u0644\u0645\u0641\u062a\u0627\u062d \u0633\u0645\u0629 \u0645\u062b\u0644 \u0627\u0644\u0645\u0648\u0642\u0639 \u0627\u0644\u062c\u063a\u0631\u0627\u0641\u064a \u0644\u0644\u0639\u0645\u064a\u0644\u060c \u0623\u0648 \u0645\u0639\u0631\u0641 \u0627\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u060c \u0623\u0648 \u0623\u064a \u0645\u0639\u0644\u0645\u0629 \u0623\u062e\u0631\u0649 \u062a\u0636\u0645\u0646 \u062a\u0648\u0632\u064a\u0639\u064b\u0627 \u0645\u062a\u0633\u0627\u0648\u064a\u064b\u0627 \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/p>\n<p>\u0639\u0646\u062f \u062a\u0646\u0641\u064a\u0630 \u0627\u0633\u062a\u0639\u0644\u0627\u0645\u060c \u064a\u062d\u062f\u062f \u0646\u0638\u0627\u0645 \u0625\u062f\u0627\u0631\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u0630\u064a \u064a\u062d\u062a\u0648\u064a \u0639\u0644\u0649 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0630\u0627\u062a \u0627\u0644\u0635\u0644\u0629 \u0628\u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0645\u0641\u062a\u0627\u062d \u0627\u0644\u062a\u062c\u0632\u0626\u0629. \u062b\u0645 \u064a\u0642\u0648\u0645 \u0628\u0639\u062f \u0630\u0644\u0643 \u0628\u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0628\u0627\u0634\u0631\u0629 \u0645\u0646 \u062a\u0644\u0643 \u0627\u0644\u0642\u0637\u0639\u0629\u060c \u0645\u062a\u062c\u0627\u0648\u0632\u064b\u0627 \u0627\u0644\u062d\u0627\u062c\u0629 \u0625\u0644\u0649 \u0627\u0644\u0628\u062d\u062b \u0641\u064a \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0623\u0643\u0645\u0644\u0647\u0627. \u0648\u0647\u0630\u0627 \u064a\u0632\u064a\u062f \u0628\u0634\u0643\u0644 \u0643\u0628\u064a\u0631 \u0645\u0646 \u0633\u0631\u0639\u0629 \u0627\u0633\u062a\u0631\u062c\u0627\u0639 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u064a\u062d\u0633\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0639\u0627\u0645 \u0644\u0644\u0646\u0638\u0627\u0645.<\/p>\n<p>\u0648\u0645\u0639 \u0630\u0644\u0643\u060c \u0645\u0646 \u0627\u0644\u0636\u0631\u0648\u0631\u064a \u062a\u0635\u0645\u064a\u0645 \u0625\u0633\u062a\u0631\u0627\u062a\u064a\u062c\u064a\u0629 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0628\u0639\u0646\u0627\u064a\u0629. \u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0624\u062f\u064a \u0645\u0641\u062a\u0627\u062d \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u063a\u064a\u0631 \u0627\u0644\u0635\u062d\u064a\u062d \u0625\u0644\u0649 \u062a\u0648\u0632\u064a\u0639 \u063a\u064a\u0631 \u0645\u062a\u0633\u0627\u0648\u064d \u0644\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0645\u0645\u0627 \u064a\u0624\u062f\u064a \u0625\u0644\u0649 \u0625\u0631\u0647\u0627\u0642 \u0628\u0639\u0636 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0628\u064a\u0646\u0645\u0627 \u062a\u0638\u0644 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0623\u062e\u0631\u0649 \u063a\u064a\u0631 \u0645\u0633\u062a\u063a\u0644\u0629 \u0628\u0634\u0643\u0644 \u0643\u0627\u0641\u064d.<\/p>\n<h2>\u0627\u0644\u0645\u064a\u0632\u0627\u062a \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629 \u0644\u062a\u0642\u0627\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<ol>\n<li><strong>\u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639<\/strong>: \u062a\u0639\u0645\u0644 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629 \u0639\u0644\u0649 \u062a\u062d\u0633\u064a\u0646 \u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639 \u0639\u0646 \u0637\u0631\u064a\u0642 \u062a\u0648\u0632\u064a\u0639 \u062a\u062d\u0645\u064a\u0644 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629.<\/li>\n<li><strong>\u0623\u062f\u0627\u0621<\/strong>: \u0646\u0638\u0631\u064b\u0627 \u0644\u0623\u0646 \u0627\u0644\u062a\u062c\u0632\u0626\u0629 \u062a\u0633\u0645\u062d \u0644\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645\u0627\u062a \u0628\u0627\u0644\u0648\u0635\u0648\u0644 \u0625\u0644\u0649 \u062c\u0632\u0621 \u0648\u0627\u062d\u062f \u0628\u062f\u0644\u0627\u064b \u0645\u0646 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0623\u0643\u0645\u0644\u0647\u0627\u060c \u064a\u0635\u0628\u062d \u0627\u0633\u062a\u0631\u062f\u0627\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062e\u0632\u064a\u0646\u0647\u0627 \u0623\u0633\u0631\u0639.<\/li>\n<li><strong>\u0627\u0644\u062a\u0648\u0641\u0631 \u0648\u0627\u0644\u062a\u0643\u0631\u0627\u0631<\/strong>: \u0645\u0639 \u0627\u0644\u062a\u062c\u0632\u0626\u0629\u060c \u0644\u0627 \u064a\u0624\u062f\u064a \u0641\u0634\u0644 \u062c\u0632\u0621 \u0648\u0627\u062d\u062f \u0625\u0644\u0649 \u0625\u0633\u0642\u0627\u0637 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0623\u0643\u0645\u0644\u0647\u0627. \u0639\u0644\u0627\u0648\u0629 \u0639\u0644\u0649 \u0630\u0644\u0643\u060c \u064a\u0645\u0643\u0646 \u0646\u0633\u062e \u0627\u0644\u0623\u062c\u0632\u0627\u0621 \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629 \u0644\u0636\u0645\u0627\u0646 \u062a\u0648\u0641\u0631 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a.<\/li>\n<li><strong>\u062a\u0648\u0632\u064a\u0639 \u062c\u063a\u0631\u0627\u0641\u064a<\/strong>: \u064a\u0645\u0643\u0646 \u062a\u062d\u062f\u064a\u062f \u0645\u0648\u0642\u0639 \u0627\u0644\u0623\u062c\u0632\u0627\u0621 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0627\u0644\u0645\u0648\u0642\u0639 \u0627\u0644\u062c\u063a\u0631\u0627\u0641\u064a \u0644\u0644\u0645\u0633\u062a\u062e\u062f\u0645\u064a\u0646\u060c \u0645\u0645\u0627 \u0642\u062f \u064a\u0642\u0644\u0644 \u0645\u0646 \u0632\u0645\u0646 \u0627\u0644\u0627\u0633\u062a\u062c\u0627\u0628\u0629 \u0648\u064a\u062d\u0633\u0646 \u0627\u0644\u0623\u062f\u0627\u0621.<\/li>\n<\/ol>\n<h2>\u0623\u0646\u0648\u0627\u0639 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<table>\n<thead>\n<tr>\n<th>\u0646\u0648\u0639 \u0627\u0644\u0645\u0634\u0627\u0631\u0643\u0629<\/th>\n<th>\u0648\u0635\u0641<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0623\u0641\u0642\u064a<\/strong><\/td>\n<td>\u064a\u0642\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0635\u0641\u0648\u0641 \u0648\u064a\u0648\u0632\u0639\u0647\u0627 \u0639\u0644\u0649 \u0623\u062c\u0632\u0627\u0621 \u0645\u062e\u062a\u0644\u0641\u0629.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0639\u0645\u0648\u062f\u064a<\/strong><\/td>\n<td>\u064a\u0642\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0623\u0639\u0645\u062f\u0629\u060c \u0623\u0648 \u0645\u062c\u0645\u0648\u0639\u0627\u062a \u0645\u0646 \u0627\u0644\u0623\u0639\u0645\u062f\u0629 \u0627\u0644\u0645\u0631\u062a\u0628\u0637\u0629\u060c \u0648\u064a\u0648\u0632\u0639\u0647\u0627 \u0639\u0628\u0631 \u0623\u062c\u0632\u0627\u0621 \u0645\u062e\u062a\u0644\u0641\u0629.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u0648\u0638\u064a\u0641\u064a<\/strong><\/td>\n<td>\u064a\u0642\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0623\u0648 \u0645\u062a\u0637\u0644\u0628\u0627\u062a \u0627\u0644\u0639\u0645\u0644.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u062a\u0646\u0641\u064a\u0630 \u0648\u0625\u062f\u0627\u0631\u0629 \u062a\u062c\u0632\u0626\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u064a\u0645\u0643\u0646 \u0623\u0646 \u064a\u0624\u062f\u064a \u062a\u0646\u0641\u064a\u0630 \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u062d\u0644 \u0627\u0644\u0645\u0634\u0643\u0644\u0627\u062a \u0627\u0644\u0645\u062a\u0639\u0644\u0642\u0629 \u0628\u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639 \u0648\u0627\u0644\u062a\u0643\u0631\u0627\u0631. \u0648\u0645\u0639 \u0630\u0644\u0643\u060c \u064a\u0642\u062f\u0645 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0623\u064a\u0636\u064b\u0627 \u062a\u062d\u062f\u064a\u0627\u062a \u062c\u062f\u064a\u062f\u0629\u060c \u0645\u062b\u0644 \u0627\u0644\u062a\u0639\u0642\u064a\u062f \u0641\u064a \u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u0623\u062c\u0632\u0627\u0621 \u0627\u0644\u0645\u062a\u0639\u062f\u062f\u0629\u060c \u0648\u0636\u0645\u0627\u0646 \u0627\u062a\u0633\u0627\u0642 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a\u060c \u0648\u0625\u0639\u0627\u062f\u0629 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0639\u0646\u062f \u0627\u0644\u0636\u0631\u0648\u0631\u0629.<\/p>\n<p>\u062a\u0648\u0641\u0631 \u0623\u0646\u0638\u0645\u0629 \u0625\u062f\u0627\u0631\u0629 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u062e\u062a\u0644\u0641\u0629 \u062d\u0644\u0648\u0644\u0627\u064b \u0644\u0647\u0630\u0647 \u0627\u0644\u062a\u062d\u062f\u064a\u0627\u062a. \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u064a\u062f\u0639\u0645 MongoDB \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0648\u0625\u0639\u0627\u062f\u0629 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0627\u0644\u062a\u0644\u0642\u0627\u0626\u064a\u060c \u0648\u064a\u0648\u0641\u0631 PostgreSQL \u0623\u062f\u0648\u0627\u062a \u0644\u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0628\u0643\u0641\u0627\u0621\u0629.<\/p>\n<h2>\u0645\u0642\u0627\u0631\u0646\u0629 \u0645\u0634\u0627\u0631\u0643\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0639 \u0645\u0641\u0627\u0647\u064a\u0645 \u0645\u0645\u0627\u062b\u0644\u0629<\/h2>\n<table>\n<thead>\n<tr>\n<th>\u0634\u0631\u0637<\/th>\n<th>\u0648\u0635\u0641<\/th>\n<\/tr>\n<\/thead>\n<tbody>\n<tr>\n<td><strong>\u062a\u0642\u0627\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/td>\n<td>\u064a\u0642\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0639\u0628\u0631 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629 \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/strong><\/td>\n<td>\u064a\u0642\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0625\u0644\u0649 \u0623\u062c\u0632\u0627\u0621 \u0623\u0635\u063a\u0631 \u0648\u0623\u0643\u062b\u0631 \u0642\u0627\u0628\u0644\u064a\u0629 \u0644\u0644\u0625\u062f\u0627\u0631\u0629 \u0648\u0644\u0643\u0646 \u064a\u062a\u0645 \u062a\u062e\u0632\u064a\u0646\u0647\u0627 \u0639\u0627\u062f\u0629\u064b \u0639\u0644\u0649 \u0646\u0641\u0633 \u0627\u0644\u062e\u0627\u062f\u0645.<\/td>\n<\/tr>\n<tr>\n<td><strong>\u062a\u0643\u0631\u0627\u0631<\/strong><\/td>\n<td>\u0639\u0645\u0644 \u0646\u0633\u062e \u0645\u0646 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0623\u0643\u0645\u0644\u0647\u0627 \u0639\u0644\u0649 \u062e\u0648\u0627\u062f\u0645 \u0645\u062a\u0639\u062f\u062f\u0629 \u0644\u0644\u0646\u0633\u062e \u0627\u0644\u0627\u062d\u062a\u064a\u0627\u0637\u064a \u0648\u0627\u0644\u062a\u0648\u0627\u0641\u0631.<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h2>\u0645\u0633\u062a\u0642\u0628\u0644 \u062a\u0642\u0627\u0633\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u0645\u0639 \u0627\u0633\u062a\u0645\u0631\u0627\u0631 \u0646\u0645\u0648 \u0623\u062d\u062c\u0627\u0645 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0628\u0634\u0643\u0644 \u0643\u0628\u064a\u0631\u060c \u0633\u062a\u0638\u0644 \u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0641\u0639\u0627\u0644\u0629 \u0623\u0648\u0644\u0648\u064a\u0629. \u0645\u0646 \u0627\u0644\u0645\u0631\u062c\u062d \u0623\u0646 \u064a\u0624\u062f\u064a \u0627\u0644\u062a\u0642\u062f\u0645 \u0641\u064a \u0627\u0644\u062a\u0639\u0644\u0645 \u0627\u0644\u0622\u0644\u064a \u0648\u0627\u0644\u0630\u0643\u0627\u0621 \u0627\u0644\u0627\u0635\u0637\u0646\u0627\u0639\u064a \u0625\u0644\u0649 \u062a\u062d\u0633\u064a\u0646 \u0627\u0633\u062a\u0631\u0627\u062a\u064a\u062c\u064a\u0627\u062a \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0648\u0623\u062a\u0645\u062a\u0629 \u0627\u0644\u0639\u0645\u0644\u064a\u0629 \u0628\u0634\u0643\u0644 \u0623\u0643\u0628\u0631. \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u0630\u0644\u0643\u060c \u0641\u0625\u0646 \u062a\u0643\u0627\u0645\u0644 \u0627\u0644\u062a\u0642\u0633\u064a\u0645 \u0645\u0639 \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0644\u0645\u0633\u062a\u0646\u062f\u0629 \u0625\u0644\u0649 \u0627\u0644\u0633\u062d\u0627\u0628\u0629 \u0633\u064a\u0641\u062a\u062d \u0637\u0631\u0642\u064b\u0627 \u062c\u062f\u064a\u062f\u0629 \u0644\u0642\u0627\u0628\u0644\u064a\u0629 \u062a\u0637\u0648\u064a\u0631 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0626\u0647\u0627.<\/p>\n<h2>\u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644\u0629 \u0648\u0645\u0634\u0627\u0631\u0643\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a<\/h2>\n<p>\u064a\u0645\u0643\u0646 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644\u0629 \u062c\u0646\u0628\u064b\u0627 \u0625\u0644\u0649 \u062c\u0646\u0628 \u0645\u0639 \u0645\u0634\u0627\u0631\u0643\u0629 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0644\u062a\u062d\u0633\u064a\u0646 \u0627\u0644\u0623\u062f\u0627\u0621 \u0648\u0623\u0645\u0646 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u0639\u0644\u0649 \u0633\u0628\u064a\u0644 \u0627\u0644\u0645\u062b\u0627\u0644\u060c \u064a\u0645\u0643\u0646 \u062a\u0643\u0648\u064a\u0646 \u062e\u0627\u062f\u0645 \u0648\u0643\u064a\u0644 \u0644\u062a\u0648\u062c\u064a\u0647 \u0627\u0644\u0637\u0644\u0628\u0627\u062a \u0625\u0644\u0649 \u0627\u0644\u062c\u0632\u0621 \u0627\u0644\u0645\u0646\u0627\u0633\u0628 \u0628\u0646\u0627\u0621\u064b \u0639\u0644\u0649 \u0645\u0641\u062a\u0627\u062d \u0627\u0644\u062a\u062c\u0632\u0626\u0629\u060c \u0648\u0628\u0627\u0644\u062a\u0627\u0644\u064a \u062a\u062d\u0633\u064a\u0646 \u0623\u062f\u0627\u0621 \u0627\u0644\u0627\u0633\u062a\u0639\u0644\u0627\u0645. \u0628\u0627\u0644\u0625\u0636\u0627\u0641\u0629 \u0625\u0644\u0649 \u0630\u0644\u0643\u060c \u064a\u0645\u0643\u0646 \u0623\u0646 \u062a\u0633\u0627\u0639\u062f \u0627\u0644\u062e\u0648\u0627\u062f\u0645 \u0627\u0644\u0648\u0643\u064a\u0644\u0629 \u0641\u064a \u062a\u0623\u0645\u064a\u0646 \u0623\u062c\u0632\u0627\u0621 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0645\u0646 \u062e\u0644\u0627\u0644 \u062a\u0648\u0641\u064a\u0631 \u0637\u0628\u0642\u0629 \u0625\u0636\u0627\u0641\u064a\u0629 \u0645\u0646 \u0627\u0644\u0623\u0645\u0627\u0646\u060c \u0645\u0645\u0627 \u064a\u0645\u0646\u0639 \u0627\u0644\u0648\u0635\u0648\u0644 \u0627\u0644\u0645\u0628\u0627\u0634\u0631 \u0625\u0644\u0649 \u0627\u0644\u0623\u062c\u0632\u0627\u0621.<\/p>\n<h2>\u0631\u0648\u0627\u0628\u0637 \u0630\u0627\u062a \u0639\u0644\u0627\u0642\u0629<\/h2>\n<ol>\n<li><a href=\"https:\/\/static.googleusercontent.com\/media\/research.google.com\/en\/\/archive\/bigtable-osdi06.pdf\" target=\"_new\" rel=\"noopener nofollow\">\u062c\u0648\u062c\u0644 BigTable<\/a><\/li>\n<li><a href=\"https:\/\/www.allthingsdistributed.com\/files\/amazon-dynamo-sosp2007.pdf\" target=\"_new\" rel=\"noopener nofollow\">\u062f\u064a\u0646\u0627\u0645\u0648 \u0623\u0645\u0627\u0632\u0648\u0646<\/a><\/li>\n<li><a href=\"https:\/\/docs.mongodb.com\/manual\/sharding\/\" target=\"_new\" rel=\"noopener nofollow\">\u0645\u0634\u0627\u0631\u0643\u0629 MongoDB<\/a><\/li>\n<li><a href=\"https:\/\/www.postgresql.org\/docs\/current\/ddl-partitioning.html\" target=\"_new\" rel=\"noopener nofollow\">\u0645\u0634\u0627\u0631\u0643\u0629 PostgreSQL<\/a><\/li>\n<\/ol>\n<p>\u0641\u064a \u0627\u0644\u062e\u062a\u0627\u0645\u060c \u064a\u0639\u062f \u062a\u0642\u0633\u064a\u0645 \u0642\u0627\u0639\u062f\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0627\u0633\u062a\u0631\u0627\u062a\u064a\u062c\u064a\u0629 \u0631\u0626\u064a\u0633\u064a\u0629 \u0641\u064a \u0625\u062f\u0627\u0631\u0629 \u0627\u0644\u062a\u0637\u0628\u064a\u0642\u0627\u062a \u0627\u0644\u0643\u0628\u064a\u0631\u0629 \u0643\u062b\u064a\u0641\u0629 \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a. \u0625\u0646\u0647\u0627 \u0623\u062f\u0627\u0629 \u0642\u0648\u064a\u0629 \u0641\u064a \u0623\u064a\u062f\u064a \u0645\u0633\u0624\u0648\u0644\u064a \u0642\u0648\u0627\u0639\u062f \u0627\u0644\u0628\u064a\u0627\u0646\u0627\u062a \u0648\u0627\u0644\u0645\u0637\u0648\u0631\u064a\u0646\u060c \u0648\u062a\u0648\u0641\u0631 \u0625\u0645\u0643\u0627\u0646\u064a\u0629 \u0627\u0644\u0623\u062f\u0627\u0621 \u0627\u0644\u0639\u0627\u0644\u064a\u060c \u0648\u062a\u062d\u0633\u064a\u0646 \u0642\u0627\u0628\u0644\u064a\u0629 \u0627\u0644\u062a\u0648\u0633\u0639\u060c \u0648\u0632\u064a\u0627\u062f\u0629 \u0627\u0644\u0645\u0648\u062b\u0648\u0642\u064a\u0629.<\/p>","protected":false},"featured_media":468169,"menu_order":0,"template":"","meta":{"_acf_changed":false,"content-type":"","inline_featured_image":false,"footnotes":""},"class_list":["post-476741","wiki","type-wiki","status-publish","has-post-thumbnail","hentry"],"acf":{"faq_title":"Frequently Asked Questions about <mark>Database Sharding: An Essential Strategy for Data Management<\/mark>","faq_items":[{"question":"What is database sharding?","answer":"<p>Database sharding is a data management strategy where a large database is broken down into smaller, more manageable parts called \"shards.\" These shards are distributed across multiple servers to enhance performance, scalability, and reliability.<\/p>"},{"question":"When was database sharding first mentioned?","answer":"<p>Database sharding was first mentioned in the context of Google's BigTable and Amazon's Dynamo. These were early database systems designed to distribute large data sets across many servers for improved performance and scalability.<\/p>"},{"question":"How does database sharding work?","answer":"<p>Sharding works by dividing the data based on a specific sharding key. This key is used to determine the shard containing the relevant data when a query is executed. The data is then retrieved directly from that shard, bypassing the need to search the entire database.<\/p>"},{"question":"What are some key features of database sharding?","answer":"<p>Some key features of database sharding include scalability (as it distributes the database load across multiple servers), improved performance (as it allows queries to access a single shard rather than the entire database), availability and redundancy (with sharding, the failure of one shard doesn't impact the entire database), and geographical distribution (shards can be located based on the geographic location of users to reduce latency).<\/p>"},{"question":"What are the different types of database sharding?","answer":"<p>There are three main types of database sharding: horizontal sharding (where the database is divided into rows and distributed across different shards), vertical sharding (where the database is divided into columns or groups of related columns and distributed across different shards), and functional sharding (where the database is split based on functionality or business requirements).<\/p>"},{"question":"How can proxy servers be used with database sharding?","answer":"<p>Proxy servers can be used in conjunction with database sharding to enhance performance and data security. They can route requests to the appropriate shard based on the sharding key, improving query performance. Proxy servers can also provide an additional layer of security to the database shards by preventing direct access.<\/p>"}]},"_links":{"self":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/wiki\/476741","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/wiki"}],"about":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/types\/wiki"}],"version-history":[{"count":0,"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/wiki\/476741\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/media\/468169"}],"wp:attachment":[{"href":"https:\/\/oneproxy.pro\/ar\/wp-json\/wp\/v2\/media?parent=476741"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}