… instrumentation chapter. What is operations training? Many companies split their technical staff between development, and operations. The operations team is responsible for tasks… pager. They are the heroes that fight fires. Our operations day of training is delivered as a hands on class. Attendees…
Post: Percona Training in London and Frankfurt
December 13, 2010 By Leave a Comment
… – last week we added training in Frankfurt and London to our website. This includes our new Operations Training announced in September. (While…
Post: Percona Training: Dublin, San Diego, NYC, and WDC
October 31, 2011 By Leave a Comment
… over. We will be holding our Developer, DBA, InnoDB, and Operations training in the following cities: Dublin, Ireland – December 5 – 8, 2011…
Page: Consulting for MySQL
July 31, 2006 By
… training, and support, and development) services for MySQL and LAMP applications. We can help with all areas of the MySQL Server – Operations… backup procedures, pro actively monitor server to avoid downtime. Customized Training for MySQL Want your developers to learn MySQL best practices… presented to focus on areas you’re looking to be trained on Candidate interview and coaching Need help with candidate interview…
Post: Why you don't want to shard.
August 6, 2009 By 33 Comments
… post is part 1 of 4 on building our training workshop. The Percona training workshop will not cover sharding. If you follow… logic (this is actually lessened with projects such as HiveDB.) Operational issues become more difficult (backing up, adding indexes, changing schema… of these tasks remain only semi-automated, so from an operations perspective there can often be a lot more work to…
Post: Aligning IO on a hard disk RAID – the Theory
June 9, 2011 By 15 Comments
…. Here’s another example of misalignment, described in SGI xfs training slides: D stands for the disk here so the RAID… this level and nor do RAID controllers as they also operate in 512-bytes internally. This however gets more complicated with SSD drives which often operate in 4kbyte units, though this is surely a topic for…
Post: How Percona does a MySQL Performance Audit
November 24, 2008 By 17 Comments
… recover from disasters? We also want to know what the operating parameters are. Can we suggest upgrades, rewriting queries, or whatnot… a prerequisite to understanding the context within which these things operate. For example, if the workload is a star schema data… queries and how EXPLAIN works. At Percona, we have peer training constantly on our internal IRC channel and mailing list. We…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
… I know it will run for days? Here’s my train of thought: It’s performing index lookups into the fact… that this equates to about 18790 * 606 = 11386740 I/O operations, assuming that the indexes are fully in memory. When you… second dimension table. That’s 300 million random I/O operations. In contrast, the optimizer chose a plan that it thought…
Post: Off to California!
September 10, 2009 By 5 Comments
… day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week. Our Montreal practice teach at Station-C… slides and our official classes will have much better information. Operational issues are one of the most important things people want…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… etc. I’m not the great person for such routine operations so it was not always done well. Good enough we… draw application structure on the whiteboard or to have mini training done about efficient MySQL usage, or simply when security is… and efficiency. We need to find a great people and train them and this is not something you can do in…
