mysql

MySQL

Technology:

Database Maintenance

Nightly script to purge the dspam database of old information.

Performance Tuning

  • Edit /etc/my.cnf and add a query_cache:

Technology:

Replication Monitoring

Various tools and tests for monitoring the status of masters and slaves.

Technology:

MySQL Sandbox

MySQL Sandbox is a tool that installs one or more MySQL servers within seconds, easily, securely, and with full control. Once installed, the sandbox is easily used and maintained, without using complex options. Replicated and multiple sandboxes can be used individually or all at once.

Installation
The easiest way to install MySQL Sandbox is to use CPAN:

perl -MCPAN -e shell
install MySQL::Sandbox
exit

MySQL Sandbox is meant to be run as a non-root user, so create one and switch to it:

adduser mysandbox
su mysandbox
cd ~

Download a binary tarball of MySQL. Latest version, at time of writing, was 5.1.41:

cd /extra/src
wget http://dev.mysql.com/get/Downloads/MySQL-5.1/mysql-5.1.41-linux-i686-glibc23.tar.gz/from/http://mirror.csclub.uwaterloo.ca/mysql/

Technology:

Subscribe to RSS - mysql

Recent Updates

  • 2 years 2 days ago
  • 2 years 2 days ago
  • 2 years 5 days ago
    php 8.x
  • 2 years 6 days ago
    10.6.7
  • 2 years 1 week ago
    Drop Centos 5/6 stuff