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

pg_paxos: Table Replication through Distributed Consensus

00:00

Formal Metadata

Title
pg_paxos: Table Replication through Distributed Consensus
Alternative Title
pg paxos: Paxos based table replication
Title of Series
Number of Parts
34
Author
License
CC Attribution 3.0 Unported:
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
This talk will discuss and demonstrate the pg_paxos extension, which adds an implementation of the Paxos distributed consensus algorithm to PostgreSQL. pgpaxos provides yet another way of doing table replication in PostgreSQL by automatically replicating a query log through Multi-Paxos. Unlike existing replication solutions, pgpaxos can provide consistent, fault-tolerant, multi-master replication across PostgreSQL servers, at the cost of high read- and write latencies and low throughput. pg_paxos is not a general replication solution, but is especially suitable for applications such as automated fail-over, distributed locking, and managing cluster membership, and can potentially replace components such as Zookeeper.
Table (information)Product (business)ImplementationDemo (music)WordCartesian coordinate systemExtension (kinesiology)DatabaseAlgorithmCellular automatonMereologyReplication (computing)Computer animation
AlgorithmServer (computing)Address spaceCategory of beingMultiplication signRandomized algorithmNumberSocial classPhysical systemAlgorithmOrder (biology)Process (computing)Server (computing)Source code
MereologyAbstractionSystem programmingCommunications protocolAlgorithmMultiplication signRow (database)AlgorithmFunctional (mathematics)DivisorBitCellular automatonPhysical systemImplementationSource code
Function (mathematics)outputVertex (graph theory)Local GroupPhase transitionGroup actionComplete metric spaceFunctional (mathematics)Key (cryptography)Point (geometry)AlgorithmCellular automatonPhase transitionoutputDivisorAsynchronous Transfer ModeSource code
outputPhase transitionSequenceNumber2 (number)Multiplication signPhase transitionMessage passingNetwork topologyoutputAlgorithmDependent and independent variablesCASE <Informatik>IdentifiabilityMathematical optimization
Phase transitionComplete metric spacePhase transitionAlgorithmRight angleSource code
outputPhase transitionRight angleNumberKey (cryptography)Phase transitionException handlingNetwork topologySource code
Finite-state machineVertex (graph theory)SequenceoutputState of matterRoundingNumberMultiplicationMultiplication signState of matterPhysical systemSequenceNumberFinite-state machineKey (cryptography)Service (economics)AlgorithmOrder (biology)MathematicsoutputRight angleSource code
Query languageConsistencySet (mathematics)Finite-state machineRoundingAlgorithmComplete metric spaceInsertion lossRoundness (object)State of matterInformationPoint (geometry)Table (information)Multiplication signReading (process)Cellular automatonOcean currentMultiplicationMathematicsConsistencyRight angleCASE <Informatik>String (computer science)BlogSystem callResultantParameter (computer programming)RootPhase transitionGoodness of fitComputer animation
MultiplicationExtension (kinesiology)Block (periodic table)System programmingBuildingBuildingConsistencyMiniDiscTotal S.A.Distribution (mathematics)WritingSerial portLogicFault-tolerant systemMultiplication signExtension (kinesiology)Table (information)Concurrency (computer science)Physical systemQuicksortAlgorithmExterior algebraData storage deviceDatabaseRight angleCellular automatonBinary multiplierBlock (periodic table)Multiplication
MultiplicationImplementationStatement (computer science)SoftwareImplementationTable (information)Dependent and independent variablesMiniDiscLink (knot theory)SequelCASE <Informatik>CodeInsertion lossMultiplication signCrash (computing)State of matterFinite-state machineFormal languageInternet service providerRemote procedure callMultiplicationMereologySource code
MultiplicationImplementationStatement (computer science)Formal languageSemantics (computer science)Computer networkFunction (mathematics)Remote procedure callPhysical systemSoftware testingType theoryConfidence intervalStandard deviationProjective planeFunctional (mathematics)Table (information)Remote procedure callAlgorithmDependent and independent variablesQuery languageSoftwareSequelSemantics (computer science)QuicksortProcedural programmingSource code
Local GroupMetadataTable (information)MultiplicationGroup actionExtension (kinesiology)Query languageFunction (mathematics)Table (information)Group actionBitExtension (kinesiology)TrailQuery languageRoundness (object)Multiplication signSequelCuboidRoundingLogarithmFunctional (mathematics)LoginMaxima and minimaConsistencyReading (process)Computer animation
Table (information)Query languageServer (computing)Local GroupBlogCloningGroup actionTable (information)LoginCellular automatonMathematicsQuery languageServer (computing)
MultiplicationQuery languageSet (mathematics)Cellular automatonPosition operatorTable (information)Right angleQuery languageFunctional (mathematics)PlanningOrder (biology)Virtual machine
Query languageNumberReading (process)Roundness (object)RoundingOrder (biology)Point (geometry)Virtual machineAlgorithmGroup actionMaxima and minimaSource code
Structural loadDemo (music)Table (information)State of matterDemo (music)Order (biology)Database transactionString (computer science)Physical systemFunctional (mathematics)WritingWeb pageSystem callStatement (computer science)Rollback (data management)Commitment schemeSoftwareReading (process)Link (knot theory)Moving averageCuboidData storage deviceInsertion lossRight angleComputer animationProgram flowchart
Phase transitionDemo (music)Structural loadState of matterRow (database)Functional (mathematics)Database transactionRemote procedure callTable (information)RoundingKey (cryptography)Insertion lossInstance (computer science)Service (economics)Process (computing)TrailCellular automatonDatabaseLastteilungDemo (music)Computer animationProgram flowchart
UsabilityTime zoneInstance (computer science)Group actionVolumeEvent horizonLocal GroupLimit (category theory)Information securityFiber bundleMaizeTask (computing)Direct numerical simulationVideo game consoleService (economics)Independence (probability theory)Cartesian coordinate systemDatabaseTwitterCuboidComputer animation
Table (information)File formatSlide ruleView (database)Coma BerenicesData typeDatabaseFunction (mathematics)AlgorithmProcedural programmingFormal languageRevision controlElectronic mailing listExtension (kinesiology)Subject indexingKey (cryptography)Key (cryptography)Table (information)Block (periodic table)Group actionMoore's lawExtension (kinesiology)CuboidMobile appInstance (computer science)Computer animationProgram flowchart
Subject indexingDatabaseAlgorithmFunction (mathematics)Procedural programmingFormal languageData typeRevision controlExtension (kinesiology)Electronic mailing listKey (cryptography)Uniqueness quantificationConstraint (mathematics)Error messageGroup actionPoint (geometry)Insertion lossNumberTable (information)Roundness (object)Lattice (order)JSONComputer animation
Subject indexingDatabaseFunction (mathematics)AlgorithmFormal languageData typeRevision controlExtension (kinesiology)Electronic mailing listKey (cryptography)Table (information)LoginBitLastteilungContent (media)Scripting languageTwitterInsertion lossJSONComputer animation
Data typeLocal ringConvex hullPort scannerComputer-generated imageryGamma functionTwitterMessage passingNetwork topologyScripting language2 (number)NumberTwitterJSONComputer animationLecture/ConferenceSource code
Data typeDataflowCohen's kappaTwitterFibonacci numberScalable Coherent InterfaceTwitterMultiplication signData centerScripting languageSource codeJSONComputer animation
Subject indexingData typeTable (information)Key (cryptography)Server (computing)System administratorError messageQuery languageContext awarenessStatement (computer science)Boolean algebraFunction (mathematics)Line (geometry)Process (computing)Stack (abstract data type)Function (mathematics)Tracing (software)Point (geometry)CuboidSequelBitConnected spaceTwitterExistenceJSONSource code
Moment (mathematics)Error messageStatement (computer science)Context awarenessFunction (mathematics)Server (computing)Boolean algebraProcess (computing)Local ringEmailTwitterPoint (geometry)Process (computing)Entire functionData centerTime zoneDifferent (Kate Ryan album)Cellular automaton2 (number)Network topologyJSONComputer animation
World Wide Web ConsortiumLocal ringEmailError messageServer (computing)Context awarenessStatement (computer science)Boolean algebraFunction (mathematics)Process (computing)File formatGoogolTouchscreenConsistencyVolumeElement (mathematics)AutomationScheduling (computing)Human migrationSource codeMetadataTwitterProcess (computing)Demo (music)Scheduling (computing)Source codeMultiplicationMultiplication signType theoryCartesian coordinate systemBitPhysical systemData centerSemantics (computer science)Reading (process)MetadataData managementHuman migrationWritingBlogFlow separationQueue (abstract data type)Group actionElement (mathematics)ConsistencyVolume (thermodynamics)NumberComputer animationSource codeJSON
MultiplicationImplementationBitDatabase transactionImplementationCommunications protocolSource codeSerial portQuery languageInjektivitätAlgorithmTelecommunicationDatabaseRight angleDifferent (Kate Ryan album)Cellular automatonSequel
State of matterDatabaseTable (information)LogicComputer animation
Computer hardwareProduct (business)Similarity (geometry)Type theoryConnectivity (graph theory)Computer animationProgram flowchart
Data typeError messageConstraint (mathematics)Uniqueness quantificationCloningLibrary (computing)Query languagePoint (geometry)Table (information)Element (mathematics)State of matterGroup actionExtension (kinesiology)Lattice (order)Cartesian coordinate systemJSON
Data typeError messageUniqueness quantificationConstraint (mathematics)Order (biology)Query languageServer (computing)Function (mathematics)Statement (computer science)Context awarenessError messageCorrespondence (mathematics)Group actionTable (information)Query languageStructural loadSource codeJSON
Error messageServer (computing)EmailStatement (computer science)Context awarenessFunction (mathematics)Boolean algebraProcess (computing)Computer configurationQuery languageSheaf (mathematics)FlagMoment (mathematics)Functional (mathematics)Table (information)AlgorithmStructural loadPoint (geometry)Virtual machineElasticity (physics)Multiplication signRoutingComputer architectureConnected spaceSource codeOcean currentLogicLastteilungData centerInstance (computer science)Row (database)Client (computing)PlanningLimit (category theory)Single-precision floating-point formatDirect numerical simulationTime zoneBitService (economics)Network topologySubject indexingCellular automatonLogical constantChemical equationFigurate numberSource codeJSON
Transcript: English(auto-generated)