Own product · Taxi dispatch SaaS
TaxiDex
My own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.
Freelance · MariaDB, MySQL
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.
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 fixColumn types, collations or engines differ between the two tables, and the error message does not say which.
The step-by-step fixThe server is stricter about grouped columns than the one the query was written on.
The step-by-step fixRecovery 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 fixPacket size, timeouts and a proxy in between all produce the same lost-connection message.
The step-by-step fixTwo tables created at different times use different collations, and joins between them stop working.
The step-by-step fixYes. TaxiDex runs on MariaDB and QistLock on MySQL, and I treat the differences between them as part of the job.
Yes. I start by reading what the app sends to the database and where the time goes, and I fix the worst cases first.
Only after a backup, with a written plan and a tested rollback, and I check the live system when it is done.
Yes, I build APIs on top of these databases, so I can fix the cause in the code as well as in the database.
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
Own product · Taxi dispatch SaaS
My own multi-tenant taxi dispatch SaaS: API, dispatcher portal, driver and passenger apps, and the servers underneath.
Live SaaS · Android systems
A NestJS and React SaaS driving an Android Device Owner agent that locks financed phones when payments lapse.
From the fix library
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)Locked out of a fresh MariaDB install as root on Mac or LinuxERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (10061)The client cannot open a TCP connection to MariaDB or MySQL (error 2003)[Warning] Can't create test file /home/mysql/beta.lower-testMariaDB will not start after a move: Can't create test file ... lower-test[Warning] Could not increase number of max_open_files to more than 4096 (request: 4214)MariaDB warns that it could not raise max_open_files to the value it wants[ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.MariaDB will not start: Plugin 'InnoDB' registration as a STORAGE ENGINE failedFailed to start MariaDB 11.4 database server.Job for mariadb.service failed: how to find the real reasonMonth by month
Next step
A discovery call within 48 hours, and a kickoff typically inside two weeks.