Which Database Mode Is My Database Using?

Posted January 14, 2020 by Jim Knicely, Vertica Principal Solution Architect

Compass rose with true north pointing to "Helpful Tips" text

You can run Vertica in either Eon Mode or Enterprise Mode. The primary difference between Eon and Enterprise Modes is where they store data. Eon Mode stores data in a shared object store called communal storage, while Enterprise Mode stores data across the filesystems of the database nodes.

If you are working with a new database that you didn’t create, you can can determine which Mode it is using by querying the V_CATALOG.STORAGE_LOCATIONS or the V_CATALOG.SHARDS system table.

Examples:

dbadmin=> SELECT CASE COUNT(*)
dbadmin->          WHEN 0 THEN 'Enterprise'
dbadmin->          ELSE 'Eon'
dbadmin->        END AS database_mode
dbadmin->   FROM v_catalog.storage_locations
dbadmin->  WHERE sharing_type = 'COMMUNAL';
 database_mode
---------------
 Eon
(1 row)
SELECT CASE COUNT(*)
         WHEN 0 THEN 'Enterprise'
         ELSE 'Eon'
       END AS database_mode
  FROM v_catalog.shards;
 database_mode
---------------
 Eon
(1 row)

Helpful Links:
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/Eon/VerticaArchitectureEonVsEnterpriseMode.htm
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/Eon/ComparingEonandEnterpriseModes.htm
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/STORAGE_LOCATIONS.htm
https://www.vertica.com/docs/9.3.x/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/SHARDS.htm

Have Fun!