Thursday 10 September 2020

Important Technology Links of different Topics

 Cassandra Topics

https://docs.datastax.com/en/dse-trblshoot/doc/troubleshooting/slowReads.html

https://blog.pythian.com/cassandra-information-using-nodetool/

https://blog.knoldus.com/learn-cassandra-nodetool-monitormanage/

https://www.vskills.in/certification/tutorial/nodetool/

https://blog.knoldus.com/?s=cassandra

Oracle DB

https://www.hhutzler.de/blog/using-datapatch-rac-env/#

http://oracle-help.com/oracle-rac/

http://rob.lasonder.org/index.php?title=Main_Page

http://www.br8dba.com/

https://oracledbwr.com/category/patching/rac-database/

https://ittutorial.org/exadata-tutorials-oracle-magic-database-machine-exadata-lessons/

https://ittutorial.org/performance-tuning-and-sql-tuning-tutorial-in-the-oracle-database/

https://www.ktexperts.com/daily-tips-for-oracle-dba/

MongoDB

http://tommongo.blogspot.com/


http://tommongo.blogspot.com/2019/01/m103-basic-cluster-administration-mongo.html

https://github.com/AlessandroCorradini/MongoDB-University

Oracle Cloud 

https://docs.oracle.com/en/solutions/design-dr/plan-dr-databases1.html#GUID-CCF50BB4-DD5B-4DE9-AD05-4FC475491AF0

AZURE

https://blog.dbi-services.com/using-the-managed-postgresql-service-in-azure/

https://docs.microsoft.com/en-us/learn/certifications/azure-database-administrator-associate?tab=tab-learning-paths

https://docs.microsoft.com/en-us/learn/paths/azure-sql-fundamentals/


MySQL

http://mysqlentomologist.blogspot.com/

https://www.dbrnd.com/2016/02/mysql-opening-and-closing-of-database-connection-is-very-costly/

https://mysqlserverteam.com/category/replication/page/2/

AWS Topics

https://www.percona.com/blog/2018/08/02/amazon-rds-multi-az-deployments-read-replicas/

https://www.cloudtp.com/doppler/designing-database-high-availability-replication-aws/

https://www.cloudtp.com/doppler/designing-database-high-availability-replication-aws/


Postgresql DB

https://severalnines.com/database-blog/understanding-and-reading-postgresql-system-catalog

https://www.enterprisedb.com/blog/postgresql-vs-mysql-360-degree-comparison-syntax-performance-scalability-and-features

https://www3.dbmaestro.com/blog/the-ultimate-oracle-to-postgresql-migration-checklist

https://www.tutorialdba.com/p/postgresql-system-catalog-views.html

https://www.enterprisedb.com/postgres-tutorials/postgresql-replication-and-automatic-failover-tutorial

https://www.digitalocean.com/docs/databases/postgresql/resources/supported-extensions/

https://blog.feedspot.com/postgresql_blogs/

https://thoughtbot.com/blog/reading-an-explain-analyze-query-plan

https://thoughtbot.com/blog/tags/postgres

https://info.crunchydata.com/blog/wheres-my-replica-troubleshooting-streaming-replication-synchronization-in-postgresql

https://valehagayev.wordpress.com/2019/09/30/migrating-from-oracle-to-postgresql-with-ora2pg/

https://www.itopstimes.com/itsec/creating-a-multi-layered-security-architecture-for-your-databases/

https://www.percona.com/blog/2019/05/24/an-overview-of-sharding-in-postgresql-and-how-it-relates-to-mongodbs/#:~:text=In%20fact%2C%20PostgreSQL%20has%20implemented,PostgreSQL%20for%20a%20long%20time.

https://medium.com/leboncoin-engineering-blog/managing-postgresql-backup-and-replication-for-very-large-databases-61fb36e815a0

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative

https://www.enterprisedb.com/blog/comparing-oracle-edb-postgres

https://www.enterprisedb.com/blog/postgres-table-partitioning

https://www.enterprisedb.com/blog/8-cool-interesting-facts-things-postgresql-can-do

https://www.enterprisedb.com/blog/8-ways-rdbms-postgres-handles-non-relational-data

https://www.enterprisedb.com/blog/why-mastercards-secret-zero-downtime-postgresql

https://www.enterprisedb.com/blog/how-to-secure-postgresql-security-hardening-best-practices-checklist-tips-encryption-authentication-vulnerabilities

https://www.enterprisedb.com/blog/postgresql-query-optimization-performance-tuning-with-explain-analyze

https://www.enterprisedb.com/blog/microsoft-sql-server-mssql-vs-postgresql-comparison-details-what-differences

https://www.enterprisedb.com/blog/postgresql-database-patching-ha-cluster-postgres-update-minor-versions

https://www.enterprisedb.com/blog/how-to-upgrade-postgresql-and-upgrading-methods-costs-risks

https://www.enterprisedb.com/blog/monitoring-postgresql-database-system-activities-performance-system-stats-extension

https://www.enterprisedb.com/blog/postgresql-wal-write-ahead-logging-management-strategy-tradeoffs

https://www.enterprisedb.com/blog/maintaining-postgresql-for-high-performance-what-is-wrong-or-right-what-consider

https://www.enterprisedb.com/blog/postgres-pulse-insights-its-still-slow-solving-bloated-postgres-database

https://www.enterprisedb.com/blog/what-does-database-high-availability-really-mean

https://www.enterprisedb.com/blog/postgresql-database-backup-recovery-what-works-wal-pitr

https://www.enterprisedb.com/blog/how-to-fix-postgresql-index-corruption-deal-repair-rebuild

https://www.enterprisedb.com/blog/top-tools-manage-postgres-enterprise-administration-performance-high-availability-and

https://www.enterprisedb.com/blog/postgresql-pgpool-connection-pool-database-load

https://www.enterprisedb.com/blog/high-availibility-parameters-configuration-streaming-replication-postgresql

https://software.fujitsu.com/jp/manual/manualfiles/m150000/j2ul1738/08enz200/j1738-00-12-01-01.html

https://www.enterprisedb.com/blog/tips-postgres-postgres-insider

https://www.percona.com/blog/2019/02/04/pg_repack-rebuild-postgresql-database-objects-online/

https://luppeng.wordpress.com/2019/11/30/handling-sensitive-data-in-postgresql-row-level-security-column-access-privileges-and-data-masking/

https://www.enterprisedb.com/blog/postgres-and-transparent-data-encryption-tde


https://www.enterprisedb.com/blog/introducing-postgres-pulse-insights-live-qa-postgres-experts

https://www.dbrnd.com/2019/06/postgresql-disable-non-durable-parameters-and-improve-server-performance/

https://www.dbrnd.com/2019/05/postgresql-how-to-remove-accents-diacritic-signs-from-lexemes/

https://www.dbrnd.com/2019/02/postgresql-dont-take-backup-until-your-database-is-changed-check-pg_stat_database-tuple/

https://www.dbrnd.com/2018/04/postgresql-9-5-brin-index-maintenance-using-brin_summarize_new_values-add-new-data-page-in-brin-index/

https://www.dbrnd.com/2018/04/postgresql-use-pgbench-for-testing-the-load-performance-of-server/

https://www.dbrnd.com/2018/03/postgresql-do-before-populating-a-new-database/

https://www.dbrnd.com/2017/12/postgresql-10-important-name-change-from-xlog-to-wal-and-location-to-lsn/

https://www.dbrnd.com/2017/12/postgresql-important-parameters-for-query-planner-configuration-enable_seqscan/

https://www.dbrnd.com/2017/07/postgresql-fatal-error-remaining-connection-slots-are-reserved-for-non-replication-superuser-connections/

https://www.dbrnd.com/2017/11/postgresql-move-table-with-data-from-one-schema-to-another-schema/



https://bucardo.org/

Standby_Lag Calculation     ---------------  https://www.postgresql.org/message-id/CADKbJJWz9M0swPT3oqe8f9+tfD4-F54uE6Xtkh4nERpVsQnjnw@mail.gmail.com

DB Migration 

https://tapoueh.org/blog/2017/07/from-mysql-to-postgresql/

https://www.infinitypp.com/amazon-aws/database-migration-service-mysql-dms/

https://dzone.com/articles/how-to-use-amazon-dms-to-perform-a-database-migrat

https://tutorialsdojo.com/aws-database-migration-service/

https://valehagayev.wordpress.com/2019/09/30/migrating-from-oracle-to-postgresql-with-ora2pg/

https://info.crunchydata.com/blog/setup-ora2pg-for-oracle-to-postgres-migration

https://severalnines.com/database-blog/migrating-oracle-postgresql-what-you-should-know

https://hevodata.com/learn/postgresql-logical-replication/

https://www.enterprisedb.com/blog/the-complete-oracle-to-postgresql-migration-guide-tutorial-move-convert-database-oracle-alternative?gclid=CjwKCAjwzIH7BRAbEiwAoDxxTiTWBr-5DhbQWTNKt5qoL61VKHpUX9cIs1F_3FA_Uv6lyPxJkSEvahoCbEYQAvD_BwE&utm_campaign=India&utm_medium=cpc&utm_source=google



MySql

https://www.percona.com/blog/2020/09/30/mysql-101-tuning-mysql-after-upgrading-memory/

https://www.percona.com/blog/2020/08/27/mysql-8-0-19-innodb-replicaset-configuration-and-manual-switchover/

https://www.percona.com/blog/2020/08/26/creating-an-external-replica-of-aws-aurora-mysql-with-mydumper/

https://www.dbrnd.com/mysql-dba-scripts/

http://howtolamp.com/lamp/mysql/5.6/log-files/

https://blog.jcole.us/

https://www.dbrnd.com/2016/01/mysql-check-optimize-and-repair-tables-using-mysqlcheck/

https://deepakmysqldba.wordpress.com/page/6/

https://www.dbrnd.com/2016/01/mysql-configured-innodb-engine-for-multithreaded-database/

https://www.infoworld.com/article/3210905/10-essential-performance-tips-for-mysql.html

https://www.infoworld.com/cms/article/http:/www.infoworld.com/article/3209665/application-development/21-rules-for-faster-sql-queries.html#tk.ifw-infsb

https://blog.pythian.com/comparing-pgpool-ii-and-pgbouncer/

https://www.dbrnd.com/2016/10/mysql-controlling-query-optimizer-to-choose-the-best-execution-plan-optimizer_prune_level-optimizer_search_depth/

https://www.dbrnd.com/2016/10/mysql-error-2006-hy000-mysql-server-has-gone-away/

https://www.percona.com/blog/2018/10/01/how-to-fix-mysql-replication-after-an-incompatible-ddl-command/

https://www.percona.com/blog/2013/05/09/how-to-create-a-new-or-repair-a-broken-gtid-based-slave-with-percona-xtrabackup/

https://www.percona.com/blog/2014/05/02/how-to-identify-and-cure-mysql-replication-slave-lag/

https://www.percona.com/blog/2013/02/08/how-to-createrestore-a-slave-using-gtid-replication-in-mysql-5-6/

https://www.percona.com/blog/2014/01/28/10-mysql-performance-tuning-settings-after-installation/

No comments:

Post a Comment