Sedna Hash Consulting

sednahash

Get Started

Documentation

Official Sedna Hash Documentation

Quick Guides

The quick guides are designed to get you up and running quickly with Sedna Hash. These guides are aimed at helping someone new to Sedna Hash in understanding the basic configuration concepts. The initial guides deal with installing Sedna Hash and performing the initial configuration. Guides detailing the two main use cases for Sedna Hash namely Read/Write Split and Sharding are also avaiable here.

Download and Install Sedna Hash

First steps after installing

How to configure Sedna Hash for the first time

How to set up Sedna Hash Read/Write Split

How to set up Sedna Hash Sharding

Reference Manual
Reference Manual

Before delving into the Sedna Hash configuration specifics it is crucial to understand the Multi Layer Configuration System and how Sedna Hash’s supported backend servers are configured and monitored in Sedna Hash.

  • Multi Layer Configuration System
  • Configuration file
  • Startup options
  • Backend Server Configuration
    • AWS Aurora Configuration
    • ClickHouse Server Configuration
    • Galera / Percona XtraDB Cluster Configuration
    • Oracle Group Replication Configuration
  • Backend Server Monitoring

Global Variables

Admin Variables

    • General MySQL Variables
    • MySQL Monitor Variable
  • Error Log
Reference Manual

  • The Sedna Hash Admin DB is configurable via a standard MySQL client and is the heart of Sedna Hash’s configuration system allowing dynamic runtime reconfiguration of Sedna Hash administrative and operational functions.

    Ensure that you fully understand how the Sedna Hash Configuration CLI works before taking a deep dive into what features are controlled in the various configuration tables.

    Sedna Hash Configuration CLI

        • main (runtime)
          • mysql_users
          • mysql_servers
          • mysql_replication_hostgroups
          • mysql_galera_hostgroups
          • mysql_group_replication_hostgroups
          • mysql_hostgroup_attributes
          • mysql_query_rules
          • mysql_query_rules_fast_routing
          • global_variables
          • Sedna Hash_servers
          • scheduler
          • mysql_collations
          • runtime_xxx tables
        • disk (persisted)
        • stats (statistics)
Security

  • All Sedna Hash security functions are configurable via the Sedna Hash Admin interface and are documented in the pages found here.

        • User configuration
          • Password management
        • SSL configuration
        • SPIFFE configuration
        • Audit Logging
        • Firewall Whitelisting
          • SQL Injection Engine
    • mysql_global_variables
    • stats_mysql_memory_metrics
    • stats_mysql_commands_counters
    • stats_mysql_connection_pool
    • stats_mysql_global
    • stats_mysql_gtid_executed
    • stats_mysql_prepared_statements_info
    • stats_mysql_processlist
    • stats_mysql_query_digest
    • stats_mysql_query_rules
    • stats_mysql_users
    • stats_Sedna Hash_servers_checksums
    • stats_Sedna Hash_servers_metrics
      •  
  •  
Features

  • Here you will find configuration details for specific Sedna Hash features and interesting information related to the inner workings of Sedna Hash. Topics cover various design aspects that are of interest to more advanced end-users and project contributors

        • Connection Multiplexing
        • Sedna Hash Cluster
        • Query Cache
        • Query Logging
        • Query Annotations
        • Prepared Statement Caching
        • Mirroring
        • Scheduler
        • HTTP Web UI Statistic Graphs
        • Sedna Hash REST API
        • Sedna Hash Threads
        • Thread Watchdog
        • Client Error Limit
        • MysqlBinLog Reader
        • DNS Cache