docs_sql_sql-locations.md

• Managed Global Database
• Locations and Geofencing

Locations and Geofencing

This document describes how to use locations and geofences to restrict your data or create linearizable semantics between locations.

Across the various table types, MGSQL support two location attributes geo-fences and regions.

• We use seaplane_region to specify a given set of regions where MGSQL guarantees linearizable semantics. Adding a seaplane_region does not restrict data to the location.
• We use seaplane_geofence to restrict data to one or more locations. When a seaplane_geofence is provided Seaplane will never store data of the restricted resource outside of the geofence.

Seaplane supports the following countries and grouped geo-regions.

2-letter code	Full Name
AE	United Arab Emirates
AU	Australia
BE	Belgium
BH	Bahrain
BR	Brazil
CA	Canada
CH	Switzerland
CL	Chile
DE	Germany
ES	Spain
FI	Finland
FR	France
GB	United Kingdom of Great Britain and Northern Ireland
HK	Hong Kong
ID	Indonesia
IE	Republic of Ireland
IN	India
IT	Italy
JP	Japan
KR	Korea, Republic of
NL	Netherlands
PL	Poland
RO	Romania
SE	Sweden
SG	Singapore
TW	Taiwan
US	United States of America
ZA	South Africa
	In addtion to countries the following grouped geo-regions are available
XA	Asia
XC	People's Republic of China
XE	Europe
XF	Africa
XN	North America
XO	Oceania
XQ	Antartica
XS	South America
XU	The UK

Tags:

• sql
• locations
• geofencing

Edit this page

Last updated on Dec 22, 2022 by fokkedekker