In my previous post I introduced materialized view concepts. This post begins with an introduction to change data capture technology and describes some of the ways in which it can be leveraged for your benefit. This is followed by a description of FlexCDC, the change data capture tool included with Flexviews. It continues with an overview of how to install and run FlexCDC, and concludes with a demonstration of the utility.

As a reminder, the first post covered the following topics:

1. What is a materialized view(MV)?
2. It explained that an MV can pre-compute joins and may aggregate and summarize data.
3. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data.
4. Keeping MVs up-to-date (refreshing) is …

TokuDB is a transactional, fully ACID-compliant storage engine that uses fractal trees for data and indexes, instead of MySQL's standard B-tree implementation. Combined with TokuDB's message-based architecture, TokuDB data and indexes do not fragment, have completely online column and index addition and removal and unlike InnoDB and XtraDB, do not fall apart when indexes no longer fit into memory.

We spoke with Martin Farach-Colton, co-founder and Chief Scientist of Tokutek about the TokuDB storage engine, including the new features in TokuDB 5.0, which was announced on Tuesday.

read more

You might be asking what is SQLHJALP?  Well to put it simply is it SQL and the Swedish word for help. Which is correctly spelled "hjälp".  What does a Swedish word and SQL have to do with each other? Well I would hope that answer was simple, but if it is not, it relates to the MySQL database, which was first developed from Sweden. I have been using this open source database for ten plus years now.

I have spent these years working on proprietary software platforms all using LAMP stacks. While I cannot expose the proprietary software code I am more than willing to help with MySQL and LAMP issues when I can. The past years I have done this  within companies.  I would never call myself a expert as that would imply to me that I have given up learning more.  I would enjoy learning from you as you might also learn from me.

I have primarily been working with Linux (CENT OS), PHP, PERL and MySQL …

Red Hat grows revenue 20%+. Google withholding Honeycomb source code. 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.”

# Red Hat reported Q4 revenue up 25% to $245m, FY revenue up 22% to $909m

# Google is withholding the source code to Honeycomb for the foreseeable future.

# Rick Clark explained why he left Rackspace amid concerns that the company is exerting too much control over OpenStack.

# DataStax …

Going on with our MySQL Cluster studies, now I am starting this new post to talk or write about the Storage or Data Nodes, that one is responsible to storage all cluster data. When we start a cluster (as you have read at MySQL Cluster First Topics), the first step is to start the Management [...]

Big Data + Big Ideas = Big Advantage

“Big Data” is the new buzzword in IT. Doing a Google search will yield over 1M hits. In Boston, there were two back-to-back Big Data events last month. On Wednesday in New York, there was another Big Data event.

Of course, everyone has an opinion on Big Data. And while size of data is always top of mind, there were some interesting discussions around the time component of Big Data – specifically, how fast data comes in and how fast one can respond to it.

Here’s a sampling of some of the interesting discussions (which was in our Twitter stream during the show):

The Need for Speed: Sample of Real World Data Rates

…

Conference season is rapidly approaching and the MySQL Cluster product team will be out on the road, sharing the latest and greatest news on best practices, use-cases and developments.  These will be valuable sessions for users who to learn more about building write-scalable, real-time transactional services with 99.999% availability, using a variety of SQL and Non-SQL (dare I say "NoSQL") interfaces to their data.

Collaborate Community Conference
Starting with the Collaborate IOUG community conference, these are some of the sessions that will be of particular interest to Oracle users:

-    The State of MySQL, 09:15 - 10:15, Monday April 11th to be delivered by Tomas Ulin, VP of the MySQL Engineering Team who will discuss the strategy for MySQL product development, including directions for MySQL Cluster.

…

Conference season is rapidly approaching and the MySQL Cluster product team will be out on the road, sharing the latest and greatest news on best practices, use-cases and developments.  These will be valuable sessions for users who to learn more about building write-scalable, real-time transactional services with 99.999% availability, using a variety of SQL and Non-SQL (dare I say "NoSQL") interfaces to their data.

Collaborate Community Conference
Starting with the Collaborate IOUG community conference, these are some of the sessions that will be of particular interest to Oracle users:

-    The State of MySQL, 09:15 - 10:15, Monday April 11th to be delivered by Tomas Ulin, VP of the MySQL Engineering Team who will discuss the strategy for MySQL product development, including directions for MySQL Cluster.

…

I am working for this small "not-really-a-travel-agency" in Amsterdam for almost 3 years now (Booking.com is part of the Priceline Group of Companies): We are reserving hotels rooms for guests using a website, and we sleep several hundred thousand people, each night.

To accomplish that we are operating a three-digit number of MySQL database servers on CentOS in about three dozen replication hierarchies, automating system administration as good as possible using puppet. Our developers are abusing these boxes using Apache and mod_perl. Because we are still growing faster than the market, we are looking for multiple MySQL DBAs. The positions are based in Amsterdam, NL and Cambridge, UK.

An applicant should have multiple years of experience with MySQL, with a focus on InnoDB, replication and partitions. Good working knowledge of …

Hi Folks,

I changed the license on Xtrabackup Manager from GPLv3 to GPLv2 today. This should make it more compatible with the MySQL Ecosystem.

If anyone has any objections, advice, comments -- please let them fly :)

Meanwhile, testing and work continue...

Cheers,
Lachlan