Does anybody have real-world experince with MySQL 5 datastore on ZFS? Any feedback on clustering of nodes? Customer is looking at X4500s for DB and data storage. Thanks Steffen
Steffen, Are they open to Postgres if it performs 1000 times faster, clusters to 120 nodes and 1.2 Petabytes? - Luke On 8/9/06 1:34 PM, "Steffen Weiberle" <Steffen.Weiberle at Sun.COM> wrote:> Does anybody have real-world experince with MySQL 5 datastore on ZFS? Any > feedback on clustering of > nodes? > > Customer is looking at X4500s for DB and data storage. > > Thanks > Steffen > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss >
Luke Lonergan wrote On 08/09/06 17:58,:> Steffen, > > Are they open to Postgres if it performs 1000 times faster, clusters to 120 > nodes and 1.2 Petabytes?Thanks, Luke. Those are compelling numbers! Have you seen them yourself? Or know who has? I had mentioned that we support it in 6/06 and I though I heard a positive non-verbal sound. (I was on a conference call so I did not get any visual feedback.) Thanks Steffen> > - Luke > > > On 8/9/06 1:34 PM, "Steffen Weiberle" <Steffen.Weiberle at Sun.COM> wrote: > > >>Does anybody have real-world experince with MySQL 5 datastore on ZFS? Any >>feedback on clustering of >>nodes? >> >>Customer is looking at X4500s for DB and data storage. >> >>Thanks >>Steffen >>_______________________________________________ >>zfs-discuss mailing list >>zfs-discuss at opensolaris.org >>http://mail.opensolaris.org/mailman/listinfo/zfs-discuss >> > > > > _______________________________________________ > zfs-discuss mailing list > zfs-discuss at opensolaris.org > http://mail.opensolaris.org/mailman/listinfo/zfs-discuss
Steffen, On 8/10/06 8:12 AM, "Steffen Weiberle" <Steffen.Weiberle at Sun.COM> wrote:> Those are compelling numbers! Have you seen them yourself? Or know who has?O''Reilly Research is a good one, they were using MySQL for data mining work and each query was taking 10 hours, despite all tuning on modern hardware. They switched to Greenplum Postgres after their queries ran in 6 minutes. The differences grow larger with more servers and larger data. We test with the 10TB TPC-H benchmark in our labs - something that no other open source DBMS can tackle.> I had mentioned that we support it in 6/06 and I though I heard a positive > non-verbal sound. (I was > on a conference call so I did not get any visual feedback.)The MPP parallel version of Postgres I''m talking about is sold pre-integrated with the X4500: http://www.informationweek.com/showArticle.jhtml?articleID=188700047 http://www.informationweek.com/software/showArticle.jhtml?articleID=19160019 7&subSection=Open+Source http://blogs.zdnet.com/BTL/?p=3375 http://www.sun.com/smi/Press/sunflash/2006-07/sunflash.20060726.1.xml http://www.sun.com/solutions/documents/articles/bidw_greenplum_aa.xml http://www.greenplum.com/ You can also download the software at bgn.greenplum.com. - Luke