Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 54

Displaying posts with tag: MySQL Workbench (reset)

MySQL Workbench 5.2 goes GA – partial support for MySQL Cluster
Employee +7 Vote Up -0Vote Down

Configure MySQL Server nodes for MySQL Cluster

The new version of MySQL Workbench (5.2.25) has just gone GA – see the Workbench BLOG for details.

So what’s the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes:

  • Start & stop the mysqld processes
  • Configure the per-mysqld configuration data held in my.cnf or my.ini

The reason that I describe the support as ‘partial’ is that these MySQL Servers are treated as independent entities (no concept of them being part

  [Read more...]
Breakfast seminar on what’s new with MySQL – London
Employee +2 Vote Up -0Vote Down

If you’re in London on Thursday 24th June then there’s a great chance to find out what’s new in MySQL.

Join us for an Oracle MySQL Breakfast Seminar to better understand Oracle’s MySQL strategy and what’s new with MySQL!
Agenda:
09:00 a.m.    Welcome Coffee/Tea
09:30 a.m.    Oracle’s MySQL Strategy
10:00 a.m.    What’s New – The MySQL Server & MySQL Cluster
10.45 a.m.    Coffee/Tea Break
11:00 a.m.    What’s New – MySQL Enterprise & MySQL Workbench
11:45 a.m.    Q&A
12:00 noon    End of the Breakfast Seminar

Cost?
None, it’s a free event! But places are









  [Read more...]
InfiniDB Alpha 1.1.2 on 64-bit Windows and MySQL Workbench
Employee +1 Vote Up -0Vote Down
This week has been rough on my computers and I had to reinstall Vista on my main Windows system. But being a 'glass half full' guy, I took it as an opportunity to load the new alphas for both InfiniDB and MySQl Workbench.

I downloaded the InfiniDB software from http://infinidb.org/downloads/cat_view/40-binary-release/137-112-alpha-binary-releases and Workbench from http://dev.mysql.com/downloads/workbench/ respectively. In stalled them in that order and started the database and then Workbench.

I was expecting to have to fiddle with configuring one or the other to get them to work together. But I received a delightful surprise. Both worked out of the chute with no customization. Congratulations to the folks writing the install scripts at both companies!
A Useful Tool to Centrally Manage Many MySQL Instances
+7 Vote Up -2Vote Down

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

  [Read more...]
MySQL Workbench 5.2.16 Beta
+1 Vote Up -0Vote Down

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



  [Read more...]
Updates in unstable repo (not only) for openSUSE
+0 Vote Up -0Vote Down

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.

MariaDB and MySQL

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...]
MySQL Unstable Builds
+0 Vote Up -0Vote Down

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

MySQL 5.4

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...]
MySQL Workbench 5.1.16 is GA!
+0 Vote Up -0Vote Down
MySQL Workbench Version 5.1.16 the General Availability build can be downloaded at http://dev.mysql.com/downloads/workbench/5.1.html.Congratulations to the Workbench team for their great effort in this release.
MySQL Workbench - Export Features
+0 Vote Up -2Vote Down
MySQL Workbench has some nice export features. They include:Forward engineer SQL Create ScriptForward Engineer SQL ALTER ScriptSynchronize With SQL Create ScriptExport as PNGExport as SVGExport as Single Page PDFExport as Single Page PostScript FileExport options (just choose File Menu then Export option):
MySQL Workbench - Visual Database Design Tool
+0 Vote Up -1Vote Down
What is MySQL Workbench?MySQL Workbench is a visual database design tool available on Window, Linux and Mac OS. The MySQL Administrator and Query Browser tools have been deprecated. The database GUI interfaces will be rolled into the MySQL Workbench 5.2 release (currently alpha). MySQL Workbench is available in a Community (free) and Enterprise edition (paid license). Below are a few good
Liking what I see in MySQL Workbench 5.2 alpha
+1 Vote Up -0Vote Down
Always looking at new toolsI've been looking for a better tool to work in a MySQL environment when I want to demo relationships between data models, physical tables, data and SQL code. It has to be a tool that the students can pick up easily without spending a lot of time understanding how it works. It's always an investment to learn another tool. So I've downloaded the MySQL Workbench 5.2
MySQL Workbench: My Impressions
Employee +0 Vote Up -0Vote Down

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.

Using MySQL Workbench to design the VoiceHotel Database Model
+0 Vote Up -0Vote Down
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.

What is MySQL Workbench (http://www.mysql.com/products/workbench/" target="_blank)?

In general terms we can say that MySQL Workbench is a tool that enables a DBA or developer in general, to create

  [Read more...]
Using MySQL Workbench to design the VoiceHotel Database Model
+0 Vote Up -0Vote Down

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.

What is MySQL Workbench? (http://www.mysql.com/products/workbench/" target="_blank)

In general terms we can say that MySQL Workbench is a tool that enables a DBA or

  [Read more...]
Utilizando o MySQL Workbench para criação do VoiceHotel Database Model
+0 Vote Up -0Vote Down
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 primeiro lugar no

  [Read more...]
Utilizando o MySQL Workbench para criação do VoiceHotel Database Model
+0 Vote Up -0Vote Down

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...]
MySQL Workbench – Next-generation visual database design application
+0 Vote Up -0Vote Down

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)

  [Read more...]

workbench-5.1.1-alpha on Fedora 9
+0 Vote Up -0Vote Down

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...]
Workbench on Linux
+0 Vote Up -0Vote Down

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:

  • liblua5.1-0
  • libglitz1
  • libzip1
  • libmysqlclient15off
  • mysql-common
  • libglitz-glx1



Workbench on Linux

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...]
MySQL Conference: The Week After
+0 Vote Up -0Vote Down
Wow... I had a great time at the annual MySQL Users Conference in Santa Clara.Highlights:Received my CMDBA designation. Woohoo!Sun announced the possibility of an open source mobile phone;All day mysql proxy tutorial with Jan Kneschke and Giuseppe Maxia;Amazon's Power of Infrastructure as a Service - great premise; glitches remain;Great food and a nifty side trip to Santa Cruz;MySQL Workbench -
8mm observations from this mornings MySQL UC Keynotes
Employee +0 Vote Up -0Vote Down

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: Check out our ER/DB design tool!
Employee +0 Vote Up -0Vote Down

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!

References:

  [Read more...]
Navigating categories within my blog
Employee +0 Vote Up -0Vote Down

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...]
Designing databases with MySQL Workbench
Employee +0 Vote Up -0Vote Down

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 54

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.