- discuss - lists.mariadb.org

Re: [Maria-discuss] MariaDB-Galera plans?
by Daniel Bartholomew 07 Aug '13

07 Aug '13

On Tue, Aug 6, 2013 at 3:30 AM, Jan Kirchhoff <j.kirchhoff(a)logical-line.de> wrote: > any news on this? I have a 5.5.29 cluster running fine for some time > now, but I'd actually like to have some functionality of MariaDB 10, > so I am waiting for a 10.0-Galera-release... > what's the packaging problem about? The packaging issues I'm involved with are: https://mariadb.atlassian.net/browse/MDEV-4229 and https://mariadb.atlassian.net/browse/MDEV-4141 I'm hoping to have some sort of fix for both issues within a day or so, and shortly after that to have a release. I don't know the status of MariaDB Galera Cluster 10.0. Thanks. -- Daniel Bartholomew Google+ - http://gplus.to/dbart Twitter - http://twitter.com/daniel_bart MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB-Galera plans?
by Aleksey Sanin 06 Aug '13

06 Aug '13

Hello, There have been no MariaDB-Galera releases since March and I am curious if you still plan to support it going forward. It feels that MariaDB-Galera development stopped completely and I wonder if I should be switching to Percona instead. Best, Aleksey

3 3

[Maria-discuss] Compiling
by Roberto Spadim 05 Aug '13

05 Aug '13

Hi guys, i installed slackware-14 downloaded the mariadb-source of 10.0.3 tar -zxf mariadb.tgz cd mariadb-10.0.3 BUILD/configure-pentium64-max and it stoped at: [ 37%] Building CXX object libmysqld/CMakeFiles/sql_embedded.dir/__/sql/sql_yacc.cc.o Linking CXX static library libsql_embedded.a [ 37%] Built target sql_embedded gmake: *** [all] Error 2 the point is... why? any log or something like it to check what happened? -- Roberto Spadim

2 10

[Maria-discuss] New Question: mariadb on Cubieboard (ARM AllWinner A10)
by AskMonty KB 04 Aug '13

04 Aug '13

Hello, A new question has been asked in "Does MariaDB support..." by aemlin: -------------------------------- Hello, I'm using mariadb on Cubieboard (within a debian server). The compile of the sources for 5.5 did work perfectly but the 10.0 does not compile , is it possible to have some help to get it running ? Also is there a way to make my mariadb 5.5 available for other users (by exemple as a .deb file)? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/mariadb-on-cubieboard-arm-allwinner-a10/

1 0

[Maria-discuss] RFC opengis and libs
by Roberto Spadim 02 Aug '13

02 Aug '13

hi guys, does we use one lib for opengis? i was using this one with php and c, and i think it's a nice library, maybe a port of this to mariadb should be nice http://trac.osgeo.org/geos/ -- Roberto Spadim SPAEmpresarial

1 0

Re: [Maria-discuss] Compiling
by Roberto Spadim 02 Aug '13

02 Aug '13

please remove this user from list, his email don't exists anymore: alexandre.almeida(a)hti.com.br thanks 2013/8/2 <alexandre(a)hti.com.br>: > Esta conta de email não está mais em uso. A mensagem não foi entregue. Favor reenvie para alexandre.almeida(a)hti.com.br > > This account is no longer in use. The message wasn't delivered. Please resend the message to alexandre.almeida(a)hti.com.br > > -- Roberto Spadim SPAEmpresarial

1 0

Re: [Maria-discuss] Which JOIN
by Richard Couture 31 Jul '13

31 Jul '13

On 07/30/2013 09:17 PM, Roberto Spadim wrote: > ---- > other tip, instead of full table name, *USE* alias > FROM ArticulosPedidos AS a, PedidosIndex AS b, CartArticulos AS c > b.NumDePedido=a.NumDePedido AND > a.ArticuloID=c.ArticuloID > > this decrease TCP/IP or UNIX SOCKET packets... if you have a very high qps > (query per second) this can save a lot of ethernet, example > 1000 queries of 1KB=1MB/second , if you can save near to 50B per query, you > will use 950*1000 = 950KB, in other words, you can send 5% more bytes over > network without changing hardware > --- > The idea is good but the syntax fails The following syntax however does work select sum( CantidadPedida ) as SumPedida, sum( CantidadRecibida ) as SumRecibida, ArticuloCodigo, ArticuloNombre, ArticuloCosto, ArticulosDisponibles, ArticuloUnidad from ArticulosPedidos as a inner join PedidosIndex as b on b.NumDePedido = a.NumDePedido inner join CatArticulos as c on a.ArticuloID = c.ArticuloID where a.Fecha between '{$_POST{'MovsDelAno'}}-{$_POST{'MovsDelMes'}}-{$_POST{'MovsDelDia'}}' and '{$_POST{'MovsAlAno'}}-{$_POST{'MovsAlMes'}}-{$_POST{'MovsAlDia'}}' group by a.ArticuloID order by SumPedida DESC limit 500; Thanks for the tip Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

1 0

[Maria-discuss] Which JOIN
by Richard Couture 31 Jul '13

31 Jul '13

I have a table of transactions for ArticleID bought and sold. I want to create a report of the fileds in that table sorted by the SUM of each ArticleID. Any suggestions??? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

2 3

[Maria-discuss] Master slave
by Richard Couture 27 Jul '13

27 Jul '13

Is it possible to set up replication in such a manner as to permit writing records to either a master or a slave replica? We want to set up a fail safe replica that can easily take over when our connection to the main replica fails, which, unfortunately, is fairly often. I read a document, some time ago which mentioned several types of replication, i.e.: by record, by table ... and the pitfalls, like IDs not necessarily matching... which confused me more than anything else... Can someone point me to some good documentation to enable me to pick the correct type of replication that I need to accomplish my task?? Thanks Richard -- LinuxCabal Asociación Civil Ing. Richard Couture Novell CNE, ECNE, MCNE HP/Compaq ASE Tel.: (+52) (333) 145-2638 Cel.: (+52) (044) 333 377-7505 Cel.: (+52) (044) 333 377-7506 Web: http://www.LinuxCabal.org E-Mail: rrc(a)linuxcabal.org Hosted en la nube Cloud Sigma - www.CloudSigma.com AVISO DE CONFIDENCIALIDAD: Este correo electrónico, incluyendo en su caso, los archivos adjuntos al mismo, pueden contener información de carácter confidencial y/o privilegiada, y se envían a la atención única y exclusivamente de la persona y/o entidad a quien va dirigido. La copia, revisión, uso, revelación y/o distribución de dicha información confidencial sin la autorización por escrito de LinuxCabal está prohibida. Si usted no es el destinatario a quien se dirige el presente correo, favor de contactar al remitente respondiendo al presente correo y eliminar el correo original incluyendo sus archivos, así como cualesquiera copia del mismo. Mediante la recepción del presente correo usted reconoce y acepta que en caso de incumplimiento de su parte y/o de sus representantes a los términos antes mencionados, LinuxCabal tendrá derecho a los daños y perjuicios que esto le cause.

1 0

[Maria-discuss] New Question: Does MariaDB support for Linux on POWER system?
by AskMonty KB 25 Jul '13

25 Jul '13

Hello, A new question has been asked in "Does MariaDB support..." by jinkoo: -------------------------------- Does MariaDB support for Linux on POWER system? -------------------------------- To view or answer this question please visit: http://kb.askmonty.org/en/does-mariadb-support-for-linux-on-power-system/

1 0