It’s time for the weekly roundup of news for Percona Server and XtraBackup. To follow up on my note from last week, we’re still checking and validating the download stats. It appears that Percona Server has been downloaded well over 100,000 times, and Percona XtraBackup has been downloaded over 200,000 times. But when we changed [...]
In my previous post I introduced materialized view concepts. As a reminder, the first post covered the following topics: What is a materialized view(MV)? It explained that an MV can pre-compute joins and may aggregate and summarize data. Using the aggregated data can significantly improve query response times compared to accessing the non-aggregated data. Keeping [...]
Conference season is rapidly approaching and the MySQL Cluster product team will be out on the road, sharing the latest and greatest news on best practices, use-cases and developments. These will be valuable sessions for users who to learn more about building write-scalable, real-time transactional services with 99.999% availability, using a variety of SQL and Non-SQL (dare I say "NoSQL") interfaces to their data.
Collaborate Community Conference
If you know me, then you probably have heard of Flexviews. If not, then it might not be familiar to you. I’m giving a talk on it at the MySQL 2011 CE, and I figured I should blog about it before then. For those unfamiliar, Flexviews enables you to create and maintain incrementally refreshable materialized [...]
Two notes for readers. First, we have been publishing a great deal of video material on our companion site Percona.TV. This includes our recordings from past conferences, user group meetings, screencasts, and most recently our webinars. (I hate the proprietary formats and silly technical restrictions that the webinar companies impose. I figured out how to [...]
Today I was looking for the ALTER TABLE EXCHANGE PARTITION feature for a customer, and it looks like it did not get included into MySQL 5.5, although there is a hint of it in the documentation index, and you can find quite a few blog posts and presentations about it.
Have just read Darren Cassar’s Recovering a MySQL `root` password – Three solutions. There’s a fourth solution: using an init-file, which leads to just one restart of the database instead of two. It also avoids the security issue involved with using skip-grant-tables.