MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily
![Język publikacji: angielski Język publikacji: angielski](https://static01.helion.com.pl/global/flagi/1.png)
- Autor:
- Daniel Bartholomew
![MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily Daniel Bartholomew - okładka ebooka](https://static01.helion.com.pl/global/okladki/326x466/e_3c5k.png)
![MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily Daniel Bartholomew - tył okładki ebooka](https://static01.helion.com.pl/global/okladki-tyl/326x466/e_3c5k.png)
- Ocena:
- Bądź pierwszym, który oceni tę książkę
- Stron:
- 282
- Dostępne formaty:
-
PDFePubMobi
Opis ebooka: MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily
Wybrane bestsellery
-
From installing and configuring through basic usage and maintenance, each chapter in this revised and expanded guide leads on sequentially and logically from the one before it, introducing topics in their natural order so you learn what you need, when you need it.
Getting Started with MariaDB. Explore the powerful features of MariaDB with practical examples Getting Started with MariaDB. Explore the powerful features of MariaDB with practical examples
-
This book helps you create efficient databases, covering data modeling, query optimization, and more. You'll be equipped with the skills needed to design robust databases using PostgreSQL and MySQL for modern data-driven applications.
Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases Database Design and Modeling with PostgreSQL and MySQL. Build efficient and scalable databases for modern applications using open source databases
(78.48 zł najniższa cena z 30 dni) -
This book provides a highly focused view of real business outcomes powered by data governance, that resonate with non-data executives such as CFOs and CEOs. You’ll also find useful insights into how to implement data governance initiatives.
Data Governance Handbook. A practical approach to building trust in data Data Governance Handbook. A practical approach to building trust in data
-
This book shows you how to use Apache Spark, Delta Lake, and Databricks to build data pipelines, manage and transform data, optimize performance, and more. Additionally, you’ll implement DataOps and DevOps practices, and orchestrate data workflows.
Data Engineering with Databricks Cookbook. Build effective data and AI solutions using Apache Spark, Databricks, and Delta Lake Data Engineering with Databricks Cookbook. Build effective data and AI solutions using Apache Spark, Databricks, and Delta Lake
-
This book will guide you through the fundamental and advanced features of the Snowpark framework in Python. You’ll learn how to use Snowpark for implementing workloads in the fields of data engineering, data science, and data applications.
The Ultimate Guide to Snowpark. Design and deploy Snowpark with Python for efficient data workloads The Ultimate Guide to Snowpark. Design and deploy Snowpark with Python for efficient data workloads
-
This report highlights the vital role of data quality in your data strategy, offering actionable steps to make it the foundation of your data culture, unlocking greater value and informed decisions in the evolving landscape of AI.
Data Quality in the Age of AI. Building a foundation for AI strategy and data culture Data Quality in the Age of AI. Building a foundation for AI strategy and data culture
-
Ця книжка познайомить вас з особливостями Jav...
Head First. Програмування на JavaScript. Head First. Програмування на JavaScript Head First. Програмування на JavaScript. Head First. Програмування на JavaScript
(84.16 zł najniższa cena z 30 dni)84.16 zł
103.90 zł(-19%) -
«Патерни проєктування» 2014 ваша книжка, якщо C...(84.16 zł najniższa cena z 30 dni)
84.16 zł
103.90 zł(-19%) -
This practical guide to implementing DeFi in your projects guides you through building full-stack DeFi solutions with popular tools and teaches you how to leverage blockchain technologies to manage crypto assets.
Building Full Stack DeFi Applications. A practical guide to creating your own decentralized finance projects on blockchain Building Full Stack DeFi Applications. A practical guide to creating your own decentralized finance projects on blockchain
O autorze ebooka
Ebooka "MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily" przeczytasz na:
-
czytnikach Inkbook, Kindle, Pocketbook, Onyx Boox i innych
-
systemach Windows, MacOS i innych
-
systemach Windows, Android, iOS, HarmonyOS
-
na dowolnych urządzeniach i aplikacjach obsługujących formaty: PDF, EPub, Mobi
Masz pytania? Zajrzyj do zakładki Pomoc »
Audiobooka "MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily" posłuchasz:
-
w aplikacji Ebookpoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych
-
na dowolnych urządzeniach i aplikacjach obsługujących format MP3 (pliki spakowane w ZIP)
Masz pytania? Zajrzyj do zakładki Pomoc »
Kurs Video "MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily" zobaczysz:
-
w aplikacjach Ebookpoint i Videopoint na Android, iOS, HarmonyOs
-
na systemach Windows, MacOS i innych z dostępem do najnowszej wersji Twojej przeglądarki internetowej
Szczegóły ebooka
- Tytuł oryginału:
- MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily.
- ISBN Ebooka:
- 978-17-832-8440-5, 9781783284405
- Data wydania ebooka:
-
2014-03-20
Data wydania ebooka często jest dniem wprowadzenia tytułu do sprzedaży i może nie być równoznaczna z datą wydania książki papierowej. Dodatkowe informacje możesz znaleźć w darmowym fragmencie. Jeśli masz wątpliwości skontaktuj się z nami sklep@ebookpoint.pl.
- Język publikacji:
- angielski
- Rozmiar pliku Pdf:
- 4.7MB
- Rozmiar pliku ePub:
- 14.0MB
- Rozmiar pliku Mobi:
- 30.9MB
Spis treści ebooka
- MariaDB Cookbook
- Table of Contents
- MariaDB Cookbook
- Credits
- About the Author
- About the Reviewers
- www.PacktPub.com
- Support files, eBooks, discount offers, and more
- Why subscribe?
- Free access for Packt account holders
- Support files, eBooks, discount offers, and more
- Preface
- What this book covers
- What you need for this book
- Who this book is for
- Conventions
- Reader feedback
- Customer support
- Downloading the example code
- Errata
- Piracy
- Questions
- 1. Getting Started with MariaDB
- Introduction
- Installing MariaDB on Windows
- How to do it...
- How it works...
- Theres more...
- HeidiSQL
- The Feedback plugin
- See also
- Installing MariaDB on Linux
- Getting ready
- How to do it...
- How it works...
- See also
- Installing MariaDB on Mac OS X
- Getting ready
- How to do it
- How it works...
- Enabling the Feedback plugin
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Switching between InnoDB and XtraDB
- How to do it...
- How it works...
- See also
- Creating a backup user
- How to do it
- How it works...
- Making backups with XtraBackup
- Getting ready
- How to do it...
- How it works...
- There's more...
- Restoring from a backup
- XtraBackup and NFS
- Making backups with mysqldump
- Getting ready
- How to do it
- How it works...
- There's more...
- --add-drop-database
- --add-drop-table
- --add-locks
- Checking and optimizing tables automatically with mysqlcheck and cron
- How to do it
- How it works...
- There's more
- Security
- Using progress reporting in the mysql client
- How to do it
- How it works...
- There's more
- Disabling progress reporting
- Progress reporting in mytop
- 2. Diving Deep into MariaDB
- Introduction
- Importing the data exported by mysqldump
- How to do it...
- How it works...
- There's more...
- See also
- Using SHOW EXPLAIN with running queries
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using LIMIT ROWS EXAMINED
- Getting ready
- How to do it...
- How it works...
- There's more...
- Using LIMIT with LIMIT ROWS EXAMINED
- Warning of incomplete results
- Using INSTALL SONAME
- How to do it...
- How it works...
- There's more...
- Plugin names versus filenames
- INSTALL SONAME versus INSTALL PLUGIN
- See also
- Producing HTML output
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Producing XML output
- Getting ready
- How to do it...
- How it works...
- See also
- Migrating a table from MyISAM to Aria
- Getting ready
- How to do it...
- How it works...
- See also
- Migrating a table from MyISAM or Aria to InnoDB or XtraDB
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 3. Optimizing and Tuning MariaDB
- Introduction
- Using SHOW STATUS to check if a feature is being used
- How to do it...
- How it works...
- There's more...
- See also
- Controlling MariaDB optimizer strategies
- How to do it...
- How it works...
- There's more...
- See also
- Using extended keys with InnoDB and XtraDB
- How to do it...
- How it works...
- There's more...
- See also
- Configuring the Aria two-step deadlock detection
- How to do it...
- How it works...
- There's more...
- See also
- Configuring the MyISAM segmented key cache
- How to do it...
- How it works...
- There's more...
- Setting the number of segments to 1
- Determining the optimal number of segments
- Other key cache variables
- See also
- Configuring threadpool
- How to do it...
- How it works...
- There's more...
- The thread_pool_stall_limit, thread_pool_max_threads, and extra_port variables
- The thread_pool_idle_timeout variable
- Pool-of-threads differences on Windows and Linux
- See also
- Configuring the Aria pagecache
- How to do it...
- How it works...
- There's more...
- See also
- Optimizing queries with the subquery cache
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Optimizing semijoin subqueries
- How to do it...
- How it works...
- There's more...
- See also
- Creating an index
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating a full-text index
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Removing an index
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using JOINs
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using microseconds in the DATETIME columns
- How to do it...
- How it works...
- There's more...
- See also
- Updating DATETIME and TIMESTAMP columns automatically
- How to do it...
- How it works...
- There's more...
- See also
- 4. The TokuDB Storage Engine
- Introduction
- Installing TokuDB
- How to do it...
- How it works...
- There's more...
- Making TokuDB the default storage engine
- Creating a TokuDB-specific configuration file
- See also
- Configuring TokuDB
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Creating TokuDB tables
- Getting ready
- How to do it...
- How it works...
- See also
- Migrating to TokuDB
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Adding indexes to TokuDB tables
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Modifying the compression of a TokuDB table
- Getting ready
- How to do it...
- How it works...
- There's more...
- 5. The CONNECT Storage Engine
- Introduction
- Installing the CONNECT storage engine
- How to do it...
- How it works...
- See also
- Creating and dropping CONNECT tables
- Getting ready
- How to do it...
- How it works...
- There's more...
- OPTION_LIST options
- Dropping CONNECT tables
- Files and CONNECT
- See also
- Reading and writing CSV data using CONNECT
- Getting ready
- How to do it...
- How it works...
- There's more...
- CSV header lines
- Changing the number and order of columns read using flags
- See also
- Reading and writing XML data using CONNECT
- Getting ready
- How to do it...
- How it works...
- There's more...
- Inserting XML data
- Tree versus HTML-like data structures
- Tags and tag attributes
- See also
- Accessing MariaDB tables using CONNECT
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using the XCOL table type
- How to do it...
- How it works...
- There's more...
- See also
- Using the PIVOT table type
- How to do it...
- How it works...
- There's more...
- See also
- Using the OCCUR table type
- How to do it...
- How it works...
- There's more...
- See also
- Using the WMI table type
- Getting ready
- How to do it...
- How it works...
- There's more...
- Performance
- Other information
- See also
- Using the MAC address table type
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 6. Replication in MariaDB
- Introduction
- Setting up replication
- Getting ready
- How to do it...
- How it works...
- There's more...
- Common causes of replication failures
- Binary logs versus relay logs
- Safer replication
- See also
- Using global transaction IDs
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using multisource replication
- Getting ready
- How to do it...
- How it works...
- There's more...
- Other ignore options
- Additional files
- See also
- Enhancing the binlog with row event annotations
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Configuring binlog event checksums
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Selectively skipping the replication of binlog events
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 7. Replication with MariaDB Galera Cluster
- Introduction
- Installing MariaDB Galera Cluster
- Getting ready
- How to do it...
- How it works...
- There's more...
- Configuring MariaDB Galera Cluster
- See also
- Dropping a node from MariaDB Galera Cluster
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Shutting down MariaDB Galera Cluster
- Getting ready
- How to do it...
- How it works...
- See also
- 8. Performance and Usage Statistics
- Introduction
- Installing the Audit Plugin
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using the Audit Plugin
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using engine-independent table statistics
- How to do it...
- How it works...
- There's more...
- See also
- Using extended statistics
- How to do it...
- How it works...
- There's more...
- See also
- Enabling the performance schema
- How to do it...
- How it works...
- There's more...
- See also
- Using the performance schema
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 9. Searching Data Using Sphinx
- Introduction
- Installing SphinxSE in MariaDB
- How to do it...
- How it works...
- There's more...
- SphinxSE versus Sphinx
- Getting SphinxSE's status
- See also
- Installing the Sphinx daemon on Linux
- How to do it...
- How it works...
- See also
- Installing the Sphinx daemon on Windows
- How to do it...
- How it works...
- There's more...
- See also
- Configuring the Sphinx daemon
- Getting ready
- How to do it...
- How it works...
- There's more...
- The Sphinx daemon and MariaDB on different hosts
- Sphinx queries
- See also
- Searching with the Sphinx daemon and SphinxSE
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 10. Exploring Dynamic and Virtual Columns in MariaDB
- Introduction
- Creating tables with dynamic columns
- How to do it...
- How it works...
- There's more...
- See also
- Inserting, updating, and deleting dynamic column data
- Getting ready
- How to do it...
- How it works...
- There's more...
- Nesting dynamic columns
- See also
- Reading data from a dynamic column
- Getting ready
- How to do it...
- How it works...
- There's more...
- Reading nested dynamic columns
- See also
- Using virtual columns
- How to do it...
- How it works...
- There's more...
- See also
- 11. NoSQL with HandlerSocket
- Introduction
- Installing and configuring HandlerSocket
- How to do it...
- How it works...
- There's more...
- See also
- Installing the libhsclient library
- Getting ready
- How to do it...
- How it works...
- Installing the HandlerSocket PERL client libraries
- Getting ready
- How to do it...
- How it works...
- Reading data using HandlerSocket and PERL
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Inserting data using HandlerSocket and PERL
- Getting ready
- How to do it...
- How it works...
- See also
- Updating and deleting data using HandlerSocket and PERL
- Getting ready
- How to do it...
- How it works...
- See also
- Installing the HandlerSocket Python client libraries
- Getting ready
- How to do it...
- How it works...
- See also
- Reading data using HandlerSocket and Python
- Getting ready
- How to do it...
- How it works...
- See also
- Inserting data using HandlerSocket and Python
- Getting ready
- How to do it...
- How it works...
- See also
- Updating and deleting data using HandlerSocket and Python
- Getting ready
- How to do it...
- How it works...
- See also
- Installing the HandlerSocket Ruby client libraries
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Reading data using HandlerSocket and Ruby
- Getting ready
- How to do it...
- How it works...
- See also
- Inserting data using HandlerSocket and Ruby
- Getting ready
- How to do it...
- How it works...
- See also
- Updating and deleting data using HandlerSocket and Ruby
- Getting ready
- How to do it...
- How it works...
- See also
- Using HandlerSocket directly with Telnet
- Getting ready
- How to do it...
- How it works...
- See also
- 12. NoSQL with the Cassandra Storage Engine
- Introduction
- Installing the Cassandra storage engine
- How to do it...
- How it works...
- There's more...
- See also
- Mapping data between MariaDB and Cassandra
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using INSERT, UPDATE, and DELETE with the Cassandra storage engine
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using SELECT with the Cassandra storage engine
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- 13. MariaDB Security
- Introduction
- Securing MariaDB with mysql_secure_installation
- How to do it...
- How it works...
- There's more...
- See also
- Securing MariaDB files on Linux
- Getting ready
- How to do it...
- How it works...
- There's more...
- Securing MariaDB files on Windows
- How to do it...
- How it works...
- There's more...
- Checking for users with insecure passwords
- How to do it...
- How it works...
- See also
- Encrypting connections with SSL
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Using roles to control user permissions
- How to do it...
- How it works...
- See also
- Authenticating using the PAM authentication plugin
- Getting ready
- How to do it...
- How it works...
- There's more...
- See also
- Index
Packt Publishing - inne książki
-
Mastering Data transformation is essential for enhancing their data models and business intelligence. The Definitive Guide to Power Query equips you with the knowledge and skills to master the tool while leveraging its remarkable capabilities.
The Definitive Guide to Power Query (M). Mastering complex data transformation with Power Query The Definitive Guide to Power Query (M). Mastering complex data transformation with Power Query
Gregory Deckler, Rick de Groot, Melissa de Korte, Brian Julius
-
API Security for White Hat Hackers is a comprehensive guide that simplifies API security by showing you how to identify and fix vulnerabilities. From emerging threats to best practices, this book helps you defend and safeguard your APIs.
API Security for White Hat Hackers. Uncover offensive defense strategies and get up to speed with secure API implementation API Security for White Hat Hackers. Uncover offensive defense strategies and get up to speed with secure API implementation
Dzieki opcji "Druk na żądanie" do sprzedaży wracają tytuły Grupy Helion, które cieszyły sie dużym zainteresowaniem, a których nakład został wyprzedany.
Dla naszych Czytelników wydrukowaliśmy dodatkową pulę egzemplarzy w technice druku cyfrowego.
Co powinieneś wiedzieć o usłudze "Druk na żądanie":
- usługa obejmuje tylko widoczną poniżej listę tytułów, którą na bieżąco aktualizujemy;
- cena książki może być wyższa od początkowej ceny detalicznej, co jest spowodowane kosztami druku cyfrowego (wyższymi niż koszty tradycyjnego druku offsetowego). Obowiązująca cena jest zawsze podawana na stronie WWW książki;
- zawartość książki wraz z dodatkami (płyta CD, DVD) odpowiada jej pierwotnemu wydaniu i jest w pełni komplementarna;
- usługa nie obejmuje książek w kolorze.
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka, którą chcesz zamówić pochodzi z końcówki nakładu. Oznacza to, że mogą się pojawić drobne defekty (otarcia, rysy, zagięcia).
Co powinieneś wiedzieć o usłudze "Końcówka nakładu":
- usługa obejmuje tylko książki oznaczone tagiem "Końcówka nakładu";
- wady o których mowa powyżej nie podlegają reklamacji;
Masz pytanie o konkretny tytuł? Napisz do nas: sklep[at]helion.pl.
Książka drukowana
![Loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
![ajax-loader](https://static01.helion.com.pl/ebookpoint/img/ajax-loader.gif)
Oceny i opinie klientów: MariaDB Cookbook. Learn how to use the database that’s growing in popularity as a drop-in replacement for MySQL. The MariaDB Cookbook is overflowing with handy recipes and code examples to help you become an expert simply and speedily Daniel Bartholomew (0)
Weryfikacja opinii następuję na podstawie historii zamówień na koncie Użytkownika umieszczającego opinię. Użytkownik mógł otrzymać punkty za opublikowanie opinii uprawniające do uzyskania rabatu w ramach Programu Punktowego.