The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Which Database Mode is My Database Using?

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!

Comments

  • There is an easy way to look for this by checking admintools.conf of a node for that database.
    In [Database:<>] section of this file, you will have "is_eon_mode = True" for EON db.
    Other information reagrding EON setup is also there like below:
    depot_base_dir = /home/dbadmin
    depot_size = 307200K
    communal_storage_url = s3://abhibucket/
    num_shards = 3

Sign In or Register to comment.

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.