… server can easily handle the write load of all the MySQL instances. The original idea was to configure them with raid… snapshot per day for the last 30 days one snapshot per hour for the last 2 days one snapshot per 5min for the last 2 hours… together, ZFS on Linux is a very interesting solution for MySQL backup servers. All backup solutions have an impact on performance…
Post: Percona Live MySQL Conference 2013 wrap-up
April 29, 2013 By Leave a Comment
…session speakers who presented insights into MySQL and MySQL-related technologies in over 110 sessions across four days. Special thanks go to …evolving MySQL ecosystem.”[/caption] Unlike last year, Oracle sent both executives and technical staff to the conference so it included all significant MySQL…
Post: 5 Percona Toolkit Tools for MySQL That Could Save Your Day: April 3 Webinar
March 22, 2013 By Leave a Comment
… Tools for MySQL That Could Save Your Day.” In this presentation you’ll learn how to perform typical but challenging MySQL database administration… for MySQL That Could Save Your Day“Percona Toolkit for MySQL is a must-have set of tools that can help serious MySQL administrators… and last only a few seconds How to run ALTER TABLE on your largest tables without downtime REGISTER NOW for this MySQL…
Post: Moving to MySQL 5.6? We can help
April 12, 2013 By Leave a Comment
… to MySQL 5.6. The class is called Moving to MySQL 5.6 and is a 2-day workshop. The Moving to MySQL 5… discount code mpb10 you can save 10% when you register. Last, I would be remiss if I did not remind you… is not too late to purchase tickets for Percona Live MySQL Conference and Expo Community in Santa Clara, California, April 22…
Post: High-load problems? Investigate them with 'pt-query-digest'
April 23, 2013 By 2 Comments
… case last week, and I thought I’d share what I think is a little known goodie from Percona Toolkit for MySQL… share of format parsers, but the one that saved the day here is also the simplest: the ‘raw’ log parser. If… issues. If you regularly work with MySQL databases, getting familiar with Percona Toolkit for MySQL will let you do more work, in…
Comment: MySQL Partitioning - can save you or kill you
April 30, 2013 By 45 Comments
… queries hit the last week or two. I have only 20 partitions; they are PARTITION BY RANGE (to_days(…)). However, the ranges are uneven — older partitions cover larger timespans. The last few partitions are one week… (within a single connection) anywhere in any ‘free’ variant of MySQL. PARTITIONs are scanned one at a time. (Please provide specific…
Post: Two Types of MySQL Users
May 10, 2010 By 5 Comments
… and write them, they may even hack on MySQL. So this fraction of MySQL Community looks a lot larger than it is… players in MySQL community participated in MySQL Users Conference over the years. This is about 2000 people a year for last 8 years… Server, they often do not attend MySQL Conference and may not even know Oracle owns MySQL these days. This group is often rather…
Post: MySQL Replication vs DRBD Battles
April 28, 2008 By 12 Comments
Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high… at the same time as running reporting queries on last month. All last month will be hot on the slave which is… have it all The state of High Availability Solutions for MySQL these days is – you can’t have it all. There is…
Post: Percona Live MySQL Conference & Expo Was A Great Event
April 17, 2012 By 2 Comments
… selection committee, event staff, and especially the attendees for making last week’s conference a resounding success. With over a thousand… for MySQL 5.6, released on Monday. MySQL 5.6 just keeps looking better and better. The SkySQL/MariaDB, Sphinx, and Drizzle day… also recorded some of the breakout sessions, so watch Planet MySQL for an announcement when she posts those online. Presentation slides…
Post: Percona Live MySQL Conference and Expo 2013: The talks I want to see
February 12, 2013 By 4 Comments
… at the last minute, but here’s what I’d choose today: Tutorial Day I’m giving my own all-day tutorial on… instruction about what some migration strategies might look like. Using MySQL Performance Schema to debug performance issues - (Zburivsky Danil, Pythian) – I… me, this seems compelling. Managing data and data archiving using MySQL 5.6 new features of Portable Tablespace and EXCHANGE PARTITION…
