mysql

Introducing MySQL InnoDB Cluster – MySQL HA: Out-of-Box, Easy to use High Availability Introducing the new MySQL InnoDB Cluster Feature MySQL has had good support for replication for a long time. After all, it is one of the key features that have enabled companies like Facebook, Booking, Twitter and so many others to grow and scale to such extreme scale with MySQL as their primary database engine.… Source: Introducing MySQL InnoDB Cluster – MySQL HA: Out-of-Box, Easy to use High Availability

MySQL 8.0: Performance Schema Instrumentation of Server Errors In MySQL 8.0.0, the Performance Schema can now instrument server errors. There are 5 new summary tables introduced: mysql> show tables like “%by_error%”; +——————————————-+ | Tables_in_performance_schema (%by_error%) | +——————————————-+ | events_errors_summary_by_account_by_error | | events_errors_summary_by_host_by_error | | events_errors_summary_by_thread_by_error | | events_errors_summary_by_user_by_error | | events_errors_summary_global_by_error | +——————————————-+ 5 rows in set (0.02 sec) As names suggest, statistics of errors in these tables are aggregated by error.… Source: MySQL 8.0: Performance Schema Instrumentation of Server Errors

MySQL 8.0: Performance Schema, now with indexes! In MySQL 8.0 we are improving the Performance Schema to support indexes. This increases the flexibility and ease of use of using performance_schema, as a number of monitoring queries will see a dramatic speed up in performance. Background Since it’s initial launch in MySQL 5.5, the Performance Schema has grown to 93 tables, with some of these exposing a lot of data.… Source: MySQL 8.0: Performance Schema, now with indexes!

MySQL 8.0: Persisting configuration variables Starting with MySQL 8.0 we are introducing a new feature which will allow configuration variables to be persisted. This means that for a number of configuration settings, you will no longer need to manually edit a configuration file and can instead make modifications directly via an SQL connection.… Source: MySQL 8.0: Persisting configuration variables