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 中文
Showing entries 1 to 30 of 47 Next 17 Older Entries

Displaying posts with tag: Infobright (reset)

MySQL webinar: ‘Introduction to open source column stores’
+1 Vote Up -0Vote Down

Join me Wednesday, September 18 at 10 a.m. PDT for an hour-long webinar where I will introduce the basic concepts behind column store technology. The webinar’s title is: “Introduction to open source column stores.”

What will be discussed?

This webinar will talk about Infobright, LucidDB, MonetDB, Hadoop (Impala) and other column stores

  • I will compare features between major column stores (both open and closed source).
  • Some benchmarks will be used to demonstrate the basic
  [Read more...]
Tips for working with append-only databases using sharding and log structured tables
+0 Vote Up -0Vote Down

This post is structured like a series of questions and answers in a conversation.  I recently had a number of conversations that all pretty much went this same way.  If you, like others, have many basic questions about how to proceed when faced with an append-only store for the first time, well then hopefully this post will help provide some answers for you.  The post focuses on column stores, the most common append-only store, but there are others.

Why do I want to use a column store?

Column stores are optimal for OLAP analysis

Column stores offer substantial performance increases for OLAP  compared to row stores.  Row stores are optimized for OLTP workloads.  While a row store can be used for OLAP, it may not perform well because a row store has to retrieve every column for a row (unless there is a covering

  [Read more...]
Where are they now: MySQL Storage Engines
+3 Vote Up -0Vote Down

There was once a big hooplah about the MySQL Storage Engine Architecture and how it was easy to just slot in some other method of storage instead of the provided ones. Over the years I’ve repeatedly mentioned how this

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

Apache OpenOffice.org proposal approved. SkySQL Tekes new funding. And more.

# The proposal for OpenOffice.org to become an Apache incubator project was unanimously approved.

# Rob Weir discussed how the relationship between OpenOffice.org and LibreOffice need not be a zero-sum game.

# Simon Phipps offered his thoughts on the potential positive and negative outcomes.

# Tekes, the main public funding agency for research, development, and innovation in Finland,

  [Read more...]
Shard-Query EC2 images available
+1 Vote Up -0Vote Down

Infobright and InnoDB AMI images are now available

There are now demonstration AMI images for Shard-Query. Each image comes pre-loaded with the data used in the previous Shard-Query blog post. The data in the each image is split into 20 “shards”. This blog post will refer to an EC2 instances as a node from here on out. Shard-Query is very flexible in it’s configuration, so you can use this sample database to spread processing over up to 20 nodes.

The Infobright Community Edition (ICE) images are available in 32 and 64 bit varieties. Due to memory requirements, the InnoDB versions are only available on 64 bit instances. MySQL will fail to start on a micro instance, simply decrease the values in the /etc/my.cnf file if you really want to try micro instances.

  [Read more...]
Big Data is how big exactly?
+4 Vote Up -0Vote Down

I see that “Big Data” has become the new buzzword with a spike of hype around it. Everyone’s jumping on it. Companies are eager to promote their products as “Big Data,” just as they were eager to be associated with Web 2.0, Service-Oriented Architectures, and all the rest. Predictably, there’s basically zero agreement on what it means.

I’ve seen “Big Data” mentioned in the context of 1TB, which I think is rather moderate sized. But worse yet, I’ve seen 100GB labeled Big Data. I’ve even seen 5GB labeled Big Data. No links — I don’t want to draw attention to them.

I don’t know what Big Data is, but the stick-of-gum-sized flash drive in my pocket holds 16GB. It’s pretty Small. I mean, I forget it’s even there — it’s definitely not Big. I don’t

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

What’s missing from WebM? VoltDB launches. The importance of profitability. 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.”

# Simon Phipps examined what’s missing from WebM, from an open source perspective.

# Mike Stonebraker’s VoltDB officially launched its open source in-memory OLTP database.

# Jim Whitehurst argued that one of Red Hat’s most valuable contributions to open source is its profitability.

# Infobright appointed former Aleri CEO Don DeLoach as its new president and chief


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

Oracle outlines MySQL plans. Datameer launches with Series A funding. 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.”

# Oracle confirmed InnoDB as the default MySQL storage engine, Hot Backup to become part of MySQL Enterprise and announced MySQL Cluster 7.1.

# Datameer launched Analytics Solution, which combines Hadoop with a spreadsheet interface, and also closed a $2.5m Series A round of funding from Redpoint Ventures.

# Infobright announced that it grew its customers base from 50 to 120 in the last 12 months,


  [Read more...]
451 CAOS Links 2010.02.02
+1 Vote Up -1Vote Down

Oracle’s plans for Sun’s OSS. The UK’s updated OSS strategy. 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.”

Oracle’s plans for Sun’s OSS
# Oracle’s MySQL strategy slide.

# eWeek reported that database thought leaders are divided on Oracle MySQL.

# Savio Rodrigues and Computerworld on Oracle’s plans for MySQL, other open source assets.

# Zack Urlocker is leaving Oracle/Sun/MySQL.

# Red Hat’s Mark Little



  [Read more...]
MySQL vs InfoBright optimizer battle
+0 Vote Up -0Vote Down

MySQL instance running an Infobright engine


mysql> explain SELECT COUNT(ac.UID) FROM ACTIVE ac JOIN ALL a;
+----+-------------+-------+------+---------------+------+---------+------+---------+-------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------+------+---------------+------+---------+------+---------+-------+
| 1 | SIMPLE | ac | ALL | NULL | NULL | NULL | NULL | 124426 | |
| 1 | SIMPLE | a | ALL | NULL | NULL | NULL | NULL | 7594256 | |
+----+-------------+-------+------+---------------+------+---------+------+---------+-------+
2 rows in set (0.01 sec)

mysql> SELECT COUNT(ac.UID) FROM ACTIVE ac JOIN ALL a ON ac.UID=a.UID;
+---------------+









  [Read more...]
Two new open source data warehousing launches
+3 Vote Up -0Vote Down

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

  [Read more...]
Calpont opens up: InfiniDB Open Source Analytical Database (based on MySQL)
+9 Vote Up -0Vote Down
Open source business intelligence and data warehousing are on the rise!

If you kept up with the MySQL Performance Blog, you might have noticed a number of posts comparing the open source analytical databases Infobright, LucidDB, and MonetDB. LucidDB

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

The future of MySQL. The SCO Group terminates Darl McBride. And more.

The future of MySQL
Monty Widenius urged Oracle to give up on MySQL in order to land Sun while Richard Stallman, Knowledge Ecology International (KEI) and the Open Rights Group sent a letter to the EC urging it to block Oracle’s acquisition of MySQL. All of which prompted Florian Mueller, who it should be noted is working with Widenius as part of his campaign, to claim that there is growing public opposition to Oracle owning Sun’s MySQL.

Meanwhile The VAR Guy reported on rumours that


  [Read more...]
Some scaling observations on Infobright
+0 Vote Up -0Vote Down

A couple of days ago, Baron Schwartz posted some simple load and select benchmarking of MyISAM, Infobright and MonetDB, which Vadim Tkachenko followed up with a more realistic dataset and interesting figures where MonetDB beat Infobright in most queries.

Used to the parallel IEE loader, I was surprised by the apparent slow loading speed of Baron's benchmark and decided to try and replicate it. I installed Infobright 3.2 on my laptop (see, this is very unscientific) and wrote a simple perl script to generate and load an arbitrarily large data set resembling Baron's description. I'm not going to post my exact numbers, because

  [Read more...]
Analyzing air traffic performance with InfoBright and MonetDB
+0 Vote Up -0Vote Down

Accidentally me and Baron played with InfoBright (see http://www.mysqlperformanceblog.com/2009/09/29/quick-comparison-of-myisam-infobright-and-monetdb/) this week. And following Baron's example I also run the same load against MonetDB. Reading comments to Baron's post I tied to load the same data to LucidDB, but I was not successful in this.

I tried to analyze a bigger dataset and I took public available data
http://www.transtats.bts.gov/DL_SelectFields.asp?Table_ID=236&DB_Short_Name=On-Time about USA domestic flights with information about flight length and delays.

The data is available from 1988 to 2009


  [Read more...]
Quick comparison of MyISAM, Infobright, and MonetDB
+4 Vote Up -0Vote Down

Recently I was doing a little work for a client who has MyISAM tables with many columns (the same one Peter wrote about recently). The client's performance is suffering in part because of the number of columns, which is over 200. The queries are generally pretty simple (sums of columns), but they're ad-hoc (can access any columns) and it seems tailor-made for a column-oriented database.

I decided it was time to actually give Infobright a try. They have an open-source community edition, which is crippled but not enough to matter for this test. The "Knowledge Grid" architecture seems ideal for the types of queries the client runs. But hey, why not also try

  [Read more...]
What data types does your innovative storage engine NOT support?
+3 Vote Up -1Vote Down

I’ve been investigating a few different storage engines for MySQL lately, and something I’ve noticed is that they all list what they support, but they generally don’t say what they don’t support. For example, Infobright’s documentation shows a list of every data type supported. What’s missing? Hmm, I don’t see BLOB, BIT, ENUM, SET… it’s kind of hard to tell. The same thing is true of the list of functions that are optimized inside Infobright’s own code instead of at the server layer. I can see what’s optimized, but I can’t see whether FUNC_WHATEVER() is optimized without scanning the page — and there’s no list of un-optimized functions.

I don’t mean to pick on

  [Read more...]
A peek under the hood in Infobright 3.2 storage engine
+0 Vote Up -0Vote Down

I've been meaning to post some real-world data on the performance of the Infobright 3.2 release which happened a few weeks ago after an extended release candidate period. We're just preparing our upgrades now, so I don't have any performance notes over significant data sets or complicated queries to post quite yet.

To make up for that, I decided to address a particular annoyance of mine in the community edition, first because it hadn't been addressed in the 3.2 release (and really, I'm hoping doing this would include it into 3.2.1), and second, simply because the engine being open source means I can. I feel being OSS is one of Infobright's biggest strengths, in addition to being a pretty amazing piece of performance for such a simple,

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

Citrix joins the Linux Foundation. BonitaSoft raises $3m. 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.”

# Citrix joined The Linux Foundation.

# Open source BPM vendor BonitaSoft raised $3m from Ventech and Auriga Partners.

# Jaspersoft updated JasperReports Professional with enhanced data visualization.

# US CIO Vivek Kundra outlined the government’s cloud strategy, using NASA’s open source Nebula cloud.

# Infobright claimed to have increased its customer base


  [Read more...]
Infobright Tuning on OpenSolaris/Solaris 10
Employee +1 Vote Up -0Vote Down

Recently I was working on a project which used Infobright as the database. The version tested was 3.1.1 both on OpenSolaris as well as Solaris 10. Infobright is like a column-oriented database engine for MySQL primarily targeted towards data warehouse, data mining type of project deployments.

While everything was working as expected, one thing we did notice that as number of concurrent connections tried to query against the database we noticed that queries deteriorated fast in the sense that not much parallel benefits were being squeezed from the machine. Now this sucks! (apparently sucks is now a technical term). It sucks because the server has definitely many  cores and typically each Infobright query still can at the max peg a core. So the expectation will be typically to atleast handle concurrent queries which is

  [Read more...]
Infobright Tuning on OpenSolaris/Solaris 10
Employee +0 Vote Up -0Vote Down

Recently I was working on a project which used Infobright as the database. The version tested was 3.1.1 both on OpenSolaris as well as Solaris 10. Infobright is like a column-oriented database engine for MySQL primarily targeted towards data warehouse, data mining type of project deployments.

While everything was working as expected, one thing we did notice that as number of concurrent connections tried to query against the database we noticed that queries deteriorated fast in the sense that not much parallel benefits were being squeezed from the machine. Now this sucks! (apparently sucks is now a technical term). It sucks because the server has definitely many  cores and typically each Infobright query still can at the max peg a core. So the expectation will be typically to atleast handle concurrent queries which is

  [Read more...]
Infobright Tuning on OpenSolaris/Solaris 10
Employee +0 Vote Up -0Vote Down

Recently I was working on a project which used Infobright as the database. The version tested was 3.1.1 both on OpenSolaris as well as Solaris 10. Infobright is like a column-oriented database engine for MySQL primarily targeted towards data warehouse, data mining type of project deployments.

While everything was working as expected, one thing we did notice that as number of concurrent connections tried to query against the database we noticed that queries deteriorated fast in the sense that not much parallel benefits were being squeezed from the machine. Now this sucks! (apparently sucks is now a technical term). It sucks because the server has definitely many  cores and typically each Infobright query still can at the max peg a core. So the expectation will be typically to atleast handle concurrent queries which

  [Read more...]
EU Should Protect MySQL-based Special Purpose Database Vendors
+2 Vote Up -0Vote Down
In my recent post on the EU antitrust regulators' probe into the Oracle Sun merger I did not mention an important class of stakeholders: the MySQL-based special purpose database startups. By these I mean:

I think it's safe to say the first three are comparable in the sense that they are all analytical databases: they are designed for data warehousing and business intelligence applications. ScaleDB might be a good fit for those applications, but I think






  [Read more...]
The EC is mostly, but not entirely, wrong about Oracle/MySQL
+2 Vote Up -0Vote Down

By now you are probably aware that the European Commission has decided to launch an extended investigation into Oracle’s acquisition of Sun based on concerns over MySQL.

The new has prompted a lot of criticism of the EC, much of it suggesting that the delay will do considerable harm to Sun (and therefore Oracle). This argument is valid - Sun’s already declining revenue has been in freefall since the deal was announced and one wonders how far it will fall in another 90 days of stasis.

Other criticism, (such as this from Matt Asay) focuses on the suggestion that the delay will do little to help MySQL or its users, and that the EC fails to understand open

  [Read more...]
Open source’s role in lowering the barriers to data warehousing
+2 Vote Up -0Vote Down

As well as contributing to the CAOS research practice here at The 451 Group I am also part of the information management team, with a focus on databases, data caching, CEP, and - from the start of this year - data warehousing.

I’ve covered data warehousing before but taking a fresh look at this space in recent months it’s been fascinating to see the variety of technologies and strategies that vendors are applying to the data warehousing problem. It’s also been interesting to compare the role that open source has played in the data warehousing market, compared to the database market.

I’m preparing a major report on the data warehousing sector, for publication in the next couple of months. What follows is a rough outline of the role open source has played in the sector. Any comments

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

Microsoft makes a patent promise. JBoss is certifiable. 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.”

# Microsoft announced that it will be applying its Community Promise to the ECMA 334 (C#) and ECMA 335 (CLI) specifications, reducing patent concerns related to Mono.

# Red Hat achieved EAL 2+ security certification for JBoss Enterprise Application Platform.

# A European Commission white paper on standards stirred some controversy with regards to open source. The white paper itself is


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

Red Hat betas Enterprise Virtualization, partners with HP for SOA. And more.

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

# Red Hat announced that its Enterprise Virtualization portfolio of products is now available for beta testing.

# Red Hat collaborated with HP on SOA.

# David Megginson published mixing GPL and non-GPL: a different perspective. A new take on the MySQL/MariaDB storage engine debate.

# UK Government CIO shed some light on “G-Cloud” plans and how the new open source policy provides an opportunity.

# WAZI: Freedom and


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

Cloudera lands funding. SourceForge acquires Ohloh. Novell reports Linux growth. And more.

Follow 451 CAOS Links live @caostheory

Cloudera shows signs of progress

GigaOM reported that Cloudera raised $6m Series B funding from Accel and Greylock and is now looking beyond web applications to wider enterprise adoption of Hadoop. Cloudera also announced its first certification program for Hadoop.

Open source goes mainstream in the UK
There have been signs of change recently with regards to open source adoption in the UK, which has traditionally lagged behind the rest of Europe and the US. CBR Magazine provided an analysis of open source in the UK




  [Read more...]
Are closed-source MySQL storage engines compatible with MariaDB?
+0 Vote Up -0Vote Down

Following the launch of the Open Database Alliance some people have assumed that it is only a matter of time before MariaDB becomes the de facto replacement for MySQL.

That assumes that Oracle will allow the development of MySQL to stagnate, either deliberately or through neglect - something that we have expressed our doubts about, but even if that were the case it appears that the GPL (or more to the point MySQL’s dual licensing strategy) may restrict the potential for MariaDB.

Curt Monash recently raised the question of whether closed-source storage engines can be used with MySQL (and, by

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

Oracle buys Sun. Sun previews MySQL update, makes GlassFish Portfolio, OpenSSO and OpenDS available on EC2. Numerous partner announcements from the MySQL conference. Red Hat maps open source adoption. And more.

Follow 451 CAOS Links live @caostheory

Oracle to acquire Sun
Unless you’ve been living under a rock (or like me you decided to take a few inappropriately-timed days off) you probably noticed that Oracle announced an agreement to acquire Sun this week. Jay delivered our assessment on Oracle’s open source credentials, while I followed up with some

  [Read more...]
Showing entries 1 to 30 of 47 Next 17 Older Entries

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.