Cassandra & Maria DB
0 likes1,133 views
This document summarizes a test of integrating Cassandra as a storage engine for MariaDB. It shows how Cassandra can be used as a "window" to access NoSQL data from a SQL database, allowing data to be stored, selected, updated and joined across SQL and NoSQL systems. Examples demonstrate inserting, selecting, and updating data in Cassandra tables from MariaDB.
![MraB[nn)>CET DTBS maeoehp
aiD (oe] RAE AAAE ywsmso;
QeyO,1rwafce (.4sc
ur K o fetd 00 e)
MraB[nn)>uemaeoehp
aiD (oe] s ywsmso;
Dtbs cagd
aaae hne
MraB[ywsmso] CET TBEues(
aiD maeoehp> RAE AL sr
-> i BGN PIAYKY
d IIT RMR E,
-> nm VRHR25)
ae ACA(5);
QeyO,0rw afce (.5sc
ur K os fetd 00 e)
MraB[ywsmso] ISR IT uesVLE (,"uin) (,"ai";
aiD maeoehp> NET NO sr AUS 1 jle", 2 mre)
QeyO,2rw afce (.0sc
ur K os fetd 00 e)
Rcrs 2 Dpiae:0 Wrig:0
eod: ulcts anns](https://image.slidesharecdn.com/cassandramariadb-121013110027-phpapp01/85/Cassandra-Maria-DB-12-320.jpg)
![MraB[ywsmso] CET TBEmtis
aiD maeoehp> RAE AL erc
- (
>
-> i CA(6 PIAYKY
d HR3) RMR E
-> dt TMSAP
ae IETM,
-> ue_dBGN,
sri IIT
-> ulVRHR25
r ACA(5)
- )egn=asnr
> niecsada
-> kypc='ywsmso'
esae maeoehp
-> clm_aiy'erc'
ounfml=mtis;](https://image.slidesharecdn.com/cassandramariadb-121013110027-phpapp01/85/Cassandra-Maria-DB-13-320.jpg)
![MraB[ywsmso] ISR IT mtisVLE (UD) NW) 1 "hm";
aiD maeoehp> NET NO erc AUS UI(, O(, , /oe)
MraB[ywsmso] SLC (aeue_dul FO mtis
aiD maeoehp> EET dt,sri,r) RM erc;
+----------+----+---+
--------------------
|dt
ae |ue_d|ul |
sri r
+----------+----+---+
--------------------
|21-01 2:22 |
021-0 02:6 1 |/oe|
hm
+----------+----+---+
--------------------
1rwi st(.2sc
o n e 00 e)](https://image.slidesharecdn.com/cassandramariadb-121013110027-phpapp01/85/Cassandra-Maria-DB-14-320.jpg)
![MraB[ywsmso] ISR IT mtisVLE (UD) NW) 2 "hm";
aiD maeoehp> NET NO erc AUS UI(, O(, , /oe)
QeyO,1rwafce (.1sc
ur K o fetd 00 e)
MraB[ywsmso] ISR IT mtisVLE (UD) NW) 1 "by)
aiD maeoehp> NET NO erc AUS UI(, O(, , /u";
QeyO,1rwafce (.0sc
ur K o fetd 00 e)](https://image.slidesharecdn.com/cassandramariadb-121013110027-phpapp01/85/Cassandra-Maria-DB-15-320.jpg)
![MraB[ywsmso] SLC dt,r,ae
aiD maeoehp> EET aeulnm
- FO mtisues
> RM erc,sr
- WEEmtisue =uesi;
> HR erc.sr sr.d
+----------+---+----
-------------------+
|dt
ae |ul |nm
r ae |
+----------+---+----
-------------------+
|21-01 2:24 |/oe|mre |
021-0 02:3 hm ai
|21-01 2:22 |/oe|jle |
021-0 02:6 hm uin
|21-01 2:25 |/u |jle |
021-0 02:4 by uin
+----------+---+----
-------------------+
3rw i st(.1sc
os n e 00 e)](https://image.slidesharecdn.com/cassandramariadb-121013110027-phpapp01/85/Cassandra-Maria-DB-17-320.jpg)
Cassandra & Maria DB
- 1. A QUICK TEST OF CASSANDRA & MARIADB By Julien Duponchelle / @jduponchelle
- 2. MARIADB An enhanced, drop-in replacement for MySQL Lead developer is Michael "Monty" Widenius, the founder of MySQL
- 3. PROJECT GOALS The primary goal of Cassandra SE (Storage Engine) is data integration between the SQL and NoSQL world
- 4. PROJECT STATUS Developed by MariaDB team Working preview announced the 28 september 2012 Still in active development
- 5. CASSANDRA STORAGE ENGINE A MariaDB storage Engine like InnoDB.
- 7. CASSANDRA AS AN SQL DATABASE? NO Cassandra SE is rather a "window" from an SQL environment into NoSQL. You should use Hadoop for analytics queries You should use InnoDB for transactions
- 8. USE CASES Store user metrics Simplify transition
- 9. EXAMPLE
- 10. clh CET KYPC maeoehpWT qs> RAE ESAE ywsmso IH .. . srtg_ls ='ipetaey taeycas SmlSrtg' .. . ADsrtg_pin:elcto_atr='' N taeyotosrpiainfco 1; clh UEmaeoehp qs> S ywsmso;
- 11. clhmaeoehp CET TBEmtis( qs:ywsmso> RAE AL erc .. i ui PIAYKY . d ud RMR E, .. dt tmsap . ae ietm, .. ue_dbgn, . sri iit .. ultx . r et );
- 12. MraB[nn)>CET DTBS maeoehp aiD (oe] RAE AAAE ywsmso; QeyO,1rwafce (.4sc ur K o fetd 00 e) MraB[nn)>uemaeoehp aiD (oe] s ywsmso; Dtbs cagd aaae hne MraB[ywsmso] CET TBEues( aiD maeoehp> RAE AL sr -> i BGN PIAYKY d IIT RMR E, -> nm VRHR25) ae ACA(5); QeyO,0rw afce (.5sc ur K os fetd 00 e) MraB[ywsmso] ISR IT uesVLE (,"uin) (,"ai"; aiD maeoehp> NET NO sr AUS 1 jle", 2 mre) QeyO,2rw afce (.0sc ur K os fetd 00 e) Rcrs 2 Dpiae:0 Wrig:0 eod: ulcts anns
- 13. MraB[ywsmso] CET TBEmtis aiD maeoehp> RAE AL erc - ( > -> i CA(6 PIAYKY d HR3) RMR E -> dt TMSAP ae IETM, -> ue_dBGN, sri IIT -> ulVRHR25 r ACA(5) - )egn=asnr > niecsada -> kypc='ywsmso' esae maeoehp -> clm_aiy'erc' ounfml=mtis;
- 14. MraB[ywsmso] ISR IT mtisVLE (UD) NW) 1 "hm"; aiD maeoehp> NET NO erc AUS UI(, O(, , /oe) MraB[ywsmso] SLC (aeue_dul FO mtis aiD maeoehp> EET dt,sri,r) RM erc; +----------+----+---+ -------------------- |dt ae |ue_d|ul | sri r +----------+----+---+ -------------------- |21-01 2:22 | 021-0 02:6 1 |/oe| hm +----------+----+---+ -------------------- 1rwi st(.2sc o n e 00 e)
- 15. MraB[ywsmso] ISR IT mtisVLE (UD) NW) 2 "hm"; aiD maeoehp> NET NO erc AUS UI(, O(, , /oe) QeyO,1rwafce (.1sc ur K o fetd 00 e) MraB[ywsmso] ISR IT mtisVLE (UD) NW) 1 "by) aiD maeoehp> NET NO erc AUS UI(, O(, , /u"; QeyO,1rwafce (.0sc ur K o fetd 00 e)
- 16. vgatmrabcsada~ clh arn@aid-asnr:$ qs Cnetdt Ts Cutra lclot96. once o et lse t oahs:10 clh uemaeoehp; qs> s ywsmso clhmaeoehp SLC (aeulue_d FO mtis qs:ywsmso> EET dt,r,sri) RM erc; dt ae |ul |ue_d r sri -------------+---+---- --------------------- 21-01 2:24+00|/oe| 021-0 02:300 hm 2 21-01 2:22+00|/oe| 021-0 02:600 hm 1 21-01 2:25+00| /u | 021-0 02:400 by 1
- 17. MraB[ywsmso] SLC dt,r,ae aiD maeoehp> EET aeulnm - FO mtisues > RM erc,sr - WEEmtisue =uesi; > HR erc.sr sr.d +----------+---+---- -------------------+ |dt ae |ul |nm r ae | +----------+---+---- -------------------+ |21-01 2:24 |/oe|mre | 021-0 02:3 hm ai |21-01 2:22 |/oe|jle | 021-0 02:6 hm uin |21-01 2:25 |/u |jle | 021-0 02:4 by uin +----------+---+---- -------------------+ 3rw i st(.1sc os n e 00 e)
- 18. TRY IT AT HOME A Vagrant Virtual Box image with: Ubuntu 12.04 Apache Cassandra 1.1 Prebuilt version of MariaDB 5.5.27 http://bit.ly/SBzf3B
- 19. THE END BY JULIEN DUPONCHELLE JULIEN@DUPONCHELLE.INFO @JDUPONCHELLE Hire me!