Maaz Zindani

Loading the index…

↑↓ move↵ openesc close4072 pages

Freelance · MariaDB, MySQL

MySQL and MariaDB consultant for databases behind live products

I am one senior engineer who designs, migrates and troubleshoots MySQL and MariaDB databases behind live products. TaxiDex runs on MariaDB with a 1,000-route API, and the QistLock back end runs on MySQL. I work remotely on the schema, the queries and the server underneath.

Who hires a freelance MariaDB, MySQL engineer?

  • Teams whose app slowed down as the tables grew and nobody has read the queries since.
  • Founders who inherited a MySQL or MariaDB database with no migrations history and a fear of touching the schema.
  • Product teams that need a second pair of senior eyes before a risky schema change goes to production.

What do I do with MariaDB, MySQL?

  • Schema designTables, keys and constraints modelled around the business rules of the product, as I did for the TaxiDex multi-tenant dispatch data.
  • Migrations run by hand and checkedSchema changes are applied and verified on the live database before the code that depends on them is released.
  • Working through an ORMLucid ORM on MariaDB in TaxiDex and TypeORM on MySQL in QistLock, so I can read what the ORM actually sends to the database.
  • Server-side troubleshootingConnection errors, start-up failures and lock problems on the database server itself, found from the logs before anything is changed.
  • Backups before changesA backup is taken before every production change to the data, and the change has a tested way back.
  • One database among many partsI also build the API and run the Linux server, so a database problem is traced across all of them instead of passed between three people.

Which MariaDB, MySQL problems am I usually called in for?

  • Requests hang, then fail with a lock wait timeout

    A long transaction holds rows that other requests need. I find the transaction that is holding the lock before changing any timeout.

    The step-by-step fix
  • A foreign key will not add during a migration

    Column types, collations or engines differ between the two tables, and the error message does not say which.

    The step-by-step fix
  • A query that worked on the old server now fails on GROUP BY

    The server is stricter about grouped columns than the one the query was written on.

    The step-by-step fix
  • MariaDB takes too long to start or will not start

    Recovery after a crash, a file limit or a bad setting can all end in a start timeout. The log says which.

    The step-by-step fix
  • Connections drop in the middle of a long query

    Packet size, timeouts and a proxy in between all produce the same lost-connection message.

    The step-by-step fix
  • Text comparisons fail on mixed collations

    Two tables created at different times use different collations, and joins between them stop working.

    The step-by-step fix

How does working with me on MariaDB, MySQL work?

  1. Send the slow query or the errorThe query, the table sizes if you know them and the error text. I reply within 24 hours.
  2. A call about the dataA call within 48 hours on how the app reads and writes, and what must never be lost.
  3. Written plan for every schema changeThe scope lists each change, the order and how it is checked, in writing.
  4. Sprints with copies firstTwo-week sprints, kickoff typically inside two weeks, and each change is tried on a copy of the data first.
  5. A tested way backProduction gets a backup before any change and a rollback I have tested, and I check the live system afterwards.

What do people ask about MariaDB, MySQL work?

Do you work on MySQL and MariaDB both?

Yes. TaxiDex runs on MariaDB and QistLock on MySQL, and I treat the differences between them as part of the job.

Can you look at a slow database without rewriting the app?

Yes. I start by reading what the app sends to the database and where the time goes, and I fix the worst cases first.

Will you change my production schema directly?

Only after a backup, with a written plan and a tested rollback, and I check the live system when it is done.

Do you also write the application code?

Yes, I build APIs on top of these databases, so I can fix the cause in the code as well as in the database.

What do you do about a lock wait timeout?

I find the session that holds the lock rather than raise the timeout. I wrote a fix page on error 1205 that follows the same order.

Proof

Products I built with MariaDB, MySQL

All projects

Own product · Taxi dispatch SaaS

TaxiDex

My own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.

TypeScriptNode.jsAdonisJSNext.js

Live SaaS · Android systems

QistLock

A NestJS and React SaaS driving an Android Device Owner agent that locks financed phones when payments lapse.

NestJSTypeScriptTypeORMMySQL

Next step

Need a senior MariaDB, MySQL engineer?

A discovery call within 48 hours, and a kickoff typically inside two weeks.