MySQL Server generates several logs that can help you monitor the activities of the server. However, once these logs are enabled, they can grow in size and start taking up too much disk space. This is why it's important to have an automated way of archiving and preserving MySQL log files for a certain duration, as well as deleting the old ones. In this blog post, we describe … [Read more...] about Managing MySQL Server Logs: Rotate, Compress, Retain & Delete
MySQL
MySQL High Availability Framework Explained Part III: Failover Scenarios
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 … [Read more...] about MySQL High Availability Framework Explained Part III: Failover Scenarios
MySQL vs PostgreSQL: 2019 Showdown
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 data in an organized manner … [Read more...] about MySQL vs PostgreSQL: 2019 Showdown
2019 Database Trends SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use
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 … [Read more...] about 2019 Database Trends SQL vs. NoSQL, Top Databases, Single vs. Multiple Database Use
MySQL Tutorial Understanding The Seconds Behind Master Value
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 The … [Read more...] about MySQL Tutorial Understanding The Seconds Behind Master Value
