LinuxQuestions.org
Register a domain and help support LQ
Go Back   LinuxQuestions.org > Articles > Jeremy's Magazine Articles
User Name
Password

Notices

By jeremy at 2007-02-05 17:15
Point-and-Click MySQL Administration
Written by Jeremy Garcia
Linux Magazine

While the MySQL database is extremely powerful, one common compliant - one loudly voiced by database administrators of other database products - is that MySQL administration is performed exclusively from the command-line. But to the contrary, MySQL does have a graphical user interface tool that's supported by MySQL AB.

MySQL Administrator, available under the same dual-license as MySQL itself, is a powerful, visual administration console that provides significantly better visibility into how your databases are operating. It allows you to visually accomplish almost any task you can accomplish from the command-line.

One nice thing about MySQL Administrator is that it integrates database management and maintenance into a single application. You can configure servers, administer users, dynamically monitor database health, monitor replication status, perform backups and restores, and view logs.

You can download MySQL Administrator from http://dev.mysql.com/downloads/administrator.html. It's available in both binary and source format.

Once the application is installed, start it by running:

Code:
$ mysql-administrator
After you start MySQL Administrator, answer the prompts in the connection dialog box. If you need full access to a database, be sure to enter a set of credentials that have the proper privileges. After providing your credentials, hit OK to connect.

MySQL Administrator starts out with the Server Information pane selected. Server Information presents statistics about the MySQL server you’re connected to and the machine the database is running on, among other metrics.

Here’s a list of the other available panes:

* Service Control starts and stops the MySQL server.

* Startup Variables configure the startup variables for the MySQL server. If you have sufficient access rights, you can see and modify all /etc/my.cnf options. This pane is also a convenient way to easily see what parameters are available.

* Server Connections views or kills current connections to the MySQL server (a resource also called threads).

* User Administration manages existing users, adds new users, and deletes existing users. Depending on the version of your MySQL server, this pane also supports advanced MySQL permissions such as Resource Limits and Schema Privileges.

* Health (shown in the figure) presents graphical displays of a number of usage or hit-rate values that affect server performance, and a hierarchical view of system and status variables.

Other panes include Server Logs, Backup, Restore, Replication Status, and Catalogs. The latter pane displays information about databases, tables, columns, indexes, and rows; optimize tables.

Beyond point-and-click convenience, MySQL Administrator stands out because it provides a simple way to manage users and the advanced privileges available in newer versions of MySQL.

Moreover, the Health pane is invaluable. The ability to see real-time status variables and receive expert advice is invaluable, especially if you’re not a MySQL expert. Watching the Health monitor can help you tune your MySQL server, while the real-time charting of connection and memory health will help you keep a close eye on how your changes impact real world performance. The ability to see all server variables, along with a quick and accurate description of each one, is also handy. Finally, the Backup features allow you to schedule regular backups, which may really come in handy in a pinch.

MySQL Administrator is a fantastic, officially-supported tool. Whether you’re a MySQL newbie or a seasoned MySQL DBA, the tool has something to offer you.

Did you know that MySQL also has a visual tool for creating, executing, and optimizing SQL queries? Let’s cover that next month.


by jason_dustrose on Tue, 2007-02-06 03:25
It looks cool enough to try out, however I have found that most of these fancy looking (supposedly "super-tools") that I run accross never work the way they should, until you've configured it ten times on five different machines, with a hundred different distros to see what combo works best. Things like Fedora-DS and smb4k among others, just haven't quite done it for me.

I have found just getting in there, typing a few extra commands here and there usually pays off in time. Plus, it's kind of cool to scroll up the terminal window to see how far you've come, and I usually end up more productive anyway.


  



All times are GMT -5. The time now is 03:08 PM.

Main Menu

My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration