Orbit
Xstreami
- About
- Services
- Blogs
- Careers
- Products
- Contact Schedule a Call
Database Insights, Tips & Expert Blogs
Avoid deadlocks, certification failures on Galera Cluster using ProxySQL
Author : sukan
Mysql
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
Mysql
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
Mysql
How real time data from transactional database(mariadb) to analytic database(columnstore) is achieved using MariaDB's maxscale binlog streaming
MySQL vs ColumnStore vs ClickHouse Benchmark
Author : Shenbaga Varna S
Clickhouse
Choosing the right database for analytics depends on the workload, data size, and query patterns. This blog compares MySQL, MariaDB ColumnStore, and ClickHouse using a large time-series dataset. The benchmark compares storage usage and query performance, with ClickHouse delivering the best results for this particular workload and ultimately being selected for production.
PostgreSQL Autovacuum Explained in Detail
Author : Shenbaga Varna S
Postgresql
This blog explains how PostgreSQL Autovacuum works — covering the launcher/worker process model, the exact formula that decides when a table becomes eligible, and the key differences between VACUUM, Autovacuum, and VACUUM FULL. It includes an interactive eligibility calculator, tunable parameters, monitoring queries, and best practices to help DBAs prevent table bloat and transaction ID wraparound.
Whats new in ProxySQL 2.0
Author : viknesh
Proxysql
Features of ProxySQL 2.0 Version
Running SQL Server on Linux: What to Know
Author : Shenbaga Varna S
Sql server
SQL Server 2017 brings the best features of the Microsoft relational database engine to the enterprise Linux ecosystem, including SQL Server Agent, Azure Active Directory (Azure AD) authentication, best-in-class high availability/ disaster recovery, and unparalleled data security.
Why Use MongoDB for Modern Applications
Author : Shenbaga Varna S
Mongodb
Next generation databases must address some of the points such as being non-relational,highly available,open source and horizontally scalable. NoSQL databases has much increased features when it comes to non-structural data. In this article, we will discuss basics of NoSQL databases and why you need.
Fixing the MariaDB Galera Bug: WSREP Lock Waits
Author : Shenbaga Varna S
Mysql
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.
Get in touch with us
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