Show simple item record

dc.contributor.authorKlauck, Stefan
dc.contributor.authorPlauth, Max
dc.contributor.authorKnebel, Sven
dc.contributor.authorStrobl, Marius
dc.contributor.authorSantry, Douglas
dc.contributor.authorEggert, Lars
dc.contributor.editorGrust, Torsten
dc.contributor.editorNaumann, Felix
dc.contributor.editorBöhm, Alexander
dc.contributor.editorLehner, Wolfgang
dc.contributor.editorHärder, Theo
dc.contributor.editorRahm, Erhard
dc.contributor.editorHeuer, Andreas
dc.contributor.editorKlettke, Meike
dc.contributor.editorMeyer, Holger
dc.date.accessioned2019-04-11T07:21:39Z
dc.date.available2019-04-11T07:21:39Z
dc.date.issued2019
dc.identifier.isbn978-3-88579-683-1
dc.identifier.issn1617-5468
dc.identifier.urihttp://dl.gi.de/handle/20.500.12116/21737
dc.description.abstractIn scale-out database architectures, client queries must be routed to individual backend database servers for processing. In dynamic database systems, where backend servers join and leave a cluster or data partitions move between servers, clients do not know which server to send queries to. Using a central dispatcher, all queries and responses are routed via a single node. In a system with many high-performance backends, such a central node can become the system bottleneck. This paper compares three different approaches for query dispatching in terms of scaling network throughput and processing flexibility. Off-the-shelf TCP/HTTP load-balancers cannot dispatch individual queries arriving over a single connection to different backend servers, unless they are extended to understand the database wire protocol. For small response sizes up to 4 KB, a purpose-built query dispatcher delivers the highest throughput. For larger responses (i.e., BLOBs or data sets for external analysis), a novel approach for network proxying that transparently maps TCP connections between backend servers performs best.We propose hybrid query dispatching that performs a TCP connection hand-over on demand when returning large database results.en
dc.language.isoen
dc.publisherGesellschaft für Informatik, Bonn
dc.relation.ispartofBTW 2019
dc.relation.ispartofseriesLecture Notes in Informatics (LNI) – Proceedings, Volume P-289
dc.subjectScale-Out Database Systems
dc.subjectQuery Dispatching
dc.subjectLoad-Balancing
dc.titleEliminating the Bandwidth Bottleneck of Central Query Dispatching Through TCP Connection Hand-Overen
mci.reference.pages97-106
mci.conference.sessiontitleWissenschaftliche Beiträge
mci.conference.locationRostock
mci.conference.date4.-8. März 2019
dc.identifier.doi10.18420/btw2019-07


Files in this item

Thumbnail

Show simple item record