d

Database Server: The Complete Documentation

• This category contains 8 Papers
• The last paper was added on 2007-03-26 (YYYY-MM-DD)

GIS and Spatial Extensions with MySQL

Published on 2004, by Anders Karlsson, ©MySQL AB..

MySQL 4.1 introduces spatial functionality in MySQL. This article describes some of the uses of spatial extensions in a relational database, how it can be implemented in a relational database, what features are present in MySQL and some simple examples. Often the spatial functions are called geographic information system (GIS) functions, because GIS applications are the most obvious use-case for the spatial functionality. The spatial functions can be used both to provide a means to organize GIS data together with more traditional types of data and to represent non-GIS data with a spatial attribute.

How To Set Up Database Replication In MySQL

Published on 2006-01-14, by Falko Timme, ©Falko Timme.

This tutorial describes how to set up database replication in MySQL™. MySQL™ replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

MySQL Performance Tuning

Published on 2001, by Jeremy D. Zawodny, ©Linux Magazine.

With tools like Apache, Perl, PHP, and Python, building great MySQL applications is easy. Making sure that they are fast, however, requires quite a bit more insight. Here's what you need to know.

MySQL Reference Manual

Published on August, 31 2000, by Tilmann Scherzer, ©Tilmann Scherzer.

MySQL is a true multi-user, multi-threaded SQL database server. SQL (Structured Query Language) is the most popular and standardized database language in the world. MySQL is a client/server implementation that consists of a server daemon mysqld and many different client programs and libraries. SQL is a standardized language that makes it easy to store, update and access information. For example, you can use SQL to retrieve product information and store customer information for a web site. MySQL is also fast and flexible enough to allow you to store logs and pictures in it. The main goals of MySQL are speed, robustness and ease of use. MySQL was originally developed because we needed a SQL server that could handle very large databases an order of magnitude faster than what any database vendor could offer to us on inexpensive hardware. We have now been using MySQL since 1996 in an environment with more than 40 databases containing 10,000 tables, of which more than 500 have more than 7 million rows. This is about 100 gigabytes of mission-critical data. The base upon which MySQL is built is a set of routines that have been used in a highly demanding production environment for many years. Although MySQL is still under development, it already offers a rich and highly useful function set. The official way to pronounce MySQL is "My Ess Que Ell" (Not MY-SEQUEL).

MySQL Wizardry

Published on 2001-06-05, by Giuseppe Maxia, ©MySQL AB.

Cross tabulations are statistical reports where you de-normalize your data and show results grouped by one field, having one column for each distinct value of a second field.

PostgreSQL vs. MySQL

Published on 2001, by Brian Jepson, ©CMP Media LLC.

To many people, PostgreSQL and MySQL seem like similar, alternative databases. Both are quickly gaining popularity. Based on the track records of older versions, there's a lot of debate over the speed of PostgreSQL and the durability of MySQL. But times have changed and each database has progressed. On both counts, the two packages are the closest they've ever been, so when deciding which to use in a Web application, a developer doesn't always have a clear winner.

Protecting MySQL Sessions With SSH Tunnel (Port Forwarding)

Published on 2004, by kenlin, ©Jupitermedia Corporation.

SSH stands for Secure SHell and is typically used as an encrypted version of telnet. In a telnet session, all communications are transmitted in plain-text, allowing anyone to listen-in on your session and steal passwords and other information. Such sessions are also susceptible to session hijacking, where a malicious user takes over your session once you have authenticated.

The Era of Open Source: Migrate your Data from MS SQL to MySQL

Published on 2004-09-09, by Allen, ©Jupitermedia Corporation.

One of the very common questions appearing on various developer forums is that of comparing the pros and cons of MySQL and MS SQL. While comparisons have been made by many, mostly on technical issues, I personally find that they are difficult to compare, especially regarding their performance.