We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

The art of multiplexing MySQL connections with ProxySQL

00:00
subtitles
off
playback rate
1
subtitles
off
English (auto-generated)
playback rate
0.25
0.5
0.75
1
1.25
1.5
1.75
2
quality
576p
458
 Cite
 Share
 Download Purchase
Logo of FOSDEM VZWFOSDEM VZW
 Cannaò, René

Formal Metadata

Title
The art of multiplexing MySQL connections with ProxySQL
Title of Series
Number of Parts
561
Author
License
CC Attribution 2.0 Belgium:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Handling tens of thousands of database connections poses seriously performance issues on any database system because resources are poorly utilized. ProxySQL, a MySQL protocol aware, reverse proxy for database servers using the MySQL protocol, is able to track connections statuses and utilize very few connections to MySQL server to serve traffic from thousands of client connections. This session will focus on explaining implementation details and how this algorithm is able to boost performance.
00:00
TDMAService (economics)Group actionThread (computing)GradientEndliche ModelltheorieScalabilitySoftwareComputer hardwareContext awarenessBefehlsprozessorCache (computing)Read-only memoryImplementationComputer networkAerodynamicsEnterprise architectureClient (computing)Computer configurationSystem callNormal (geometry)Proxy serverLevel (video gaming)Front and back endsServer (computing)Database transactionTable (information)Variable (mathematics)Presentation of a groupGraph (mathematics)Default (computer science)BefehlsprozessorConnected spaceServer (computing)Context awarenessRevision controlSemiconductor memoryProxy serverLatent heat10 (number)Multiplication signAuthorizationCache (computing)Thread (computing)NumberWechselseitiger AusschlussContent (media)Group actionConsistencyInjektivitätEndliche ModelltheorieCartesian coordinate systemClient (computing)Windows RegistrySoftwarePhysicalismProcess (computing)Different (Kate Ryan album)CASE <Informatik>InformationImplementationInternational Date LineReplication (computing)Set (mathematics)Database transactionTDMASequelDatabaseWater vaporQuery languageQuicksortSequenceWavePhysical systemPerformance appraisalEnterprise architectureBoiling pointComputer animation
07:10
Client (computing)Computer configurationFront and back endsDatabase transactionTable (information)Reading (process)Communications protocolSet (mathematics)Variable (mathematics)Rule of inferenceMoving averageException handlingTDMASample (statistics)NumberDifferent (Kate Ryan album)Variable (mathematics)Run time (program lifecycle phase)Proxy serverMobile appServer (computing)Connected spaceGraph (mathematics)Thread (computing)Query languageFront and back endsDefault (computer science)Queue (abstract data type)Maxima and minimaKey (cryptography)Revision controlSoftware testingStructural loadTDMARule of inferenceSet (mathematics)Table (information)Reading (process)Latent heatMultiplicationCommunications protocolClient (computing)RoutingGoodness of fitDatabase transactionStatement (computer science)Cartesian coordinate systemResponse time (technology)Device driverMessage passingFlash memoryProduct (business)BenchmarkSequelGraph (mathematics)Multiplication signPhysical systemOnline helpLogic gateWordRight angleComputer data loggingComputer animation
14:15
Client (computing)FreewareFront and back endsMoving averageComputer configurationException handlingClient (computing)Proxy serverServer (computing)Thread (computing)Connected spaceStatement (computer science)Configuration spaceQuery languageMultiplication signAverageNumberRoutingGraph (mathematics)Total S.A.BitType theoryDifferent (Kate Ryan album)Front and back endsVariable (mathematics)DatabaseWorkloadDrop (liquid)Run time (program lifecycle phase)Rule of inferenceSlide ruleBenchmarkOrder (biology)EmailSequelElement (mathematics)Selectivity (electronic)Internet forumCodeSocial classCommunications protocolTheory
21:19
Euler anglesDiagramComputer animation
Transcript: English(auto-generated)