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|
- Product options
- MySQL Enterprise Backup
- LVM/SAN Snapshot
- Filesystem copy
- Binary log backup options
- B&R Strategy considerations
- Time to backup
- Time to restore
- Partial Capabilities
- Technical Requirements
- Testing & Verification
- Using Failover
- What are the common approaches to data replication?
- Why do you want to use data replication in your application?
- What MySQL offers with different replication types.
- What are the limitations of different MySQL replication.
- How to evaluate your architecture needs
- A new architecture mindset
- Data Availability
- Data Classification
- Data Pipelines
At our September 2016 New York City MySQL Meetup was a demonstration of how to implement role-based security in MySQL using Hexatier. In addition, several other important security features demonstrated included role based dynamic data masking down to a per column level and full statement auditing.
Thanks to Scott Unrick, Lead Database Administrator at Teladoc for the great presentation. Slides are available here.
At our June meetup, our guest speaker and Chief Evangelist from MariaDb Colin Charles gave a presentation on “Lessons from database failures”. Some of the details of his presentation included:
- Notable failures causing companies to go out of business
- varying backup commands and options
- Understanding a/semi/synchronous replication
- Replication topology management tools
- Proxy and sharding tools
- Security, SQL injections and encryption
At our August meetup, our guest Calvin Sun gave a presentation on life @ Twitter. Some of the details of his presentation included:
- Information on existing data and storage solutions in operation.
- MySQL 5.6 performance improvements over MySQL 5.5
- The short upgrade cadence, most servers are running 5.6.26.
- Various patches and optimizations developed by Twitter to run at scale.
- Cotton on Mesos
- Best practices
In this presentation on High Performance SQL and NoSQL to the New York Web Performance Meetup I use the simple analogy of applying the same techniques used in Web Performance Optimization (WPO) to your data path (SQL or NoSQL) performance.
This presentation provides examples for 5 of the most common WPO optimizations and how to apply this to your applications access to data:
- Gzip assets
- Make fewer HTTP requests
- Add expires headers
- Use a CDN
- Optimized Images
This presentation was recorded. A video link will be available at a later time.
Thanks to Grovo for hosting the event.