Our Effective MySQL Books
At Effective MySQL we provide resources for the DBA, Developer and Architect to best use MySQL. This includes currently three books in our series, available in print, PDF and Kindle formats.
 |
 |
 |
| Buy Now | Buy Now | Buy Now |
Understanding Tokutek Fractal Tree Indexes
Thanks to Tim Callaghan for speaking Tuesday night at the Effective MySQL New York meetup on Fractal Tree Indexes : Theory and Practice (MySQL and MongoDB). There was a good turnout and a full room to learn how the TokuDB storage engine from Tokutek is changing how to handle big data in MySQL.
Also interesting is how the same technology has been applied for use in MongoDB including giving MongoDB transactions; a big change for NoSQL.
Related News: Tokutek Meets Big Data Demand With Open Source TokuDB
New MySQL 5.6 Replication Features
There is a long list of new replication features in the latest MySQL 5.6 release including:
- Binary log group commit
- Multi-threaded slaves
- Crash-save slaves
- Global Transaction Identifier (GTID)
- Replication checksums
- Optimized row-based replication
- Time-delayed replication
- Remote binary log backup
- UUID
This presentation from the MySQL Tech Tour events in New York and Boston provides an overview and syntax examples of many of these features. The Effective MySQL: Replication Techniques in Depth also discusses many of these features in detail. Chapter 3 is available for FREE download.
MySQL 5.6 features for NoSQL, Big Data and the Cloud
At the recent MySQL Tech Tour Events in New York and Boston I gave a presentation on MySQL integration with NoSQL,Big Data and the Cloud.
This covered discussion on topics including:
- Memcached API for InnoDB
- InnoDB Online Alter
- InnoDB Full Text Search (FTS)
- Partitioning inprovements for import/export
- SSD Optimisations
- Replication Improvements
- And much more …
Secrets of mysqlnd Presentation
At the recent New York PHP Group in New York, I gave a presentation on “Secrets of mysqlnd”. While there are no real “secrets” of the new MySQL Native Driver for PHP, available in PHP 5.3, and the default for PHP 5.4+ replacing libmysqlclient, there are new features of the driver many are unaware of. If you have ever had to fight the gods with compiling a particular version of PHP with the right libmysqlclient dependency, the good news is that legacy requirement is no longer necessary.
Some of the topics discussed in detail included support for read/write splitting and load balancing with existing applications, and the implications for consistency with MySQL replication. Mysqlnd can also provide failover capabilities, and when combined with using MySQL cluster, Tungsten Replicator and HA manages including MMM and MHA, a more smoother application management of failover in the future may be possible with applicable design.
Mysqlnd also provides a number of other plugin extensions which shows the potential of this new driver for the future. There is still a lot of work to be done, particularly with getting distros and package management to support all capabilities for ease of installation and management.
Lessons learned managing large AWS Environments
At the recent AWS Meetup group in New York, I gave a presentation on “Lessons learned managing large AWS Environments”.
This included my experiences in managing and optimizing AWS costs, CLI automation for web scale (my work at GitHub), knowing about and improving security, what is important monitoring and dealing with failure.
