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 57

Displaying posts with tag: sandbox (reset)

MySQL Proxy => proxydb + replication
Employee +4 Vote Up -0Vote Down
A couple of weeks ago I wrote a lua script to use with the MySQL Proxy that transforms the Proxy into a key=>value lookup dictionary.

But I couldn't just stop there. So I decided to add replication to it :).

The basic idea is that you have one proxy that acts like a master, it can handle all write/read operations. Once it receives a write query, it will send that query to the slave proxy instances, and after the last slave gets the query, the master will return a confirmation to the mysql client.
And of course,

  [Read more...]
MySQL Sandbox 3.0 is released - looking at the future
+12 Vote Up -0Vote Down

It's done. MySQL Sandbox 3.0 is now available.
New features include:
  • Installation as a Perl module;
  • Copying, moving, deleting, and preserving sandboxes;
  • Port checking before installing;
  • A test suite with 200 tests;
  • User defined modular tests;
  • A rich cookbook

If you get the source code through the Bazaar repository, you will see something new. There is now

  [Read more...]
MySQL Sandbox 3.0 release candidate
+7 Vote Up -0Vote Down

MySQL Sandbox is now in release candidate status. If no bugs are reported on the latest version (2.0.99f), I will repackage it as 3.0.
In addition to the list of features previously announced, I managed to implement another feature that has been in the wish list for long time, i.e. creating a sandbox from existing binaries, such as the ones installed by a .rpm or .deb package.

The new script make_sandbox_from_installed meets the expectations by creating a fake BASEDIR with symbolic links.
Other important

  [Read more...]
Test driving the Spider storage engine - sharding for the masses
+7 Vote Up -0Vote Down

At the MySQL Conference 2009 I attended a session about the Spider storage engine, an engine with built-in sharding features.
The talk was notable for the speaker wearing a spiderman costume, and for some language barrier that made the talk less enjoyable than it should be. That's a pity, because the engine is very intriguing, and deserves some exploration.

What is the Spider engine, then? In short, it's an extension to the partitioning engine with the ability of connecting to remote servers. Basically, partitions + federated, except that Federated is explicitly removed during the compilation. Additionally, the spider

  [Read more...]
MySQL University: Testing multiple servers with MySQL Sandbox
Employee +1 Vote Up -0Vote Down

This Thursday (April 30th, 14:00 UTC), Giuseppe Maxia will give a MySQL University session on Testing Multiple Servers With MySQL Sandbox. Giuseppe is the creator of MySQL Sandbox, and has recently announced a new Sandbox version and other interesting changes, for example the --query-analyzer option to make_sandbox (but note the date when this was announced!).

For MySQL University sessions, point your browser

  [Read more...]
Gurus show at the Los Angeles Meetup - April 17
+0 Vote Up -0Vote Down

If you are in the Los Angeles area, you have two more chances to meet the MySQL gurus on their way to the the MySQL Conference.
Today at the USC, Sheeri and I will conclude the South California MySQL Campus Tour.
Tomorrow, April 17, big gathering at the Los Angeles MySQL Meetup Group, where Andrew Aksyonoff, Sheeri, and myself will be the speakers. Come along!During the event, I will do a quick live demonstration of the new features included in

  [Read more...]
MySQL Sandbox 3 - Now feature complete
+1 Vote Up -0Vote Down

MySQL Sandbox 2.0.98i is now feature complete. The most notable additions are a robust test suite, with over 120 tests, and some features that have been in the wish list for long time.
The first one that makes a lot of difference is the ability of installing a sandbox from a build directory.
This feature has requested many times, and I have been reluctant to implement it, because it involved fiddling with the internals of low_level_make_sandbox, which should behave differently depending on the base directory. An installed BASEDIR has a different

  [Read more...]
Multi-source replication with MySQL Cluster
+0 Vote Up -0Vote Down
With MySQL Cluster it is possible to aggregate data from many MySQL Servers using Replication. Here is how.

E.g, you might have a sensor network, where each sensor writes data into a mysql server. The problem is that you have a quite few of these sensors, and you want to do aggregate this data, e.g. in order to do data mining on the combined data set.

The standard MySQL server does not support multi-source (i.e, one slave server can be connected to many masters), but Cluster can be used for this, since you can have many mysql servers connected to Cluster acting as slaves.

It is also possible to extend

  [Read more...]
Using MySQL sandbox for testing
+0 Vote Up -0Vote Down

MySQL Sandbox is a great tool for quickly deploying test MySQL instances, particularly if your daily work involves diagnosing problems across multiple MySQL versions.

Once you’ve downloaded it, it needs no installation. Just have a few MySQL binary releases at hand, and begin creating sandboxes in just a few seconds:

./make_sandbox mysql-5.0.77-linux-x86_64-glibc23.tar.gz


./make_sandbox mysql-5.1.32-linux-x86_64-glibc23.tar.gz

Pretty simple, huh?

Suppose you have a parallel build around, say, 5.0.77-percona-highperf. The default syntax won’t work if you’ve already created a 5.0.77 sandbox, since Sandbox will use ‘5.0.77′ as the sandbox dir. In this case, you’ll need to manually specify a directory

  [Read more...]
MySQL Sandbox even more sandboxed
+0 Vote Up -0Vote Down

In the late evening of March 31st I had a good coding session with MySQL Sandbox. I implemented a feature that has been in the wish list for long time. Checking the port before installing, and providing a non used port that positively avoids conflicts is a great step forward.

Now you can do things like this:
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
$ make_sandbox 5.1.33 --check_port --no_confirm
And you will get no errors!
The Sandbox

  [Read more...]
Query Analyzer features integrated in MySQL Sandbox
+0 Vote Up -0Vote Down
Community strikes.
It was about time that someone provided a match for MySQL Query Analyzer, the flagship feature of MySQL Enterprise.
Now MySQL Sandbox includes a --query_analyzer option, which will convert your sandboxed server into an analysis machine. No need to buy Enterprise. No need to waste tons of money on expensive consultants.
Just download the latest tarball and install a sandbox as usual, with the additional option.

$ make_sandbox 5.1.32 --query_analyzer

And that's it! Your worries will be over. Enjoy!

Update As it should be clear by now, this was an April's fool joke. See the

  [Read more...]
MySQL Sandbox approaching version 3
+0 Vote Up -0Vote Down

MySQL Sandbox is approaching another milestone. Preparing for version 3.0, which will include some new features, version 2.0.98 (based on 2.0.18) can be installed like any other Perl module, and the scripts become available in the PATH.
It means a few seconds more to install the scripts, but a faster and easier usage.

This latest change also means that MySQL Sandbox will be available through the CPAN (Comprehensive Perl Archive Network, for the uninitiated).
The next step will be to include this

  [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...]
Easy server testing with MySQL Sandbox
+0 Vote Up -0Vote Down

MySQL Sandbox 2.0.18 introduces a new feature, changing port. You can now change the listening port for a sandboxed server, either as a standalone operation, or while moving it, using the sbtool.
There is a feature in the Sandbox, introduced in 2.0.13, that makes really easy to test servers in special conditions. If you need to start or restart a server using an option that you know you will need only for the next test, you can add the option to the command line invocation of the start or restart scripts.

  [Read more...]
MySQL Sandbox and Summer of Code 2009
+0 Vote Up -0Vote Down

As you may have seen, MySQL Sandbox is improving, but there are still many features to be implemented.
If you know Perl - or you want to convert the Sandbox into another portable language - and you want to help with the new development, you may consider getting into Google Summer of Code under MySQL mentorship. To apply, you must be a student, and accept the program terms.
sbtool - a new advanced entry in the MySQL Sandbox toolkit
+0 Vote Up -0Vote Down

MySQL Sandbox 2.0.17 introduces a new item in the toolkit. sbtool is a multi-purpose tool for advanced tasks with MySQL sandboxes.
Most notables: assigned and used port detection, port range detection, replication tree, copying and moving sandboxes.


./sbtool --help
usage: ./sbtool [options]
-o --operation (s) - what task to perform
'info' returns configuration options from a Sandbox
'copy' copies data from one Sandbox to another
'ports' lists ports used by the Sandbox
'tree' creates a replication

  [Read more...]
MySQL Sandbox 2.0.13 with improved features
+0 Vote Up -0Vote Down

MySQL Sandbox 2.0.13 was just released, with two main improvements.
  • Now the sandbox looks for gtar before looking for tar. If it is installed, it uses it. This allows the Sandbox successfully expanding and installing from a tarball on Solaris, where the native tar tool has always been source of problems for MySQL.
  • The start and restart scripts now accept a parameter. Anything passed to them from the command line will be added to mysqld_safe invocation. This allows quick tests with unusual parameters, without need of changing the configuration file.


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

John Goulah wrote a nice quick tutorial to MySQL Sandbox.
Thanks, John!
Circular Replication Implementation / Testing using MySQL Sandbox
+0 Vote Up -0Vote Down

This is a simple mysql circular replication implementation on a single machine (just a proof of concept) which can easily be done on a broader scale. Just be aware of the cons of circular replication which mainly gets down to: once a node freaks out or stops for one reason or the other, it’s a bitch and you need to take care of IMMEDIATELY.

Download Sandbox from https://launchpad.net/mysql-sandbox/+download
Download MySQL from http://dev.mysql.com/downloads

Copy the downloaded software onto the your *nix box onto any folder of your preference called $BASEDIR



gunzip mysql_sandbox_X.X.XX.tar.gz
tar -xf mysql_sandbox_X.X.XX.tar

ln -s mysql_sandbox_X.X.XX sandbox

time /$BASEDIR/sandbox/make_replication_sandbox –circular=4 –topology=circular

  [Read more...]
New ideas about MySQL Sandbox at the Boston meetup
+0 Vote Up -0Vote Down

Presenting a topic to a new audience is a two ways learning experience. The attendees learn what the presenter came prepared to say, and in presence of an attentive audience, the presenter can learn something on the spot.
During today's Boston MySQL meetup, I got two interesting ideas aboou how to improve MySQL Sandbox.

  • Using the Sandbox as a test for the future production environment is useful. But it would be even more useful if there were a simple way of transferring the contents of a well tested Sandbox to the main server, or transferring the setup of a successfully tuned replication

  [Read more...]
MySQL University on MySQL Sandbox
Employee +0 Vote Up -0Vote Down

Today, Giuseppe Maxia gave a presentation on MySQL Sandbox. This was our second MySQL University session using the new conferencing system, Dimdim.

Most attendees arrived in time, but like with any real-life university, some arrived late, and some left during the session. We had an average of 16-17 attendees, and a peak of 19.

Giuseppe presented using a slide set, rather than using the desktop sharing facility that Dimdim offers. Clicking through slides feels real-time, while desktop sharing requires some time for changes to arrive on the receiving end (as we've experienced with the previous session). Also, clicking through slides requires virtually no bandwidth (after

  [Read more...]
MySQL University - Quick and easy testing with MySQL Sandbox
+0 Vote Up -0Vote Down

As announced by Stefan Hinz, our tireless documentation leader, we are using a new system for MySQL University.
With DimDim, we can have more fluid and interactive presentations. Unlike the previous homegrown system, you don't need to download the slides, which will be shown to you by the presenter. There is

  [Read more...]
Introducing the MySQL community-driven Replication Monitoring Tools
+0 Vote Up -0Vote Down

If you are using MySQL replication, you know how hard is to monitor it properly.
You have a wide choice of commercial and free tools, all of which check the health of your replication system from the outside.
A few years ago, I wrote an article advocating a self-monitoring and self-healing replication system, using new features in MySQL 5.1. At the time, there were some missing technology pieces to make this project feasible. Now the pieces exist, and you can create your own self monitoring replication system.

Hartmut rules!

It started during

  [Read more...]
Test stressing OpenSolaris with MySQL
Employee +0 Vote Up -0Vote Down

Over the last months I have seen some impressive presentations about Open Solaris, and I wanted to give it a try.

The live CD provided with opensolaris 2008.05 is very easy to install, and so I set it up in a virtual machine.

The environment looks familiar for a seasoned Linux user, and thus I decided to use it as a test bed for my MySQL Sandbox, which includes a test suite that lets you run a complete test with little effort.

Well, little effort for you, maybe, but not for the operating system. The test puts a lot of stress on the operating system, as you can see from this picture.

Running a complete test for a single

  [Read more...]
MySQL Sandbox 2.0 has been released
+0 Vote Up -0Vote Down

Taking advantage of Launchpad excellent development services, I completed the tasks necessary to release MySQL Sandbox 2.0.
So, you may ask, what's new? Quite a lot, actually:
  • more intuitive script names
  • master sandbox directory
  • faster
  • supports circular replication
  • more error checking
  • includes a test suite
  • uses a default options file

more intuitive script names

One of the problem in the old sandbox was that the names of the scripts suggested some installation of the sandbox

  [Read more...]
MySQL Sandbox University lesson - June 12, 14:00 GMT
Employee +0 Vote Up -0Vote Down

On Thursday, June 12, at 15:00 CEST (14:00 GMT), there will be a MySQL University Lesson on MySQL Sandbox, a tool to install one or more side server in a few seconds.

To attend the lesson, follow the instructions for attendees and download the recommended material.

MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia
+0 Vote Up -0Vote Down

Here are my liveblogging notes from MySQL Sandbox: Easily Using Multiple Database Servers in Isolation by Giuseppe Maxia

Giuseppe has been a community member since 2001, and in the past year or so, a MySQL Employee.

He likes to give things away for free — he gave away T-shirts to the early arrivers to the workshop, and that’s why he’s giving away the sandbox as well. The sandbox is NOT an official MySQL product. It is released from GPL, available from http://sf.net/projects/mysql-sandbox.

Why the sandbox? To be able to set up 1 server in under 10 seconds. And to be able to set up multiple MySQL instances very

  [Read more...]
Previous 30 Newer Entries Showing entries 31 to 57

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.