Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 61 to 67

Displaying posts with tag: scaling (reset)

Archive strategies for OLTP servers, Part 3
+0 Vote Up -0Vote Down

In the first two articles in this series, I discussed archiving basics, relationships and dependencies, and specific archiving techniques for online transaction processing (OLTP) database servers. This article covers how to move the data from the OLTP source to the archive destination, what the archive destination might look like, and how to un-archive data. If you can un-archive easily and reliably, a whole new world of possibilities opens up.

Archive strategies for OLTP servers, Part 2
+0 Vote Up -0Vote Down

In the first article in this series on archiving strategies for online transaction processing (OLTP) database servers, I covered some basics: why to archive, and what to consider when gathering requirements for the archived data itself. This article is more technical. I want to help you understand how to choose which rows are archivable, and how to deal with complex data relationships and dependencies. In that context, I'll also discuss a few concrete archiving strategies, their strengths and shortcomings, and how they can satisfy your requirements, especially requirements for data consistency, which as you will see is one of the most difficult problems in archiving.

Archive strategies for OLTP servers, Part 1
+0 Vote Up -0Vote Down

In May 2005, I wrote a widely-referenced article about how to efficiently archive and/or purge data from online transaction processing (OLTP) database servers. That article focused on how to write efficient archiving SQL. In this article I'll discuss archiving strategy, not tactics. OLTP servers tend to have complex schemas, which makes it important and sometimes difficult to design a good archiving strategy.

Slides from PHP Vancouver
+0 Vote Up -0Vote Down

From the keynote presentation this past Tuesday:
http://krow.net/talks/ScalingVancouver2007.pdf

I have an audio recording of the talk as well but it is in poor shape. If I can clean it up I will post it as well.

Genesis: Application Clustering
+0 Vote Up -0Vote Down

In the previous article I discussed using Read Replication Clustering to scale out reads for a website. What I will now do is describe a refined approach to the problem of scaling by creating "Application Clusters with Replication".

A common approach to website design is that a web designer creates a website and decides that search is a feature that they want to implement. If they use the MyISAM engine this means that they can add fulltext indexes to their tables and then make use of them in queries. I will ignore the case where the developer decides that an unanchored LIKE clause is an appropriate solution, since this developer will quickly hit a wall on performance and …

  [Read more...]
Genesis: Read Replication Cluster
+0 Vote Up -0Vote Down

If there is a common method of scaling with MySQL databases it is the
Read Replication Cluster solution.

Most websites start out with a single database and grow from there.
If the site's content is being generated from their database then
they will eventually hit a wall with reads from the database. Tuning
and hardware will buy you some growth but in the end disks spin only
so quickly. Luckily most websites are predominantly read intensive
and for this reason replication will solve scaling problems for many
people. Replication is a means by which MySQL sends updates of one
database to one or more databases which …









  [Read more...]
Genesis: The Search for Scaling
+0 Vote Up -0Vote Down

I've never been all that interested in solving small problems. Small problems with scaling are resolved with single indexes, upgrades to hardware, or simply creating a bigger pipe.

When the measure of the Internet was a T-1, you could flood the network with the average 486. At the time I watched people buy hardware in the hundred's of thousands, and sometimes more, which never went used. Today's hardware is overkill for a lot of applications, so the first step in scaling is often tuning the hardware that you have already purchased. Make use of what you already have.

The "Slashdot Effect" is a perfect example of what is normally a small problem. What is the …



  [Read more...]
10 Newer Entries Showing entries 61 to 67

Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.