Glossary

Overview

This is a glossary of terms used within the MariaDB SkySQL Documentation:

A, B, C

A

allowlist

See IP Allowlist.

available selections at service launch

Available selections at service launch are required decisions made from a menu when a SkySQL service is launched. Selections include topology, cloud provider, instance size, region, and software version. For additional information, see "Available Selections at Service Launch".

AWS

AWS, Amazon Web Services, is a cloud provider. For additional information, see "Cloud Providers".

AWS DMS

AWS DMS, Amazon Web Services Data Migration Service, supports the migration of databases from AWS database services such as Amazon Aurora and Amazon RDS. For information on using DMS to migrate to SkySQL, see "Migrate to MariaDB SkySQL using AWS DMS".

AWS PrivateLink

AWS PrivateLink, connects your Amazon Web Services (AWS) VPC (Virtual Private Cloud) network to MariaDB SkySQL with connectivity over Amazon's network. AWS PrivateLink improves network latency and security when communicating between servers in the same AWS region. For additional information, see "Options: AWS PrivateLink".

C

C

C is a programming language. For information on connecting to MariaDB SkySQL from C applications, see "MariaDB Connector/C".

C++

C++ is a programming language. For information on connecting to MariaDB SkySQL from C++ applications, see "MariaDB Connector/C++".

certificate authority chain

A certificate authority chain is a .pem file used by your database client to verify the server's TLS certificate. For additional information, see "Connection Parameters: Certificate Authority Chain".

Configuration Manager

The Configuration Manager interface is used to configure database settings for SkySQL services. For additional information, see "Configuration Manager".

configuration variables

Configuration variables are customer-settable database or load balancer settings exposed through the Configuration Manager. For additional information, see "Configuration Manager".

Connector/C

See MariaDB Connector/C.

Connector/C++

See MariaDB Connector/C++.

Connector/Node.js

See MariaDB Connector/Node.js.

Connector/ODBC

See MariaDB Connector/ODBC.

Connector/Python

See MariaDB Connector/Python.

Connector/R2DBC

See MariaDB Connector/R2DBC.

cross-region replicas

Cross-region replicas support disaster recovery (DR) implementation by replicating data from one region to a different region. For additional information, see "Cross-Region Replicas".

D, E, F

D

data-at-rest encryption

Data-at-rest encryption is the protection of data through encryption when storage is inactive (unmounted, disconnected, powered off, or physically removed). For additional information, see "Data-at-Rest Encryption".

data-in-transit encryption

Data-in-transit encryption is the protection of data through encryption during network communication. By default, data-in-transit encryption is enabled for SkySQL services. For additional information, see "Data-in-Transit Encryption".

DBaaS

A DBaaS is a DataBase-as-a-Service. A DBaaS is a managed database delivered by a cloud database provider. MariaDB SkySQL is a DBaaS. For additional information, see "FAQ: DBaaS vs On-Premises".

DBaaS API

See SkySQL DBaaS API.

DBeaver

DBeaver is a graphical database client. For information on connecting to MariaDB SkySQL services with DBeaver, see "Clients: DBeaver Universal Database Tool".

dbForge Studio

dbForge Studio is a graphical database client. For information on connecting to MariaDB SkySQL services with dbForge Studio, see "Clients: dbForge Studio".

Distributed Transactions

The Distributed Transactions SkySQL service topology is designed for read/write scale applications with high concurrency and availability. This topology is built with MariaDB Xpand and MariaDB MaxScale. The on-premises equivalent is the Xpand Performance Topology. For additional information, see "Distributed Transactions".

DMS

See AWS DMS.

DPA

A DPA, Data Processing Addendum, is a means to meet GDPR adequacy and security requirements. For additional information, see the MariaDB Trust Center.

F

FAQ

A FAQ, or Frequently Asked Questions list, provides answers to common questions. See the MariaDB SkySQL FAQ for answers to common SkySQL questions.

Foundation Tier

Foundation Tier is the default service tier for MariaDB SkySQL. For details on enhanced service, see "Power Tier".

G, H, I

G

GCP

GCP, Google Cloud Platform, is a cloud provider. For additional information, see "Cloud Providers".

GDPR

GDPR, General Data Protection Regulation, is a European Union data privacy and security law. MariaDB offers a Data Processing Addendum (DPA) as a means of meeting GDPR adequacy and security requirements. For additional information, see the MariaDB Trust Center.

H

HeidiSQL

HeidiSQL is a graphical database client. For information on connecting to MariaDB SkySQL services with HeidiSQL, see "Clients: HeidiSQL".

helper procedure

A helper procedure is a stored procedure that reduces complexity or provides the privileges required to perform an operation. MariaDB SkySQL uses helper procedures to enable self-service configuration of replication. For additional information, see "SkySQL Replication Helper Procedures".

I

IP Allowlist

An IP Allowlist defines which IP addresses are permitted to access a service located behind a firewall. MariaDB SkySQL maintains separate customer-configurable IP Allowlists for access to SkySQL services and access to SkySQL Monitoring. For additional information, see "Security: Firewalls".

J, K, L

J

Java

Java is a programming language. For information on connecting to MariaDB SkySQL from Java applications, see "MariaDB Connector/J".

M, N, O

M

maintenance window

A maintenance window is a scheduled period of time when hardware, network, software, or configuration changes can be applied, and processes can be restarted. This does not refer to self-service actions performed by a customer. For additional information, see "Maintenance Windows".

MariaDB Client

MariaDB Client is a console database client. For information on connecting to MariaDB SkySQL services with MariaDB Client, see "Clients: MariaDB Client".

MariaDB Connector/C

MariaDB Connector/C connects C and C++ applications to MariaDB SkySQL services. For additional information, see "MariaDB Connector/C".

MariaDB Connector/C++

MariaDB Connector/C++ connects C++ applications to MariaDB SkySQL services. For additional information, see "MariaDB Connector/C++".

MariaDB Connector/Node.js

MariaDB Connector/Node.js connects Node.js applications to MariaDB SkySQL services. For additional information, see "MariaDB Connector/Node.js".

MariaDB Connector/ODBC

MariaDB Connector/ODBC connects applications to MariaDB SkySQL services using the ODBC API. For additional information, see "MariaDB Connector/ODBC".

MariaDB Connector/Python

MariaDB Connector/Python connects Python applications to MariaDB SkySQL services. For additional information, see "MariaDB Connector/Python".

MariaDB Connector/R2DBC

MariaDB Connector/R2DBC connects reactive Java applications to MariaDB SkySQL services. R2DBC operations are non-blocking, which makes the R2DBC API more scalable than Java's standard JDBC API. MariaDB Connector/R2DBC is available both with a native R2DBC implementation and the Spring Data R2DBC framework. For additional information, see "MariaDB Connector/R2DBC".

MariaDB ID

MariaDB ID is an identity provider used, by default, to authenticate users to the MariaDB SkySQL Portal. MariaDB ID can be accessed at https://id.mariadb.com/ using your web browser. For additional information, see "Security: Portal Accounts".

MariaDB SkySQL

MariaDB SkySQL is a cloud database service (DBaaS) from MariaDB Corporation. MariaDB SkySQL delivers MariaDB Enterprise, a comprehensive data platform for modern applications. MariaDB SkySQL runs on expert-maintained cloud infrastructure. For additional information, see "Features and Concepts".

Microsoft Power BI

Microsoft Power BI is a freely-downloadable Business Intelligence (BI) tool for Microsoft Windows. Using the MariaDB Direct Query Adapter, a Microsoft-certified connector, you can connect to your SkySQL service and query data without downloading the entire data set to your local machine. For additional information, see "Connect using Microsoft Power BI".

Multi-Node Analytics

The Multi-Node Analytics SkySQL service topology is designed to run complex analytical queries on large datasets. This topology is built with MariaDB Enterprise ColumnStore, MariaDB MaxScale, and object storage. The on-premises equivalent is the ColumnStore Object Storage Topology. For additional information, see "Multi-Node Analytics".

multi-node infrastructure

See scale fabric.

MySQL Workbench

MySQL Workbench is a graphical database client. For information on connecting to MariaDB SkySQL services with MySQL Workbench, see "Clients: MySQL Workbench".

N

Navicat

Navicat is a graphical database client. For information on connecting to MariaDB SkySQL services with Navicat, see "Clients: Navicat".

Node.js

Node.js is a runtime environment for the JavaScript programming language. For information on connecting to MariaDB SkySQL from Node.js applications, see "MariaDB Connector/Node.js".

O

ODBC

ODBC, Open Database Connectivity, is an API. For information on connecting to MariaDB SkySQL from applications that use the ODBC API, see "MariaDB Connector/ODBC".

options

Options are optional features which augment the default MariaDB SkySQL service experience. For additional information, see "Options".

P, Q, R

P

P1

P1 is an incident severity. P1 is the highest incident severity, and P4 is the lowest incident severity. For details on support response times based on incident severity, see "Support Options".

P2

P2 is an incident severity. P2 is the second-highest incident severity. For details on support response times based on incident severity, see "Support Options".

P3

P3 is an incident severity. P3 is the third-highest incident severity. For details on support response times based on incident severity, see "Support Options".

P4

P4 is an incident severity. P4 is the lowest incident severity, and P1 is the highest incident severity. For details on support response times based on incident severity, see "Support Options".

POC

A POC, proof of concept, enables a business to confirm the viability of a service to meet business requirements. A POC provides a real, working service implementation for testing. For additional information on SkySQL POCs, see "Proof of Concept (POC)".

Portal

See SkySQL Portal.

Power BI

See Microsoft Power BI.

Power Tier

Power Tier is a premium offering for MariaDB SkySQL customers who have the most critical requirements for uptime, availability, performance, and support. Power Tier customers receive an enhanced SLA and highly-customizable service experience. For additional information, see "Power Tier".

PrivateLink

See AWS PrivateLink.

Python

Python is a programming language. For information on connecting to MariaDB SkySQL from Python applications, see "MariaDB Connector/Python".

R

R2DBC

R2DBC is Reactive Relational Database Connectivity (R2DBC) API. R2DBC operations are non-blocking, which makes the R2DBC API more scalable than Java's standard JDBC API. MariaDB Connector/R2DBC is available both with a native R2DBC implementation and the Spring Data R2DBC framework. For information on connecting to MariaDB SkySQL from Java R2DBC applications, see "MariaDB Connector/R2DBC".

RAM

RAM is Random Access Memory. For information on available RAM configurations, see "Instance Sizes".

registration

See sign up.

release notes

Release notes itemize details about feature changes effective a certain date. For additional information on SkySQL feature changes, see "Release Notes".

Replicated Transactions

The Replicated Transactions SkySQL service topology is designed for read scale applications with high availability. This topology is built with MariaDB Enterprise Server and MariaDB MaxScale. The on-premises equivalent is the Primary/Replica Topology. For additional information, see "Replicated Transactions".

ro

ro is an abbreviation for read-only.

rw

rw is an abbreviation for read/write.

S, T, U

S

scale fabric

Scale fabric costs and charges represent the additional network, host, and backup infrastructure needed to support multi-node topologies. In addition to multi-node topologies, this charge also applies to the Distributed Transactions topology when deployed with 1 Xpand node, since infrastructure is present to support scale-up to a multi-node configuration. For information on other costs and charges, see "Pricing".

selections

See available selections at service launch.

sign up

Sign up is a process to register for access to a service. For information on how to access MariaDB SkySQL, see "Sign up for SkySQL".

Single Node Analytics

The Single Node Analytics SkySQL service topology is designed to run complex analytical queries. This topology is built with MariaDB Enterprise ColumnStore, MariaDB MaxScale, and object storage. For additional information, see "Single Node Analytics".

Single Node Transactions

The Single Node Transactions SkySQL service topology is designed for smaller datasets with modern concurrency. This topology is built with MariaDB Enterprise Server. This topology is useful as a development and test environment for OLTP workloads. For additional information, see "Single Node Transactions".

SkyDBA

SkyDBA is an additional level of support available to customers with Enterprise or Platinum Support Plans. SkyDBAs (MariaDB staff who work on the SkyDBA team) extend the capabilities of your in-house DBAs with the backing from a global team of expert MariaDB DBAs, available 24/7 for the most severe (P1) issues. For additional information, see "Features and Concepts: SkyDBA".

SkySQL

See MariaDB SkySQL.

SkySQL DBaaS API

The SkySQL DBaaS API provides an interface to launch and manage SkySQL services. This is a REST API. For additional information, see "MariaDB SkySQL DBaaS API".

SkySQL Monitoring

SkySQL Monitoring is an interface that provides status and metrics dashboards for SkySQL services and servers. Alerts and notifications can be configured with rules for problem notifications to customer-defined contacts. For additional information, see "SkySQL Monitoring".

SkySQL Portal

The SkySQL Portal is a web interface used to launch and manage SkySQL services. An alternative is the SkySQL DBaaS API. The SkySQL Portal can be accessed at https://cloud.mariadb.com/ using your web browser. For additional information, see "SkySQL Portal".

skysqlcli

The skysqlcli utility provides a command-line interface to launch and manage SkySQL services. skysqlcli uses the SkySQL DBaaS API. For additional information, see "skysqlcli".

SQLyog

SQLyog is a graphical database client. For information on connecting to MariaDB SkySQL services with SQLyog, see "Clients: SQLyog".

T

TablePlus

TablePlus is a graphical database client. For information on connecting to MariaDB SkySQL services with TablePlus, see "Clients: TablePlus".

technical preview

From time to time, features are made available as a technical preview to enable early testing by customers. Technical preview features should not be used for production workloads. Technical preview features can change before release as "generally available" features. Technical preview features are itemized in release notes. For additional information, see "Release Notes".

TLS

TLS, Transport Layer Security, is the successor to SSL. TLS is used to deliver data-in-transit encryption. For additional information, see "Data-in-Transit Encryption".

U

UI

A UI is a user interface. For information on SkySQL user interfaces, see "Interfaces".

V, W, X

V

vCPU

A vCPU is a virtual processor. Where physical computers contain a CPU, virtual machines contain a virtual processor. For information on available vCPU configurations, see "Instance Sizes".

VPC Peering

VPC Peering, connects your Google Cloud Platform (GCP) VPC (Virtual Private Cloud) network to MariaDB SkySQL with connectivity over Google's network. VPC Peering improves network latency, improves security, and reduces egress bandwidth costs when communicating between servers in separate GCP regions. For additional information, see "Options: VPC Peering".

W

WLA

See Workload Analysis.

Workload Analysis

Workload Analysis is an interface that provides interactive visualizations of database workloads, key metrics, and transitions as workloads change over time. For additional information, see "Workload Analysis".

Y, Z, Misc.