Home
Features
Modules
Integrations
PowerMTA Docs
MailerQ Docs
Pricing
Blog
D
e
m
o
Home
Features
Modules
Integrations
PowerMTA Docs
MailerQ Docs
Pricing
Blog
D
e
m
o
Home
Features
Modules
Integrations
PowerMTA Docs
MailerQ Docs
Pricing
Blog
Home
Knowledge base
Knowledge base
MailerQ knowledge base
›
Layer
Cluster database
entries in this theme: 73
Three families of limit, applied at once
critical
Written by the Hub
mechanism
A delivery is governed by the domain limits, the address limits and the connection limits simultaneously, and the strictest of everything that matches decides.
One database, every node, no master
critical
Written by the Hub
mechanism
Every node reads the same 33 tables and none of them owns the data; a change is a row plus a reload message, and everything else follows from that.
capacity
critical
Written by the Hub
database table
One row is a complete delivery profile: message and connection limits per domain and per address, seventeen SMTP timeouts, TLS mode and behaviour on unexpected responses.
capacity_rules
critical
Written by the Hub
database table
Binds a throttle profile to a domain, a sending address, a pool — or any combination, with blanks meaning "any", and each such combination belongs to exactly one profile.
dkim_keys
critical
Written by the Hub
database table
Private keys and their signing parameters: domain, selector, algorithm, canonicalisation, priority, expiry, extra headers, oversigning, ARC.
dkim_patterns
critical
Written by the Hub
database table
Matches a key to messages by sender address, with five match types: exact, regular expression, substring, wildcard, global.
paused
critical
Written by the Hub
database table
Holds deliveries for a destination, address, pool or tag, optionally until a given time, on one node or across the cluster.
rest_tokens
critical
Written by the Hub
database table
Tokens that authorise the REST API — the only credentials it accepts, stored in clear text.
suppressions
critical
Written by the Hub
database table
Addresses and domains that are failed immediately, with a chosen code, checked at the moment of delivery.
errors
important
database table
Fails matching deliveries on purpose with a chosen SMTP code and description, and counts how often it has done so.
flood_responses
important
database table
A throttle profile that switches itself on when a receiving server says something matching a pattern, and switches itself off after a set time.
ips
important
database table
One row per sending address, each with its own broker, exchange and queue — which is how a specific address can be given its own stream of mail.
mtanames
important
Written by the Hub
database table
The name each sending address announces in the SMTP greeting.
mx_pattern_groups
important
Written by the Hub
database table
Named groups that MX patterns belong to, usable wherever a domain can be named.
mx_patterns
important
Written by the Hub
database table
Patterns matched against a domain's MX records, so domains served by the same provider fall into one group.
pool_ips
important
Written by the Hub
database table
One row per address in a pool; an address may appear at most once.
pools
important
Written by the Hub
database table
Named groups of sending addresses, referenced by name in a message's job data.
response_patterns
important
database table
Matches what a receiving server said, narrowed by destination, sending address, pool and tag, in priority order.
rewrite_actions
important
database table
What a rule does: set or remove a sending address or pool, add or remove tags, delay, redirect to a smarthost, patch the job.
rewrite_triggers
important
database table
Selects messages to be modified on consumption, with a time window, a precedence and an enabled flag.
capacity_schedules
database table
A named schedule that raises limits over days; left empty on our nodes by decision.
external_mtas
database table
Addresses that are not on the machine: the engine binds locally, connects to a proxy, and mail leaves from an address the proxy owns.
ip_ranges
database table
Address ranges of receiving servers, grouped so that limits can apply to a whole network.
locals
Written by the Hub
database table
Incoming addresses that are not relayed but published to a queue of their own — postmaster, abuse, feedback loops.
response_actions
database table
The things that can happen when a response matches: pause, suppress, retry, add or remove an address or tag, set a property on the message or on the result.
rewrite_conditions
database table
Extra tests a message must pass — on the envelope, the subject, or any JSON property — before its rule applies.
capacity_schedules_rules
database table
Binds a schedule to combinations of sending address and destination domain.
capacity_schedules_states
database table
The engine's own record of which day of a schedule each address-and-domain pair has reached.
capacity_schedules_steps
database table
One row per step: from this day of the schedule, add this throttle profile to the ones already in force.
dns
database table
Pins a hostname to an address, bypassing resolution for that name.
ip_range_groups
database table
Named groups of receiver address ranges.
notification_subscriptions
database table
Browser subscriptions for the console's push notifications.
response_patterns_actions
database table
Many-to-many link between triggers and actions, with its own ordering.
sessions
database table
Active management-console logins.
vapid
database table
Key pair used to sign the console's browser push notifications.
domain_maxmessages
critical
Written by the Hub
database field
How many messages a minute may be sent to one destination domain, across every sending address.
ip_maxmessages
critical
Written by the Hub
database field
The per-address half of the limits: the same six quantities, counted for the pair of sending address and destination rather than for the destination alone.
localip
critical
Written by the Hub
database field
The sending address this rule applies to; empty means all of them.
privatekey
critical
Written by the Hub
database field
The PEM-encoded private key, stored in the cluster database in clear text.
target
critical
Written by the Hub
database field
The destination being held — a domain, a receiving address, or
*
for everything the node sends.
value
critical
Written by the Hub
database field
One address or one whole domain that mail is never delivered to.
connection_minmessages
important
Written by the Hub
database field
How much work an existing connection must be given before the engine decides to open a second one.
connection_offlinetime
important
Written by the Hub
database field
After a failed connection or handshake, how long the engine stops trying that receiving address.
domain
important
Written by the Hub
database field
The destination this rule's profile applies to; empty means every destination.
domain_maxconnecting
important
Written by the Hub
database field
How many connections to one domain may be in the middle of being established at once — shipped at one.
domain_maxconnections
important
Written by the Hub
database field
How many SMTP connections to one domain may be open at the same time.
domain_maxconnects
important
Written by the Hub
database field
How many new connections a minute may be opened to one domain.
enforce
important
Written by the Hub
database field
Not what its name suggests: it records whether the signing algorithm was stated explicitly, and therefore whether the engine needs to ask DNS.
expire
important
Written by the Hub
database field
The moment a pause stops applying; zero means it stays until removed.
flags
important
Written by the Hub
database field
A bit field holding the console's behaviour switches — the ones with no column of their own.
meaningful
important
Written by the Hub
database field
The companion mask to
flags
: one bit per switch, saying whether this profile decides it at all.
pattern
important
database field
What the receiving server said, matched against its response text.
security
important
database field
How hard the engine tries to encrypt: never, opportunistically, required, or required with strict certificate checks.
selector
important
Written by the Hub
database field
The label that tells a receiver which DNS record holds the public key for this signature.
begin
database field
With
until
, the period during which a rewrite rule applies; zero at both ends means always.
canonicalization
Written by the Hub
database field
How tolerant the signature is of whitespace changes in headers and body, as a pair of modes.
code
database field
The SMTP result recorded for deliveries this rule stops.
connection_maxidletime
Written by the Hub
database field
Seconds an unused connection is held open before being closed.
connection_maxmessages
Written by the Hub
database field
How many messages may be sent down one SMTP connection before it is closed and reopened.
domain_maxidle
Written by the Hub
database field
How many established but unused connections to a domain are kept for reuse.
final
database field
Whether remaining triggers are skipped once this one has matched.
incoming
Written by the Hub
database field
The recipient pattern that makes incoming mail be published to a queue instead of relayed onward.
maxqueue
Written by the Hub
database field
How many messages for this destination are held in the engine's memory at once.
occurrences
database field
A counter the engine increments each time this forced error matches a delivery.
pool_id
Written by the Hub
database field
Restricts a rule to addresses in one pool.
precedence
database field
The order in which rewrite rules are considered.
protocol
database field
The protocol spoken to the proxy that owns the public address.
timeout_connect
database field
Representative of the seventeen per-stage timeouts: how long the engine waits at each step of an SMTP conversation.
type
database field
Exact, substring, wildcard or regular expression.
connection_featurestime
database field
Seconds the engine caches what a receiving server announced in its greeting.
domain_maxbytes
database field
Bandwidth ceiling towards one domain, counted in bytes per minute.
precedence
database field
Not a priority at all: the engine stamps the moment the profile was created and uses it to keep the console list in a stable order.
priority
Written by the Hub
database field
Where this signature is placed when a message is signed by more than one key.