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: tutorial (reset)

MySQL Workbench: Introducing Utilities
Employee_Team +8 Vote Up -0Vote Down

MySQL has the well earned reputation for ease-of-use and “15-minutes-to-success”, since we continually focus making the server easy to use. MySQL Workbench provides the visual tools for database design, development, and administration. However, many DBAs prefer using the command-line, and there are many tasks that require the creation scripts for doing the job.

To make it easier to work with the server, the latest release of the MySQL Workbench—version 5.2.31—contain a set of Python scripts intended to make the life easier for DBAs by providing easy-to-use utilities for common tasks, which were introduced in the blog MySQL Workbench: Utilities. The set currently consists of just a few utilities, but will expand over time.

The utilities available in the Workbench are:

  [Read more...]
MySQL Workbench Plugin: Auto-Create Foreign Keys
Employee_Team +6 Vote Up -0Vote Down

To automatically create Foreign Key relationships is a typical use case for developers working with the MyISAM storage engine. This has been a popular topic on the Blog and forums so we’re revisiting it here – with a new and improved plugin written in Python.

While the InnoDB storage engine supports foreign keys, MyISAM doesn’t, but developers often pick it for various reasons and leave the application to handle relationships itself. MySQL Workbench can be used to reverse engineer a database to a model to better visualize or maintain it. But since MyISAM doesn’t have foreign keys, databases that use it will be lacking a very important part of it’s structure in the diagrams. You can link the columns manually, using the relationship tool to link columns, but you can also automate that. Databases are usually created so that columns that represent relationships have names that follow some

  [Read more...]
Install, configure and run MySQL Cluster – demo video
Employee +8 Vote Up -0Vote Down

There is a new video available: Demonstration of installing, configuring and running MySQL Cluster (LINUX) (http://www.mysql.com/products/database/cluster/cluster_install_demo_linux.html" target="_blank) to accompany the MySQL Cluster Quick Start guides (http://www.mysql.com/products/database/cluster/get-started.html#quickstart" target="_blank). The Flash video video lasts for about 7 minutes.

If you aren’t able to view Flash on your device then a (poorer quality) version is included here – watch the Flash version (http://www.mysql.com/products/database/cluster/cluster_install_demo_linux.html" target="_blank) if you’re able to!

Quick start guides: MySQL cluster in 10 minutes
+11 Vote Up -2Vote Down
Scared of MySQL Cluster?
Don't be. You may want to try the quick start guides that are available in the Cluster downloads page.
These guides are a step-by-step instructions set to create a simple cluster in one host.
Following the instructions, you will be able to shape up all the cluster components in 10 minutes or less. This will be far from production ready, of course, but it shows that cluster is not rocket science, and anyone can get started with it with a minimal time investment.I tried the Linux instructions on my Mac, and it worked without need for any changes. Things may be different when you deploy a real set of servers on

  [Read more...]
Videos of Pythian Sessions from the 2010 O’Reilly MySQL Conference and Expo
+2 Vote Up -0Vote Down

Here’s a sneak peek at a video matrix — this is all the videos that include Pythian Group employees at the MySQL conference. I hope to have all the rest of the videos processed and uploaded within 24 hours, with a matrix similar to the one below (but of course with many more sessions).

TitlePresenterSlidesVideo link
(hr:min:sec)Details (Conf. site link)

Main Stage
Keynote: Under New Management: Next Steps for the CommunitySheeri K. Cabral (Pythian)N/A18:16
session 14808Ignite talk: MySQLtuner 2.0Sheeri K. Cabral (Pythian)PDF5:31N/A
Thoughts on Drizzle and

  [Read more...]
Going to the O'Reilly MySQL Conference & Expo
Employee +0 Vote Up -0Vote Down

As I've been doing the last couple of years, I will be going to the O'Reilly MySQL Conference & Expo. In addition to the tutorial and the replication sessions that I will be holding together with Lars, I will be holding a session about the binary log together with Chuck from the Backup team which the Replication team normally works very close with.

This year, O'Reilly also have a Friend of the Speaker discount of 25% that you can use when you register using the code mys10fsp.

The sessions that we are going to hold are listed below. Note that I am using Microformats[Read more...]
MySQL Workbench 5.2 Beta Quick-Start Tutorial
Employee_Team +0 Vote Up -0Vote Down

MySQL Workbench 5.2 introduces a lot of new functionality and therefore this short tutorial will help you to get started quickly.

The Home Screen

The most prominent new addition in respect to previous Workbench releases is the new Home Screen. It allows you to access the main features of Workbench in a nice and easy way and is divided into 4 parts.

The upper Workbench Central panel features a few Links and Action Buttons to quickly access common resources.

The lower Workspace panel shows the main feature sets, grouped horizontally.

  • SQL Development allows editing and execution of SQL queries and scripts, create or alter database objects and edit table data.
  • Data Modeling covers the EER Modeling functionality you might already be familiar with from previous MySQL Workbench releases.
  • Server Administration offers
  [Read more...]
Technical Webinars
Employee +0 Vote Up -0Vote Down

You want to use or to know more about Sun technologies? Join these Webinars to improve your knowledge and skills. You will be able to ask questions to Sun's experts.

  • Mercredi 10 Février : Securité pour les applications Web. Pour les startups du Web, la protection et la sécurisation de leurs applications, de leurs données, et de celles de leurs clients est un véritable facteur clé de succès.  Ce Webinar couvre les différents challenges liés à la sécurité ainsi que les solutions associées telles que l'encryption, l'authentification, les certificats, la sécurisation du stockage et le stockage à tolérance de panne, les environnements étanches. Les architectes de Sun Startup Essentials présenteront des implémentations économiques basées sur des composents standards et ouverts tel qu'Apache,

  [Read more...]
MySQL Workbench Administrator Plugin
Employee_Team +1 Vote Up -0Vote Down

Recently we have released Workbench 5.2.4 Alpha. This version has some new features, and amongst them there is Workbench Administrator plugin or WBA plugin for short.

The plugin aims to ease the managing process of server instances. What we offer with WBA is a simple way to check status, configure and control one server instance. Some parts will resemble discontinued MySQL Administrator.

And here is a short summary of what we will have in WBA:

  • Start/Stop server
  • Edit server configuration (my.cnf)
  • Manage user accounts
  • Monitor user connections
  • Status/Server variables browsing
  • Log browsing
  • Dump/Restore

In this alpha we have implemented a subset, which targets local usage only. Remote management and administration is upcoming. The subset includes:

  • Add new Server Profiles
  • Start/Stop the Server
  • Edit
  [Read more...]
Backup MySQL in a Second with ZFS
Employee +1 Vote Up -1Vote Down

MySQL backup soon becomes an important matter when the database is used in production. The pain-point comes from the fact that while backuping the database is not available to respond to client requests anymore. With mysqldump - the standard tool for performing MySQL backups - and a large database the operation can go over many tenth of minutes if not hours. If I am running my business on line this is simply not acceptable.

The classical approach to workaround this problem is to take advantage of MySQL replication. I set up a master/slave configuration where the slave acts as copy of the master. Then, when needed, I run mysqldump on the slave without any service interruption on the master.

But ZFS snapshosts bring a new straightforward approach that avoids the pain and the complexity of a master/slave replication.

  [Read more...]
MySQL Workbench 5.2 Querying Quick-Tour
Employee_Team +0 Vote Up -0Vote Down

For anybody interested in trying out our new MySQL Workbench 5.2 Alpha2 I have prepared a short Quick-Tour that will show you the most important steps to successfully use WB to query your databases.

Manage Your Connections

MySQL Workbench 5.2 introduces a new Home Page that makes it very easy to access all your Database Connections and EER Models. It features the Workbench Central Panel, the Database Connections Panel and the Model Files Panel.

In order to be able to connect to your  MySQL server you have to create a new Database Connection so MySQL Workbench knows about your server instance. Follow the steps shown below to create your first Database Connection.

Click on the screen shot to see it at full size.

  [Read more...]
Free Workshop + Free Workbench SE at MySQL UC
Employee_Team +0 Vote Up -0Vote Down

Everybody attending the MySQL Users Conference this year please mark your calenders! This is your chance to become a MySQL schema design expert as well as learn how to use Workbench from the experts.

We are going to do a free Workshop called “Introduction to Data Modeling with MySQL Workbench” on Tuesday - Thursday 3 - 4:30 PM in the Santa Clara Ballroom.

Some of the topics that will be covered:

  • Database Schema Design
    • Get familiar with common concepts of database schema design
    • Learn to avoid typical mistakes (do-s & don’t-s)
    • Tricks how to resolve typical problems
    • Performance-tune your schemata
  • MySQL Workbench
    • Get introduced to MySQL Workbench
    • Learn how to use MySQL Workbench in real world scenarios
    • Make use
  [Read more...]
My favorite tutorial at the UC2009 : Build and release management
+0 Vote Up -0Vote Down

I am looking forward to the MySQL Users Conference and Expo 2009. Since I am a tutorial speaker, my choice of tutorials to attend is limited. Upon completion of my duties, I will attend Greg Haase's tutorial on Build and Release Management for Database Engineers.
There are many reasons for that. For starting, Greg is the winner of the MySQl 5.1 Use Case competition where he has shown his DBA skills, and then, he is using the MySQL Sandbox

  [Read more...]
New MySQL Sandbox tutorial
+0 Vote Up -0Vote Down

John Goulah wrote a nice quick tutorial to MySQL Sandbox.
Thanks, John!
MySQL Workbench - LUA-Script For Batch Renaming Of Foreign Keys
Employee_Team +0 Vote Up -0Vote Down

Yesterday there was a short discussion on our public IRC channel (#workbench on freenode). It was about how Workbench handles Foreign-Key-Names.

Especially if you intend to use Synchronization feature (available in SE edition only) its good to have names for FKs (and their coresponding Indices). Workbench does that by default if you’re using the Relationship-tools (Hotkeys 1 to 6 when canvas is focused). But if you prefer to create your FKs in a not-so-visual way (entering the values on the FK-Tab in the table-Editor) you are on your own when it comes to naming your FKs. Though Workbench initially only accepts creating keys after you typed a name into the name-field theres still the possibility to rename the FK later to even empty names. If you try to create empty named FKs on a MySQL Server the server will generate a name for the key.

If you want to change FK names later, when your model

  [Read more...]
Moving From Perl 5 to Perl 6 – What's New, Tutorial Style
+0 Vote Up -0Vote Down

Newsflash: Perl 6 is not dead (in case you thought it was)!

I stumbled upon this most excellent series of posts by Moritz Lenz of perlgeek.de that describe the differences between Perl 5 and the upcoming Perl 6 (thanks to Andy Lester for the link). The posts are done in the form of tutorials, which helps comprehension. Simply awesome, Moritz.

It seems like Perl 6 is going to be a lot more object oriented, but such orientation is optional and not forced upon programmers, like in, say, Java. It warms my heart

  [Read more...]
Nice Blog Postings About MySQL Workbench
Employee_Team +0 Vote Up -0Vote Down

Quite a few Blog postings pop up recently, let me outline two of them.

Gerry Narvaja talks about multi-page printing by using the MySQL Workbench community edition utilizing the PDF output. Find his posting here.

Weizh posted a nice step-by-step tutorial on how to use Workbench to show differences between two databases. Find it here.

Both workflows get you what you want by using the Community Edition. For those of you who want everything on a silver plate there is the Standard Edition (http://mysql.com/products/workbench/) of course, which simplifies these tasks even more.

On a side note: To get more information about the printing topic Gerry joined us on our IRC #workbench

  [Read more...]
Printing in Workbench
Employee_Team +0 Vote Up -0Vote Down

A common misunderstanding seems to be that the only way to increase the available “paper space” for a diagram is by increasing the size of the paper. But there is another way to do that, which is in the Model -> Diagram Size dialog, where you can set the number of pages your diagram has, vertically and horizontally (perhaps it’s not very obvious to first time users, so we’ll be working on making it more easily accessible).

  [Read more...]
Good MySQL Workbench Article
Employee_Team +0 Vote Up -0Vote Down

Please find a nice article by Djoni Darmawikarta here. He gives a nice step-by-step tutorial on how to use MySQL Workbench to create a simple model and then use the Forward Engineering functionality to create the actual database schema.

If you have written such a tutorial yourself or plan to write one, please drop us a email at workbench@mysql.com and we will be happy to feature you on our official Workbench Blog!

MySQL Workbench Community Edition: Guide to Schema Synchronization
Employee_Team +0 Vote Up -0Vote Down

As you can see in the MySQL Workbench Edition feature grid, Live Schema Synchronization is a Standard Edition feature only. But that does not mean that you cannot make use of the same functionality in the OSS Edition in an offline scenario - which is even more preferable in some cases.

  • Create an SQL CREATE script from your model
    You might already have the SQL CREATE script if you started your model with an import of an existing schema. If you started designing your model from scratch inside Workbench, you are going to export an SQL CREATE script anyway - in order to create the initial schema on the database server.
  • Update your Workbench model
    At this point your database is already running. But as we all know you always have to make changes to your first design. Do the necessary changes to the model.
  • Export SQL ALTER

  •   [Read more...]
    EXPLAIN Cheatsheet
    +0 Vote Up -0Vote Down

    At the 2008 MySQL Conference and Expo, The Pythian Group gave away EXPLAIN cheatsheets. They were very nice, printed in full color and laminated to ensure you can spill your coffee* on it and it will survive.

    For those not at the conference, or those that want to make more, the file is downloadable as a 136Kb PDF at explain-diagram.pdf

    * or tea, for those of us in the civilized world.

    Slides from "Real World Web: Performance & Scalability, MySQL Edition"
    +0 Vote Up -0Vote Down

    The slides from my tutorial yesterday are up at develooper.com. 189 slides this year! A handful of people have told me today (and more yesterday obviously) that they learned a lot and got new ideas for how to build things - yay!

    I’m considering putting up a version of the slides with sound. Would anyone want a 3 hour quicktime movie of that?

    Well, maybe split up into smaller bits, but you get the idea. You wouldn’t get the hand waving, but you would get a bunch more detail, obviously.

    I actually had audio recorded, but I

      [Read more...]
    External Libraries in XCode
    +0 Vote Up -0Vote Down

    I need to compile something and use the MySQL C++ library. I have mysql and mysql++ already compiled, I won’t go over how to do that now.

    I added the following code to the top of my source:

    #include <mysql++.h>

    I got an error

    /Users/jhaddad/dev/search_engine/main.cpp:4:21: error: mysql++.h: No such file or directory

    Not cool.

    How to fix:

    In XCode, open up the project settings (under the project menu). Go down to search paths, and you can change your Header search paths to the correct locations where you installed whatever you’re looking for. In this case, mine was /usr/local/includes and /usr/local/mysql/

    Next time you try to recompile, you’ll get a different error, this time it should be during Linking. Might look something like the

      [Read more...]
    AJAX Tutorial with Prototype
    +0 Vote Up -0Vote Down

    Here's the AJAX prototype example that I used in my AJAX presentation today.

    I wanted to give an example of a good use of AJAX, and at the same time keep it simple. So I thought a good example would be to build a zip code verifier. As soon as the person enters the zip code it makes a request to the server to see if the zip code is in the database, and returns the city and state.

    So the user first sees this:

    Once the zip code is entered, and the response received it looks like this:

    If the zip code is not found in the db:

    Ok, now lets build it...

    Download prototype, and a zip  [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.