GitHub

MySQL Config Suggester (Ruby)

An interactive Ruby script designed to assist in optimizing MySQL (my.cnf) configurations based on server characteristics and database usage patterns. This script gathers system information (RAM, CPU, ...
GIGAZINE

無料で「実践ハイパフォーマンスMySQL 第3版」第8章が全文公開中

「O'Reilly Japan - 実践ハイパフォーマンスMySQL 第2版」の次のバージョンと言うべき「実践ハイパフォーマンスMySQL 第3版」の「Chapter 8, Optimizing Server Settings.(第8章：サーバー設定の最適化)」の原文が全文無料公開中です。 図もちゃんとあり、具体的な項目が多い ...
InfoWorld

MySQL tutorial: Get started with MySQL 8

How to install and configure the latest edition of the popular open source database, plus tips for migrating from MySQL 7 MySQL remains one of the most common and consistent elements in the modern ...
GitHub

Ansible Automated Database Setup

This Ansible playbook is designed to automate the deployment and configuration of database management systems on an Ubuntu VPS with minimal human intervention. It allows for the automatic installation ...
TheServerSide

Comparing MySQL and Postgres 9.0 Replication

Replication is one of the most popular features used in RDBMS’s today. Replication is used for disaster recovery purposes (i.e. backup or warm stand-by servers), reporting systems where query activity ...