With the build system, repos, patches and launchpad sorted, we can release! First up is a build of 5.0.67, using patchrev d6, for i386/x86_64. This is basically Percona patchset 5 with a few fixes plus the Sphinx storage engine. It even passes the testsuite
Other useful links:
Now, this being a first release into the wild, there are bound to …
[Read more]A whole bunch of people have successfully written plugins for MySQL using the plug-in framework which first appears in MySQL 5.1. On the whole, the simple examples work great, as long as all your code is in one directory. Here is a helpful tip...Inside the plug.in file, you can use MYSQL_PLUGIN_DIRECTORY_<FOO> as an alias to the directory in which your plug.in is located within, where FOO is the
Network.com setup in Vegas, Thumper disk bay, green by Shawn Ferry
As I expected it would, the fact that I used ZFS compression on our MySQL volume in my little OpenSolaris experiment struck a chord in the comments. I chose gzip-9 for our first pass for a few reasons:
I got both those data points with enough granularity to be useful: a 2.12X compression ratio over a …
[Read more]
A while back, Giuseppe pointed out Andrey Zhakov’s implementation of Virtual Columns for MySQL.
Since then, Andrey has ported that code to Drizzle and sent us a message about the Launchpad Tree.
First, the bad news. I waited long enough to actually look at it that the merge was no longer clean. The Drizzle codebase moves pretty quickly, you know. Andrey was wonderful about helping fix those issues, I got it all merged in and tested, and pushed.
Drizzle now has Virtual Columns. w00t.
As a quick aside, I’d like to mention a few things Andrey …
[Read more]
So many engines, and so little to choose from. This is one of our
two major decision points in Drizzle right
now.
Let me explain.
Today we have Innodb, Maria, Falcon, and PBXT.
Simple?
Not really. Innodb is not a single engine, it is three engines.
We have the default one which is shipped. It has been the
wunderkinder for years now but has been showing its age. Go buy a
piece of hardware that has four cores and it quickly becomes
apparent that it is not aging well. There is the Innodb plugin,
and while it delivers on features, performance still …
Want to use Dtrace or ZFS but are unfamiliar with building MySQL on Solaris? Dont panic, its never been easier. Here are the steps that worked for me.
pfexec pkg install ss-dev
export CC=/opt/SunStudioExpress/bin/cc export CXX=/opt/SunStudioExpress/bin/CC export CFLAGS="-xO3" #Your fav compiler flags go here export CXXFLAGS="-xO3" ./configure --with-plugins=innobase,myisam --with-mysqld-libs=-lmtmalloc gmake
Yes, it is that simple. Of course you could just download the binaries and use them too; they work just fine.
Want to use Dtrace or ZFS but are unfamiliar with building MySQL on Solaris? Dont panic, its never been easier. Here are the steps that worked for me.
pfexec pkg install ss-dev
export CC=/opt/SunStudioExpress/bin/cc export CXX=/opt/SunStudioExpress/bin/CC export CFLAGS="-xO3" #Your fav compiler flags go here export CXXFLAGS="-xO3" ./configure --with-plugins=innobase,myisam --with-mysqld-libs=-lmtmalloc gmake
Yes, it is that simple. Of course you could just download the binaries and use them too; they work just fine.
This Thursday, Stewart Smith will give a MySQL University session:
Checking Threading and Locking With Helgrind
Note that this particular session starts 9:00 BST /
10:00 CET /
18:00 Brisbane/Melbourne
Stewart is always enjoyable to listen to, both because he knows his stuff and because he is a really fun guy (heads up for the MySQL Conference 09, the Monty Taylor/Stewart Smith double act at this years conference was one of the most interesting and information sessions I went to).
Please register for this session by filling in your name on the
session
Wiki page. Registering is not required but appreciated. That Wiki
page
also contains a section to post questions. Please use it!
MySQL University sessions normally start at 13:00 UTC (summer) or
14:00
…
Introduction
One of the features that make MySQL so great is its easy replication set-up. If you are experienced and know-how to do it, it takes you about 15 minutes to set-up a slave. What you have in the end is a replication from one master to one or several slaves. So you can build a top-down data stream pyramid and spread your data on many slaves.
From time to time some customers are asking for the other way: Many masters replicating to one slave (which is also called multi-source replication). For this requirement MySQL replication cannot help you directly.
Possibilities
You can circumvent this situation in the following ways:
Find out about Sun's new 4-chip UltraSPARC T2 Plus system direct from the source: Sun's engineers.
Sun today announced the 4-chip variant of its UltraSPARC T2 Plus system, the Sun SPARC Enterprise T5440. This new system is the big brother of the 2-chip Sun SPARC Enterprise T5140 and T5240 systems released in April 2008. Each UltraSPARC T2 Plus chip offers 8 hardware strands in each of 8 cores. With up to four UltraSPARC T2 Plus chips delivering a total of 32 cores and 256 hardware threads and up to 512Gbytes of memory in a compact 4U package, the T5440 raises the bar for server performance, price-performance, energy efficiency, and compactness. And with Logical Domains (LDoms) and Solaris Containers, the potential for server consolidation is compelling.
Standard configurations of the Sun SPARC Enterprise T5440 include 2- and 4-chip systems at 1.2 GHz, and a 4-chip system at 1.4 GHz. All of these configurations come with 8 cores per …
[Read more]