Howdy folks,
I'm running an all nvme pci-4 proxmox cluster with hyperconverged ceph, on 8 nodes
over an SFP+ network.
I have around 16ms of write lag
as shown by 'rbd perf image iotop'
and this slows down mysql
as it does a sync for each operation.
I've 'fixed' the issue by adding
innodb_flush_log_at_trx_commit = 0
and
innodb_flush_log_at_timeout = 3
to mysql's configuration
.. which would result in max 3 seconds of data loss in the event of a crash.
I wonder which tricks you are using to speed up the writes !
Is there some magic option for ceph ?
Do I need to add some hardware ?
Thank you,
Mike
I'm running an all nvme pci-4 proxmox cluster with hyperconverged ceph, on 8 nodes
over an SFP+ network.
I have around 16ms of write lag
as shown by 'rbd perf image iotop'
and this slows down mysql
as it does a sync for each operation.
I've 'fixed' the issue by adding
innodb_flush_log_at_trx_commit = 0
and
innodb_flush_log_at_timeout = 3
to mysql's configuration
.. which would result in max 3 seconds of data loss in the event of a crash.
I wonder which tricks you are using to speed up the writes !
Is there some magic option for ceph ?
Do I need to add some hardware ?
Thank you,
Mike