(Ivan Cachicatari) The auto_increment for MySQL fields are very useful but what about if I need a custom auto-increment like a custom format like 001-000033,

(eduardo.lago.aguiar) This tutorial shows how to create a portable MySQL installation on GNU/Linux. It applies to:

(Robert Hodges) Slave prefetch is an increasingly popular technique for speeding up native MySQL replication, with several tools already published to enable it, such as mk-slave-prefetch and Replication Booster. Tungsten Replicator is now joining the fray. This article explains how our implementa

(Rob Gravelle) When it comes to protecting user passwords, MySQL offers a lot of options, from minimal to incredibly robust. Of course, password encryption is not a one-size-fits-all type solution. It all depends on your data and what priority you place on its safety. To that end, today’s article

(Ivan Cachicatari) From command line we have the entire MySQL server on hands (if we have privileges too of course) but we don’t have a overall overview, at this point the show table status command is every useful, or not?.

(Dathan Pattishall) A few years ago I wrote about Asynchronous Shard Queries verses Synchronous Shard Queries, and in this post I talked about having to write a server to handle this for me in Java. Now I do it in PHP and got great results that are posted below.

(Vadim Tkachenko) My previous post I finished with the graph with unstable results.

(Gavin Towey) Using a multi-insert to save rounds trips to the database can be a great time saver, but what if you want to also retrieve all the auto-increment values from those rows you just inserted?

(Miguel Angel Nieto) In my previous post I explained how it could be possible to recover, on some specific cases, a single table from a full backup in order to save time and make the recovery process more straightforward. Now the scenario is worse because we don’t have a backup or the backup restore

(Ivan Cachicatari) Those who have used PostgresSQL usually gets lazy when write the SQL code to auto-numeric fields, but we miss that feature when we are in a MySQL database.