Book Image

Yii2 Application Development Cookbook - Third Edition

By : Sergey Ivanov, Andrew Bogdanov, Dmitry Eliseev
Book Image

Yii2 Application Development Cookbook - Third Edition

By: Sergey Ivanov, Andrew Bogdanov, Dmitry Eliseev

Overview of this book

Yii is a free, open source web application development framework written in PHP5 that promotes clean DRY design and encourages rapid development. It works to streamline your application development time and helps to ensure an extremely efficient, extensible, and maintainable end product. Being extremely performance optimized, Yii is a perfect choice for any size project. However, it has been built with sophisticated, enterprise applications in mind. You have full control over the configuration from head-to-toe (presentation-to-persistence) to conform to your enterprise development guidelines. It comes packaged with tools to help test and debug your application, and has clear and comprehensive documentation. This book is a collection of Yii2 recipes. Each recipe is represented as a full and independent item, which showcases solutions from real web-applications. So you can easily reproduce them in your environment and learn Yii2 fast and without tears. All recipes are explained with step-by-step code examples and clear screenshots. Yii2 is like a suit that looks great off the rack, but is also very easy to tailor to fit your needs. Virtually every component of the framework is extensible. This book will show how to use official extensions, extend any component, or write a new one. This book will help you create modern web applications quickly, and make sure they perform well using examples and business logic from real life. You will deal with the Yii command line, migrations, and assets. You will learn about role-based access, security, and deployment. We’ll show you how to easily get started, configure your environment, and be ready to write web applications efficiently and quickly.
Table of Contents (19 chapters)
Yii2 Application Development Cookbook Third Edition
Credits
About the Authors
About the Reviewer
www.PacktPub.com
Preface
Index

Replication and read-write splitting


In this recipe we will have a look at how to do replication and read-write splitting. We will see how slave and master servers help us in getting these done.

Getting ready

  1. Create a new application using the Composer package manager, as described in the official guide at http://www.yiiframework.com/doc-2.0/guide-start-installation.html.

  2. Set up the database connection and create a table named post, as follows:

    DROP TABLE IF EXISTS 'blog_post';
    CREATE TABLE IF NOT EXISTS 'blog_post' (
        'id' INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
        'title' VARCHAR(255) NOT NULL,
        'text' TEXT NOT NULL,
        'created_at' INTEGER,
        'modified_at'INTEGER,
         PRIMARY KEY  ('id')
    );
  3. Generate the BlogPost model for the table blog_post.

  4. Configure master-slave replication between your database servers, for example, as in the article at https://www.digitalocean.com/community/tutorials/how-to-set-up-master-slave-replication-in-mysql/.

  5. Configure the db component in config/main...