(Jonathan Haddad) I was poking around the MySQL Worklog again over the weekend, and found a request for materialized views for MySQL. This feature has existed in Oracle for a while, in DB2 as a materialized query table, and appeared in MS SQL Server 2000 and 2005 as indexed views.
Tag: Open Source
Efficient CDP solution with instantaneous point-in-time recovery for MySQL
(Dmitri Joukovski) Ask any DBA what are his top priorities for backup of MySQL. Chances are that hot backup and recovery to a specific point-in-time (or transaction) will be on top of everybody’s list.
The MySQL Model
(Ignacio Correas) I have always considered MySQL as the best model for open source companies. Their approach to the market, the execution of different business models, their relation with the community or the way their work internally as a virtual organization have shown an innovative and successful
MySQL Workbench for Database Change Management
(Robin Schumacher) Managing database change is an incredibly important discipline that very few database professionals overtly talk or worry about until they’re in the thick of things with a particular database – moving it from development to production, making changes to a newly installed productio
REST in PostgreSQL Part 3 A – Simple REST Client in Adobe Flex 3
(Leo Hsu and Regina Obe) Adobe Flex is the development API for developing standard Flash and Adobe Air applications which Adobe calls Rich Internet Applications (RIA). Adobe Air run as desktop apps and regular Flex Flash apps run in a browser. At its core is ActionScript 3 which one can think of as
Learning about MySQL Table Fragmentation
(Peter Zaitsev) Recently I was working with the customer who need quick warmup – to get Innodb table fetched in memory as fast as possible to get good in memory access performance.
MySQL: Time Delayed Replication
(Jon Haddad) I was cruising the MySQL Forge Worklog when I came across the idea of Time Delayed Replication. I had never considered the benefits of deliberately keeping a slave server behind a master.
MySQL Replication vs DRBD Battles
(Peter Zaitsev) Well these days we see a lot of post for and against (more, more) using of MySQL and DRBD as a high availability practice.
Benchmark MySQL Proxy and HSCALE
(Pero) As part of developing HSCALE, a partitioning / sharding solution, I set up a benchmark test suite. I made it scripted and thus repeatable to monitor the progress and performance regressions during the development.
The MySQL optimizer, the OS cache, and sequential versus random I/O
(Baron Schwartz) In my post on estimating query completion time, I wrote about how I measured the performance on a join between a few tables in a typical star schema data warehousing scenario.