Orbit
Xstreami
- About
- Services
- Blogs
- Careers
- Products
- Contact Schedule a Call
Database Insights, Tips & Expert Blogs
Access Control & Account Management In MySQL 8
Author : sukan
June 08, 2023
Discover how MySQL 8 enhances security through features like password expiry, password validation, account lock/unlock, privilege management, and dual passwords. Safeguard your valuable data and streamline access control in your MySQL environment.
Significance of using Invisible Primary key (GIPK) with MySQL 8.0
Author : sukan
February 21, 2023
How Generated Invisible Primary Keys (GIPK) Can Boost Your Database Efficiency
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
August 02, 2019
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.
What is Spider Storage Engine
Author : murali
July 10, 2019
Know about spider storage engine, its types and how the data is partitioned / Shard.
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
May 28, 2019
How real time data from transactional database(mariadb) to analytic database(columnstore) is achieved using MariaDB's maxscale binlog streaming
MariaDB Galera Bug [WSREP: BF lock wait long]
![MariaDB Galera Bug [WSREP: BF lock wait long]](/blog_images/1699608343-Su-4.jpg "MariaDB Galera Bug [WSREP: BF lock wait long]")
Author : sukan
May 18, 2018
Major Galera bug which puts the entire cluster down
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