Transcript

Benefits of Third-Party Tools for MySQL

A feature-rich tool for MySQL can help DBAs manage their databases more efficiently by streamlining many of the daily tasks that drain their productivity.

The following list shows some of the most important ways that third-party software can make MySQL DBAs more productive.

1. automate synchronization
• synchronize MySQL Servers manually for maximum control
• automate synchronization to ensure data consistency
• use job agent to schedule automatic data synchronization
• use interactive wizards to define jobs without knowledge of XML and schemas

2. streamline scheduled backups
• back up databases automatically
• use interactive wizards to schedule and fine-tune backups
• export databases as SQL scripts for schema and data

3. manage users
• display selected objects and privileges that are available for each object
• select specific privileges for users
• avoid incorrectly assigning elevated privileges
• prevent definition of redundant privileges

4. profile queries
• display information on executed queries
• display query performance and index use
• display actually executed query
• display internal operations, changes in status, and warnings

5. import external data
• transfer data from any ODBC-compliant data source to MySQL
• import incrementally
• schedule import sessions
• use interactive wizards to define import job parameters

6. schedule queries
• generate emails with query results
• run schedule maintenance queries outside of normal work hours
• use interactive wizards to validate queries before scheduling

7. minimize dependencies
• use compact, efficient executables
• avoid runtimes like Java and .NET
• avoid database abstraction layers like JDBC and ODBC
• avoid third-party libraries like MFC and STL

8. additional features
• design, optimize, and document schema
• create, drop, and alter tables
• diagnose tables that perform poorly
• graphically manage tables, relationships, indexes, and columns
• create secure connections to database servers via tunneling and SSL