MySQL High Availability Framework Explained – Part III: Failover Scenarios

Posted Leave a commentPosted in Cloud, Technical

In this three-part blog series, we introduced a High Availability (HA) Framework for MySQL hosting in Part I, and discussed the details of MySQL semisynchronous replication in Part II. Now in Part III, we review how the framework handles some of the important MySQL failure scenarios and recovers to ensure high availability. MySQL Failover Scenarios Scenario 1 – Master MySQL Goes […]

MySQL vs PostgreSQL: 2019 Showdown

Posted Leave a commentPosted in Cloud, Technical

PostgreSQL and MySQL are types of database management systems (DBMS). This article explains the differences between the systems, reviews the recent trends, and attempts to answer the question of which database management system takes the lead in 2019. Hint: it might not be an either-or answer. Primary Database Model – RDBMS vs ORDBMS Databases store […]

2019 Database Trends – SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use

Posted Leave a commentPosted in Technical

Wondering which databases are trending in 2019? We asked hundreds of developers, engineers, software architects, dev teams, and IT leaders at DeveloperWeek to discover the current NoSQL vs. SQL usage, most popular databases, important metrics to track, and their most time-consuming database management tasks. Get the latest insights on MySQL, MongoDB, PostgreSQL, Redis, and many others to see which database management systems are […]

MySQL Tutorial – Understanding The Seconds Behind Master Value

Posted Leave a commentPosted in Big Data, Cloud

In a MySQL hosting replication setup, the parameter Seconds_Behind_Master (SBM), as displayed by the SHOW SLAVE STATUS command, is commonly used as an indication of the current replication lag of the slave. In this blog post, we examine how to understand and interpret the MySQL Seconds Behind Master value in various situations. Possible Values of  Seconds Behind Master […]

MySQL High Availability Framework Explained – Part I

Posted Leave a commentPosted in Technical

In this two-part blog series, we will explain the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semi-synchronous replication and the Corosync plus Pacemaker stack. In Part I, we’ll walk you through the basics of High Availability, the components of an HA framework, and then introduce you to the HA framework for MySQL. MySQL High Availability […]