Back last fall I ran the DBT3 TPC-H test suite using mariadb on top of a
QEMU/KVM RBD volume (dumpling release) on a virtual machine. I
intentionally kept the cache sizes small to force more disk IO and
compared to the same test running on a local disk passed through to the
VM as well.
In that scenario we were undersubscribed (30 OSDs with only 1 VM
attached!), but we were using 3X replication. Compared to the local
disk, Ceph was typically about 3-4x faster, but there were a couple of
(probably latency bound) situations where the Ceph volume was up to 2x
slower. Specifically these were queries 1, 6, and 12. In query 22
performance was about the same.
I neer dug into the specific queries enough to draw any meaninful
conculsions from them, but they are well documented:
http://www.tpc.org/tpch/spec/tpch2.16.0.pdf
http://sourceforge.net/p/osdldbt/dbt3/ci/master/tree/doc/
Mark
On 04/03/2014 01:08 PM, Gregory Farnum wrote:
Ceph will allow anything; it's just providing a block device. How it
performs will depend quite a lot on the database workload you're
applying, though. We've heard from people who think it's wonderful and
others who don't, depending on what hardware they're using and what
their use case is. You'll need to test it, although if you can
describe your workload in more detail somebody with a similar one is
more likely to appear. :)
-Greg
Software Engineer #42 @ http://inktank.com | http://ceph.com
On Thu, Apr 3, 2014 at 11:04 AM, Brian Beverage
<bbever...@americandatanetwork.com> wrote:
I am looking at setting up a Ganeti cluster using KVM and CentOS. While
looking at storage I first looked at Gluster but noticed in the
documentation it does not allow Live Database files to be saved to it. Does
Ceph allow the use of LIVE database files being saved to it. If so does the
database perform well? We have a couple Database servers that will be
virtualized. I would like to know what other Ceph users are doing with their
virtual environments that contain databases. I do not want to be locked into
a SAN. I also would like to do this without being locked into a proprietary
VM software. That is why Ganeti and KVM was the preferred software.
Thanks,
Brian
_______________________________________________
ceph-users mailing list
ceph-users@lists.ceph.com
http://lists.ceph.com/listinfo.cgi/ceph-users-ceph.com
_______________________________________________
ceph-users mailing list
ceph-users@lists.ceph.com
http://lists.ceph.com/listinfo.cgi/ceph-users-ceph.com
_______________________________________________
ceph-users mailing list
ceph-users@lists.ceph.com
http://lists.ceph.com/listinfo.cgi/ceph-users-ceph.com
