Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский
Showing entries 1 to 20 of 18599 Next 20 Older Entries
MySQL Conference 2010 - The call for participation is open
Employee +3 Vote Up -0Vote Down

MySQL Conference 2010

The MySQL Conference 2010, with Sun Microsystems as founding sponsor, has opened its Call for participation.
There is already an impressive lineup of tutorials, and I don't say that only because I am on that list. You will find the usual suspects (Replication, Cluster, Certification) and several new ones: Partitioning (covering 5.5), Drizzle replication plugins and core development, Dual master setup, Scaling Applications, Diagnosing and fixing performance, Inspecting variables,
  [Read more...]
When is MySQL going to get a global transaction ID in the binary log?
+1 Vote Up -0Vote Down
MySQL 5.5 includes a number of features first implemented by the "Google patch", but in a different way. One feature in the patch that is still missing from 5.5 appears to be a monotonically increasing transaction identifier in the binary log.

I'm wondering where this feature is on the roadmap, and if we are likely to see it in one of the upcoming milestones?
EOL of MySQL Query Browser, MySQL Administrator, MySQL Migration Toolkit
Employee_Team +0 Vote Up -0Vote Down

With the beta releases of MySQL Workbench 5.2 well under way, we recently announced the EOL (http://www.mysql.com/support/eol-notice.html) of the MySQL GUI Tools Bundle.

The MySQL Tools team has been working on MySQL Workbench 5.2 to give DBAs and developers an integrated tools environment for:

  • Database Design & Modeling
  • SQL Development (replacing MySQL Query Browser)
  • Database Administration (replacing MySQL Administrator)

MySQL Workbench 5.2 also provides:

  • Remote Administration (using SSH-Tunneling)
  • Python scripting and plugins
  • Native GUI for Windows, Mac, Linux

A future release of MySQL Workbench (post 5.2) will add a migration plugin, providing features comparable to the MySQL Migration Toolkit component of the MySQL GUI Tools Bundle.  We will also be adding

  [Read more...]
Loading dynamic plugins at start-up in drizzle
Employee +3 Vote Up -0Vote Down

The re-enabling of the dlopen()-based dynamic plugin loading has hit the Drizzle trunk. This means that plugins can now be built as shared modules and loaded at will on server startup. We still do not support dynamically loading a plugin in a running server via the LOAD PLUGIN command, nor will we until this can be done without re-introducing global mutexes.

Since this is a feature we turned off a while ago, but that was there before, why mention it? There have been several changes to the system that I thought would be handy to mention.

First of all, Drizzle has a crap-ton of plugins and the numbers are only growing. In the tree now, the default is to build any of them we are able to, and to build them all as shared modules, rather than statically linking them into the server.  Then, from the list of built and available plugins, there is a default list of plugins that should be loaded if no other options

  [Read more...]
CAOS Theory Podcast 2009.12.18
+0 Vote Up -0Vote Down

Topics for this podcast:

*2009 review and 2010 preview
*New CAOS survey and report – Climate Change
*Ups and downs in new round of GPL lawsuits
*Oracle-Sun-MySQL saga continues

iTunes or direct download (30:00, 6.9 MB)

MySQL Workbench 5.2.11 Beta 3 Available
Employee_Team +3 Vote Up -0Vote Down

Dear MySQL Users,

We are proud to announce public Beta 3 of MySQL Workbench 5.2.

First off, again a big “Thank You” to all the people who have been testing MySQL Workbench 5.2 alphas and betas and taking the time to file bugs and provide valuable feedback. We have fixed another pile of bugs and included some minor changes in some of the workflows. We have upgraded our linux packages and are now serving packages for Fedora 12 and Ubuntu 9.10.

This build includes fixes for 54 bugs – 9 P1, 28 P2 and 17 P3.

MySQL Workbench 5.2 Beta 3 provides:

  1. Data Modeling
  2. Query (upgrade from MySQL Query Browser)
  3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench

As

  [Read more...]
451 CAOS Links 2009.12.18
+0 Vote Up -0Vote Down

Shuttleworth steps down as Canonical CEO. Open source at SAP. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

For the latest on Oracle’s acquisition of MySQL via Sun, see Everything you always wanted to know about MySQL but were afraid to ask

# Mark Shuttleworth explained why he is stepping down as CEO of Canonical.

# Groklaw published The EU and Microsoft Settle Browser Issue; Interoperability with FOSS Still a Problem.

# Erwin

  [Read more...]
Log Buffer #173
+0 Vote Up -0Vote Down

Nicklas Westerlund has published the 173rd edition of Log Buffer, the weekly review of database blogs, on SELECT mysqlgenie FROM lamp;.

Log Buffer will be off next week for the holidays, and back early in 2010 to begin another year of presenting the best of database blogs. Please get in touch with the Log Buffer coordinator if you’d like to publish an edition of your own.

Happy Holidays to everyone! Here is Log Buffer #173.

InfiniDB test scripts updated to include HAVING tests
+0 Vote Up -0Vote Down

With the release of InfiniDB 0.9.5.3 that includes HAVING functionality, the test scripts have been updated to include HAVING tests as well.  Updated UNION tests and RENAME tests have also been included.  You may download these new 0.9.5.3 test scripts here.

Log Buffer #173: a Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

Time keeps on moving and we’re now only one week from Christmas, when people spend time with their families and loved ones. But, that is in a week, today it is time for a new edition of Log Buffer, where we catch up on database blogs from across the world, starting with SQL Server.

SQL Server
Over at Less Than Dot Ted Krueger brings up the question of the good, the bad and the ugly of database design where he says “In my career I have seen the ugly and then the really ugly but I found on this particular implementation it could get even uglier.”

Over at

  [Read more...]
MySQL Replicant: a library for controlling replication deployments
Employee +1 Vote Up -0Vote Down
Keeping a MySQL installation up and running can be quite tricky at times, especially when having many servers to manage and monitor. In the replication tutorials at the annual MySQL Users' Conference, we demonstrate how to set up replication appropriately and also how to handle various issues that can arise. Many of these procedures are routine: bring down the server, edit the configuration file, bring the server up again, start a mysql client and add a user, etc.

It has always annoyed me that these procedures are perfect candidates for automation, but that we do not have the necessary interfaces to manipulate an entire installation of MySQL servers.

If there were an interface with a relatively small set of primitives—re-directing servers, bringing servers down, add a line to the configuration file, etc.—it would be possible to

  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On Mandriva 2010.0 (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Mandriva 2010.0 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on a Mandriva 2010.0 server with PHP5 support (mod_php) and MySQL support.

MariaDB Buildbot configuration file published
+1 Vote Up -0Vote Down

I have now published the Buildbot configuration file that we use for our continuous integration tests in our Buildbot setup. Every push into main and development branches of MariaDB is built and tested on a range of platforms to catch and fix any problems early (and we also test MySQL releases before merging to easily see whether any new problems already existed in MySQL or were introduced by something specific to MariaDB).

The configuration is included in the Tools for MariaDB Launchpad project.

Now, the Buildbot configuration file is not something that most MariaDB users will

  [Read more...]
Former MySQL CEO represents Oracle at EC hearing?
+2 Vote Up -11Vote Down

I just came across several blog posts regarding the Oracle/Sun/MySQL war, including this one. There are a lot of interesting clarifications and opinions, but I want to highlight this comment from MySQL's founder Monty about Mårten Mickos which is worth reading. One excerpt:

That could however explain why he [Mårten] is now so eager to help Oracle buy MySQL and even represented Oracle at the EC hearing.

MySQL's former CEO representing Oracle in the EC hearing? Is it because Mårten converted to the dark side of the planet or is it because he believes MySQL will have a great future under Oracle's umbrella? Or has it to do with stock options as Monty's comment suggests?

MySQL Memory Usage Limits on 32 bit Linux
+0 Vote Up -0Vote Down
I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the maximum capacity of the address space is 2^32 bytes and that is where these limits come from. * For MYSQL 5.0: Following are memory (storage) limits: Max DB size: [...]
MySQL Workbench 5.2 (Beta 5.2.11, published on Friday, 18 Dec 2009)
+0 Vote Up -0Vote Down
MySQL Workbench 5.2 (Beta 5.2.11, published on Friday, 18 Dec 2009)
Where to stick config.h
Employee +2 Vote Up -0Vote Down

I keep running in to issues with how folks use config.h, so I thought I'd clear up any confusion folks have. For those who haven't been following along at home, the autotools (i.e. autoconf and autoheader in this case) generate a file called config.h which contains a bunch of defines to help control the build based on what things exist or don't exist on your system. There are two main rules for this file that lots of folks get wrong:

  1. config.h should ALWAYS be the first thing included by EVERY non-header C/C++ file in your project.
  2. config.h should NEVER NEVER NEVER NEVER NEVER NEVER be installed.

Why?

For the first point, you must ensure that config.h is included first, because it sets behaviors. It must be included before any system headers because it may contain things that control the behavior of the system headers. It

  [Read more...]
Kontrollbase login issue resolved
+0 Vote Up -0Vote Down
If you were wondering why you couldn’t login to your previously working Kontrollbase install in the several hours it was because of the News & Announcements section receiving improperly formatted data from the master news RSS feed, thus breaking the ExtJS DataGrid row data which resulted in an unterminated string literal error. The issue has [...]
Promises, Promises
+3 Vote Up -2Vote Down

I was contacted by Doug Henschen on Monday for an article he was writing for Intelligent Enterprise on Oracle’s just announced promises to the European Commission regarding MySQL.  It turns out Doug was polling all the major open source data warehousing and business intelligence vendors to get our perspectives on the promises, and it appears as if we all had roughly the same response:  “cautious optimism” as Doug put it.

Having invented the industry’s first SQL Chip that improves the performance and scalability of reporting and analytics for MySQL by 10x – 1000x, we have been keenly interested and aware of Oracle’s announced intent to acquire Sun, and along with it MySQL.  While we have architected our product to work with other database management

  [Read more...]
Fixing a MariaDB package bug
+4 Vote Up -0Vote Down

One of the things that I am really happy about in MariaDB is that we have our releases available as apt (and yum for Centos) repositories. This is largely thanks to being able to build this on the OurDelta package build infrastructure (which again builds on things like the Debian packaging scripts for MySQL).

Something like the Debian apt-get package system (which is also used by Ubuntu) is one of the major innovations in the Free Software world in my opinion. Debian has spent many years refining this system to where it is today. Want to run the mysql client, but it isn't installed? Just try to run it on your local Ubuntu host:

    $ mysql
    The program 'mysql' can be found in the following packages:
     * mysql-client-5.0
     * mysql-client-5.1
    Try: sudo apt-get install <selected package>
    -bash: mysql:
  [Read more...]
Showing entries 1 to 20 of 18599 Next 20 Older Entries

Planet MySQL © 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Sun Microsystems, Inc. and does not
necessarily represent the opinion of Sun Microsystem, Inc. or any other party.