Challenges of Big Databases with MySQL
Many database management tasks become difficult as you move from millions of rows and gigabytes of data to billions of rows and terabytes of data. Such tasks include ingesting data while maintaining indexes; changing schemas without downtime; and supporting connections, replication, and backup. For some scaling problems (connections and replication), MySQL is better than most of the competition. For others, such as indexing, schema changes, and backup, MySQL has typically been harder to use. Fortunately, the tasks MySQL does well are in its core, whereas the tasks that are more difficult can be solved with storage engine plug-ins.
This presentation discusses how MySQL’s storage engines have recently made dramatic progress in large database manageability. I’ll be speaking Sunday (10/2) 2:45 pm at Moscone West, 2018. Details can be found here. A complete list of MySQL talks can be found in a handy list that Sheeri put together here.