External Articles
Includes all customer-facing articles
ANNOUNCEMENTS
- SingleStoreDB 8.0 Release Announcement
- SingleStore 7.8 Release Announcement
- Apache Log4j2 (CVE-2021-44228) Security Alert
- SingleStore 7.6 Release Announcement
- SingleStore 7.5 release announcement
- End-of-Life Versions of SingleStoreDB
FAQ
- Granting REQUIRE SSL privilege to set of users
- Disable SSL in a SingleStore cluster
- DATABASE REPLICATION - ERROR 1037 (HY001): Out of memory; please try the operation again
- Recommended Linux Distributions
- Locking database user account in SingleStore
- Old log files in the /data dir
CLUSTER
- YAML file for cluster migration
- A "distributed" user
- Default password for root user when SingleStore cluster is installed
- Configuring toolbox on a Child Aggregator
- Checking if node auto-restart is enabled/disabled on reboot or not
- Disabling SingleStore node auto restart after host reboot
REPLICATION
- Leaf Error (127.0.0.1:3307): Unknown database 'testdb_2'
- Lag in database replication
- Paired leaf replication in High Availability vs. Load Balanced leaf replication
- Replication between clusters is not healthy
- Snapshots and Transaction logs used in replication
- What Is Reprovisioning?
ENGINE
- READ COMMITTED in SingleStore
- Disk space got exhausted - the "logs" directory is taking too much space
- Thread launch delays
- Resource Pool: HARD CPU Limit, SOFT CPU Limit and default_pool
- Why there are old transaction log files in my data dir
- Maximum_memory error on Query execution (ERROR 1712 ER_MEMSQL_OOM)
SQL
- Illegal command warning for group by
- ON DUPLICATE KEY UPDATE
- Data sorting using GROUP_CONCAT in subquery
- The "SeekableString" Encoding
- ERROR 1406 (22001): Leaf Error (x.x.x.x:330X): Data too long for column 'column_name'
- Comparing two databases
STORAGE
- Fragmentation on Rowstore table
- Estimating size for MySQL tables when migrating to SingleStore
- When to use reference tables
- Storage in SingleStore
- Understanding Disk Usage
- Storage reformatting from v6.x to v7.x
PIPELINE
- SKIP a specific file in S3 Pipelines
- Skip errors due to invalid JSON or Geospatial values during ingestion
- Investigating Pipeline Lag
- Loading pipeline in order
- Using information_schema tables to investigate pipeline issues
- Pipeline decompressing compressed file
BACKUP and RESTORE
- Backup and Restore completeion
- BACKUP/RESTORE ERROR: Remote connection timed out waiting for a response from the external endpoint
- SQL Error [2298] [HY000]: Leaf Error (x.x.x.x:3306): Could not perform remote backup. MissingAuthenticationToken: Request is missing Authentication Token
- What causes backup to fail with the error "x509: certificate signed by unknown authority"
- What causes the "Attempting to get the size of the backup target failed. Forbidden: Forbidden status code: 403" error during backups/restore
- ERROR: "Remote connection timed out because no metadata was received" for pipelines
DRIVERS
UPGRADE
MISCELLANEOUS
- ERROR 1045 (28000): GSS Major Error: Unspecified GSS failure. Minor code may provide more information. GSS Minor Error: Cannot find key for HTTP/memsql.s2.local@S2.LOCAL kvno 14 in keytab
- How to use XML output from SAML Chrome Panel to troubleshoot SingleStoreDB Cloud SSO Connections
- Disable THP (Transparent Hugepages)
- Troubleshooting Managed Service Cluster Connection to Kafka (Private Link - Outbound)
- Effect of host timezone on data
- memsqld and memsqld_safe processes
K8S & OPERATOR
- Custom "Height" With SingleStore Operator
- Kubernetes Service Ingress Error
- Connecting to your Kubernetes SingleStoreDB cluster
- View Node (and Exporter) Logs in a Kubernetes Environment (SingleStore Operator)
- Use of SingleStore Tools with the Kubernetes Operator
- Configure local PVs in Kubernetes
SingleStoreDB Cloud
- Workspace Group ID or Cluster ID
- Rename Workspace Group
- Creating Management API Key
- How to allow SingleStore Support to access my SingleStoreDB Cloud cluster
- Payment Methods for SingleStore Managed Service
- Change your Organization's maintenance window notification email address