Free mysql software for linux

MySQL Administrator is a powerful visual administration console that enables you to easily administer your MySQL environment and gain significantly better visibility into how your databases are operating.
MySQL Administrator now integrates database management and maintenance into a single, seamless environment, with a clear and intuitive graphical user interface.
By using MySQL Administrator you will be able to:
- Achieve higher database availability through improved management
- Reduce errors through visual database administration
- Lower database administration costs through improved productivity
- Deliver a more secure environment through easier privilege management
MySQL Administrator enables developers and DBAs to easily perform all the command line operations visually including configuring servers, administering users, and dynamically monitoring database health.
Other common administrative tasks such as monitoring replication status, backup and restore, and viewing logs can also be performed through the MySQL Administrator graphical console.
User Administration in Minutes
Administering users, granting privileges and viewing user privilege information has never been easier! Now you can leverage the full power of MySQLs user management and privilege capabilities to fully protect your MySQL server host using an integrated graphical user administration console.
For example, a form-based interface provides a simple method for adding users, assigning passwords and including user profile information. Plus, assigning and revoking global, database, and table/column privileges is as easy as adding and removing privilege items from an available list. Finally, an explorer interface provides a hierarchical view allowing you to easily view user privileges by privilege type.
Single View Dynamic Health Monitoring
Dynamic health monitoring gives you an immediate view into the key indicators of the health of your MySQL environment. Dynamic graphs enable you to easily view percentage of memory usage, connection usage, hit rates, as well as the number of SQL queries on an ongoing basis, as your system runs.
The Disk Health tab gives you an overview of the amount of hard disk space, tablespace, and log files being used. You can also use the visual health monitoring feature to get a hierarchical view into status and server variables such as the number of outstanding connections, number of bytes sent and received by clients, buffer allocations size and more.
Quickly Optimize MySQL
MySQL Administrator now allows you to easily view and setup key parameters so you can quickly optimize the performance of MySQL. Using a graphical forms-based environment, you quickly fine tune general and advanced parameters. For example you can set memory usage parameters and configure server start-up parameters related to the MyISAM and InnoDB table types.
Rapid Disaster Prevention and Recovery
Now you can rapidly create consistent backups and restore data by simply visually selecting the schemas and tables you want to back/restore from your hierarchical data directory. The graphical environment gives you additional visibility into Tabletype, Rows, Data Length, and Update time.
Server Information At-a-Glance
The server information section of MySQL Administrator allows you to quickly view basic information about the server and client. This view gives you immediate visibility into items such as server status, client and server version numbers and IP address, as well as connection information.
View Replication Status
Now you can quickly set up replication to increase the robustness and speed of your MySQL environment. The replication features within MySQL Administrator allow you to easily view the network topology of your replication master and slaves. Plus, the graphical environment provides additional visibility into IP addresses and logfiles.
View Server Logs from a Centralized Administration Environment
Now you can view all the MySQL log files including error logs, binary logs, and InnoDB logs from a single, centralized administration environment so you can diagnose server problems quicker and track database changes.
Service Control
Gain complete control of service creation and overcome the time consuming task of installing and setting up services. Plus, start and stop MySQL servers and view corresponding log messages.
Browse Catalog
Browse your catalog and view corresponding tables with columns, all indices and users with privileges to access selected databases. From here you can monitor and optimize tables.
Cross Platform
MySQL Administrator will initially be available for Microsoft Windows and Linux, and be compatible with MySQL version 4.0 or later.

MySQLfs is Linux userspace filesystem which stores data in a MySQL database. The project uses FUSE to interface with the kernel.

Zmanda Recovery Manager for MySQL simplifies life of a database administrator who needs an easy to use yet flexible and robust backup and recovery solution for MySQL server. With ZRM for MySQL you can:
- Schedule full and incremental logical or raw backups of your MySQL database
- Perform backup that is the best match for your storage engine and your MySQL configuration
- Get e-mail notification about status of your backups
- Monitor and browse your backups
- Recover database easily to any point in time or to any particular transaction

Remote MySQL Query is a PHP class that can easily execute queries on a remote MySQL server using only HTTP.

It works by accessing a PHP script on the remote web server that executes queries based on passed in URL parameters.

The client passes a secret key to the remote script to prevent unauthorized access.

The remote script passes back the results to the requesting client using XML to marshal the data.

The class parses the results XML data returned by the server script and returns an array.

It, also, retrieves (into class variables) the number of records returned by the query and the time the query took to execute.

The server script may be used to execute MySQL queries that can be retrieved by programs written in other languages besides PHP.

MaxDB is a heavy-duty, SAP-certified open source database for OLTP and OLAP usage which offers high reliability, availability, scalability and a very comprehensive feature set. MaxDB by MySQL is targetted for large mySAP Business Suite environments and other applications that require maximum enterprise-level database functionality and complements the MySQL database server.
Today, about 6,000 customer installations are using MaxDB technology globally, including Toyota, Intel, DaimlerChrysler, Braun-Gillette, Bayer, Colgate, Yamaha, and Deutsche Post (the German Post Office).
Main features:
- Reduced cost of your SAP implementation
- Easy configuration and low administration
- Elaborate backup and restore capabilities
- Continuous operation, no scheduled downtimes required
- Designed for large number of users and high workloads
- Scales to database sizes in the terabytes
- High availability through cluster and hot-standby support
- Synchronization Manager to control enterprise-wide data replication
- Easy-to-use graphical database tools
- Available for all enterprise HW/OS platforms
- Supports all major SAP solutions
High performance, availability, operational reliability, scalability, ease of use, and low total cost of ownership are just a few of the demands that enterprise environments place on a DBMS infrastructure. MaxDB helps you meet these demands. It is a powerful, state-of-the-art DBMS built for enterprise usage scenarios.
Some other features of MaxDB;
Description Maximum Value
Database size 32 TB (with 8 KB page size)
Number of files/volumes per database 64...4096, specified by a configuration parameter
File/volume size (data) 518 ...8 GB (dependent on operating system limitations)
File/volume size (log) 16 TB (dependent on operating system limitations)
SQL statement length >= 16 KB (Default value 64 KB, specified by a system variable)
Identifier length 32 characters
Numeric precision 38 places
Number of tables unlimited
Number of columns per table (with KEY) 1024
Number of columns per table (without KEY) 1023
Number of primary key columns per table 512
Number of columns in an index 16
Number of foreign key columns per table 16
Number of columns in an ORDER or a GROUP clause 128
Number of columns in a SELECT statement 1023
Number of columns in an INSERT statement 1024
Number of columns in a result table 1023
Number of join tables in a SELECT statement 64
Number of triggers per Basis table 3
Number of indexes per table 255
Number of referring CONSTRAINT definitions (foreign key dependencies) per table unlimited
Number of references per table unlimited
Number of rows per table limited by database size
Internal length of a table row 8088 Bytes
Total of internal lengths of all primary key columns 1024 Bytes
Total of internal lengths of all foreign key columns 1024 Bytes
Total of internal lengths of all columns belonging to an index 1024 Bytes
Internal length of a LONG column 2 GB
Length of columns in an ORDER or a GROUP clause 1020 Bytes
Nested trigger levels unlimited
Nested subqueries 127
Number of join conditions in a WHERE clause of a SELECT statement 128
Number of correlated columns in an SQL statement 64
Number of correlated tables in an SQL statement 16
Number of parameters in an SQL statement 2000
Enhancements:
- This maintenance release features some important bugfixes.

sqlupdate reads a MySQL table declaration file and compares it to an existing database. sqlupdate project then generates a MySQL script for updating the database to match the SQL file.