… the market. Facebook has been using them for years now so we can call it pretty proven used with MySQL. Nimbus Data…, filtering, cross database replication. It feature set beats MySQL 5.6 but as Robert Hodges puts it , “it works with MySQL 5.0… in his inspiring Keynote. Clustrix have been showing their scalable MySQL compatible database solution built from the ground up. They got very…
Post: Battery Learning still problem many years after
February 10, 2011 By 7 Comments
… back. We wrote about it, other people from MySQL Community too. The situation did not get better, …lot better than forcing write cache without Battery as database should not get corrupted in case of bad … I’m also wondering if this is something where Facebook Flash Cache can be helpful – if it can …
Post: Percona Live gets bigger: two more speaker tracks!
May 3, 2011 By 1 Comment
… every angle of running a large database in the cloud. This isn’t an extraordinary database, all things considered — as they told…, who make it all possible: Clustrix, Vork, Continuent, Webyog, EffectiveMySQL, Facebook, OmniTI, Sphinx, Tokutek, Zmanda, DaniWeb, and PalominoDB.
Post: Percona Server and XtraBackup weekly news, March 5th
March 6, 2011 By Leave a Comment
… Squeeze in our repositories on the next release based on MySQL 5.1.55, which we estimate will be released on… feature could help alleviate. We merged a change developed by Facebook that reduces excess fcntl() calls. This has been shown to…. We have decided to make innobackupex always back up the MySQL system database, even for partial backups; it contains data that is…
Comment: Introducing new type of benchmark
February 26, 2012 By 16 Comments
… have a few key databases but our dataset is 150G for one, 500G for another (for databases that are our lively hood). So we’re not at a scale of Facebook or Twitter, and given… at the scale of Facebook and/or have a sharded datastore. A possible solution is to use mysql proxy and an alterate…
Post: Level 2 Flash cache is there
April 27, 2010 By 5 Comments
… my talk An Overview of Flash Storage for Databases I see in the near and middle term …. I congrats Facebook with implementation of great idea and I am happy to see Facebook releases it under … David Jiang http://code.google.com/p/david-mysql-tools/wiki/innodb_secondary_buffer_pool, it allows …
Comment: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… like Facebook and Twitter do *exactly* this. Especially in Facebook‘s case, this strategy has been key to their scalability. Treating MySQL like… your applications to conform to the performance characteristics of the database. It stinks of a lack of understanding of how code… like DBAs aren’t aware that anything other than the database even exists. Sometimes (actually, almost always) there are good reasons…
Post: Commodity Hardware, Commodity Software and Commodity People
June 15, 2007 By 9 Comments
… head not to mention understanding all ups and downs of database management system. This sounds nice in theory but there are… because of very small database size. Now, for a smaller projects even if you happened to have smart MySQL guy you might… BigTable or FaceBook API, I know few other companies have their special “database” interfaces which run on top of MySQL or other databases. Other…
Comment: When should you store serialized objects in the database?
February 9, 2011 By 47 Comments
…, if Facebook had to start over and knew what they know now, do you think they would have used MySQL again? Based… replication? streaming replication: This streaming replication allows one or more databases to be replicated from a master server. It’s an… ability. This allows a secondary database to be designated as a hot standby should the primary database fail. Another big new feature…
Post: Scaling: Consider both Size and Load
July 13, 2010 By 5 Comments
…Reduced efficiency of CPU cache, Mutex contention and database lock contention all come here. Some of… of versions in system. Applications such as Facebook, Flickr or Twitter have a very clear … scalability. The Replication is perfect example in MySQL world. Slave executes replication stream in single…
