19:09 Btw xtrabackup is not only backup.. » MySQL Performance Blog

It is obvious thing for me, but I just figured out it may be not common understanding. Xtrabackup is also can be used (not only can, but we actually use it this way) to clone one slave to another, or just setup new slave from the master. And it is done in almost non-blocking way ( true for InnoDB setups) for cloned server. Here is command

CODE:
  1. innobackupex-1.5.1 --stream=tar /tmp/--slave-info | ssh user@DESTSERVER "tar xfzi - -C /DESTDIR"

When it finished on destination server you run

CODE:
  1. innobackupex-1.5.1 --apply-log --use-memory=2G  /DESTDIR

And you have ready database directory, just copy my.cnf from original server and start mysqld.


Entry posted by Vadim | No comment

Add to: delicious | digg | reddit | netscape | Google Bookmarks

14:48 How to Use Ecommerce Tracking in Google Analytics » Google Analytics Blog
Last year, Justin Cutroni of EpikOne published a four-part tutorial on how to use Ecommerce Tracking in Google Analytics. We've seen a lot of interest in this topic, so we thought we'd republish the first part of the series here on the Analytics blog.


Ecommerce Tracking Part 1: How it Works

This post is the first in a series of e-commerce transaction tracking with Google Analytics. Why is e-commerce tracking important? Well, transaction data is a vital piece of information when analyzing online business performance.

Sure, it’s great to measure things like conversion rate, but revenue is much more tangible to many business owners. Having the e-commerce data in your web analytics application makes it easier to perform analysis. Do you need to set up e-commerce tracking? No, but it sure helps. :)

The Big Pictures

E-commerce tracking is based on the same principal as standard pageview tracking. JavaScript code sends the data to a Google Analytic servers by requesting an invisible gif file. The big difference is that e-commerce data is sent rather than pageview data.

But how does Google Analytics get the e-commerce data? That’s the tricky part. You, the site owner, must create some type of code that inserts the transaction data into the GA JavaScript. Sounds tricky, huh? Well, its not that bad.

Step by Step: How it Works

Let’s break it down and walk through what actually happens.

  1. The visitor submits their transaction to your server.
  2. Your server receives the transaction data and processes the transaction. This may include a number of steps at the server level, such as sending a confirmation email, checking a credit card number, etc.
  3. After processing the transaction the server prepares to send the receipt page back to the visitor. While preparing the receipt page your server must extract some the transaction data and insert it into the Google Analytics JavaScript. This is the code that you must create.
  4. The receipt page is sent to the visitor’s browser.
  5. While the receipt page renders in the visitor’s browser the e-commerce data is sent to Google Analytics via special GA JavaScript.
  6. Here’s a basic diagram of the process. Again, the biggest challenge during implementation is adding code to your web server that inserts the transaction data, in the appropriate format, into the receipt page. I’ll cover the setup in part 2 of this series.


What Data can be Tracked?

Google Analytics collect two types of e-commerce data: transaction data and item data. Transaction data describes the overall transaction (transaction ID, total sale, tax, shipping, etc.) while item data describes the items purchased in the transaction (sku, description, category, etc.). All of this data eventually ends up in GA reports. Here’s a complete list of the data:

Transaction Data

Item Data

A few notes about the data. First, the geo-location data is no longer used by Google Analytics. The new version of GA tries to identify where the buyer is located using an IP address lookup.

Also, you should avoid using any non-alpha numeric characters in the data. Especially in the numeric fields. Do not add a currency identifier (i.e. dollar sign) in the total, tax or shipping fields. this can cause problems with the data.

Continue reading parts 2-4 of this series on EpikOne's Blog, Analytics Talk

Posted by Sebastian Tonkin, Google Analytics
06:13 5月UCD书友会,北京、上海、南京、深圳、广州、杭州 » UCDChina.com

夏天了。

UCD书友会2009年5月话题: 电子商务网站的购物流程设计

欢迎从事电子商务的产品经理、设计师参与讨论!

各城市书友会地址:

请注意深圳时间为16号(周六)。

北京,西直门附近奇遇花园,
17号(周日)、下午14:30,
联系人:千鸟 13366219527

上海,上海市长宁区延安西路889号 太平洋企业中心22楼PCHOME办公室,
17号(周日)、下午14:30,
联系人:Sky 13918016880

南京,珠江路665号南楼6楼 途牛旅游网,
17号(周日)、下午14:30,
联系人:JunChen 13913833651

深圳,深圳市南山区科技园科苑路15号科兴生物谷研发中心六楼,
16号(周六)、下午14:30,
联系人:Lytous 13723766365

广州,广州市中山大道西华景路1号南方通信大厦3层 广东移动
17号(周日)、下午14:30,
联系人:胡晓 13560220908

杭州,杭州市西湖区通普路41号 BetaCafe(原盛西庭艺术空间),
17号(周日)、下午14:30,
联系人:坏人 15068883444

通过 Google Maps 查看地址详情

书友会详细信息:http://ucdchina.com/club/

转载请注明出自UCDChina.com,谢谢。

相关文章

05:03 DyradLINQ » High Scalability - Building bigger, faster, more reliable websites.

The goal of DryadLINQ is to make distributed computing on large compute cluster simple enough for ordinary programmers. DryadLINQ combines two important pieces of Microsoft technology: the Dryad distributed execution engine and the .NET Language Integrated Query (LINQ).

04:49 Dyrad » High Scalability - Building bigger, faster, more reliable websites.

The Dryad Project is investigating programming models for writing parallel and distributed programs to scale from a small cluster to a large data-center.

03:24 Art of Distributed » High Scalability - Building bigger, faster, more reliable websites.

Art of Distributed

Part 1: Rethinking about distributed computing models

I ‘m getting a lot of questions lately about the distributed computing, especially distributed computing model, and MapReduce, such as: What is MapReduce? Can MapReduce fit in all situations? How we can compares it with other technologies such as Grid Computing? And what is the best solution to our situation? So I decide to write about the distributed computing article in two parts. First one about the distributed computing model and what is the difference between them. In the second part I will discuss the reliability, and distributed storage systems.

Download the article in PDF format.
Download the article in MS Word format.

I wait for your comments, and questions, and I will answer it in part two.


^==Back Home: www.chedong.com

^==Back Digest Home: www.chedong.com/digest/

<== 2009-05-06
  五月 2009  
        1 2 3
4 5 6 7 8 9 10
11 12 13 14 15 16 17
18 19 20 21 22 23 24
25 26 27 28 29 30 31
==> 2009-05-08