DevOps in a Nutshell

DevOps in a Nutshell

Поиск

SearchSearch

Databases

28 дек. 2024 г.

Ссылки по базам данных. Материалы для изучения.

Инструменты для разработчиков

  • ReplyByte is a blazingly fast tool to seed your databases with your production data while keeping sensitive data safe.
  • Altas — open-source schema migration tool. curl -sSf https://atlasgo.sh | sh
  • Prisma — Next-generation ORM for Node.js and TypeScript. Prisma unlocks a new level of developer experience when working with databases thanks to its intuitive data model, automated migrations, type-safety & auto-completion.
  • Barman - Backup and Recovery Manager for PostgreSQL. Allows your company to implement disaster recovery solutions for PostgreSQL databases with high requirements of business continuity. Taking an online hot backup of PostgreSQL is now as easy as ordering a good espresso coffee.
  • Orchestrator — a MySQL high availability and replication management tool, runs as a service and provides command line access, HTTP API and Web interface.
  • mycli - MyCLI is a command line interface for MySQL, MariaDB, and Percona with auto-completion and syntax highlighting.
  • Percona XtraBackup — open-source hot backup utility for MySQL - based servers that doesn’t lock your database during the backup. Percona XtraBackup 8.0 can back up data from InnoDB, XtraDB, MyISAM, and MyRocks tables on MySQL 8.0 servers as well as Percona Server for MySQL with XtraDB, Percona Server for MySQL 8.0, and Percona XtraDB Cluster 8.0. Документация. Другой софт для бд от Percona.
  • Percona Monitoring and Management (PMM) is an open source database observability, monitoring, and management tool for MySQL, PostgreSQL, and MongoDB. With PMM, you can spot critical performance issues faster, understand the root cause of incidents better, and troubleshoot them more efficiently.

Percona Operator for MySQL based on Percona XtraDB Cluster

git clone -b rebrain-event https://github.com/percona/percona-xtradb-cluster-operator.git

Программы и веб-интерфейсы для администрирования БД

  • MySQL Workbench is a unified visual tool for database architects, developers, and DBAs. MySQL Workbench provides data modeling, SQL development, and comprehensive administration tools for server configuration, user administration, backup, and much more. MySQL Workbench is available on Windows, Linux and Mac OS X.
  • Dbeaver Community is a free cross-platform database tool for developers, database administrators, analysts, and everyone working with data. It supports all popular SQL databases like MySQL, MariaDB, PostgreSQL, SQLite, Apache Family, and more.
  • HeidiSQL — free software, and has the aim to be easy to learn. “Heidi” lets you see and edit data and structures from computers running one of the database systems MariaDB, MySQL, Microsoft SQL, PostgreSQL and SQLite. Invented in 2002 by Ansgar, HeidiSQL belongs to the most popular tools for MariaDB and MySQL worldwide.
  • phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. phpMyAdmin supports a wide range of operations on MySQL and MariaDB. Frequently used operations (managing databases, tables, columns, relations, indexes, users, permissions, etc) can be performed via the user interface, while you still have the ability to directly execute any SQL statement.
  • Adminer - Database management in a single PHP file. Replace phpMyAdmin with Adminer and you will get a tidier user interface, better support for MySQL features, higher performance and more security.
  • dbKoda A modern open source database development and admin tool, now available for MongoDB. Latest Release: v1.1.0. It has features to support development, administration and performance tuning on MongoDB databases.
  • SQLPad is a web app for writing and running SQL queries and visualizing the results. Supports Postgres, MySQL, SQL Server, ClickHouse, Crate, Vertica, Trino, Presto, Pinot, Drill, SAP HANA, BigQuery, SQLite, TiDB and many others via ODBC.

Установка phpMyAdmin и Adminer с плагинами будет рассмотрена в отдельной статье.

Материалы для изучения

YouTube каналы

  • Теория БДот Дмитрия Елисеева. Немного о теории реляционных баз данных. На форуме и в личных сообщениях часто спрашивают о проектировании базы данных и о работе со связями в ActiveRecord во фреймворке. Про сохранение связанных моделей, про их вывод, про сортировку и поиск. Но и при этом многие не знают, откуда эти связи берутся, как организовываются и как за ними нужно следить. Поэтому отдельно поговорили о теории баз данных с практическим уклоном на нормализацию и внешние ключи.
  • Percona Database Performance - contains technical videos, webinars and screencasts about everything related to MySQL and MongoDB
  • Postgres Open — is a non-profit, community-run conference series in the United States focused on business users, database professionals and developers of PostgreSQL, the open source database.
  • PGCon — PostgreSQL Conference for Users and Developers
  • MongoDB-

RDBMS (Relational DBMS, Реляционные базы данных)

  • Firebird - True universal database.
  • Galera - Galera Cluster for MySQL is an easy-to-use high-availability solution with high system up-time, no data loss, and scalability for future growth.
  • MariaDB - Community-developed fork of the MySQL.
  • Percona Server - Enhanced, drop-in MySQL replacement.
  • PostgreSQL - Object-relational database management system (ORDBMS).
  • PostgreSQL-XL - Scalable PostgreSQL-based database cluster.
  • SQLite - Library that implements a self-contained, serverless, zero-configuration, transactional SQL DBS.

Курсы: