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
- Autor:
- Daniel Bartholomew
- 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
-
Ця книжка познайомить вас з особливостями 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
-
The Definitive Guide to Data Integration is for data eclectics looking to explore the modern data stack. Complete with practical examples and insights, it covering tools, techniques, and best practices to unleash your data's potential.
The Definitive Guide to Data Integration. Unlock the power of data integration to efficiently manage, transform, and analyze data The Definitive Guide to Data Integration. Unlock the power of data integration to efficiently manage, transform, and analyze data
Pierre-Yves BONNEFOY, Emeric CHAIZE, Raphaël MANSUY, Mehdi TAZI, Stephane Heckel
-
Learn T-SQL Querying, Second Edition, is an up-to-date reference designed to help you write more efficient T-SQL code to perform simple-to-advanced tasks for data management and data analysis tasks.
Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition Learn T-SQL Querying. A guide to developing efficient and elegant T-SQL code - Second Edition
-
With the help of well-structured and practical recipes, this book will teach you how to integrate data from the cloud and on-premises. You’ll learn how to transform, clean, and consolidate data into a single data platform and get to grips with ADF
Azure Data Factory Cookbook. Build ETL, Hybrid ETL, and ELT pipelines using ADF, Synapse Analytics, Fabric and Databricks - Second Edition Azure Data Factory Cookbook. Build ETL, Hybrid ETL, and ELT pipelines using ADF, Synapse Analytics, Fabric and Databricks - Second Edition
Dmitry Foshin, Tonya Chernyshova, Dmitry Anoshin, Xenia Ireton
-
Learn new techniques to ingest, transform, merge, and deliver trusted data to downstream users using modern cloud data architectures and Scala, and learn end-to-end data engineering that will make you the most valuable asset on your data team.
Data Engineering with Scala and Spark. Build streaming and batch pipelines that process massive amounts of data using Scala Data Engineering with Scala and Spark. Build streaming and batch pipelines that process massive amounts of data using Scala
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
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
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.