Diese Seite ist nur auf Englisch verfügbar.

macma/macma-core

Resource Requests and Limits

Memory requirements are mainly determined by the "Configure by File" Excel-file export and import functionality, which depends mainly on number of roles and resources.

Plant Size

Small

Medium

Large

#roles × #resources

<250k

400k

>750k

Version 1.42 will reduce memory requirement by up to 40-65% (more for larger plants).

Resource

Request

Limit

CPU (in millicpu)

100

Memory (in MiB) up to 1.41

768

1536 (Small) / 2048 (Medium) / 4096 (Large)

Memory (in MiB) since 1.42

768

1024 (Small) / 1280 (Medium) / 1536 (Large)

Local File Storage (in MB)

1200

1500

Required infrastructure services

Databases

Either of

Oracle DB / 19c / Enterprise Edition

Supported Versions

19c

Extensions

Character set (strongly recommended) (AL32UTF8)
National Character set (required) AL16UTF16)

DBs / Schemas / Users

schema and user are configurable (schema needs to be default for user)

Required Privileges
For the MACMA database
  • An oracle user with the privileges "NEXEED_BASIC_ROLE" as described in the Nexeed IAS Operations Manual is required

Relative Capacity

depending on amount of tenants, users, applications and resources managed

Microsoft SQL Server 2016/2017/2019, Azure SQL

(only with MS JDBC driver, not jtds)

Supported Versions
  • 2016

  • 2017

  • 2019

Database Settings

To reduce the amount of potential deadlocks the following settings must be enabled for macma-core database:

ALTER DATABASE [master-data-database] SET ALLOW_SNAPSHOT_ISOLATION ON
ALTER DATABASE [master-data-database] SET READ_COMMITTED_SNAPSHOT ON WITH NO_WAIT

Azure SQL already has these settings enabled by default

The READ_COMMITTED_SNAPSHOT setting can only be applied if not other connections to the database exist. There are various options to enforce that:

  • limit database to mode RESTRICTED_USER (rather than SINGLE_USER) temporarily before reverting to MULTI_USER using:

    ALTER DATABASE [master-data-database] SET <mode> WITH ROLLBACK AFTER 30 SECONDS
  • shut down all applications;

  • add WITH ROLLBACK IMMEDIATE instead of WITH NO_WAIT to force a rollback of all active transactions;

  • use database failover to replicas to reconfigure them one by one.

Database Collation

SQL_Latin1_General_CP1_CI_AS

DBs / Schemas / Users

schema and user are configurable (schema needs to be default for user)

Required Privileges

Full access to manage objects and data within the schema DDL + DML

Relative Capacity

depending on amount of tenants, users, applications and resources managed

Messaging Middleware

AMQP Broker

Supported Versions

standard compliant AMQP 0.9.1 broker

Extensions

-

Queues / Topics / Exchanges

IAS std. queues for event propagation

Required Privileges

IAS std.

Relative Capacity

-

Required resources

Resources Comments

Certificates

Certificates required for outgoing connections can be configured via the environment variable USE_SYSTEM_CA_CERTS (see macma/macma-core Configuration for more information)

Edit this pageDiese Seite bearbeiten

Feedback on this pageFeedback zu dieser Seite