GDS Features Many third-party solutions are not fully integrated with Oracle software, which makes it difficult for them to benefit from the features that GDS has, such as runtime load balancing. In the replica set, some databases may have a slower response because of the high load, while others may have room to serve new…
Configuration Best Practices of GDS in Maximum Availability Architecture – Introduction to Oracle Global Data Services
Configuration Best Practices of GDS in Maximum Availability Architecture Each region should have a total of three GSMs, with each GSM residing on dedicated hardware. This setup ensures redundancy, as even if one GSM experiences an outage, the other two will continue to provide the required services. The GDS catalog, which is essential for GDS…
GDS Restrictions, License, and Compatibility – Introduction to Oracle Global Data Services
GDS Restrictions, License, and Compatibility GDS operates as a shared infrastructure, allowing a single GDS configuration to handle the following: •\ Management of up to 300 database instances •\ Support for 1,000 global services •\ Provision of 20 GDS pools •\ Organization of 10 GDS regions •\ Availability of five GSMs per region •\ Facilitation…
What Is Sharding? 2 – Introduction to Oracle Sharding
The user-defined method considers that the user maps data to individual shards. This method is necessary when there is a strict requirement to have some type of data on a particular shard. The benefit of this method is that the user knows what data becomes unavailable during a particular sharding failure. The disadvantage is that…
What Is Sharding? – Introduction to Oracle Sharding
What Is Sharding? Oracle Sharding is a technology that distributes user data across multiple databases, called shards, within the same or different datacenters. In a shared-nothing architecture, the data is horizontally partitioned across a number of physically independent databases. Sharding is similar to the table partitioning. The difference between them is that the table partitioning…
Oracle Sharding Workshop – Introduction to Oracle Sharding
Oracle Sharding Workshop In this interactive section, we will present detailed instructions and real-life scenarios showcasing the implementation of Oracle Sharding with GDS. This practical approach will equip you with the necessary tools and commands to apply sharding techniques in your own environments. At the end of this section, you will have the opportunity to…
Creating the Catalog Database – Introduction to Oracle Sharding
Creating the Catalog Database On the gsmcat server, create the gsmcatdb database using DBCA from the RDBMS home and follow these instructions: \ 1.\ The shard catalog database gsmcatdb must use a server parameter file (spfile).\ 2.\ The database character set and national character set chosen for gsmcatdb must contain all the possible characters that…
Creating the Shard Catalog – Introduction to Oracle Sharding
Creating the Shard Catalog Connect to the catalog database server via SSH and create the catalog database using GDSCTL. [oracle@gsmcat ~]$ export ORACLE_HOME=/u01/app/oracle/product/19.3.0/ gsmhome_1 [oracle@gsmcat ~]$ export ORACLE_BASE=/u01/app/oracle [oracle@gsmcat ~]$ export PATH=$ORACLE_HOME/bin:$PATH [oracle@gsmcat ~]$ gdsctl GDSCTL> create shardcatalog -database gsmcat.mycompany.mydomain:1521/ gsmcatdb -region region1 -user gsm_admin/Oracle123 -agent_port 8080 -agent_password oracle -chunks 12 Here, gsmcat.mycompany.mydomain is a…