Just a quick note to let you know that Part 2 of my Intro to InfiniDB article is now live on the MySQL dev zone... Let me know if you have any questions or comments.

In the article ‘An alternative way of EAV modelling’, I discussed how to do EAV modelling by casting all values (except text) to integers. I’ll continue on that and talk about more advanced topics like multi-value fields.

As binary set
Not all questions have only a single option. Some fields we want to represent by radio-buttons, allow the user to select any number of options. For this we can mimic the behaviour of the SET field type of MySQL. A SET is almost similar to an ENUM, except that each bit represents an option. The value can have multiple bits enabled to represent multiple options.

Example: field options for field ‘programming language’

+-------+-------------+
| value | description |
+-------+-------------+
| 1     | C/C++       |
| 2     | PHP         |
| 4     | Java        |
| 8 …

On Thursday, November 29th (tomorrow) Padraig O'Sullivan, a graduate student and Drizzle team member extraordinaire and amazing developer who has worked on a number of projects both for Drizzle and libmemcached-- and who also helped me get the memcached functions for Drizzle off the ground is giving a webinar on the C++ API to libmemcached. As the site mentions, this webinar will explain the the functionality of memcached and how it can be used to scale applications, providing a "technical deep dive" into libmemcached's C++ interface. Also, presented will be the current status of the memcached (as well as libmemcached) project, future development goals and how to participate in the memcached community, something Dustin has recently posted about.

SilverStripe is a open source content management system(CMS) to create and
maintain website, it is currently published to the OpenSolaris /contib repository.

Installation of SilverStripe on OpenSolaris is straightforward by simply clicking
the installation button on the silverstrip's 'install.php' page,
however, the installation didn't work complaining with mysql query
execution failed:

"[User Error]  Couldn't run query: SELECT `SiteTree_Live`.\*,
`GhostPage_Live`.\*, `ErrorPage_Live`.\*, `RedirectorPage_Live`.\*,
`VirtualPage_Live`.\*, `SiteTree_Live`.ID,
if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS
RecordClassName FROM `SiteTree_Live` LEFT JOIN …

SilverStripe is a open source content management system(CMS) to create and
maintain website, it is currently published to the OpenSolaris /contib repository.

Installation of SilverStripe on OpenSolaris is straightforward by simply clicking
the installation button on the silverstrip's 'install.php' page,
however, the installation didn't work complaining with mysql query
execution failed:

"[User Error]  Couldn't run query: SELECT `SiteTree_Live`.\*,
`GhostPage_Live`.\*, `ErrorPage_Live`.\*, `RedirectorPage_Live`.\*,
`VirtualPage_Live`.\*, `SiteTree_Live`.ID,
if(`SiteTree_Live`.ClassName,`SiteTree_Live`.ClassName,'SiteTree') AS
RecordClassName FROM `SiteTree_Live` LEFT JOIN …

I would like to welcome everyone to the new InfiniDB CE home at InfiniDB.org!

We have been working hard on creating this community to be both informative, easy to navigate and built with functionality to let all of the users have and give their feedback. If there is any sugestions you may have please stop by the forum and make a post in the "Suggestion Box".

To get to the forums, just go to the dropdown menu under "Community" and it is the first link you will see - "Forums".

Read More...

I would like to welcome everyone to the new InfiniDB CE home at InfiniDB.org!

We have been working hard on creating this community to be both informative, easy to navigate and built with functionality to let all of the users have and give their feedback. If there is any sugestions you may have please stop by the forum and make a post in the "Suggestion Box".

To get to the forums, just go to the dropdown menu under "Community" and it is the first link you will see - "Forums".

Read More...

In our recent report on the data warehousing market we speculated that there would soon be a change in the number of vendors operating in what is a crowded market. We were anticipating that the number of vendors would go down, rather than up, but - in the short term at least - we have been proved wrong, as two new open source analytical databases emerged this week.

First came the formation of Dynamo Business Intelligence Corp, (aka Dynamo BI), a new commercially supported distribution, and sponsor, of LucidDB. Then came the launch of InfiniDB Community Edition, a new open source analytic database based on MySQL from Calpont.

Read the rest of …

There is a nagios plugin available on the MMM's google-code page, but if you didn't find it yet, here it is:

http://code.google.com/p/check-mysql-all/wiki/check_mmm

You can call this plugin over nrpe. I'm already working on to fork a version which more useful with passive checks.

This plugin was developed by Ryan Lowe (Percona).

We got good responses to the “identify this query profile” question. Indeed it indicates an SQL injection attack. Obviously a code problem, but you must also think about “what can we do right now to stop this”. See the responses and my last note on it below the original post.

Got a new one for you!

You find a system with broken replication, could be a slave or one in a dual master setup. the IO thread is still running. but the SQL thread is not and the last error is (yes the error string is exactly this, very long – sorry I did not paste this string into the original post – updated later):

“Could not parse relay log event entry. The possible reasons are: the master’s binary log is corrupted (you can check this by running ‘mysqlbinlog’ on the binary log), the slave’s relay log is corrupted (you …