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 20

Displaying posts with tag: infinidb (reset)

Using InfiniDB MySQL server with Hadoop cluster for data analytics
+1 Vote Up -0Vote Down

In my previous post about Hadoop and Impala I benchmarked performance of analytical queries in Impala.

This time I’ve tried InfiniDB for Hadoop (open-source version) on the modern hardware with an 8-node Hadoop cluster. One of the main advantages (at least for me) of InifiniDB for Hadoop is that it stores the data inside the Hadoop cluster but uses the MySQL server to execute queries. This allows for an easy “migration” of existing analytical tools. The results are quite interesting and promising.

Quick How-To

The InfiniDB documentation is not very clear on step-by-step instructions so I’ve created this

  [Read more...]
New MySQL & MariaDB Instructional Videos from SkySQL
+3 Vote Up -0Vote Down

Are you looking to expand your knowledge about MySQL and MariaDB database solutions?

Well, you’re in luck! SkySQL is introducing an exclusive collection of educational videos featuring some of the industry’s leading experts on the MySQL database and related technologies. View informative, technical talks on a variety of topics, from the experts at SkySQL, MariaDB, Calpont InfiniDB, Continuent, ScaleDB, Severalnines, Sphinx, Webyog, and others.

read more

Vote for MySQL[plus] awards 2011 !
+5 Vote Up -0Vote Down

First of all, I wish you a happy new year.
Many things happened last year, it was really exciting to be involved in the MySQL ecosystem.
I hope this enthusiasm will be increased this year, up to you !

To start the year, I propose the MySQL[plus] Awards 2011
It will only take 5 minutes to fill out these polls.
Answer with your heart first and then with your experience with some of these tools or services.

Polls will be closed January 31, so, vote now !
For “other” answers, please,  let me a comment with details.

Don’t hesitate to submit proposal for tools or services in the comments.

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

Oracle increases MySQL pricing. Jono Bacon wants some respect. And more.

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

# Oracle increased the prices for MySQL and rejigged its editions.

# A good overview of the resulting MySQL pricing hubbub from @tiensoon

# SkySQL named first customers in open letter to Oracle MySQL customers.

# Actuate reported over $5.1m in BIRT-related business for Q3, up 8% YoY.

# Actuate

  [Read more...]
Calpont InfiniDB 2.0 and BI QuickStarts
Employee +1 Vote Up -1Vote Down
The 2.0 release of Calpont InfiniDB
is ready for download. New features for the columnar database storage engine for MySQL include data compression, fully parallelized & scalable UDFs, and partition drop has been added to the automatic vertical & horizontal data partitioning.

    Benefits of InfiniDB Enterprise 2.0
  • 20-50% query performance improvement when reading from disk
  • Distributed in-database calculations provide greater flexibility to the data analyst, and enable faster performance for deep analytics
  • Removing obsolete data from the database quickly frees up disk storage and improves query response

And for those of you new to data warehousing and business intelligence, there are QuickStart for

  [Read more...]
Open Source BI -- Pentaho and Jaspersoft Part I
Employee +1 Vote Up -0Vote Down
Hey DBAs! Are you seeking more efficient ways of shifting through your data to aid your business operations? Two popular Business Intelligence products have community Open Source software are Pentaho and JasperSoft. And both work with MySQL.

Both are easy to download and install. Both will use a JDBC connector to connect to MySQL. But how easy are the two to configure and run a simple report against a running instance of MySQL?

Setting up a JDBC connection with JasperSoft or Pentaho is pretty much like using any other JDBC connection.

  [Read more...]
InfiniDB 1.5 Final is Now Available!
+0 Vote Up -0Vote Down

I am very excited to announce that the the FINAL 1.5 version of the InfiniDB Community Edition is now available for use.  Thanks to everyone in the community for helping us through the alpha, beta, and RC cycles to the 1.5 release of InfiniDB.

We've put a lot of hard work into this release and we've come a long way since 1.0. Here's a reminder of a few of the features that have been added since 1.0:

High-speed subqueries. 
Support for running on...
Doing your own on-time flight time analysis Part III
Employee +2 Vote Up -0Vote Down
In the last post, the data from the on-time flight database was loaded in a column-orientated storage engine. Now the numbers can be crunched.

The original goal of this exercise was to find the flight from Los Angeles International Airport, LAX, to Dallas Fort Worth International Airport, DFW, that was the most likely to arrive on-time.

The data is 'opportunity rich' in that there is a lot information in there. It is easy to start wondering about the various nuggets of information in there. Are their certain aircraft (tail numbers) that are routinely bad performers? Are some days of the week better than others? Do national holidays have an effect on the on-time performance? If you are delayed, is there a 'regular amount' of delay? Does early departure make for an early arrival? Can the flight crew make up for a late departure? How much time is

  [Read more...]
Anybody have a few millions lines of Apache Log files they can share?
Employee +0 Vote Up -0Vote Down
Anybody have a few millions lines of Apache Log files they can share? I am working on a lab/demo on InfiniDB and need a few millions lines of an Apache HTTPD log file. I no longer run any large websites and would rather use real data over creating something. I will sanitize your URL so you will be anonymous, so www.YourCompanyHere.com will end up as www.abc123.com or something similar.

The demo/lab will show how to load data into the columnar InfiniDB storage engine and run some analytics against the data. Please let me know if you can help.
InfinDB Extent Maps saving I/O
Employee +1 Vote Up -0Vote Down
InfiniDB uses Extent Maps to retrieve data. Data is stored in extents and each extent is a logical block of space that holds the same number of rows.

The Extent Map catalogs all extents and their corresponding blocks. The Extent Map also maintains minimum and maximum values for a column’s data within an extent.

The Extent Map lets InfiniDB to retrieve only the blocks needed to satisfy a query. There is another benefit – that of logical range partitioning. This is accomplished via the minimum and maximum values for each extent that are contained within the Extent Map. Extent elimination is first accomplished in InfiniDB via the column-oriented architecture (only needed columns are scanned), but the process is

  [Read more...]
InfiniDB Alpha 1.1.2 on 64-bit Windows and MySQL Workbench
Employee +1 Vote Up -0Vote Down
This week has been rough on my computers and I had to reinstall Vista on my main Windows system. But being a 'glass half full' guy, I took it as an opportunity to load the new alphas for both InfiniDB and MySQl Workbench.

I downloaded the InfiniDB software from http://infinidb.org/downloads/cat_view/40-binary-release/137-112-alpha-binary-releases and Workbench from http://dev.mysql.com/downloads/workbench/ respectively. In stalled them in that order and started the database and then Workbench.

I was expecting to have to fiddle with configuring one or the other to get them to work together. But I received a delightful surprise. Both worked out of the chute with no customization. Congratulations to the folks writing the install scripts at both companies!
Getting started with InfiniDB Part I
Employee +3 Vote Up -0Vote Down
My new job with Calpont has me scrambling to learn all the facets of the InfiniDB storage engine. For those of you new to the scene, InfiniDB is column-orientated as opposed to row-orientated and is designed for data warehouses and business intelligence. Most MySQL DBAs are probably not used to thinking sideways and hopefully this series of postings will change that.

To make things interesting, I am using real data from BP's Statistical Review of World Energy 2009. The data is a historical information on various forms of energy. And it is free to download and comes in Excel workbook format. I wanted data that was unfamiliar to me and in a format that would be commonly used in a BI setting.

The first step is to

  [Read more...]
No North Texas Users Group Meeting in May, new job
Employee +2 Vote Up -0Vote Down
There will not be a May meeting of the North Texas MySQL Users Group but I am scrambling to get us a great location for the June meeting. I have left my Job with MySQL/Sun/Oracle and am no longer responsible for MySQL Certifications. That means my access to the Sun office were we have been meeting is ended also.

I am now the Customer Service Manager for Calpont and the InfiniDB storage engine. InfiniDB is column based, multi-threaded, and the community edition is open source. If you run intensive reports against InnoDB or MyIsam databases, you need to investigate this product. And if you regularly run massive queries in data warehousing or business analytic operation that you need to see how the massively parallel process architecture of the enterprise product can make life

  [Read more...]
Log Buffer #182, a Carnival of the Vanities for DBAs
+3 Vote Up -0Vote Down

This is the 182nd edition of Log Buffer, the weekly review of database blogs. Make sure to read the whole edition so you do not miss where to submit your SQL limerick!

This week started out with me posting about International Women’s Day, and has me personally attending Confoo (Montreal) which is an excellent conference I hope to return to next year. I learned a lot from confoo, especially the blending nosql and sql session I attended.

This week was also the Hotsos Symposium. Doug’s

  [Read more...]
InfiniDB gets the release process right
+8 Vote Up -4Vote Down

InfiniDB has a sensible Enterprise/Community release process, which seems similar to what I suggested for MySQL. Its simplicity also stands in stark contrast to MySQL’s new release policy, which is hard to understand and has been confusing people.

Related posts:

  • Thank you for the MySQL 5.4 Community Release MySQL 5.4
  • How to find per-process I/O
  •   [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...]
    InfiniDB test scripts updated to include HAVING tests
    +0 Vote Up -0Vote Down

    With the release of InfiniDB 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 test scripts here.

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

    With the release of InfiniDB 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 test scripts here.

    451 CAOS Links 2009.10.30
    +0 Vote Up -0Vote Down

    Government adoption. Financial results. New 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.”

    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

    Government approval
    The US Department of Defense issued guidance on the adoption of open source software, while ComputerWorld reported that the U.S Department of Defense has open-sourced an enterprise

      [Read more...]
    Interview with Robin Schumacher Discussing Calpont's InfiniDB
    Employee +7 Vote Up -1Vote Down
    I got a chance to sit down with Calpont's new VP of Products, Robin Schumacher last week to discuss the announcement of their new open source column-oriented database, InfiniDB. To listen to the interview, click on the embedded link below.

    Robin has also posted part one of a two part technical article on InfiniDB in the DevZone. You can check out the article here.

    You can also get "up close and personal" with InfiniDB when Robin delivers a free webinar on the advantages of column oriented databases for analytics, high performance query systems and data warehousing next month. Register here (http://www.mysql.com/news-and-events/web-seminars/display-459.html).

    For more info on what Calpont is up to with InfiniDB, check out their community .org site here.
    Showing entries 1 to 20

    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.