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 中文
Showing entries 1 to 30 of 53 Next 23 Older Entries

Displaying posts with tag: tutorial (reset)

New MySQL Workbench video
Employee_Team +3 Vote Up -0Vote Down

The MySQL Workbench team just uploaded a new video to the MySQL channel at Youtube. This video is meant for beginners and describes the process of creating and troubleshooting connections in MySQL Workbench.

MySQL Workbench: Vertical Query Output
Employee_Team +1 Vote Up -0Vote Down

MySQL Workbench have one nice feature which is probably a stranger for some of us. The name of this feature is vertical query output, it help in situations where the standard Workbench output will not be very useful. This functionality is very easy to use and in this post I’ll try to visualize some of it’s benefits.

First we need to know how to use it, so we’ve provided you two options to execute the query with vertical output. One of them is the menu bar where you can find item named Execute vertically, you’ll also find hint about the shortcut for that option it’s CTRL+ALT+RETURN.

After you know how to get the vertical query output, I’ll show you some screen shots to compare it with command line output.

Let’s take the command that suits best to this type of output, it’s SHOW ENGINE

  [Read more...]
MySQL Workbench 6.0: Help is on the way…
Employee_Team +2 Vote Up -0Vote Down

Do you know this scenario: you are writing down  a stored procedure but you can’t for the life of you remember the exact syntax of that CASE statement? Has it to end with CASE or not? Can I use more than one WHEN part and how should that be written? Usually you end up opening a web page and read through the excellent MySQL online docs. However, this might cost too much time if you quickly need different statements and other detail info. Here’s where MySQL Workbench’s context help jumps in.

The server can help

It’s probably only known to the die-hard terminal operators who write most of their SQL queries in a MySQL console window: the MySQL server already has a stripped down set of help topics produced by the Docs team. That means you can always get at least the syntax but often

  [Read more...]
Video Tutorial: Setup a Restricted SQL Server Account for Migrations with MySQL Workbench
Employee_Team +0 Vote Up -0Vote Down

Some users have asked us what is the minimum set of privileges that your Microsoft SQL Server user needs to successfully migrate databases from SQL Server using the MySQL Workbench Migration Wizard. Even though we don’t execute any query that alters anything in your source RDBMS servers, it’s never a bad idea to add an extra security barrier around it.

In short, you need the VIEW ANY DEFINITION permission for the server and the CONNECT and SELECT permissions for the database(s) you want to migrate. But to make this easier for you, we have created a video tutorial showing how to create a user with these permissions using the Microsoft SQL Server Management Studio.

How-To: Database Migration from Sybase Adaptive Server Enterprise using MySQL Workbench
Employee_Team +0 Vote Up -0Vote Down

In this tutorial I’m going to show you how to migrate your Sybase Adaptive Server Enterprise databases to MySQL.

As usual, we’ll start with a couple assumptions:

  • You have MySQL Workbench 6.0 installed.
  • You have a running Sybase Adaptive Server Enterprise database somewhere in your network. I’ll be using the pubs3 sample database that Sybase distributes with Adaptive Server Enterprise 15.
  • You have installed the Sybase Adaptive Server Enterprise ODBC drivers in the same PC where MySQL Workbench is running. The ODBC drivers are distributed with the Sybase Adaptive Server Enterprise SDK and included in the Adaptive
  [Read more...]
MySQL Workbench 6.0: Model Synchronization Improvements
Employee_Team +1 Vote Up -0Vote Down

In MySQL Workbench 6.0, three longstanding issues related to model synchronization were addressed. In this post, we’ll cover how these issues can happen, the underlying cause and how to resolve them.

Model Synchronization

When you synchronize a model to a database, Workbench performs the following steps:

  • Retrieve and reverse engineer the target schema from the database, to an internal representation that can be worked on by Workbench
  • Compare the schema from the model with the corresponding schema from the database, object by object
  • For each difference found, perform the corresponding action needed to change either the source or the target object, so they’re both looking the same. This may mean creating, altering or dropping objects in the database or updating the model to match the database. Because some of
  •   [Read more...]
    MySQL Workbench 6.0: Table Data Search
    Employee_Team +3 Vote Up -0Vote Down

    scr 1. Location of Search table data on the main toolbar

    One of the new features of MySQL Workbench 6.0 is Table Data Search. The main purpose of this was to ease data searching through the whole instance. Previously, we needed to use some tricks to get the query to run over all schemas that we’ve got on the server. Now it’s easy to find the searched term with much less hassle. This functionality is easy to use and provides searching through all columns and even all types. However, we can’t forget that due to the nature of this tool we must take some precautions to not overload your server.

    To use this functionality we pick it up

      [Read more...]
    How-To: Database Migration from Sybase SQLAnywhere using MySQL Workbench
    Employee_Team +3 Vote Up -0Vote Down

    In MySQL Workbench 6.0 two new additions have been made to the supported RDBMS sources list in the Migration Wizard: Sybase SQLAnywhere and SQLite. In this tutorial I’m going to show you how to migrate your Sybase SQLAnywhere databases to MySQL.

    As usual, we’ll start with a couple assumptions:

    • You have MySQL Workbench 6.0 installed.
    • You have a running Sybase SQLAnywhere database in your local computer (i.e. the computer where you are running MySQL Workbench. I’ll be using the demo database that Sybase distributes with SQLAnywhere 12.
    • A running MySQL Server instance with proper user access is available and you are able to connect to it from MySQL Workbench. The Migration Wizard supports MySQL versions from 5.1 onwards so make sure you have a supported
      [Read more...]
    MySQL Workbench 6.0: Home Screen
    Employee_Team +1 Vote Up -0Vote Down

    The home screen of MySQL Workbench is the first thing you see when you start up the application and it’s therefor an important hub to quickly reach important parts or do repeating tasks like opening certain connections. This article describes the home screen in some detail with additional info and tips.

    There are 3 areas with the connection area being the biggest one which you can also expand by resizing the application window. In the rare case you need a very small window or have many entries each area has a paging control to flip between different parts of a listing.

    Shortcuts – a direct wire to your plugins, docs and support sites

    The shortcuts section is what the starters used to be in pre-6.0

      [Read more...]
    MySQL Workbench Tunneling to Socket File only servers
    Employee_Team +1 Vote Up -0Vote Down

    Brandon Johnson at Mozilla has posted a nice tip on how to use MySQL Workbench SSH tunneling with MySQL servers configured to accept only Unix Socket File connections (no TCP/IP). Head over there for more info about how to use the “socat” utility to bridge a SSH tunnel from WB to a socket only MySQL.

    Getting started with replication from MySQL to MongoDB
    +1 Vote Up -0Vote Down

    As you probably know, Tungsten Replicator can replicate data from MySQL to MongoDB. The installation is relatively simple and, once done, replication works very well. There was a bug in the installation procedure recently, and as I was testing that the breakage has been fixed, I wanted to share the experience of getting started with this replication.

    Step 1: install a MySQL server

    For this exercise, we will use a MySQL sandbox running MySQL 5.5.31.

    We download the binaries from dev.mysql.com and install a sandbox, making sure that it is configured as master, and that it is used row-based-replication.

    $ mkdir -p $HOME/opt/mysql
    $ cd ~/downloads
    $ wget

      [Read more...]
    Installing and administering Tungsten Replicator - Part 2 : advanced
    +2 Vote Up -0Vote Down

    Switching roles

    To get a taste of the power of Tungsten Replicator, we will show how to switch roles. This is a controlled operation (as opposed to fail-over), where we can decide when to switch and which nodes are involved.

    In our topology, host1 is the master, and we have three slaves. We can either ask for a switch and let the script select the first available slave, or tell the script which slave should be promoted. The script will show us the steps needed to perform the operation.

    IMPORTANT! Please note that this operation is not risk free. Tungsten replicator is a simple replication system, not a complete management tool like Continuent Tungsten. WIth the replicator, you must make sure that the applications have stopped writing to the master before starting the switch, and then you

      [Read more...]
    Installing and Administering Tungsten Replicator - Part 1 - basics
    +2 Vote Up -0Vote Down

    Intro

    Tungsten Replicator is an open source tool that does high performance replication across database servers. It was designed to replace MySQL replication, although it also supports replication from and to Oracle and other systems. In this article, we will only cover MySQL replication, both simple and multi-master.

    Preparing for installation

    To follow the material in this article, you will need a recent build of Tungsten Replicator. You can get the latest ones from http://bit.ly/tr20_builds. In this article, we are using build 2.0.8-167.

    Before starting any installation, you should make sure that you have satisfied all the prerequisites. Don't

      [Read more...]
    MySQL Cluster Tutorial: NoSQL JavaScript Connector for Node.js
    Employee_Team +4 Vote Up -0Vote Down

    This tutorial has been authored by Craig Russell and JD Duncan

    The MySQL Cluster team are working on a new NoSQL JavaScript connector for MySQL. The objectives are simplicity and high performance for JavaScript users:

    - allows end-to-end JavaScript development, from the browser to the server and now to the world's most popular open source database

    - native "NoSQL" access to the storage layer without going first through SQL transformations and parsing.

    Node.js is a complete web platform built around JavaScript designed to deliver millions of client connections on commodity hardware. With the MySQL NoSQL Connector for JavaScript, Node.js users can easily add data access and persistence to their web, cloud, social and

      [Read more...]
    Flexible Fail-over Policies Using MySQL and Global Transaction Identifiers
    Employee +1 Vote Up -0Vote Down
    << Previous Post: Advanced use of Global Transaction Identifiers

    As we saw in my previous posts, Global Transaction Identifiers in MySQL 5.6 allow you to change the replication topology arbitrarily. You don't even need to specify the positions in the replication stream – when you turn on auto-positioning, the master automatically sends only those transactions that are missing on the slave.

    When you do a fail-over, you want to make sure that the new master is up-to-date. For instance, consider the following scenario:





      [Read more...]
    Sessions at Percona Live MySQL Conference 2013: fun, competition, novelties, and a free pass
    +3 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo 2013 is almost 1 month away. It's time to start planning, set the expectations, and decide what to attend. This post will give a roundup of some of the sessions that I recommend attending and I look forward to.

    First, the unexpected!

    After much talk and disbelief, here they come! Oracle (http://www.mysql.com) engineers will participate to the Percona Live conference. This is wonderful! Their participation was requested by the organizers, by the attendees, and by community advocates, who all told the Oracle management how important it is to be in this conference. Finally, they have

      [Read more...]
    Installing a driver for Microsoft SQL Server and Sybase ASE in Linux and Mac
    Employee_Team +3 Vote Up -0Vote Down

    In a recent post we showed you how to migrate a SQL Server database to MySQL. There, we used the oficial Microsoft ODBC driver and that’s OK if you are running MySQL Workbench in Windows. But what if your desktop OS is some Linux variant or Mac OS X?

    It turns out that Microsoft has recently released an ODBC driver for Linux. However, you can’t use this driver with MySQL Workbench for Linux. (Actually you can, but you would have to rebuild Workbench). The main reason is that this ODBC driver was linked against unixODBC (an ODBC driver manager), while Workbench uses another ODBC driver manager: iODBC and the two of them

      [Read more...]
    MySQL 5.6 Replication: New Resources for Database Scaling and HA
    Employee_Team +8 Vote Up -0Vote Down
    MySQL 5.6 reached GA (General Availability) today and is packed with a wealth of new features and capabilities.  Exciting stuff!
    MySQL 5.6 also introduces the largest set of enhancements to replication ever delivered in a single release, including: - 5x higher performance to improve consistency across a cluster and reduce the risks of data loss in the event of a master failing - Self-healing clusters with automatic failover and recovery from outages or planned maintenance - Assured data integrity with checksums implemented across the replication workflow - DevOps automation
    Of course, getting started with all of these enhancements can be a challenge - whether you are new to MySQL replication or an experienced user. So two new Guides are available to help take advantage of

      [Read more...]
    Solving replication problems with Tungsten replicator
    +1 Vote Up -0Vote Down

    On Monday afternoon, Neal Armitage and I will be speaking at Percona Live in London. It will be a three hours tutorial about Tungsten replicator.

    The contents of this tutorial are mostly new. We have released recently a new and easier way of installing different topologies, in the shape of cookbook scripts, which are distributed with the replicator tarball.

    Using this cookbook, any user can simply install multiple topologies, from the simple master/slave to all-masters, fan-in, and star.

    There are recipes for showing the replication cluster, switching roles between master and a chosen slave, taking over MySQL replication, installing direct slaves with parallel replication, testing each topology, and

      [Read more...]
    How-To: Migrate PostgreSQL databases to MySQL using the MySQL Workbench Migration Wizard
    Employee_Team +6 Vote Up -0Vote Down

    MySQL Workbench 5.2.41 introduced the new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. As of Workbench 5.2.44 you can migrate databases from Microsoft SQL Server, PostgreSQL and Sybase Adaptive Server Enterprise. It also provides for generic migrations, i.e. migrations from other RDBMSes that are not explicitely supported, provided that they have a well behaved ODBC driver. More on this in an upcoming post…

    Additionally, you can use the Migration Wizard to perform MySQL to MySQL database migrations, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.

    We have already described in a previous post how to use the

      [Read more...]
    Advanced use of Global Transaction Identifiers
    Employee +3 Vote Up -0Vote Down

    Details of Re-execution and Empty Transactions

    << Previous post: Failover and Flexible Replication Topologies in MySQL 5.6
    Next post: Flexible Fail-over Policies Using MySQL and Global Transaction Identifiers >>

    This post was kindly translated to Japanese by Ryusuke Kajiyama.

    In my previous post, we saw how GTIDs are generated and propagated, we described the new replication protocol, and we saw how these simple elements fit



      [Read more...]
    Failover and Flexible Replication Topologies in MySQL 5.6
    Employee +6 Vote Up -0Vote Down

    Global Transaction Identifiers – why, what, and how

    Next post: Advanced use of Global Transaction Identifiers
    This post was kindly
    translated to Japanese by Ryusuke Kajiyama.

    In MySQL 5.6 we introduced a new replication feature called Global Transaction Identifiers, or GTIDs. While there are many use cases, our primary motivation for introducing GTIDs is that it allows for seamless failover. By this, we mean promoting one of the slaves to be come a master, if the master crashes, with minimal manual intervention and service disruption.

    This is the first in a series of several blog posts. We will go through several use cases and show how




      [Read more...]
    How-To: Guide to Database Migration from Microsoft SQL Server using MySQL Workbench
    Employee_Team +3 Vote Up -0Vote Down

    MySQL Workbench 5.2.41 introduces a new Migration Wizard module. This module allows you to easily and quickly migrate databases from various RDBMS products to MySQL. In this initial version, migrations from Microsoft SQL Server are supported, but it should also be possible to migrate from most ODBC capable RDBMS as well, using its generic RDBMS support. Additionally, you can use it to perform MySQL to MySQL database copies, which can be used for tasks such as copying a database across servers or migrating data across different versions of MySQL.

    So let’s get our hands dirty and run through the Migration Wizard in order to migrate a Microsoft SQL Server database to MySQL. In the rest of this post I assume that you have:

    • A running SQL Server instance in which you have proper access to the database you want to migrate.
      [Read more...]
    Building MySQL Workbench from sources on Ubuntu/Debian
    Employee_Team +0 Vote Up -0Vote Down

    To build MySQL Workbench one would need to install dependencies, fetch source code, configure it and actually do a build.

    Note: On a Core2 Quad 2.4 GHz and a 4G of RAM it takes about 30-40 minutes to build Workbench. Also it uses about 4.2G of hdd space to build.

    Here are steps to build Workbench on Ubuntu/Debian:

    1) install deps. It is better to use terminal. The command to install deps is below:

    sudo apt-get install build-essential autoconf automake libtool libzip-dev libxml2-dev libsigc++-2.0-dev libglade2-dev libgtkmm-2.4-dev libglu1-mesa-dev libmysqlclient15-dev uuid-dev liblua5.1-dev libpcre3-dev g++ libglade2-dev libgnome2-dev python-pexpect libboost-dev libsqlite3-dev python-dev libgnome-keyring-dev libctemplate-dev

    2) Get source code from http://www.mysql.com/downloads/workbench/

    3) unpack

      [Read more...]
    Four short links: 28 June 2011
    +0 Vote Up -1Vote Down

  • Networks Blocking Google TV -- the networks are carrying over their old distribution models: someone aggregates eyeballs and pays them for access. In their world view, Google TV is just another cable company. They're doubling down on this wholesale model, pulling out of Hulu and generally avoiding dealing with the people who ultimately watch their shows except through ad-filled shows on their corporate sites. (via Gina Trapani)
  • Mobile Market Snippets -- lots of numbers collected by Luke Wroblewski. After the Verizon iPhone launched in
  •   [Read more...]
    Workbench and MySQL server at non-standard location in Linux.
    Employee_Team +1 Vote Up -0Vote Down

    Recently I had to test MySQL Workbench against fresh version of the server. Naturally, the default mysql-server was already installed from repository of my Linux distro. So I installed the latest server version into my /opt/server directory. And then I had several points to resolve, for example, how to start detached server process from Workbench Adminstrator; how to detect if the server is running or not, given that there are many of them running; how to stop the server.

    Now I will show several workarounds to perform tasks listed in the previous paragraph. Below are the commands I put into Server Instance Editor, there are corresponding text entries labeled: ‘Start MySQL’, ‘Stop MySQL’, ‘Check MySQL Status’:

    - Staring server – (nohup /opt/server/5.5.9/bin/mysql_safe –defaults-file=/opt/server/5.5.9/my.cnf & disown %1)
    Note!

      [Read more...]
    Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!
    Employee +0 Vote Up -0Vote Down

    I've been reworking the Creating a CRUD Application with PHP tutorials. The new version should be ready for 7.0 Beta 2 release. In the new version:

    • I replaced mysql functions with mysqli functions.
    • With the help of Christoper Jones, I've added OCI8 versions of the code for connecting to Oracle Database
    • I've fixed some old bugs and improved the tutorials overall.

    In the course of this work, two things have come to my attention. These are two things that you can help with.

    • The title Creating a CRUD Application... is not very appealing.
    • The sample CSS used for Lesson 8 is terrible.

    So first, can anyone suggest a new title? We have one


      [Read more...]
    Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!
    Employee +0 Vote Up -0Vote Down

    I've been reworking the Creating a CRUD Application with PHP tutorials. The new version should be ready for 7.0 Beta 2 release. In the new version:

    • I replaced mysql functions with mysqli functions.
    • With the help of Christoper Jones, I've added OCI8 versions of the code for connecting to Oracle Database
    • I've fixed some old bugs and improved the tutorials overall.

    In the course of this work, two things have come to my attention. These are two things that you can help with.

    • The title Creating a CRUD Application... is not very appealing.
    • The sample CSS used for Lesson 8 is terrible.

    So first, can anyone suggest a new title? We have one


      [Read more...]
    MySQL Workbench: Manage MySQL on Windows Servers the Windows way
    Employee_Team +8 Vote Up -1Vote Down

    The MySQL team has been continuously improving its products on the Windows platform. Along this line, we’ve responded to a request from our users of Workbench on Windows – to provide remote access to Windows Servers using Windows management methods – as an alternative  to SSH.

    Managing a MySQL server obviously requires access to the target machine, which usually requires elevated rights for certain tasks like restarting the server or manipulating the configuration file on Windows (where this file is in a protected path). For local connections this is mostly not a big deal. However for remote boxes security measures prevent easy manipulation of such essential things like server processes. In this blog post we discuss native Windows management and how it can be used in MySQL Workbench.

    Remote Management

    MySQL Workbench first introduced remote access via SSH (secure shell), a

      [Read more...]
    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...]
    Showing entries 1 to 30 of 53 Next 23 Older Entries

    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.