Tag: Mysql
-
Exposing MyRocks internals via system variables: data writing
Posted on May 31, 2019, Level intermediate Resource Length medium
Peter Sylvester wrote this blog post about new storage engine for MySQL that's rising in popularity. MyRocks, the log-structured merge-driven RocksDB engine in MySQL.
Tags database mysql miscellaneous
-
MySQL high availability framework explained – part one
Posted on February 24, 2019, Level intermediate Resource Length medium
This is three-part blog series, in which author explains the details and functionality of a High Availability (HA) framework for MySQL hosting using MySQL semisynchronous replication and the Corosync plus Pacemaker stack. Published by Prasad Nagaraj VP Engineering at ScaleGrid.
Tags mysql database software devops
-
Combining Amazon Aurora, Lambda, and SQS to go beyond the native capabilities of MySQL
Posted on November 26, 2018, Level intermediate Resource Length medium
David Yahalom posted on redgate Hub about innovative combination of Amazon Aurora, serverless Lambda and Simple Que Service to strecth MySQL beyond native capabilities.
Tags mysql serverless aws devops miscellaneous queues
-
10 MySQL database tuning tips for peak workloads
Posted on November 17, 2018, Level intermediate Resource Length long
Folks from MariaDB wrote this article in which they collated 10 MySQL tuning tips for peak workloads. As we head into the holiday season and the start of a new year, now is a great time to ensure your database is ready for whatever comes its way.
Tags mysql database performance
-
MySQL vs. MariaDB: Reality check
Posted on January 4, 2018, Level beginner Resource Length long
Colin Charles published extensive comparison between MySQL vs. MariaDB (including Percona Server for MySQL). His goal was to evaluate, at a higher level, MySQL, MariaDB and Percona Server for MySQL side-by-side to better inform the decision making process. It is largely an unofficial response to published comments from the MariaDB Corporation.
Tags mysql database software
-
MySQL 8.0 performance and ReadWrite workloads scalability
Posted on October 30, 2017, Level advanced Resource Length long
Dimitri Kravtchuk (MySQL Performance Architect, Oracle) - published blog post on new MySQL 8.0 performance. He writes about how their Read-Only scalability was a big pain, as Read-Only (RO) workloads were often slower than Read-Write (sounds very odd: "add Writes to your Reads to go faster", but this was our reality ;-)) -- and things were largely improved since MySQL 5.7 where we broke 1M queries per second (QPS) barrier and reached 1.6M QPS for the first time. However, improving Writes or mixed Read+Writes (RW) workloads is a much more complex story.
Tags mysql database software