Profile banner
Nilnandan Joshi

Nilnandan Joshi

Senior MySQL/MariaDB database engineer and support specialist

nilnandan
Pune, India
Joined March 2026
Favicon imagein.linkedin.com
Favicon imagepercona.com
Favicon imageslideshare.net

Network

3K connections
🐘
Percona Database Experts
💻
General Database Administrators
🦋
MariaDB Engineering
🤝
MariaDB Support
📈
Percona Management
👑
MariaDB Leadership
🏛️
DB Sol Arch

Summary

Experienced MySQL/MariaDB support and database engineer who focuses on practical, operational solutions: backups, tablespace management, and InnoDB internals. percona+2
Active technical communicator: publishes detailed how‑tos and case studies and presents at meetups about debugging, core-file analysis, backup/restore, and replication/Galera workflows. percona+2
Hands-on troubleshooting experience across versions and platforms: diagnosing tablespace import errors between MySQL 5.6 and 5.7, and converting Galera/async replication topologies. percona+1
Community-facing support background with Percona and MariaDB: combines customer support experience with authored technical content and public presentations. percona+1

Work

Education

Projects

Writing

Convert Galera Node to Async Slave And Vice-versa With Galera Cluster

February 1, 2018

Step-by-step instructions for converting a Galera node into an asynchronous replica and converting an async replica back to a Galera node without shutting down servers.

Favicon imagemariadb.com

Transporting tablespace from MySQL 5.6 to MySQL 5.7 (case study)

December 1, 2015

Case study describing issues when importing tablespaces between MySQL 5.6 and 5.7, diagnostic steps, and a workaround related to row formats and innodb_file_format changes.

Favicon imagepercona.com

InnoDB locks and deadlocks with or without index for different isolation level

April 1, 2015

Detailed test cases demonstrating how SELECT ... FOR UPDATE, gap locks, and isolation levels (READ-COMMITTED vs REPEATABLE-READ) affect locking and deadlocks in InnoDB.

Favicon imagepercona.com

How to reclaim space in InnoDB when innodb_file_per_table is ON

September 1, 2013

Explains methods to reclaim space for InnoDB tables when innodb_file_per_table is enabled, including OPTIMIZE TABLE and pt-online-schema-change usage and caveats.

Favicon imagepercona.com

Want to archive tables? Use Percona Toolkit's pt-archiver

August 1, 2013

Guide to using pt-archiver for archiving rows from large tables, including options, replication considerations, and example commands.

Favicon imagepercona.com

Limited disk space? Compact backups with Percona Xtrabackup 2.1

June 1, 2013

Examines the compact backup option in Percona XtraBackup 2.1, trade-offs between backup size and prepare time, and practical test results.

Favicon imagepercona.com

Hobbies

Enjoys listening to Indian classical/semi-classical music, watching TV, and playing cricket and badminton. percona