%APPDATA%\MySQL on Windows)
Cherry-picking from the Change log:
--bind_addressto complement the effects of
MySQL 5.6 includes a host of enhancements to replication (http://www.mysql.com/products/enterprise/replication.html), enabling DevOps teams to reliably scale-out their MySQL infrastructure across commodity hardware, on-premise or in the cloud.
One of the most significant enhancements is the introduction of Global Transaction Identifiers (GTIDs) where the primary development motivation was:
- enabling seamless failover or switchover from a replication master to slave
- promoting that slave to the new master
- without manual intervention and with minimal service disruption.
You can download the new MySQL Replication High Availability Guide (http://www.mysql.com/why-mysql/white-papers/mysql-replication-high-availability/) to[Read more...]
So the common solution is to artificially warm upthe server by doing queries which will fill the buffer pool. Typical solutions might be to do: SELECT COUNT(*) FROM some_table FORCE INDEX (PRIMARY) LIMIT ... on a number of tables to fill up the pool on startup. Fitting this into the standard mysql init start script is somewhat tricky as no hooks are provided for this sort of post-start action. (It would be nice to have this for other tasks too.)Of course choosing the right parameters here can be tricky as workload changes over time, and as the ratio of the size of the database to the size of the [Read more...]