Category: Databases

Distributed Database Systems

In today’s web-enabled world, the use of Database Management Systems (DBMS) is extremely common and becoming even more necessary as each day passes. In most cases, the choice is your typical RDBMS such as MySQL, PostreSQL, SQLite or SQL Server. Some larger, enterprise-level systems choose larger solutions such as Oracle.

As a company grows, it becomes a much bigger pain and seemingly less logical to maintain data relationally. It requires more and bigger hardware, labor, decreased performance and becomes difficult to maintain and scale out. This can partly be blamed for the nature of relational systems.

Read More ...
 

Optimizing Your MySQL Compilation

System administrators constantly worry about optimization with code compilation. This is no different for MySQL. Most systems are fine with the binaries distributed by their flavor of Linux or directly from Oracle. But there are many who need to maximize their hardware usage by pushing their software. I intend to show how to tweak your MySQL compilation to achieve these results.

Read More ...
 

Navicat MySQL: A Tool for Developers and DBAs

Navicat MySQL is a tool produced by PremiumSoft CyberTech Ltd that allows both developers and DBAs to access, design, manipulate, report and manage data and the MySQL server. Although it’s not free, it is certainly worth taking the time to play around with. Navicate MySQL is certainly the tool of choice for my DBA needs. [...]

Read More ...
 

Using the mysqldump tool

This tutorial will cover using the mysqldump executable for backing up databases. If you are an average user of MySQL, and are not interested in administering a MySQL server, then this tutorial might be useless to you. The mysqldump tool is a backup program that is distributed with every MySQL download. If you aren’t familiar [...]

Read More ...