Sukan

ProxySQL is one of the advanced software load balancer that we have in market. ProxySQL has an in-built abilty to identify the reads,writes and route the write traffic to master and read traffic between the available slaves. One occurence of a Replication delay or server crash or replication breakag

Query Caching - Query Routing - Mirroring - Query Rewrite - Data Masking

Major Galera bug which puts the entire cluster down

Comparison of MySQL, Columnstore, Clickhouse with respect to time series queries.

How real time data from transactional database(mariadb) to analytic database(columnstore) is achieved using MariaDB's maxscale binlog streaming

Dealing with deadlocks, certification failures on Galera cluster by running single node writer using ProxySQL

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.

Importance of audit log in MySQL, MariaDB and ProxySQL. Best practices to enable audit log

How Generated Invisible Primary Keys (GIPK) Can Boost Your Database Efficiency

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.

Blog post on how TiDB handles the OLAP requests without compromising OLTP

Dive into our blog post to uncover signs that hint it's time to move on from MySQL and find out how TiDB steps up as the ideal solution

Analytics with TiDB's Row-Wise Filtering. Discover how our client slashed costs and boosted flexibility with TiDB's granular data management features. Dive into the future of database optimization with Mafiree

Discover how effective data archival can slash your infrastructure costs by 50%! Learn how we helped one client streamline their database management and improve performance.

Unlock the full potential of ClickHouse with these must-know functions. From data transformation to advanced analytics, elevate your database skills today!

A client came to us with a classic AWS database storage optimization problem: 15.2 TB allocated, less than a third actually in use — and a bill that kept growing regardless. Within one week, Mafiree had reclaimed 3.6 TB, validated a safe path to cut allocation nearly in half, and executed a zero-downtime migration. Here's the full story.