SQL Generator for testing SQL servers (MySQL, JavaDB, PostgreSQL)

Registered 2008-10-23 by Philip Stoev

This project implements a pseudo-random data and query generator that can be used to test any Perl DBI, JDBC or ODBC-compatible SQL server, in particular MySQL, but also JavaDB and PostgreSQL.

The Random Query Generator is a new tool for generating complete databases and executing queries against them for the purpose of functional and stress testing.

The tool is capable of executing test scenarios that include:
* Generate a database from a description of the desired data contents and properties;
* Execute random queries based on SQL templates the queries must conform to;
* Compare the results returned by different server versions, configurations, or storage engines;
* Monitor the server during the test and detect deadlocks, crashes, replication failures and other interesting events;

The tool is useful for the following audiences:
* Storage engine implementors can use the tool to test their code and the way it interacts with features of the core server (such as partitioning and replication);
* Individual users who are eager to break the server will have a powerful weapon in their hands.
* Implementors who wish to evaluate MySQL stability and performance can generate syntetic data and workloads that match the application they are planning to deploy;

 Copyright © 2008, 2013, Oracle and/or its affiliates. All rights reserved.

Project information

Part of:
MySQL
Maintainer:
Random Query Generator Team
Driver:
Random Query Generator Team
Development focus:

2.0 series 

lp:randgen 
Browse the code

Programming Languages:
Perl
Licences:
GNU GPL v2
(Copyright © 2008 Sun Microsystems, Inc. All rights reserved. Use is subject to license terms.)

RDF metadata

View full history Series and milestones

Random Query Generator 2.0 series is the current focus of development

Get Involved

Downloads

Latest version is 2.2.0
released on 2010-02-09

All downloads