Network Settings

This article describes the necessary Amazon EC2 security group rules and the default ports used by Exasol.

Security group rules

The following inbound/outbound traffic must be allowed for the security group associated with your Exasol deployment:

• SQL client connections to the database
• SSH access to all cluster nodes
• HTTPS access to the Administration API
• NTP
• DNS

Optional:

• LDAP

For information on how to configure Amazon EC2 security group rules, see Security group rules - Amazon Elastic Compute Cloud.

Default ports

The following tables describe the default ports used in Exasol for different protocols and services. Many of these protocols and database management systems can be manually configured to use other ports.

Incoming ports

Protocol	Port	Source	Destination	Description
TCP	4444	Customer network	All nodes	HTTPS access to the Administration API
TCP	2580	Database client	Database nodes	Default BucketFS service You must assign a HTTP or HTTPS port for each BucketFS service that you create.
TCP	8563	Database client	Database nodes	Exasol database client connection port
TCP	20000 to 21000	Database nodes (source)	Database nodes (target)	Data transfer between nodes
TCP	20002	Customer network	All nodes	Shell access to EXACluster Operating System (COS) on all nodes
TCP	20003	Customer network	All nodes	XML-RPC access to ConfD

Outgoing ports

Protocol	Port	Source	Destination	Description
TCP	20	Database nodes	FTP server	FTP data port for IMPORT/EXPORT Additional ports may be required for passive transfer mode.
TCP	21	Database nodes	FTP server	FTP command port for IMPORT/EXPORT
TCP	53	All nodes	DNS server	DNS port
TCP	80	Database nodes	HTTP server	HTTP port for IMPORT/EXPORT
TCP	123	All nodes	NTP server	NTP port
TCP	389	All nodes	LDAP server	LDAP port
TCP	443	Database nodes	HTTPS server	HTTPS port for IMPORT/EXPORT
TCP	636	All nodes	LDAPS server	LDAPS port
TCP	990	Database nodes	FTPS server	FTPS port for IMPORT/EXPORT
TCP	1433	Database nodes	SQL Server database	SQL Server port (JDBC connection)
TCP	1521	Database nodes	Oracle database	Oracle server port (JDBC/ORA connection)
TCP	3306	Database nodes	MySQL database	MySQL server port (JDBC connection)
TCP	5000	Database nodes	Sybase ASE database	Sybase ASE server port (JDBC connection)
TCP	5432	Database nodes	PostgreSQL database	PostgreSQL server port (JDBC connection)
TCP	8563	Database nodes	Database client	Exasol database client connection port
TCP	20000 to 21000	Database nodes (source)	Database nodes (target)	Data transfer between nodes
TCP	50000	Database nodes	DB2 database	DB2 server port (JDBC connection)