驯服烂代码_驯服MySQL管理

驯服烂代码

Taming the management of your MySQL Server may have just become a little easier with the most recent release of Navicat.

使用最新版本的Navicat来驯服MySQL Server的管理可能会变得容易一些。

This GUI administration tool for MySQL servers has some advantages for the developer — for starters it runs on Linux, Macintosh and Windows with fair consistency (as far as equivalent feature sets go). A feature matrix is available online.

这种用于MySQL服务器的GUI管理工具对开发人员具有一些优势-对于初学者，它可以在Linux，Macintosh和Windows上以相当的一致性(就等效的功能集而言)运行。 在线提供功能矩阵。

(to see the screen shots included with this post please see the Open Sourcery blog at https://www.sitepoint.com/blog-post-view.php?id=200601)

(要查看此帖子中包含的屏幕截图，请访问Open Sourcery博客， 网址为https://www.sitepoint.com/blog-post-view.php?id=200601 )

Several existing and new features will appeal to power users, including:

若干现有功能和新功能将吸引高级用户，其中包括：

• Import from ODBC source (Windows only)
  从ODBC源导入(仅Windows)
• Stored Procedure design for MySQL 5 (all versions)
  MySQL 5(所有版本)的存储过程设计
• Batch Job and Scheduling (all versions)
  批处理作业和计划(所有版本)
• Data Transfer from MySQL to MySQL or to a file (all versions)
  从MySQL到MySQL或文件(所有版本)的数据传输
• Manage indexes and foreign key configuration
  管理索引和外键配置
• User privileges management
  用户权限管理

I kicked around Navicat on both Mac OS 10.3.5 and Windows XP Pro using both development and production database servers and found it easy to use in function and interface. Some of the areas of interest are below.

我同时使用开发和生产数据库服务器在Mac OS 10.3.5和Windows XP Pro上使用Navicat，发现它在功能和界面上易于使用。 一些有趣的领域如下。

The main view of Navicat, as shown below, is a clean workspace with support for multiple sql server connections.

Navicat的主视图如下所示，它是一个干净的工作区，支持多个sql服务器连接。

Interaction with connections and tables can be done via double clicks and right click contextual menus.

可以通过双击和右键单击上下文菜单来完成与连接和表的交互。

To get started with testing, I moved some data from a production server to a development system via Navicat’s data transfer, which could surely become an invaluable tool for various purposes.

为了开始测试，我通过Navicat的数据传输将一些数据从生产服务器移至开发系统，这无疑可以成为用于各种目的的宝贵工具。

I then did some querying both through the programs visual query builder —

然后，我通过程序的可视查询生成器进行了一些查询-

— and some simple sql tests via the raw sql pad also available.

—并且还提供了一些通过原始sql pad进行的简单sql测试。

Finally, one can see the results on demand within the program.

最后，可以在程序中按需查看结果。

The included Export Wizard allows for export to delimited, XML and Dbase file formats on Mac OS X and up to 18 formats on Windows. Unfortunately the Linux version does not currently support exports from query results.

随附的导出向导允许在Mac OS X上导出为带分隔符的XML和Dbase文件格式，在Windows上最多导出18种格式。 不幸的是，Linux版本当前不支持从查询结果中导出。

As with any database administrator’s routine, monitoring the performance of your databases is essential. The Server Monitor within Navicat allows for one or more active MySQL connections to run a “show processlist;” within the GUI. Tools include a static capture of running processes or an active refresh for ongoing tracking.

与任何数据库管理员的例行程序一样，监视数据库的性能至关重要。 Navicat中的服务器监视器允许一个或多个活动MySQL连接运行“显示进程列表”； 在GUI中。 工具包括对正在运行的进程进行静态捕获或对正在进行的跟踪进行主动刷新。

Additionally, with a click one can see the results of the “show status;” and “show variables;” mysql commands.

此外，只需单击一下，即可看到“显示状态”的结果； 和“显示变量”； mysql命令。

The ability to kill processes is available within Server Monitor.

服务器监视器提供了杀死进程的功能。

Finally, a feature I like personally for use during development, Navicat’s Backup/Restore allows for hot backups and restoration of MySQL database/tables.

最后，我个人喜欢在开发过程中使用的一项功能，Navicat的备份/还原功能允许对MySQL数据库/表进行热备份和还原。

For smaller MySQL deployments this will also work as a production backup routine. However, in my case I leave production backup running via an automation script (not Navicat) on my various servers, dumping all backups to a separate consolidated backup server.

对于较小MySQL部署，这也可以作为生产备份例程。 但是，就我而言，我将通过自动化脚本(不是Navicat)在各个服务器上运行生产备份，将所有备份转储到单独的统一备份服务器上。

Navicat ranges in price from $45 US to $125 depending upon your licensing needs and can be purchased online from the company’s store.

Navicat的价格从$ 45美元到$ 125美元不等，具体取决于您的许可需求，可以从公司的商店在线购买。

Product inquiries can be directed to sales at navicat.com

产品查询可以直接通过navicat.com进行销售。

翻译自: https://www.sitepoint.com/taming-mysql-administration/

驯服烂代码