Single Node Transactions
This page is part of MariaDB's Documentation.
The parent of this page is: Services
Topics on this page:
Overview
The Single Node Transactions topology is available on MariaDB SkySQL on AWS and GCP.
The Single Node Transactions topology is useful as a development and test environment for OLTP (transactional) workloads.
Component View
In this service:
MariaDB Enterprise Server provides a modern SQL RDBMS with pluggable storage engines, hot online backups, and audit logging.
InnoDB provides a row-based storage engine for ES that delivers excellent performance for transactional or online transactional processing (OLTP) workloads.
Service Details
The Single Node Transactions topology on SkySQL delivers the following features:
Topology | Single Node Transactions |
Workload Optimization | Transactional |
Server | |
Storage Engine | InnoDB |
Storage | EBS Provisioned IOPS (AWS),
Zonal SSD Persistent Disk (GCP)
|
Number of Instances | 1 |
Replication | No |
Load Balancing | No |
Failover | No |
Production-Ready | No |
Development/UAT-Ready | Yes |
The Single Node Transactions topology uses EBS Provisioned IOPS (AWS) or Zonal SSD Persistent Disk (GCP), and the ACID-compliant InnoDB storage engine.
This topology features a single instance. For additional information on instance options, see "Single Node Transactional Instance Sizes".
Support of a cross-region replica for Disaster Recovery (DR) is available for Power Tier customers.
InnoDB is the supported storage engine for customer-created tables in Single Node Transactions services, which are dependent on the enhanced capabilities and compatibility of InnoDB for transactions, backups, crash recovery, replication, and other features.
Resources
Screenshots
FAQ
These questions and answers pertain to the Single Node Transactions topology.
For a complete list of questions and answers, see the SkySQL Frequently Asked Questions (FAQ) list.
What features does MariaDB Enterprise Server provide?
Features of MariaDB Enterprise Server include:
Enterprise-optimized builds with backports of critical fixes, improved code stability, and enterprise enhancements.
Compatibility with most programming languages and clients that work with MariaDB or MySQL, for off-the-shelf integration to your stack.
Online schema changes with InnoDB's Instant ALTER.
MariaDB Enterprise Audit for enhanced audit logging.
MariaDB Enterprise Backup for hot online backups.
What is the SLA?
See Service Availability (SLA) for complete details. SLA is not provided for Single Node Transactions services, as High Availability (HA) features are not enabled in single-node configurations.
If an SLA is needed, please consider the Replicated Transactions topology.
What is configurable?
At time of service launch, region, instance sizes and storage sizes, and MariaDB Enterprise Server version are configurable.
After launch, MariaDB Enterprise Server is configurable using SkySQL's Configuration Manager. A full list of configurable parameters is available.
How are backups performed?
Automated nightly backups are performed with MariaDB Enterprise Backup, which enables hot online backups. MariaDB Enterprise Backup breaks up backups into non-blocking stages so writes and schema changes can occur during backups.
How do I monitor my database?
SkySQL Monitoring provides real-time status and metrics. For the Single Node Transactions topology, SkySQL Monitoring includes server-level and service-level monitoring.
What support is available?
Foundation Tier services include Standard Support.
Power Tier customers choose between Enterprise and Platinum support plans optimized to meet the needs of mission-critical deployments requiring 24x7 support.
An option available to customers with Enterprise or Platinum support plans, SkyDBA further extends the premium support experience and 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. MariaDB's SkyDBAs manage your MariaDB SkySQL databases both proactively and reactively so you can focus on your core business.
What if I have other requirements?
SkySQL Power Tier is a premium service offering for MariaDB SkySQL customers who have the most critical requirements for uptime, availability, performance, and support.