# Placement Rules In Sql
__*Placement Rules in SQL*__
+ Clusters deployed cross geo-location to support local access
+ Isolate resources based on business
+ Allocate resources and number of replica per business level

![left](./student-guide/diagram/PlacementRulesInSQLAfter_aa_001_20220515.png)

------------------------------------------------------------
With Placement Rules in SQL, we can do fine-grained data placement, as shown in the figure:

The T2 table and the T3 table are placed in a cluster in the Beijing region to realize a cluster deployed cross geo-location and support local access.

In the NewYork region, we set the T5, T6, and T7 tables as the region of the leader role and placed them on the three servers TiKV-4, TiKV-5, and TiKV-6 respectively, to isolate resources according to the business.

Regarding the separation of hot and cold data, let's see that in the Tokyo region, the region of the leader role of the T7 table is placed on the TiKV-8 server with better performance, while the T8 table uses three servers with average performance TiKV-7, TiKV-9, and TiKV-10. In addition, we have seen that the T7 table has 5 replica, unlike other tables, so it is possible to allocate resources and replica according to business level.