There have been a couple of recent blog articles (here and here) asking for parallel replication based on something other than schemas. These articles both focus on the problem of parallelizing updates within a single MySQL schema. I read these with great interest, not least because they both mentioned Tungsten (thanks!) and also found that our schema-based parallelization approach [...] [...more]
Knowledge: A Different Approach to a Database on the Desktop KDE.news: “Desktop applications for ‘Information Management’ that go beyond conventional card-index style databases are hard to find. The ideas behind such software are perhaps not that well known, so a prototype program, Knowledge, has been developed to put them firmly into the public domain.” Read [...] [...more]
I want to delete users that hasn’t logged in in a certain amount of days, and other expired entries in a database. What is the best way of doing this automatically? I’m using MySQL and PHP for my web application. One way I have thought is having a clean_db() function that I call in every [...] [...more]
Another thing I find interesting about MongoDB is its approach to Durability, Data Consistency and Availability. It is very relaxed and will not work for some applications but for others it can be usable in current form. Let me explain some concepts and compare it to technologies in MySQL space. First I think MongoDB is [...] [...more]
I went to MongoSF today – quite an event, and I hope to have a chance to write more about it. This post is about one replication problem and how MongoDB solves it. If you’re using MySQL Replication when your master goes down it is possible for some writes to be executed on the master, [...] [...more]
