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’:

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 widely used and well known …

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.

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 kind of convention or pattern. For …

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 separate hosts, but it's a good …

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).

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, which will …

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.