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
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/2019/01/m103-basic-cluster-administration-mongo.html
https://github.com/AlessandroCorradini/MongoDB-University
Oracle Cloud
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://www3.dbmaestro.com/blog/the-ultimate-oracle-to-postgresql-migration-checklist
https://www.tutorialdba.com/p/postgresql-system-catalog-views.html
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://medium.com/leboncoin-engineering-blog/managing-postgresql-backup-and-replication-for-very-large-databases-61fb36e815a0
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/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/
MySql
https://www.percona.com/blog/2020/09/30/mysql-101-tuning-mysql-after-upgrading-memory/
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