Showing entries 31 to 40 of 63
« 10 Newer Entries | 10 Older Entries »
Displaying posts with tag: tutorial (reset)
Failover and Flexible Replication Topologies in MySQL 5.6

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 easy it is to do a failover. We explain …

[Read more]
How-To: Guide to Database Migration from Microsoft SQL Server using MySQL Workbench

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. (I’ll call this database from now on the source database). I have a remote SQL Server 2000 instance …
[Read more]
Building MySQL Workbench from sources on Ubuntu/Debian

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 downloaded archive …

[Read more]
Four short links: 28 June 2011
  1. 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)
  2. Mobile Market Snippets -- lots of numbers collected by Luke Wroblewski. After the Verizon iPhone launched …
[Read more]
Workbench and MySQL server at non-standard location in Linux.

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! the command above must be used including parentheses
- …

[Read more]
Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!

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 suggestion already, internally: Creating a Database Application …

[Read more]
Rewriting the Creating a CRUD Application with PHP tutorial cycle: help wanted!

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 suggestion already, internally: Creating a Database Application …

[Read more]
MySQL Workbench: Manage MySQL on Windows Servers the Windows way

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 …

[Read more]
MySQL Workbench: Introducing Utilities

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

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 …

[Read more]
Showing entries 31 to 40 of 63
« 10 Newer Entries | 10 Older Entries »