mohit | Shared With: Everyone - 12 days ago | mysql, performance, development, replication, technology, databases
There are some helpful tips in here, whether or not you use replication. In my experience, the most important thing with database performance is to minimize the time and row range over which you hold write locks -- and that's what this post is essentially about.
Quoted: Piping data through application is the best solution in many cases and is quite easy - it is trivial to write the function which will take SELECT query and the table to which store its result set and use in your application in all cases when you need this functionality.
- mohit | Shared With: Everyone - Apr 10 2008 | mysql, development, web development, replication, scalability, innovator's dilemma
Some of the referenced blog posts are quite interesting, too.
Quoted: There are interesting posts these day about future of MySQL Replication by Brian Frank and Arjen. I think it very interesting to take a look at a bit bigger picture using framework from Innovators Dilemma and Innovators Solution.
...
All these requirements made traditional databases irrelevant for many web properties - too complex and too expensive to start with. - mohit | Shared With: Everyone - Oct 12 2007 | mysql, sql, performance, databases, development, replication
You have to assume that there will be replication lag. Having said that, chopping up long queries into smaller ones (if using replication) is a good rule of thumb.
Quoted: And the final advice - do not assume very short lag time when planning your application. Having application which can adapt to lag time rather than break is very good idea. Especially it will be handy when you will be reaching replication capacity and will need to buy time to fix things, during which replication lag can be higher than normally.
- mohit | Shared With: Everyone - Feb 15 2007 | mysql, replication, data center, databases
Not rocket science, but helpful nonetheless. We used to run into minor problems until we implemented some of the techniques (primarily the session based approach) below.
Quoted: MySQL Replication is asynchronous which causes problems if you would like to use MySQL Slave as it can contain stale data.
- mohit | Shared With: Everyone - Feb 13 2007 | databases, sql server, mysql, microsoft, replication
A friend was asking me how MySQL replication compares to that in SQL Server, and I didn't know.
Quoted: Unlike MySQL one-way replication, SQL Server offers replication in a number of models: snapshot, transactional and merge.
Related Content from Around Faves
mysql
-
1 FaverViewed: 3 TimesQuoted: Hivelogic is the website of Dan Benjamin
- derek - Aug 21 20081 FaverViewed: 8 Times
- ketchup - 6 days ago1 FaverViewed: 2 Times
database
-
Those plucky penguins--already passé. Whales and polar bears--just fads. But dinosaurs have kept their scaly grip our imaginations. The new DinoBase from the University of Bristol in the U.K. offers plenty of information for everyone from dino dabblers to devotees who want to check whether there's such an animal as "Elvisaurus." (There isn't.) A database holds vital statistics--such as length, weight, and time span--for several hundred dinosaur species, including Stygimoloch spinifer (above), a 3-meter-long herbivore from what is now Montana. Its elaborate headgear might have served as a weapon or as a lure for mates. Visitors can tour a gallery of dino art or dig into the site's forum for announcements of fresh finds and the latest on current debates, such as whether commercial fossil hunters hurt or help paleontology.
Volume 316, Number 5828, Issue of 25 May 2007
1 FaverViewed: 9 Times - mohit - Jul 22 20081 FaverViewed: 2 Times
- garraxxi - Aug 04 20071 FaverViewed: 19 Times
