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 8

Displaying posts with tag: vertica (reset)

Tungsten University
+1 Vote Up -0Vote Down
posted by Robert Hodges on Thu 10 Jan 2013 06:59 UTC
Tags:
(edit) mysql, Oracle, Replication, cloud computing, tungsten, mariadb, vertica
We have started a new series of webinars at Continuent that we call Tungsten University.  They provide education on Tungsten clustering and replication in handy one-hour chunks.  These are not sales pitches.  Our goal is to provide accessible education about setting up and operating Tungsten without any marketing fluff.

The first Tungsten University webinar entitled "Configure & provision Tungsten clusters" will take place on Thursday January 17th at 10:00 PST.  It will show you how to set up a cluster in Amazon EC2.  There will be a repeat on January 22nd at 15:00 GMT.  We usually record webinars, so you can look at them later as well. 
You do not have to be a customer to


  [Read more...]
Slides from Percona Live London and a Request
+1 Vote Up -0Vote Down
posted by Robert Hodges on Tue 11 Dec 2012 02:18 UTC
Tags:
(edit) mysql, Replication, tungsten, vertica
Percona hosted another excellent Percona Live conference this past December 3-4 in London.  It was my pleasure to deliver 3 talks including the first keynote following Peter Zaitsev.  Percona does a great job of organizing these conferences--this year's London conference was well attended and in an excellent location in Kensington.  My thanks to the entire Percona team for putting this together.

Here are the slides for my talks in case you would like to see them.

Keynote:  Future-Proofing MySQL for the World-Wide Data Revolution -- Covering the greatly exaggerated death of MySQL and design patterns for robust MySQL systems that can last for decades

Talk:  





  [Read more...]
Typical “Big” Data Architecture
+1 Vote Up -0Vote Down
posted by Venu Anuganti on Fri 30 Nov 2012 22:15 UTC
Tags:
(edit) mysql, postgresql, sql, database, scalability, hadoop, data warehouse, MapReduce, hbase, cloudera, NoSQL, vertica, Hive, bigdata, Big Data Architecture, Big Data Warehouse, Data Architecture, Impala, NoSQL and BigData
Here is the typical “Big” data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[...]
MySQL to Vertica Replication, Part 2: Setup and Operation
+0 Vote Up -0Vote Down
posted by Robert Hodges on Mon 04 Jun 2012 06:58 UTC
Tags:
(edit) mysql, Replication, mariadb, vertica, bigdata
As described in the first article of this series, Tungsten Replicator can replicate data from MySQL to Vertica in real-time.  We use a new batch loading feature that applies transactions to data warehouses in very large blocks using COPY or LOAD DATA INFILE commands.  This second and concluding article walks through the details of setting up and testing MySQL to Vertica replication.

To keep the article reasonably short, I assume that readers are conversant with MySQL, Tungsten, and Vertica.  Basic replication setup is not hard if you follow all the steps described here, but of course there are variations in every setup.  For more information on Tungsten check out the Tungsten Replicator

  [Read more...]
MySQL to Vertica Replication, Part 1: Enabling Real-Time Analytics with Tungsten
+0 Vote Up -0Vote Down
posted by Robert Hodges on Mon 04 Jun 2012 06:41 UTC
Tags:
(edit) mysql, Replication, mariadb, vertica, bigdata
Real-time analytics allow companies to react rapidly to changing business conditions.   Online ad services process click-through data to maximize ad impressions.  Retailers analyze sales patterns to identify micro-trends and move inventory to meet them.  The common theme is speed: moving lots of information without delay from operational systems to fast data warehouses that can feed reports back to users as quickly as possible.

Real-time data publishing is a classic example of a big data replication problem.  In this two-part article I will describe recent work on Tungsten Replicator to move data out of MySQL into Vertica at high speed with minimal load on DBMS

  [Read more...]
Replicating Data Now and Then with Tungsten
+1 Vote Up -0Vote Down
posted by Robert Hodges on Sat 19 Nov 2011 07:11 UTC
Tags:
(edit) mysql, Replication, vertica
What do cruise ship management software and data warehouses have in common?  One answer:  they both depend on intermittent data replication.   Large vessels collect data to share with a home base whenever connectivity permits.  If there is no connection, they just wait until later.  Data warehouses also do not replicate constantly.  Instead, it is often far faster to pool updates and load them in a single humongous batch using SQL COPY commands or native loaders.  Replicating updates in this way is sometimes known as batch replication.  Tungsten Replicator supports it quite easily.

To illustrate we will consider a Tungsten master/slave configuration.  (Sample setup instructions

  [Read more...]
451 CAOS Links 2009.08.14
+0 Vote Up -0Vote Down
posted by The 451 Group on Fri 14 Aug 2009 16:32 UTC
Tags:
(edit) mysql, Oracle, links, Linux, Apache, ibm, novell, ogg, opensource, nokia, symbian, Red Hat, 451 group, 451caostheory, 451group, caostheory, matt aslett, mattaslett, matthew aslett, matthewaslett, open-source, The 451 Group, the451group, SugarCRM, Larry Augustin, Zmanda, JasperSoft, maemo, VMWare, OpenSUSE, springsource, talend, free software foundation, nuxeo, joyent, boxee, hippo, Rightscale, alex weid, vertica, autotrader, Éric Barroca, capgemini, commercial open source, dailymotion, debra bowen, falconview, free demo, georgia tech, Peter Fenton, telerik, unix migration, voting systems

Peter Fenton’s open source investment tips. Boxee raises $6m. 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.”

*451 CAOS Links will return on August 25*

Digesting the VMware-SpringSource deal
In the wake of VMware’s acquisition of SpringSource the WSJ examined Peter Fenton’s open source investment portfolio and what he looks for in an open source vendor. Meanwhile Matt Asay noted that VMware’s purchase of SpringSource is the first big acquisition of a company based on an Apache license, while Charles Babcock reported


  [Read more...]
Open source’s role in lowering the barriers to data warehousing
+2 Vote Up -0Vote Down
posted by The 451 Group on Thu 06 Aug 2009 17:45 UTC
Tags:
(edit) postgresql, Oracle, software, Linux, microsoft, sun, opensource, 451 group, 451caostheory, 451group, caostheory, matt aslett, mattaslett, matthew aslett, matthewaslett, open-source, The 451 Group, the451group, Kickfire, Ingres, Infobright, greenplum, netezza, calpont, Teradata, vectorwise, aster data, bizgres, C-store, datallegro, Eigenbase, luciddb, madison, omne, paraccel, vertica

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...]
Showing entries 1 to 8

Planet MySQL © 1995, 2013, 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.