Payday Loans no credit check
Site Map 022 Site Map 127 Site Map 096 Site Map 046 Site Map 028 Site Map 103 Site Map 074 Site Map 111 Site Map 068 Site Map 059 Site Map 062 Site Map 092 Site Map 057 Site Map 043 Site Map 078 Site Map 123 Site Map 100 Site Map 009 Site Map 036 Site Map 086 Site Map 131 Site Map 118 Site Map 012 Site Map 081 Site Map 018 Site Map 026 Site Map 107 Site Map 130 Site Map 087 Site Map 072 Site Map 002 Site Map 085 Site Map 001 Site Map 076 Site Map 016 Site Map 073 Site Map 044 Site Map 005 Site Map 102 Site Map 109 Site Map 132 Site Map 134 Site Map 121 Site Map 053 Site Map 015 Site Map 047 Site Map 008 Site Map 023 Site Map 035 Site Map 017 Site Map 082 Site Map 128 Site Map 037 Site Map 093 Site Map 004 Site Map 039 Site Map 013 Site Map 112 Site Map 050 Site Map 079 Site Map 051 Site Map 089 Site Map 040 Site Map 064 Site Map 058 Site Map 006 Site Map 116 Site Map 067 Site Map 045 Site Map 011 Site Map 097 Site Map 030 Site Map 054 Site Map 027 Site Map 126 Site Map 105 Site Map 099 Site Map 061 Site Map 119 Site Map 041 Site Map 042 Site Map 065 Site Map 083 Site Map 084 Site Map 075 Site Map 038 Site Map 063 Site Map 007 Site Map 024 Site Map 049 Site Map 091 Site Map 120 Site Map 094 Site Map 066 Site Map 069 Site Map 090 Site Map 071 Site Map 098 Site Map 019 Site Map 080 Site Map 032 Site Map 014 Site Map 029 Site Map 104 Site Map 077 Site Map 106 Site Map 025 Site Map 056 Site Map 055 Site Map 110 Site Map 117 Site Map 070 Site Map 113 Site Map 088 Site Map 133 Site Map 052 Site Map 101 Site Map 048 Site Map 060 Site Map 021 Site Map 115 Site Map 122 Site Map 114 Site Map 003 Site Map 125 Site Map 010 Site Map 031 Site Map 095 Site Map 129 Site Map 124 Site Map 020 Site Map 108 Site Map 033 Site Map 034
 
 
Home MySQL Blogs Another day at MySQL connect 2012
01
Ott
2012
Another day at MySQL connect 2012 PDF Stampa E-mail
Scritto da Marco Tusa   

Today was another good day, but I had a problem with one presentation and keynote.

the "Big Data is a Big Scam: Most of the Time". There is something that is not convincing me in the architecture,

and is mainly base on the lack of numbers and match between requirements and implementation.

 

The presentation was interesting from some aspects, and the tile approach is probably a good one.

 

I have enjoy the general idea and I did found awesome the bravery of setting up a circular replication cross geographic regions.

 

Never the less I remain bewildered by the tiles approach numbers, probably because the presentation was missing of few additional information.

 

Just to be more clear I was trying to understand better the real number and how works.

 

As for example if each tile is compose by 1 MySQL node, and 2 data node, and given that this solution use Xtra large EC2 with 68GB ram. I can assume that,

we have approximately 65 GB data (given some overhead for buffers and so on) for the current Node Group on this tile.

From the description I have also understood that the number of tails implemented, is different by region.

 

Given that the number of Node Group is different and by direct consequence the memory available as well, and the MySQL SQL node as well.

 

This raise an immediate question, are we having the same data set replicated world wide?

 

Or are we having a different sets?

 

Also,

each Node Group can host ~69GB, the maximum number of data node in 7.2 is still 48 (http://dev.mysql.com/doc/refman/5.5/en/mysql-cluster-ndbd-definition.html), which means that the maximum size that can be served is of 1.3TB for the whole cluster.

 

Given during the presentation my understanding was that the data set is of 100TB, where are located, now or in the future, the remaining 98.7TB? Keeping in mind that I asks if table on disks where used and answer was NO.

Then I have another question-mark infront of me.

If the set of tiles in US is compose of 20 tiles, (so 20 MySQL SQL Nodes, 40 Data nodes and so on), and it set like this because it needs to sustain the traffic mainly it requires that setting for "calculation power" needs.

I assume (probably wrong) that this is due to the number of request per second coming in.

 

Given we have circular replication in the architecture, and given we have different numbers of tiles, and by consequence of MySQL nodes, HOW can a 8 MySQL SQL Node setup (say in Australia) sustain the traffic coming in from a 20 MySQL SQL nodes setup?

 

I am sure, we are missing something in the presentation in terms of real numbers.

 

Being a MySQL NDB lover, I would really like to have more information and details, given that what I get from the presentation was not enough for me.

 

{joscommentenable}

Commenti (0)
Solo gli utenti registrati possono inviare commenti!

!joomlacomment 4.0 Copyright (C) 2009 Compojoom.com . All rights reserved."

Ultimo aggiornamento Domenica 18 Agosto 2013 17:24
 
 

Who's Online

 20 visitatori online