- Видео 69
- Просмотров 46 382
KloudDB
Добавлен 21 авг 2022
Kmon is next-gen Postgres monitoring solution - Find slow queries , Heavily written tables , Sequential scans , Database metrics , Security checks , vacuuming issues , Topology diagrams for your replication clusters and more
Is quantum computing a threat to cryptography ? #security #postgres #postgresql
* Is Quantum computing a threat to cryptography ?
* Existing cryptography methods
* What is the current threat status ?
klouddb.gitbook.io/klouddb_sh... Please try KloudDB Shield today
* Existing cryptography methods
* What is the current threat status ?
klouddb.gitbook.io/klouddb_sh... Please try KloudDB Shield today
Просмотров: 41
Видео
postgres shutdown modes- smart , fast , immediate #postgres #postgresql
Просмотров 99День назад
- What is smart shutdown mode ? - What is fast shutdown mode ? - Demo - Fast mode - Demo - Immediate mode - Demo - Immediate mode
Postgres Fillfactor - Fillfactor can impact performance ? #postgres #postgresql
Просмотров 16214 дней назад
What is default fill factor in Postgres ? Fillfactor impacts performance ? HOT updates and its relation to fillfactor How to change fillfactor ?
Stopping Vs Terminating Instance : RI FAQs Episode1 - Controlling cloud costs (weekly podcast)
Просмотров 4014 дней назад
* What happens to RI coverage when you stop the instance ? * What happens to RI coverage when you terminate the instance ?
How Netflix reduced their cloud bill by 5-10% - Controlling cloud costs (weekly podcast)
Просмотров 11421 день назад
* RI Coverage * Video Encoding * How Netflix reduced their cloud bill by 5-10% ? * Peak usage Vs off-peak NOTE : To obtain a free e-copy of our book "FinOps for Database Engineers" please email us at support@klouddb.io Try our products- Kmon , KloudDB Shield and KloudDB School
Time to crack a complex password - Use complex passwords #postgres #postgresql #security
Просмотров 21628 дней назад
klouddb.gitbook.io/klouddb_shield Please try KloudDB Shield today * Time to crack a complex 8 character length password ? * Time to crack a complex 7 character length password ? * Generate random and complex passwords * Postgres passwords
Turning off autovacuum disables autovacuum completely ? #postgresql #postgres
Просмотров 107Месяц назад
* NOTE - Never turnoff autovacuum * What if you turn off ? Does wraparound vacuum still run in this case ? * DEMO * What about DDLs ? * freeze age parameters and how they impact
Patroni failure scenarios - What if Postgres crashes ?
Просмотров 152Месяц назад
* Postgres crashes * Postgres crashes but could not come up * Patroni failure scenario - Postgres crash * What is the timeout period ?
7 different Postgres streaming replication failure scenarios - Kmon #postgres #postgresql
Просмотров 185Месяц назад
* Primary down * Replica down * Replica lagging * Intermediate primary down
Postgresql shared_buffers #postgres #postgresql
Просмотров 224Месяц назад
* 25% of RAM good enough ? * Shared_buffers in Aurora defaults to 75% of RAM * Depends on your backend memory usage * Shared_buffers is very important parameter Podcast with Nikolay - Founder at Postgres.ai
Anatomy of RDS/Aurora cloud costs (Part 1) - Controlling cloud costs (weekly podcast)
Просмотров 58Месяц назад
* Common instances ? * Burstable instances - when to choose ? * Region could impact costs ? * Instance size selection
Simulate password attacks using KloudDB Shield #postgresql #postgres
Просмотров 582 месяца назад
* What is dictionary attack ? Please see complete guide at klouddb.gitbook.io/klouddb_shield * How to use KloudDB Shield to simulate dictionary attack NOTE - Password attack feature is an experimental feature and can be used in sandbox/lower environments. You can copy your users to lower environment/sandbox for the test. Also you can have your own custom password files and supply those as input
Generate complex and random passwords - Postgres Security #postgres #postgresql
Просмотров 862 месяца назад
* Use KloudDB Shield to generate complex and random passwords Please see complete guide at klouddb.gitbook.io/klouddb_shield * Custom password profiles * 20 length by default * Customizable password specs * Next time when you create a new user you can try this
Postgres common usernames - Postgres Security #postgresql #postgres
Просмотров 882 месяца назад
* Detect common usernames Please see complete guide at klouddb.gitbook.io/klouddb_shield * Using common usernames can pose a security threat KloudDB Shield - New Feature
Postgresql Max_connections - How to properly configure ? #postgres #postgresql
Просмотров 3212 месяца назад
* How to use superuser reserved connections ? * OLTP Vs DW ? * Number of VCPUs and memory usage * Pgbouncer level connection settings Podcast with Nikolay
Postgres DBA Series - Tales from the field : Giovanni(Covermymeds)
Просмотров 2052 месяца назад
Postgres DBA Series - Tales from the field : Giovanni(Covermymeds)
Postgres Security - Finding Unique client ips #postgres #postgresql
Просмотров 1002 месяца назад
Postgres Security - Finding Unique client ips #postgres #postgresql
Postgres Oncall Incident - Replication lag(Kmon) #postgresql #postgres
Просмотров 1262 месяца назад
Postgres Oncall Incident - Replication lag(Kmon) #postgresql #postgres
Postgres benchmarking with pgbench - Podcast with Franck #postgresql #postgres
Просмотров 3132 месяца назад
Postgres benchmarking with pgbench - Podcast with Franck #postgresql #postgres
Postgres Security - Finding Inactive Users #postgresql #postgres
Просмотров 2492 месяца назад
Postgres Security - Finding Inactive Users #postgresql #postgres
Postgres Oncall Incident - Load Average(Kmon) #postgres #postgresql
Просмотров 962 месяца назад
Postgres Oncall Incident - Load Average(Kmon) #postgres #postgresql
Postgres Partitioning Tips and Tricks - Podcast with Jimmy #postgresql #postgres
Просмотров 5622 месяца назад
Postgres Partitioning Tips and Tricks - Podcast with Jimmy #postgresql #postgres
Reserved instances gotchas - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Просмотров 902 месяца назад
Reserved instances gotchas - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Performance pitfall - 1 GB segments in Postgres and 20TB table #postgresql #postgres
Просмотров 2702 месяца назад
Performance pitfall - 1 GB segments in Postgres and 20TB table #postgresql #postgres
Importance of logging connections and disconnections in Postgres #postgresql #postgres
Просмотров 1023 месяца назад
Importance of logging connections and disconnections in Postgres #postgresql #postgres
How Cvent Saved 3 million USD - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Просмотров 1143 месяца назад
How Cvent Saved 3 million USD - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Postgres for Oracle DBAs - Config Changes (Demo)
Просмотров 4073 месяца назад
Postgres for Oracle DBAs - Config Changes (Demo)
Postgres Security Series - Password Life #postgres #postgresql
Просмотров 1073 месяца назад
Postgres Security Series - Password Life #postgres #postgresql
Tags and its importance - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Просмотров 1533 месяца назад
Tags and its importance - Controlling cloud costs (Weekly podcast) #postgresql #postgres
Toast and its impact on performance, Toast internal algorithm #postgresql #postgres
Просмотров 2083 месяца назад
Toast and its impact on performance, Toast internal algorithm #postgresql #postgres
Promo-SM
In the PaaS AWS, Aurora will take the control
Buying RI doesn’t give you the guarantee you will have a reserved capacity…
That might be true, but which system/service allows you to enter password with 0 delay inbetween entering passwords and have 0 input and server latency? If we really consider any real world scenarios, cracking a password is pretty much impossible. Though I still hope people would start using password managers, and hopefully websites start letting me use more that just 10-15 characters. I just want to crank it to the full 128-characters and be done...
If you're entering passwords like that, you have only 3 attempts. It doesn't take a genius to figure out that this is not how passwords are cracked
Hi sir, how to do troubleshoot if conversions didn't happen
I'am issuing same etcdctl command to get kay-value, but nothing returning. What can be problem
Interesting topic, thanks for the presentation.
Hi can you share the query that you have used either in github
Can you please paste the script here? that polls for the primary node continuously?
Your explanation simple yet superb , Kindly share the document
00:05 Passwords may appear in Postgres logs when creating new roles or users. 00:34 Postgres logs can expose sensitive passwords. 01:06 Reset PG start statements and create a test role 01:46 Logging all or ddl statements can expose passwords in Postgres logs. 02:25 Sensitive passwords appearing in Postgres logs 03:00 Passwords appearing in PG statements is a security issue 03:30 Mitigate the risk of storing plain text passwords in Postgres logs 04:08 Postgres logs can store plain text passwords.
Do i have to take a downtime during switchover if i randomly wanted to switch one node and remove it
Hi can you you make a vedio for pgpool ssl configuration.
🎯 Key Takeaways for quick navigation: 03:35 🤖 Patroni handles node failures and failovers internally. 04:19 🛡️ A demonstration of simulating a primary node failure and leader election in Patroni. 07:28 💼 How to perform a planned leader switch-over in Patroni. 09:22 🤖 Introduction to etcd commands for Patroni configuration and monitoring. Made with HARPA AI
🎯 Key Takeaways for quick navigation: 00:01 🤖 Introduction to Patroni and its reliance on DCS (etcd) - Patroni is a Python-based bot used in PostgreSQL clustering. - Patroni relies on a Distributed Configuration Store (DCS), like etcd, for coordination and leader election. 03:35 🛡️ Overview of Node Failure and Failover in Patroni - When the primary node fails, a new leader election process is triggered. - Replicas check the status of other nodes, and the one with the least replication lag becomes the new leader. 04:19 💼 Demonstration of Node Failure and Leader Election - The TTL of the leader key counts down, and the first replica to acquire it becomes the new leader. - Demonstrates the leader election process when the primary node fails. 07:28 🛡️ Planned Leader Switch Over in Patroni - Shows how to manually switch the leader in a planned maintenance scenario. - Node 1 is promoted as the new leader using the "switch over" option. 09:22 🤖 Introduction to etcd Commands - Introduction to etcd commands used for Patroni configuration and monitoring. - Demonstrates commands like "get leader key value," "get configuration," and "get member details." Made with HARPA AI
thanks
where is part2?
So if a table is 1TB size then we will see 1024 files in disk? Isn’t that too difficult to maintain?
where is part2?
How do we know about this seminars that you are conducting online ??
Please follow our Linkedin profiles - For future webinars
Very interesting
Thanks for the feedback
Where is the document ?
Very useful examples, thanks for the demo!
Thanks for your feedback
This is a great video. Thanks for this.
Glad it was helpful!
hi Does the clone database also replicated the data from the source after its creation or its a database from snapshot at that point?
I read from the document is said it's from the same volume not from a snapshot
thanks 😉
You're welcome!
Can we change this segment value? Does it have any effect on performance? Cuz postgresql is operating on 8kb pages by default
Very informative, thank you for sharing this.
Glad it was helpful!