Glossary
This page is part of MariaDB's SkySQL Documentation.
Topics on this page:
Overview
This is a glossary of terms used within the MariaDB SkySQL Documentation:
A, B, C
A
- 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".
- 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".
- 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".
- 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".
- 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".
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 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".
- 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".
- 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".