← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB,TokuDB and FusionIO

 

Hum xa works with galera or just myisam/innodb?

Em quinta-feira, 2 de outubro de 2014, Christophe Le Roux <
christophe.le.roux@xxxxxxxxxxxx> escreveu:

>  Hi Tim,
>
>
>
> Thank you for your answer.
>
>
>
>
>
> Cordialement,
>
>
>
> Christophe Le Roux
>
>    [image: Claranet] <http://www.claranet.fr/>
>
> [image: Linkedin] <http://www.linkedin.com/company/claranet>
>
> [image: Twitter] <https://twitter.com/#!/Claranet_FR>
>
> [image: Youtube] <http://www.youtube.com/user/ClaranetFR>
>
> [image: Gartner MQ] <http://www.claranet.fr/propos-de/gartner.html>
>
>
>
> *De :* Tim Callaghan [mailto:tmcallaghan@xxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','tmcallaghan@xxxxxxxxx');>]
> *Envoyé :* jeudi 2 octobre 2014 13:08
> *À :* Christophe Le Roux
> *Cc :* MARK CALLAGHAN; Tim Callaghan; Maria Discuss; Jan Lindström
> *Objet :* Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
>
>
>
> One drawback to mixed engines inside single transactions is the need for
> XA prepare (and extra fsyncs).
>
>
>
> On Wed, Oct 1, 2014 at 3:36 AM, Christophe Le Roux <
> christophe.le.roux@xxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','christophe.le.roux@xxxxxxxxxxxx');>> wrote:
>
> Hi Mark,
>
>
>
> Tim Callaghan ( same lastname, your brother ?  ;-)  )from Tokutek told me
> similar things :
>
>
>
> “As for benefit, that's to be determined but since we don't have to
> double write like InnoDB that isn't important to us, plus we are extremely
> write optimized.“
>
>
>
> If we have FusionIO device and mixed tables (innodb, tokudb), is there any
> benefit (or drawback ?) to use NVMFS with TokuDB table ?
>
>
>
>
>
> Cordialement,
>
>
>
> Christophe Le Roux
>
> [image: Claranet] <http://www.claranet.fr/>
>
> [image: Linkedin] <http://www.linkedin.com/company/claranet>
>
> [image: Twitter] <https://twitter.com/#!/Claranet_FR>
>
> [image: Youtube] <http://www.youtube.com/user/ClaranetFR>
>
> [image: Gartner MQ] <http://www.claranet.fr/propos-de/gartner.html>
>
>
>
> *De :* MARK CALLAGHAN [mailto:mdcallag@xxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','mdcallag@xxxxxxxxx');>]
> *Envoyé :* mardi 30 septembre 2014 18:23
> *À :* Christophe Le Roux; Tim Callaghan
> *Cc :* Jan Lindström; Maria Discuss
>
>
> *Objet :* Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
>
>
>
> AFAIK:
> * TokuDB does large random writes, not small ones
> * TokuDB doesn't do update in place
>
> So it doesn't need something like the doublewrite buffer in InnoDB. I am
> not sure whether they might benefit from atomic writes. They would benefit
> from access to a few nice/fast FusionIO devices.
>
>
>
> On Tue, Sep 30, 2014 at 2:12 AM, Christophe Le Roux <
> christophe.le.roux@xxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','christophe.le.roux@xxxxxxxxxxxx');>> wrote:
>
> Hi Jan,
>
>
>
> Thank you for your answer.
>
>
>
> I am writing to the TokuDB community.
>
> I hope for good news J
>
>
>
>
>
> Cordialement,
>
>
>
> [image: Claranet] <http://www.claranet.fr/>
>
> [image: Linkedin] <http://www.linkedin.com/company/claranet>
>
> [image: Twitter] <https://twitter.com/#!/Claranet_FR>
>
> [image: Youtube] <http://www.youtube.com/user/ClaranetFR>
>
> [image: Gartner MQ] <http://www.claranet.fr/propos-de/gartner.html>
>
>
>
> *De :* Jan Lindström [mailto:jan.lindstrom@xxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','jan.lindstrom@xxxxxxxxxxx');>]
> *Envoyé :* mardi 30 septembre 2014 10:38
> *À :* Christophe Le Roux; Maria Discuss
> *Objet :* Re: [Maria-discuss] MariaDB,TokuDB and FusionIO
>
>
>
> Hi,
>
>
>
> On Tue, Sep 30, 2014 at 11:27 AM, Christophe Le Roux <
> christophe.le.roux@xxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','christophe.le.roux@xxxxxxxxxxxx');>> wrote:
>
>
>
> About NVM compression, is it a hardware compression doing by the FusionIO
> controller or is it a software compression doing by the CPU of the server ?
>
>
>
> Compression is done by CPU in the MariaDB server (InnoDB/XtraDB storage
> engine).
>
>
>
> About Atomic Write, I understand there is missing code to have this
> feature to the TokuDB engine. Should I ask to the Mariadb dev team or the
> Tokutek dev team (or SanDisk/FusionIO dev team ?) to add it (maybe it’s
> technically no doable ?)?
>
>
>
> I would start from Tokutek dev team, I do not know fully how database
> tables are stored on Tokutek, but I do not see immediately a reason why
> atomic writes would not be possible.
>
>
>
> Do you think this can boost performances for huge TokuDB tables ?
>
>
>
> Atomic will boost performance but only if database is stored on device
> that supports atomic writes.
>
> R: Jan
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','maria-discuss@xxxxxxxxxxxxxxxxxxx');>
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>
>
>
>
> --
> Mark Callaghan
> mdcallag@xxxxxxxxx <javascript:_e(%7B%7D,'cvml','mdcallag@xxxxxxxxx');>
>
>
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> <javascript:_e(%7B%7D,'cvml','maria-discuss@xxxxxxxxxxxxxxxxxxx');>
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp
>
>
>


-- 
Roberto Spadim
SPAEmpresarial
Eng. Automação e Controle

PNG image

PNG image

PNG image

PNG image

JPEG image


References