Orbit
Xstreami
Database Insights, Tips & Expert Blogs
Optimize Your Database: Exploring MySQL 8.0 JSON Functions
Author : Abish
February 21, 2023
This blog highlights the some of the important JSON function in MySQL 8.0 with examples. Level up your SQL skills with MySQL 8.0's JSON functions.
Best practices on enabling Audit log on MySQL, MariaDB and ProxySQL
Author : sukan
August 13, 2020
Importance of audit log in MySQL, MariaDB and ProxySQL. Best practices to enable audit log
High Availability for MySQL using Orchestrator and ProxySQL
Author : sukan
September 10, 2026
Auto slave promotion without any DBAs intervention using Orchestrator and ProxySQL. If you are looking for a HA solution without going for synchronous replication or Aws RDS then Orchestrator with ProxySQL is a great choice.
Understanding the Spider Storage Engine
Author : Murali
September 10, 2026
MariaDB Spider is a storage engine that supports federation and sharding across multiple MySQL or MariaDB servers. It helps distribute data and workloads, making it useful for scaling large datasets, balancing traffic, and improving data retrieval through parallel processing.
Avoid deadlocks, certification failures on Galera Cluster using ProxySQL
Author : sukan
July 06, 2019
Dealing with deadlocks, certification failures on Galera cluster by running single node writer using ProxySQL
MySQL Character Set: UTF8MB4 vs UTF8 and How to Choose the Right Encoding
Author : Abishek S
March 26, 2026
Choosing the right MySQL character set is critical for ensuring accurate data storage, multilingual support, and proper text comparison. While the legacy utf8 (utf8mb3) character set supports only up to 3-byte characters, it fails to handle modern Unicode requirements such as emojis and certain international symbols. In contrast, utf8mb4 provides full 4-byte Unicode support, making it the recommended standard for modern applications. This guide explains the differences between UTF8MB4 and UTF8, their impact on storage and performance, and provides step-by-step instructions to configure and migrate your MySQL databases safely.
Real time data streaming from MariaDB to Columnstore
Author : sukan
September 11, 2026
How real time data from transactional database(mariadb) to analytic database(columnstore) is achieved using MariaDB's maxscale binlog streaming
Fixing the MariaDB Galera Bug: WSREP Lock Waits
Author : sukan
September 10, 2026
A MariaDB Galera cluster can experience severe stalls when concurrent updates to the same primary key trigger an unexpected deadlock issue. This blog explains how we reproduced the issue in MariaDB 10.2, why the affected node became unresponsive, and the recovery and upgrade options used to resolve it.
Highlights
More than 6000 Servers Monitored
Happy Clients
Certified DBAs
24 x 7 x 365 Support
Contacts
Nagercoil Office
Miru IT Park, Vallankumaranvillai,
Nagercoil, Tamilnadu - 629 002.
Bangalore Office
Unit 303, Vanguard Rise,
5th Main, Konena Agrahara,
Old Airport Road, Bangalore - 560 017.
Call: +91 6383016411
Email: sales@mafiree.com