Companies Home Search Profile

High Performance MySQL: Proven Strategies for Operating at Scale

High Performance MySQL: Proven Strategies for Operating at Scale

Download pdf

High Performance MySQL: Proven Strategies for Operating at Scale

High Performance MySQL: Proven Strategies for Operating at Scale

Category

SQL

MySQL

Software Development

Author

Jeremy Tinley

Silvia Botros

Publication

OReilly Media

0 View

How can you realize MySQL\'s full power? With High Performance MySQL, you\'ll learn advanced techniques for everything from setting service-level objectives to designing schemas, indexes, and queries to tuning your server, operating system, and hardware to achieve your platform\'s full potential. This guide also teaches database administrators safe and practical ways to scale applications through replication, load balancing, high availability, and failover.

Updated to reflect recent advances in cloud- and self-hosted MySQL, InnoDB performance, and new features and tools, this revised edition helps you design a relational data platform that will scale with your business. You\'ll learn best practices for database security along with hard-earned lessons in both performance and database stability.

Dive into MySQL\'s architecture, including key facts about its storage engines
Learn how server configuration works with your hardware and deployment choices
Make query performance part of your software delivery process
Examine enhancements to MySQL\'s replication and high availability
Compare different MySQL offerings in managed cloud environments
Explore MySQL\'s full stack optimization from application-side configuration to server tuning
Turn traditional database management tasks into automated processes

'

Download pdf

ISBN-10

1492080519

ISBN-13

978-1492080510

Publisher

OReilly Media

Price

41.49

File Type

PDF

Page No.

388

Jeremy Tinley

Jeremy Tinley is a Senior Staff Engineer at Etsy, with over 20 years of MySQL experience. Throughout ...

Silvia Botros

Discover more of the author’s books, see similar authors, read author blogs and more ...

About the Author

Silvia Botros is a Senior Principal Engineer at Twilio. During her time at SendGrid, she helped deploy and maintain various MySQL datastores that support the mail pipeline and other products that SendGrid offers and to drive MySQL designs from inception to production.

Jeremy Tinley is a Senior Staff Engineer at Etsy, with over 20 years of MySQL experience. Throughout his career, he has managed tens of thousands of MySQL instances with an eye towards availability, reliability, and operational efficiency.

Similar Books

Programming Languages and Systems: 31st European Symposium on Programming, ESOP 2022, Held as Part of the European Joint Conferences on Theory and Practice ... Notes in Computer Science Book 13240)

Programming Languages and Systems: 31st European Symposium on Programming, ESOP 2022, Held as Part of the European Joint Conferences on Theory and Practice ... Notes in Computer Science Book 13240)

Ilya Sergey

Software Engineering

Foundations of Software Science and Computation Structures: 25th International Conference, FOSSACS 2022, Held as Part of the European Joint Conferences ... Notes in Computer Science Book 13242)

Foundations of Software Science and Computation Structures: 25th International Conference, FOSSACS 2022, Held as Part of the European Joint Conferences ... Notes in Computer Science Book 13242)

Patricia Bouyer

Software Architecture

Accelerator Programming Using Directives: 8th International Workshop, WACCPD 2021, Virtual Event, November 14, 2021, Proceedings (Lecture Notes in Computer Science Book 13194)

Accelerator Programming Using Directives: 8th International Workshop, WACCPD 2021, Virtual Event, November 14, 2021, Proceedings (Lecture Notes in Computer Science Book 13194)

Sridutt Bhalachandra

Software Engineering

Engineering Multi-Agent Systems: 9th International Workshop, EMAS 2021, Virtual Event, May 3–4, 2021, Revised Selected Papers (Lecture Notes in Computer Science Book 13190)

Engineering Multi-Agent Systems: 9th International Workshop, EMAS 2021, Virtual Event, May 3–4, 2021, Revised Selected Papers (Lecture Notes in Computer Science Book 13190)

Natasha Alechina

Software Engineering

Parallel and Distributed Computing, Applications and Technologies: 22nd International Conference, PDCAT 2021, Guangzhou, China, December 17–19, 2021, Proceedings ... Notes in Computer Science Book 13148)

Parallel and Distributed Computing, Applications and Technologies: 22nd International Conference, PDCAT 2021, Guangzhou, China, December 17–19, 2021, Proceedings ... Notes in Computer Science Book 13148)

Hong Shen

Software Development

Services Computing – SCC 2021: 18th International Conference, Held as Part of the Services Conference Federation, SCF 2021, Virtual Event, December 10–14, ... Notes in Computer Science Book 12995)

Services Computing – SCC 2021: 18th International Conference, Held as Part of the Services Conference Federation, SCF 2021, Virtual Event, December 10–14, ... Notes in Computer Science Book 12995)

Ajay Katangur

Formal Methods for Software Engineering: Languages, Methods, Application Domains (Texts in Theoretical Computer Science. An EATCS Series)

Formal Methods for Software Engineering: Languages, Methods, Application Domains (Texts in Theoretical Computer Science. An EATCS Series)

Markus Roggenbach

Software Engineering

Kafka Up and Running for Network DevOps: Set Your Network Data in Motion

Kafka Up and Running for Network DevOps: Set Your Network Data in Motion

Eric Chou

Software Development

JMP for Mixed Models

JMP for Mixed Models

Ruth Hummel

Software Development

Programming Concurrency on the JVM: Mastering Synchronization, STM, and Actors

Programming Concurrency on the JVM: Mastering Synchronization, STM, and Actors

Venkat Subramaniam

Software Development

Seven Languages in Seven Weeks: A Pragmatic Guide to Learning Programming Languages (Pragmatic Programmers)

Seven Languages in Seven Weeks: A Pragmatic Guide to Learning Programming Languages (Pragmatic Programmers)

Bruce Tate

Software Development

Building Applications with IBM Rational Application Developer and JavaBeans

Building Applications with IBM Rational Application Developer and JavaBeans

Colette Burrus

Software Development

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

Scott Cosentino

Software Development

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Professional Azure SQL Database Administration: Equip yourself with the skills to manage and maintain data in the cloud, 2nd Edition

Ahmad Osama

Microsoft Azure

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Mastering PostgreSQL 11: Expert techniques to build scalable, reliable, and fault-tolerant database applications, 2nd Edition

Hans-Jürgen Schönig

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Practical SQL, 2nd Edition: A Beginner's Guide to Storytelling with Data

Anthony DeBarros

SQL Pocket Primer

SQL Pocket Primer

Oswald Campesato

Apache Pulsar in Action

Apache Pulsar in Action

David Kjerrumgaard

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

SQLScript for SAP HANA (Second Edition) (SAP PRESS)

Jörg Brandeis

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Practical Fraud Prevention: Fraud and AML Analytics for Fintech and eCommerce, Using SQL and Python

Gilit Saporta

MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators

Alkin Tezuysal

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

The MySQL Workshop: A practical guide to working with data and managing databases with MySQL

Scott Cosentino

Software Development

MySQL Cookbook: Solutions for Database Developers and Administrators

MySQL Cookbook: Solutions for Database Developers and Administrators

Alkin Tezuysal

Efficient MySQL Performance: Best Practices and Techniques

Efficient MySQL Performance: Best Practices and Techniques

Daniel Nichter

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Querying MariaDB: Use SQL Operations,Data Extraction, and Custom Queries to Make your MariaDB Database Analytics more Accessible (English Edition)

Adam Aspin

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

Advanced MySQL 8: Discover the full potential of MySQL and ensure high performance of your database

Eric Vanier

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

Practical PHP 7, MySQL 8, and MariaDB Website Databases: A Simplified Approach to Developing Database-Driven Websites

Adrian W. West

Web Development

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers

Jesper Wisborg Krogh

Software Development

Learn PHP 7: Object Oriented Modular Programming using HTML5, CSS3, JavaScript, XML, JSON, and MySQL

Learn PHP 7: Object Oriented Modular Programming using HTML5, CSS3, JavaScript, XML, JSON, and MySQL

Steve Prettyman

PHP, MySQL, & JavaScript All-in-One For Dummies

PHP, MySQL, & JavaScript All-in-One For Dummies

Richard Blum

PHP, MySQL, & JavaScript All-in-One For Dummies (For Dummies (Computer/Tech))

PHP, MySQL, & JavaScript All-in-One For Dummies (For Dummies (Computer/Tech))

Richard Blum

Other Authors' Books

Other Publishing Books

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Learning Domain-Driven Design: Aligning Software Architecture and Business Strategy

Vlad Khononov

Software Architecture

CockroachDB: The Definitive Guide: Distributed Data at Scale

CockroachDB: The Definitive Guide: Distributed Data at Scale

Guy Harrison

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

SQL Server Advanced Troubleshooting and Performance Tuning: Best Practices and Techniques

Dmitri Korotkevitch

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Advanced Analytics with PySpark: Patterns for Learning from Data at Scale Using Python and Spark

Akash Tandon

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Snowflake: The Definitive Guide: Architecting, Designing, and Deploying on the Snowflake Data Cloud

Joyce Avila

Cloud Computing

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Python for Data Analysis: Data Wrangling with pandas, NumPy, and Jupyter

Wes McKinney

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Python for Geospatial Data Analysis: Theory, Tools, and Practice for Location Intelligence

Bonny P McClain

Efficient Go: Data-Driven Performance Optimization

Efficient Go: Data-Driven Performance Optimization

Bartlomiej Plotka

Software Development

Foundations of Scalable Systems: Designing Distributed Architectures

Foundations of Scalable Systems: Designing Distributed Architectures

Ian Gorton

Software Development

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Consul: Up and Running: Service Mesh for Any Runtime or Cloud

Luke Kysow

Reliable Machine Learning: Applying SRE Principles to ML in Production

Reliable Machine Learning: Applying SRE Principles to ML in Production

Todd Underwood

Machine Learning

Operating OpenShift: An SRE Approach to Managing Infrastructure

Operating OpenShift: An SRE Approach to Managing Infrastructure

Manuel Dewald

Software Development

User Reviews

Log in first to post a comment

Rating

0

0

0

0

0

average 0

Total votes0