PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ...
Transcript of PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ...
![Page 1: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/1.jpg)
![Page 2: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/2.jpg)
PostgreSQL
Luis Antonio Burbano@tonnyec
www.inprise.ec
Creciendo en productividad, no en costos
![Page 3: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/3.jpg)
La era conectada Nuevos retos Amplio acceso al Internet Computador, Tablet, Smartphone Bajos costos Comercio electrónico Mejora de servicios
![Page 4: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/4.jpg)
El Problema 28 Agencias 20 Ciudades 200~ Empleados 900 000~ Clientes 24x7
![Page 5: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/5.jpg)
SISTEMA INTEGRADO DE VENTA DE PASAJESY ENVÍO ENCOMIENDAS
PARA UNA EMPRESA DE TRANSPORTE PÚBLICO
Implementar
![Page 6: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/6.jpg)
El Cliente Computadores antiguos Conexiones a internet básicas En algunas ciudades muy mala conectividad Intermitencia
Qué funcione conectado/desconectado
![Page 7: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/7.jpg)
Multimaster ?
Cluster de base de datos de 34 nodos
NODO 1
MASTER
NODO 2 NODO 3 NODO 34
34 BASES DE DATOS
. . . . .>
![Page 8: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/8.jpg)
La Solución
![Page 9: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/9.jpg)
~7500 pasajes/díaVenta de Pasajes
![Page 10: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/10.jpg)
~1200 envíos/díaEnvío de Encomiendas
![Page 11: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/11.jpg)
Cluster de base de datos de 34 nodos; esquema elaborado para poder obtener un multimaster, ya que postgresql no soporta nativamente (BDR).
cloud
uio gye
uio
gye
gye
uio gyeuiomec
mec
mec
mec
Londiste & pgQ
Herencia y particionamiento de tablas
![Page 12: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/12.jpg)
Londiste is easy to use asynchronous master/slave replication tool written in python and is part of Skytools package.
Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it
Londiste uses PgQ as transport layer therefore it needs PgQ maintenance daemon called ticker.
SkyTools
![Page 13: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/13.jpg)
Estado de los nodos
![Page 14: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/14.jpg)
LOGs de cada nodo
![Page 15: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/15.jpg)
● OpenVPN● Servidores y Estaciones GNU/Linux● Python scripts en el servidor● Django web framework● Django REST framework
Recursos Adicionales
![Page 16: PostgreSQL · Herencia y particionamiento de tablas. ... Skytools is a package containing PgQ module for Postgres, Python framework and several tools built on top of it Londiste uses](https://reader034.fdocuments.co/reader034/viewer/2022042211/5eb103b40227e8201d064514/html5/thumbnails/16.jpg)
Costos ???Licencias de servidor 0 USDLicencias de base de datos 0 USDConsultoría 5000 USDImplementación 55000 USDTotal 60 000 USD
CLUSTER DE BASE DE DATOS MULTIMAESTRO PARA 34 NODOS