Magento 2 Development Cookbook

Magento 2 Development Cookbook

Overview of this book

With the challenges of growing an online business, Magento 2 is an open source e-commerce platform with innumerable functionalities that gives you the freedom to make on-the-fly decisions. It allows you to customize multiple levels of security permissions and enhance the look and feel of your website, and thus gives you a personalized experience in promoting your business.

Magento 2 Development Cookbook

Credits

About the Author

About the Reviewers

www.PacktPub.com

Preface

Free Chapter

Upgrading from Magento 1

Introduction

Creating a Magento 1 website with sample data

Creating a Magento 2 website

Preparing an upgrade from Magento 1

Upgrading the database

Using an IDE

Writing clean code with PHP MD and PHP CS

Working with Products

Introduction

Configuring the catalog defaults

Working with attribute sets

Working with product types

Adding social media buttons

Embedding an HTML object

Changing the URL of a product page

Theming

Introduction

Exploring the default Magento 2 themes

Creating a Magento 2 theme

Customizing the HTML output

Adding extra files to the theme

Working with LESS

Changing a page title

Working with translations

Adding widgets to the layout

Customizing email templates

Creating a Module

Introduction

Creating the module files

Creating a controller

Adding layout updates

Adding a translation file

Adding a block of new products

Adding an interceptor

Adding a console command

Databases and Modules

Introduction

Creating an install and upgrade script

Creating a flat table with models

Working with Magento collections

Programmatically adding product attributes

Repairing the database

Magento Backend

Introduction

Registering a backend controller

Extending the menu

Adding an ACL

Adding configuration parameters

Creating a grid of a database table

Working with backend components

Adding customer attributes

Working with source models

Event Handlers and Cronjobs

Introduction

Understanding event types

Creating your own event

Adding an event observer

Introducing cronjobs

Creating and testing a new cronjob

Creating a Shipping Module

Introduction

Initializing module configurations

Writing an adapter model

Extending the shipping method features

Adding the module in the frontend

Creating a Product Slider Widget

Introduction

Creating an empty module

Creating a widget configuration file

Creating the block and template files

Creating a custom configuration parameter

Finalizing the theming

Performance Optimization

Introduction

Benchmarking a website

Optimizing the frontend of the website

Optimizing the database and MySQL configurations

Optimizing the Apache web server

Finding performance leaks in Magento

Configuring OPcache, Redis, and Memcached

Optimizing the PHP configurations

Debugging and Unit Testing

Introduction

Logging into Magento 2

Getting started with Xdebug

Running automated tests from Magento

Creating a Magento test case

Index

Customer Reviews

5 star

4 star

3 star

2 star

1 star

Optimizing the database and MySQL configurations

The Magento applications use a database to store all the data, including products, customers, orders, and more. The database is the central storage of all the data that is available in the Magento instance. Scaling Magento to multiple frontend servers is not that hard but scaling the database is much harder because the data is something that needs to be in sync.

In this recipe, we will see how we can optimize the database and the MySQL server.

Getting ready

Ensure that you have access to a database client where you can do some queries to your database. In this recipe, we will use phpMyAdmin.

How to do it...

In the first part of this recipe, we will optimize the table structures of the Magento database. Take a look at the following steps:

Open phpMyAdmin and click on the Magento database. You will see an overview of all the tables.
At the bottom of this page, click on the Check All button.
When you click on the dropdown list, you can repair the table...

Magento 2 Development Cookbook

Magento 2 Development Cookbook

Overview of this book

Related Content you might be interested in

Current Title:

Magento 2 Development Cookbook

Optimizing the database and MySQL configurations

Getting ready

How to do it...