|Previous 30 Newer Entries||Showing entries 31 to 52|
I have been talking with a group of folks who have been making a product that has lots of free functionality, including the ability to centrally manage many MySQL instances. The administration functions include starting and stopping MySQL, seeing status and system variables, seeing and managing the MySQL config file (/etc/my.cnf), seeing and managing accounts, a small dashboard of overall health graphs, and more.
With this free tool you can look at and manage local and remote databases. It supports ssh tunneling, including ssh using password-protected ssh keys. It’s pretty neat, and I have been working with the product manager to add features. I think this took will become the de facto standard for centralized GUI administration of MySQL.
The tool is
MySQL workbench….Surprise! One of the best new features for the
MySQL Workbench 5.2.16 is a beta release, which comes with upgraded query browser, upgraded system administrator and addition features of workbench as a all in one bundle.
I was using workbench 5.0 earlier and the changes in 5.2.16 is very much visible. Best thing I could utilize is printing the ER diagrams to pdf files and other file formats. It’s now lot more easier to use and seems like many bugs have been addressed.
The 5.2.16 beta release is enabled to store passwords in OSX-keychain, gnome-keyring or on windows in a encrypted password-vault-file
New wizard added and reworked the “new server instance”.
Features like SQL templates from object context-menu to copy statements to clipboard or right into the query area
Administration module stabilization has been improved
Added option to change the placement of the sidebar in query mode
I already mentioned this repository several times on my blog. It is the repository where I’m trying to keep bleeding edge stuff for MySQL. I’ve been updating it recently and we’ve got new package there and some interesting updates I want to mention.
First thing to mention is that this repository contains MariaDB builds. MariaDB is fork of MySQL and their goals are certainly interesting. For list of differences, try upstream page. As I consider it interesting, I’m keeping eye on it Maybe our users may benefit from it.[Read more...]
It’s been some time already since I informed you about server: database: UNSTABLE repository in openSUSE Build Service. Today I want to mention what is going on there. As the name of the repository suggests, it’s probably not the best idea to use anything from here on your production servers
I’m keeping there MySQL 5.4. Currently in version 5.4.3 beta. 5.4 branch of MySQL contains some patches to improve performance. That is the reason why it might be interesting. Downside is that it isn’t released as often as 5.1 and it is not considered production ready. I already[Read more...]
I’ve been using the MySQL Workbench 5.1 beta for the past few days now, and I’m wondering how I designed databases without it.
Okay, so that’s a pretty strong statement, but I’m genuinely happy with it. 5.1 has fixed my main problem with 5.0, in that the EER diagram mode was horribly slow to render, now it’s all nice and smooth. The ability to easily visualise tables and their relationships makes design very simple.
In fact, I really only have one (minor) complaint, the ability to export without foreign keys would be nice. Sometimes you just don’t want to deal with the performance hit.
That’s about it. Go and download the OSS edition for free now, have a play around. Make it your Friday afternoon experiment. I promise you’ll like it.
In this post I will present the process for creating the MySQL database used in the VoiceHotel project, using the MySQL Workbench Community Edition, focusing on the features offered by this tool. The VoiceHotel project was the Grand Prize Winner of the Sun Students Contest in 2008, MySQL and GlassFish step.
update 1: english readers can view here the translated version of this post.
Neste post apresentarei o processo para criação da base de dados MySQL utilizada no projeto VoiceHotel, utilizando o MySQL Workbench Community Edition, focando nas funcionalidades oferecidas por esta ferramenta. O projeto VoiceHotel foi vencedor do[Read more...]
Visual database design is very essential. Almost every web application needs database. And by designing visual representation, relation of tables makes an developer easy to understand on the database. There are many tools to design database like DBDesigner, SQLYog. Recently I found another application that is called MySQL Workbench. It can be used to efficiently design, manage and document database schemata. After using it’s functionality, I found this is a really good tool for design database specially for MySQL.
It is available as both, open source and commercial editions. The Community (OSS) Edition is available from this page under the free software/opensource GNU General Public License (commonly known as the “GPL”) (http://www.mysql.com/company/legal/licensing/opensource-license.html)
So, you want to compile Workbench for Linux, on Fedora 9. You need to install the following packages:
autoconf automake libtool libzip-devel libxml2-devel libsigc++20-devel libglade2-devel gtkmm24-devel mesa-libGLU-devel mysql-libs mysql mysql-devel uuid-devel lua-devel glitz-devel glitz-glx-devel pixman-devel pcre-devel libgnome-devel gtk+-devel pango-devel cairo
I feel I’m being too liberal with dependencies, but I’m not about to strip it, I just want to get it working first :)
You need to have ctemplate and ctemplate-devel installed from updates-testing-newkey (relevant koji build log).
By default, configure.in in Workbench looks for “google-ctemplate”, as opposed to just “ctemplate” as[Read more...]
I had the pleasure of sitting right across the MySQL GUI Tools Team, and decided to try my hand at Workbench (Workbench for Linux, that is). Congratulations to the entire team for the great work! I am excited.
First up, the things you need on Ubuntu 8.04 (I created a fresh install, and installed all the updates), if you’re downloading the binary:
It works. It starts up. Its exciting. Of course, when I try to edit a table name or even create a table, it fails by[Read more...]
Allow me to provide some relaxed photographic observations from this morning’s MySQL UC keynotes.
Warning 1: My view is distorted, by my favourite lens, Sigma 8mm.
Warning 2: I took the pics with a shaky hand in low light, so they’re not sharp ones, of the James Duncan Davidson type (the guy who takes all the great pics for O’Reilly).
On Johnny Good’s command, doors open, and the audience starts pouring in.
Zack Urlocker has challenged me in the James Callis Lookalike Contest (of Battlestar Galactica fame), but is himself clearly in the lead.
Journalist James Niccolai of IDG, taking a picture of Rich[Read more...]
MySQL Workbench, the successor to DBDesigner 4 from FabForce, is a visual database design tool that integrates database design, modeling, creation and maintenance into a single, seamless environment for the MySQL database system. You can use it to design and create new database schemas, document existing databases and even perform complex migrations to MySQL.
It’s now a good week ago since our first Release Candidate numbered 5.0.15, and if you haven’t checked it out yet, now is a good time!
With 130 entries in the “MySQL” category and no MySQL-related subcategories, my blog had become impossible to search and navigate easily.
And thus I created a number of new categories for the MySQL entries within my blog. They’re listed in the left navigation bar, below the months, as well as below:[Read more...]
A week ago, Mike Zinner and his team released the beta version of MySQL Workbench on http://dev.mysql.com/workbench/. MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.
There are two different editions of MySQL Workbench at this point in time - an open source edition and a standard edition that is only available for paying customers.
This means that MySQL Workbench introduces a new concept for MySQL. Until now, MySQL products have either been open source or only available through a commercial subscription (such as MySQL Enterprise Monitor[Read more...]
|Previous 30 Newer Entries||Showing entries 31 to 52|