Re: SQL databases storage

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I am interested in testing this as well. What kinds of database corruption did you see, Samuel? I can try to replicate what happened and will also report the results of my own testing. 

I can see how accessing the databases concurrently from two or more different clients can cause problems. A mysql instance expects to have exclusive access to the database files... But what about using replicate to mirror the database to another server for DR? That is what I had in mind. In this use case, only one server instance would be accessing the files at any given time, but they would be then be available elsewhere in case of failure. 

Chris

----- "Stephan von Krawczynski" <skraw@xxxxxxxxxx> wrote:

> Hello,
> 
> one should note that you should avoid using "performance/quickread"
> even in
> trivial db cases (like ascii tables) because it will eat your data.
> 
> Regards,
> Stephan
> 
> 
> On Mon, 22 Feb 2010 06:57:34 -0600 (CST)
> "Tejas N. Bhise" <tejas@xxxxxxxxxxx> wrote:
> 
> > Hi Samuel,
> > 
> > Gluster is known to work with databases because we provide posix
> compliance. However we only recommend use of Gluster for unstructured
> file data. 
> > 
> > Regards,
> > Tejas
> > 
> > 
> > ----- Original Message -----
> > From: "Samuel Hassine" <samuel.hassine@xxxxxxxxx>
> > To: "Gluster List" <gluster-devel@xxxxxxxxxx>
> > Cc: "Yann Autissier" <yann.autissier@xxxxxxxxxxxxxxxxxx>
> > Sent: Monday, February 22, 2010 6:22:59 PM GMT +05:30 Chennai,
> Kolkata, Mumbai, New Delhi
> > Subject: SQL databases storage
> > 
> > Hi all,
> > 
> > I am trying to store MySQL and PostgreSQL files on the Gluster. I
> > started with MySQL and was suprised because it seems to work fine.
> > 
> > Firstly, is someone trying to do the same thing ? I am interested
> in
> > feedbacks or any kind of experience reviews.
> > Secondly, as I thought, I encoutered several database corrumptions
> but
> > MySQL repair tool works well and can fix these problems (however I
> have
> > to do that manually so it is useless).
> > 
> > @Gluster: are you intereted in database storage over GlusterFS
> > feedbacks? because we are trying to deploy MySQL, PostgreSQL and
> LDAP
> > directly on a GlusterFS space. Is it interesting to track the errors
> and
> > try to fix or this technology is not provided for these types of
> using?
> > 
> > Thanks for your answers.
> > 
> > Kind regards.
> > Sam
> > 
> > 
> > 
> > _______________________________________________
> > Gluster-devel mailing list
> > Gluster-devel@xxxxxxxxxx
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> > 
> > _______________________________________________
> > Gluster-devel mailing list
> > Gluster-devel@xxxxxxxxxx
> > http://lists.nongnu.org/mailman/listinfo/gluster-devel
> > 
> 
> 
> 
> 
> _______________________________________________
> Gluster-devel mailing list
> Gluster-devel@xxxxxxxxxx
> http://lists.nongnu.org/mailman/listinfo/gluster-devel




[Index of Archives]     [Gluster Users]     [Ceph Users]     [Linux ARM Kernel]     [Linux ARM]     [Linux Omap]     [Fedora ARM]     [IETF Annouce]     [Security]     [Bugtraq]     [Linux]     [Linux OMAP]     [Linux MIPS]     [eCos]     [Asterisk Internet PBX]     [Linux API]

  Powered by Linux