Database Administration

AWS Secrets Manager is a secrets management service that helps you protect access to your applications, services, and IT resources. This… — In this post, let's see what secrets manager and how to rotate db credentials secrets with the secrets manager. AWS Secrets Manager is a secret management service that helps you protect access to your applications, services, and IT resources. This service enables you to easily rotate, manage, and retrieve database…

An automatically versioned database schema with the SmartGrid “ontology engine”. — Dealing with DB migrations is always painful and involve the intervention of different people (developer requesting the change, database administrator…) and sometimes a three (or more) steps process for the change to be applied. The future as we see it is much simpler: make the change, even in the production…

Biz axborot asrida yashamoqdamiz. Kundalik hayotimizning ko’p qismi ma’lumotlar bilan o’ralgan. Kunlik onlayn xaridlarimiz, ijtimoiy… — Biz axborot asrida yashamoqdamiz. Kundalik hayotimizning ko’p qismi ma’lumotlar bilan o’ralgan. Kunlik onlayn xaridlarimiz, ijtimoiy tarmoqdagi qoldirilayotgan rasm va izohlar, internet nashrlari kunlik chiqarayotgan maqolalar, do’stimiz bilan chatdagi yozishmalarimiz va hokazolar ma’lumotlarga aylanib qoladi.

DAY 3 — DAY 3 1. Numbering & String Function 1.1 Numbering Function Min & Max MIN(x) : return the minimum values of x including null values. MAX(x) : return the maximum values of x including null values.

We are excited to announce that Race Capital has co-led the $12M Series A for Ottertune, an AI automated Database optimisation platform… — Our Investment in Ottertune: AI automated Database optimisation platform We are excited to announce that Race Capital has co-led the $12M Series A for Ottertune, an AI automated Database optimisation platform, alongside our friends at Intel Capital with participation from Accel. We are thrilled to partner with Andy Pavlo, Dana…

By Assaf Araki & Nick Washburn — By Assaf Araki & Nick Washburn [This post originally appeared on the Intel Capital website on May 10, 2022] The database is a complex beast. To optimally install and configure a database, one needs to understand how to choose the right CPU, memory, storage system, and network. There will be…

A Blog around common database issues — Mistake 1: Allowing Redundancies. When you are scaling your database, it is always important to make sure that you are not allowing for any redundancies. Redundancies occur when you have several entries in your database that contain the same or similar information. Redundancies are found in every database and are a common issue when…

Linux Hugepage Kavramı — Linux Hugepage Kavramı Linux hugepage kavramı bellekteki sanal bir bloğun en küçük boyutunu belirler. Yani sanal page’lerin bir tanesinin boyutunu belirler. THP(Transparent Huge Page) kavramından farklıdır. İkisinin karıştırılmaması önemlidir. Modern x86 CPU mimarilerinde hugepage’ler 4kB,2MB yada 1GB olarak ayarlanabilir. Bu konu özellikle veritabanı performansına doğrudan etki etmektedir.

A blog about running and maintaining an open source database — Why run an open source database? The whole idea of open source is that the code is available for everyone to see, use, change and improve. It’s no surprise that there are some several different open source databases out there. The idea of open source is that by being open and transparent, you can build a…