Postgres Plus Advance Server 9.4
0 likes329 views
Presentation delivered by Gabriel Gy旦ri from #Elos Technologies during #EnterpriseDB seminar held in Prague, 25th March 2015.
More Related Content
Featured (20)
Postgres Plus Advance Server 9.4
- 1. Postgres Plus Advanced Server 9.4 Gabriel Gyori - ELOS Technologies, s.r.o. gabriel.gyori@elostech.cz http://www.elostech.cz 25. 4. 2015 Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 1 / 21
- 2. Obsah Obsah prezent卒acie Obsah prezent卒acie 卒Uvod Architekt卒ura datab卒aze Moznosti nasadenia Kon鍖gur卒acia datab卒aze Oracle kompatibilita Migr卒acia datab卒aze Optimaliz卒acia v卒ykonu Z卒alohy datab卒aze Vysok卒a dostupnost Moznosti rozs卒脹renia Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 2 / 21
- 3. Postgres Plus Advance Server Postgres Plus Advance Server relacn卒a datab卒aza viac nez 15 rokov aktivn卒eho v卒yvoja multiplatformn卒a datab卒aza vyv卒脹jan卒a v jazyku ANSI C jednoduch卒e moznosti rozs卒脹renia Multi-Version Concurrency Control (MVCC) ANSI-SQL:2008 standard Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 3 / 21
- 4. Postgres Plus Advance Server Postgres Plus Advance Server Bezpecnost Host-based autenti鍖k卒acia Object-level opr卒avnenia Auditing (PEM) SSL EDB SQL/Protect Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 4 / 21
- 5. Postgres Plus Advance Server Limity datab卒aze Maxim卒alna velkost datab卒aze neobmedzen卒a Maxim卒alna velkost tabulky 32 TB Maxim卒alna velkost z卒aznamu 1.6 TB Maxim卒alny pocet riadkov neobmedzen卒y Maxim卒alny pocet st卒lpcov 250 - 1600 Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 5 / 21
- 6. Architekt卒ura datab卒aze Architekt卒ura datab卒aze PostgreSQL nepouz卒脹va thready ale procesy hlavn卒y proces postmaster background writer WAL writer checkpointer proces autovacuum launcher/worker logging collector stats collector backend proces / user session WAL (transakcn卒e) logy archiv卒acia transakcn卒ych logov adres卒ar d卒atov卒eho clusteru Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 6 / 21
- 7. Moznosti nasadenia Moznosti nasadenia One-Click instal卒ator bal卒脹cky operacn卒ych syst卒emov RPM/YUM DEB Debian/Ubuntu FreeBSD port Solaris bal卒脹cek kompil卒acia zdrojov卒ych k卒odov PostgresPlus Solution Pack Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 7 / 21
- 8. Kon鍖gur卒acia datab卒aze Kon鍖gur卒acia datab卒aze v即acsina kon鍖gur卒acie v s卒ubore (postgresql.conf) host-based autenti鍖k卒acia (pg hba.conf) kon鍖guracn卒e s卒ubory per d卒atov卒y cluster parameter - hodnota Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 8 / 21
- 9. Oracle kompatibilita Oracle kompatibilita - podporovan卒e zdrojov卒e datab卒aze Object Oracle Sybase SQL Server MySQL Schemas Tables List-Partitioned Tables Range-Partitioned Tables Constraints Indexes Triggers Table Data Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 9 / 21
- 10. Oracle kompatibilita Oracle kompatibilita - podporovan卒e zdrojov卒e datab卒aze Object Oracle Sybase SQL Server MySQL Views Packages Procedures Functions Sequences Users/Roles Object Types Database Links Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 10 / 21
- 11. Oracle kompatibilita EDB*PLUS Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 11 / 21
- 12. Migr卒acia datab卒aze Migr卒acia datab卒aze moznost testovania nov卒ych technol卒ogii moznost volby alternat卒脹vnej datab卒aze dynamick卒e testovanie Postgres Plus Advance Server alternat卒脹vne technol卒ogie mozu usetrit podstatn卒u cast n卒akladov 鍖rmy Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 12 / 21
- 13. Migr卒acia datab卒aze Migration Toolkit Migration Toolkit zdrojov卒y k卒od: java konzolov卒a aplik卒acia online migr卒acia o鍖ine migr卒acia velk卒e mnozstvo explicitn卒ych nastaven卒脹 migr卒acie de鍖n卒脹cia pripojenia dvojice datab卒az (kon鍖guracn卒y s卒ubor) Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 13 / 21
- 14. Migr卒acia datab卒aze Migration Toolkit Proces migr卒acie Krok za krokom de鍖n卒脹cia zdrojovej a cielovej datab卒aze identi鍖k卒acie potenci卒alnych probl卒emov inform卒acii rozdelenie migr卒acie rozsiahlych sch卒em do dvoch cast卒脹 migr卒acia sch卒em migr卒acia d卒at vykonanie konkr卒etnej migr卒acie overenie migr卒acie prekonvertovanie aplik卒acie na novu datab卒azu testovanie a optimaliz卒acia syst卒emu Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 14 / 21
- 15. V卒ykon datab卒aze Optimaliz卒acia Optimaliz卒acia pouzitie VACUUM pouzitie ANALYZE optimaliz卒acia dotazov pouzitie cache pridelenie dostatku pam即ati upgrade datab卒aze pouzitie ulozn卒ych proced卒ur pouzitie partitioningu hardware Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 15 / 21
- 16. V卒ykon datab卒aze DRITA Dynamic Runtime Instrumentation Tools Architecture casov卒y odhad vykon卒avan卒ych procesov odhad z卒ataze konkr卒etnych objektov ci operacn卒eho syst卒emu inform卒acie pre odhalovanie v卒ykonnostn卒ych nedostatkov vyladenie v卒ykonu datab卒aze Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 16 / 21
- 17. V卒ykon datab卒aze edb dynatune Dynatune Urcenie mnozstva pouzit卒ych zdrojov datab卒azov卒ym serverom edb dynatune 1 - 33 - testovacie servery na ktor卒ych bezia dalsie aplik卒acie 34 - 66 - 鍖xn卒y pocet ostatn卒ych aplik卒acii spusten卒ych na serveri 67 - 100 - server urcen卒y v卒yhradne pre spr卒avu datab卒aze edb dynatune pro鍖le oltp - zv卒ysene n卒aroky na online transakcn卒e procesy reporting - datab卒azov卒e servery pouz卒脹vane na reporty mixed - kompromis oboch modelov Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 17 / 21
- 18. Z卒alohovanie datab卒aze Z卒alohovanie datab卒aze Logick卒a z卒aloha pg dump pg dumpall pg restore Fyzick卒a z卒aloha archiv卒acia WAL logov z卒aloha d卒atov卒eho adres卒ara PITR EDB Backup and Recovery Tool Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 18 / 21
- 19. Replik卒acie datab卒aze Replik卒acie datab卒aze Moznosti replik卒acie Log shipping (Hot standby) Streaming (Hot standby) Selekt卒脹vna replik卒acia Londsite Selekt卒脹vna replik卒acia Slony Load balancing pgpool II Multimaster replik卒acia EDB replikacn卒e n卒astroje xDB Replication console multi master xDB Replication console single master EDB Failover Manager Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 19 / 21
- 20. Replik卒acie datab卒aze EDB Failover manager Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 20 / 21
- 21. Replik卒acie datab卒aze Dakujem za pozornost Gabriel Gyori (ELOS Technologies) Postgres Plus Advanced Server 25. 4. 2015 21 / 21