MySQL Help

MySQL is being made like Oracle. The enterprise edition may be nice if you can afford it, but much of is not needed if you free and open other solutions. It seems MySQL from Oracle is on a dead path somewhat. Oracle seems to have made their own solutions after years of stagnation where Percona and MariaDB forged ahead. It seems the might be intereseted in MySQL again because Oracle is too expensive for cloud solutions. One wonders if they will provide database services with mysql in the cloud and not call it mysql.

Cloud and new technologies

Monyog -- monitoring and displays replication tree, how things are running.
Continuous backups with binlogs-- here
Flush binlogs and backup. The last binlog should remain.
Take backup with binlog position.
Get the date of the first command from binlog. Get the binlog position.
Apply all binlogs with start and stop time. The stop time is the same as pointin time recovery. Really you should use the start position of the backup and the stop time that you want.

MySQL Enterprise Benefits

AWS -- list options here. EBs snapshots and NFS snapshots.

MySQL Sharding or lack thereof

MySQL Frabric Links -- overall, not very popular. Overall, I don't like it. Sharding done right has to be done per table, in the software layer for the application based on what the most important queries will use most of the time.

Others

  https://www.percona.com/blog/2014/07/11/managing-shards-mysql-databases-mysql-fabric-2/
  https://www.percona.com/blog/2014/04/25/managing-farms-of-mysql-servers-with-mysql-fabric/
  https://www.percona.com/blog/2014/08/04/qa-putting-mysql-fabric-to-use/
https://www.slideshare.net/bytebot/best-practices-for-mysqlmariadb-serverpercona-server-high-availability

MySQL tools

Workbench, MySQL enterprise stuff (like monitoring), Oracle MySQL utilities 1.6, MySQL router, percona tools, mariadb, ...etc.

MySQL Routers is usd witjh InnoDB cluster, like Glarea Cluster, to route quweries to the correct server. So if a server goes down it will redirect to another.

MySQL ReleaseNotes

Thread Pool -- enterprise. Should be in standard. Dumb.
Audit --- should be in stnadard, Dumb.
pluggable Authentication. This is good. You can define how someone autheticates.
Lots of Innodb improvements. adaptive hash, flushing, comncurrency, prefech, io threads, being able to set global variables that needed a reboot previously.
NDB is released as a separate product. Not sure why. Probably some marketing scheme.
Semisynchronous replication
Lots of other improvements and also depreciations (some were stupid depreciations).
Performance Schema.
Enhanced show innodb status

MySQL cofig editor.
stronger encryption options and password options.
Innodb full text search
data directory option for create table.
transportable tablespaces -- lets you export and import innodb tables.
Move out the undo into its own tablespaces.
Improcements to engines and internal actions.
Row level replication can do imagfe control where only the columns that change are updated.
Binary logs are crash safe.
changes in replication.
Delayed Replicaiton
--- check on multiple masters.
Multiple replication threads for one per database. Not too helpful.
You can now do explain for insert, update, delete. Question, can you do explain witout permissions to write for IUD.
Get disagnostics.

Encrypted connections, password management, account lockout, ssl and rsa,
ngram and MeCab full-text parser plugins.
Temporary table space now has its own file.
InnoDB supports the Transportable Tablespace feature for partitioned InnoDB tables and individual InnoDB table partitions.
innodb_buffer_pool_size is now dynamic
Table spaces outside the datadir canhold mutiple tables.
Support for json documents in json columns with json functions.
Mutiple triggers
Multi source replication
Group Replication Performance Schema tables.
Group Replication SQL.

user account changes: roles
resource management for threads
json enchancements

Percona Release Notes

MariaDB Release notes

Group commit, MySQL workbench, fabric, gtid (does ot suport multi source ,except mariadb), https://pmmdemo.percona.com/

Tungsten replicator

MySQK to Mogno replication, postgresql, or Oracle.
Free Golden Gate solution.
Different replication topologies allowed.
Automatic failover, don't need MHA.
Multi-master with cloud topologies too.

MySQL-MMM, Serverlnines ClusterControl (good), Orchestrator, Tuingsten Replicastor(good), 5.6 mysqlfailover; mysqlrpladmin, MySQL MHA, Percona REplication Manager, MariaDB Replciation Manager. Hearbeat, PAcemaker, RedHArt CLuster Suite,.

Load balancers for Gaslera: HAProxy, Galera Load Balancer, MaxScale, ProxySQL

Conclusions for HA

MySQL repication: DRDB -> SNA

Sync replication, async for WAN

Suync Multi-master -- no failvoer required

GTId better

Galera

Sharding: spider, tungestren repicator, tumblr jetpants, google vitness, shardquery.

Setup Percona Monitoring and Management Documentation¶ for MysQL and Mongo