Guide to deploying a highly-available MariaDB Galera cluster using Docker on CoreOS for self-managed MySQL-compatible databases.
Explains how to configure MySQL strict mode and custom SQL modes in Laravel 5.2, enabling or disabling it via database configuration.
Guide to disabling MySQL strict mode on Laravel Forge/Ubuntu servers to fix application compatibility issues.
A technical guide on recovering a MySQL InnoDB database after a catastrophic DROP TABLES command, using tools from Twindb.
Introduction to Drupal performance tuning, focusing on database optimization, query analysis, and monitoring tools for better web application speed.
A guide on setting up and connecting a Laravel application to a MySQL database using the ClearDB add-on on the Heroku platform.
Explains why MySQL's -p password parameter cannot have a space, detailing the command-line parsing logic behind this design choice.
An overview of daloRADIUS, an advanced open-source RADIUS web management platform for hotspots and ISPs, featuring user management and reporting.
A tutorial on setting up and securing a new Ubuntu server on Linode, covering initial provisioning, SSH connection, and essential software installation.
A technical tutorial explaining how to use AJAX with jQuery to query a MySQL database and display the results in a tooltip on a webpage.
Explains why MySQL's 'utf8' charset is incomplete and how to use 'utf8mb4' for full Unicode support, including emojis.
How rewriting a MySQL query to use indexes properly improved performance from 10 seconds to 0.03 seconds.
A tutorial on building a Java EE 6 web application with MySQL, JPA 2.0, and Servlet 3.0 using the GlassFish Tools Bundle for Eclipse.
A developer compares MySQL and MS SQL Server, listing syntax and usability advantages of MySQL based on personal experience.
Announcing a new database backup feature for daloRADIUS, focusing on portable INSERT-based backups for compatibility across database types.
A technical guide showing how to get the UNIX timestamp for New Year's Day in MySQL, Excel, and Visual BASIC.
A practical guide to setting up MySQL replication, covering master-slave configuration, log files, and initial data synchronization.
