Few days back I am facing a problem to convert a time zone from "America/Chicago" (which is my server default time zone) to Pacific Standard Time(PST). I did some googling and found that to make the time zone in PST we need to set the time zone to "America/Los_Angeles" by using the function date_default_timezone_set() but when I do this and do some database insertion to my site from front end it shows different result and when I tries to show the time zone along with my date it does not shows me exact PST time.

After some time I realize that the PHP server timezone and mysql server time zone are different and if we have to store the date in our database I should use PHP date function (that is date('Y-m-d H:i:s')) in my insert SQL query instead of MySql now() function.


To do this I modified my php.ini file instead of using "date_default_timezone_set()" function in every PHP page. The code that I have used in my php.ini file is as below:

date.timezone = "America/Los_Angeles";

and then I uploaded my php.ini file to the server root directory.

NOTE:This is the new feature that I have seen intead of modifying the server actual php.ini file I simply add my own php.ini file for the services to be  enable on the server. I think not all server support such functionality, but you can try it.


Second I replace all my date query from now() to PHP's date('Y-m-d H:i:s'). This is the solution which works for me.

Q. How to convert local time in php to GTM time?
A. Similar to date() function which shows server local time there is another function named "gmdate()" which is used convert your server local time to GMT. The code is very simple see below.
echo 'Current Local Time : '.  date("H:i:s d-M-y"); echo '
GMT Time :   '.  gmdate("H:i:s d-M-y"); ?>

Q. How to convert a local Unix timestamp to GMT?
A. This can be achieved by using the function gmtdate(). See the code below:

if ( ! function_exists('local_to_gmt'))
{
 function local_to_gmt($time = '')
 {
 if ($time == '')
 $time = time();
 return mktime( gmdate("H", $time), gmdate("i", $time), gmdate("s", $time), gmdate("m", $time), gmdate("d", $time), gmdate("Y", $time));
 }
}

?>

Q. From where I should compare my time has been converted to GMT or not?
A. There are so many sites in available for comparison but I like the URL: http://wwp.greenwichmeantime.com/info/current-time/ which shows the GMT time.

Comment (0)

Zend Framework has the reputation of being difficult to learn. But if you understand the work-flow of a request in Zend Framework, things start becoming more clear.

Make sure that you have WAMP/LAMP/MAMP Configured for Zend Framework. 

First of all, make sure that your OOP concepts are clear.  It is suggested that before you learn programming in Zend Framework, you should understand the principles and practices that are used in Zend Framework. So make sure that you understand MVC and other design patterns carefully.

Once you are clear with these things, go through the online manual. Read the tutorials and documentation present on the official website and try to execute the sample programs. 

Remember, Keep practicing.

 

If you need expert guidance or if you wish to learn Zend Framework professionally, please visit http://www.zendframework-training.com for more details. 

Comment (0)

Hello I want share something to all the developers who really want to integrate FirstData(formerly know as Link Point) webservice(which allows you to make payment via payment gateway but without going outside of your site) as there payment gateway.

I have search a lot for integration on it as I was novice to FirstData and I really want to integrate it in my sites http://www.nobcche.org/.

Before going live you need to create test account The test account can be created from the following URL: http://www.firstdata.com/gg/apply_test_account.htm. Once you register to the test account you will receive a tar.gz file of your certificate. This will be a list of files as below:
1. WS1909487962._.1.auth.txt
2. WS1909487962._.1.key
3. WS1909487962._.1.key.pw.txt
4. WS1909487962._.1.ks
5. WS1909487962._.1.ks.pw.txt
6. WS1909487962._.1.p12
7. WS1909487962._.1.p12.pw.txt
8. WS1909487962._.1.pem

The number 1909487962 would be different for your test store.

Then the next step is to create a script which will use this certificate and do some test payments.
Note: If you would try to execute the FirstData script it will not work as it require live server testing environment.

I have used PHP script with curl and the sample script is as below:

//php script sample code first data integration starts here


<?php
/*** code for new php file with named firstdata_cfg.php**/
//This file can be placed inside include folder /**
Config file for FirstData Payment Gateway
**/
define("FDAPI_URL","https://ws.merchanttest.firstdataglobalgateway.com/fdggwsapi/services/order.wsdl");// URL for test store test payment.
//############## OR ###############
define("FDAPI_URL", "https://ws.firstdataglobalgateway.com/fdggwsapi/services/order.wsdl");// URL for live store for actual payment.

define("FD_USERPWD", "WSXXXXXXXXX._.1:XXXXXXXX");//Replace WSXXXXXXXXX._.1:XXXXXXXX with actual username:password
define("FD_SSLCERT", "/home/105364/domains/yoursite.org/html/certificate/WSXXXXXXXX._.1.pem"); //replace WSXXXXXXXX._.1.pem with actual pem file define("FD_SSLKEY", "/home/105364/domains/yoursite.org/html/certificate/WSXXXXXXXXX._.1.key"); //replace WSXXXXXXXXX._.1.key with actual key file.
define("FD_SSLKEYPASSWD", "ckp_1284657964"); //Replace "ckp_1284657964" key with your store key . You can download all these from your store after loged into your account


/**** function to get Transacion ID ******/
function getFirstDataTransactionID($result)
{
    $varPos = strpos($result, '<fdggwsapi:TransactionID>');
    $varPos2 = strpos($result, '</fdggwsapi:TransactionID>');
    $varPos = $varPos + 25;
    $varLen = $varPos2 - $varPos;
    return substr($result,$varPos,$varLen);
}
/***** function to get Transaction Result ****/
/****** Return Type APPROVED /  FAILED    ****/
function getTransactionResult($result)
{
    $varPos = strpos($result, '<fdggwsapi:TransactionResult>');
    $varPos2 = strpos($result, '</fdggwsapi:TransactionResult>');
    if($varPos !== false)
    {
        $varPos = $varPos + 29;
        $varLen = $varPos2 - $varPos;
        return substr($result,$varPos,$varLen);
    }
    else
    {
        return 'FAILED';
    }
        }

/*** function to get the orderID ****/
/***###################
 This function is used in case of recurring billing as in case of  recurrring billing we get OrderID instead of Transaction ID
 #######################
***/
function getRecurrringOrderID($result)
{
    $varPos = strpos($result, '<fdggwsapi:OrderId>');
    $varPos2 = strpos($result, '</fdggwsapi:OrderId>');
    if($varPos !== false)
    {
        $varPos = $varPos + 19;
        $varLen = $varPos2 - $varPos;
        return substr($result,$varPos,$varLen);
    }
    else
    {
        return '';
    }
}
//end firstdata_cfg.php code
?>
<?php
// This is the code that you have to use to test your first data web service transactions.
// Set the fdggwsapi request - XML String-we have broken it down for viewing purposes
$body = "<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/>

<SOAP-ENV:Body>
<fdggwsapi:FDGGWSApiOrderRequest xmlns:v1="http://secure.linkpt.net/fdggwsapi/schemas_us/v1" xmlns:v3="http://secure.linkpt.net/fdggwsapi/schemas_us/a1" xmlns:fdggwsapi="http://secure.linkpt.net/fdggwsapi/schemas_us/fdggwsapi">

<v1:Transaction>

<v1:CreditCardTxType>
<v1:Type>sale</v1:Type>
</v1:CreditCardTxType>

<v1:CreditCardData>
<v1:CardNumber>4012000033330026</v1:CardNumber>
<v1:ExpMonth>12</v1:ExpMonth>
<v1:ExpYear>12</v1:ExpYear>
</v1:CreditCardData>

<v1:Payment>
<v1:ChargeTotal>120.00</v1:ChargeTotal>
</v1:Payment>

</v1:Transaction>

</fdggwsapi:FDGGWSApiOrderRequest>

</SOAP-ENV:Body>
</SOAP-ENV:Envelope>";




// initializing cURL with the IPG API URL (OLD URL):
$ch = curl_init(FDAPI_URL);



// setting the request type to POST:
curl_setopt($ch, CURLOPT_POST, 1);

// setting the content type:
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml"));

// setting the authorization method to BASIC:
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);

// supplying your credentials:
curl_setopt($ch, CURLOPT_USERPWD, FD_USERPWD);

// filling the request body with your SOAP message:
curl_setopt($ch, CURLOPT_POSTFIELDS, $body);

// telling cURL to verify the server certificate:
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

// setting the path where cURL can find the certificate to verify the
// Info directly from the API Manual Below:
 curl_setopt($ch, CURLOPT_SSLCERT, FD_SSLCERT);
 curl_setopt($ch, CURLOPT_SSLKEY, FD_SSLKEY);
 curl_setopt($ch, CURLOPT_SSLKEYPASSWD, FD_SSLKEYPASSWD);
// telling cURL to return the HTTP response body as operation result
// value when calling curl_exec:
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

// calling cURL and saving the SOAP response message in a variable which
// contains a string like "<SOAP-ENV:Envelope ...>...</SOAP-ENV:Envelope>":
$result = curl_exec($ch);  //if the curl executed successfully then it will return the <saop> XML response with getTransactionResult

if (getTransactionResult($result) == 'FAILED') {
        s$res = 2;
}
else{
      $res = 1 ;
}
curl_close($ch);
# end code
print("The response is $result");
if($res == 1)
{
   echo 'success';
}
else
{
  echo 'fail';
}
?>
//depending on the response we will do appropriate action as we need like database update or send email to customer etc.

//depending on the response we will do appropriate action as we need like database update or send email to customer etc.

//php script sample code ends here

Comment (6)

This is my second post related to FirstData integration. Here I will discuss about the recurring billing and give you sample script of FirstData recurring billing integration in PHP .

If you want to learn from start please read my first article on FirstData. Before I show you the script I will make you about recurring billing.

Recurring billing is the process in which payment is deducted periodically from your account for n number of time where "n" can be "n" Year/Month/quarter etc. This type of billing is basically required for the people who sell services for which they want to deduct money every month/year depending on the subscription.

Recurring is an agreement between two parties one is payer and other is receiver. FirstData also provide such type of recurring billing process the sample script for this would be like as below:

//sample script starts here

<?php
/*** code for new php file with named firstdata_cfg.php**/
//This file can be placed inside inluce folder /**
Config file for FirstData Payment Gateway
**/
define("FDAPI_URL","https://ws.merchanttest.firstdataglobalgateway.com/fdggwsapi/services/order.wsdl");// URL for test store test payment.
//############## OR ###############
define("FDAPI_URL", "https://ws.firstdataglobalgateway.com/fdggwsapi/services/order.wsdl");// URL for live store for actual payment.

define("FD_USERPWD", "WSXXXXXXXXX._.1:XXXXXXXX");//Replace WSXXXXXXXXX._.1:XXXXXXXX with actual username:password
define("FD_SSLCERT", "/home/105364/domains/yoursite.org/html/certificate/WSXXXXXXXX._.1.pem"); //replace WSXXXXXXXX._.1.pem with actual pem file define("FD_SSLKEY", "/home/105364/domains/yoursite.org/html/certificate/WSXXXXXXXXX._.1.key"); //replace WSXXXXXXXXX._.1.key with actual key file.
define("FD_SSLKEYPASSWD", "ckp_1284657964"); //Replace "ckp_1284657964" key with your store key . You can download all these from your store after loged into your account


/**** function to get Transacion ID ******/
function getFirstDataTransactionID($result)
{
    $varPos = strpos($result, '<fdggwsapi:TransactionID>');
    $varPos2 = strpos($result, '</fdggwsapi:TransactionID>');
    $varPos = $varPos + 25;
    $varLen = $varPos2 - $varPos;
    return substr($result,$varPos,$varLen);
}
/***** function to get Transaction Result ****/
/****** Return Type APPROVED /  FAILED    ****/
function getTransactionResult($result)
{
    $varPos = strpos($result, '<fdggwsapi:TransactionResult>');
    $varPos2 = strpos($result, '</fdggwsapi:TransactionResult>');
    if($varPos !== false)
    {
        $varPos = $varPos + 29;
        $varLen = $varPos2 - $varPos;
        return substr($result,$varPos,$varLen);
    }
    else
    {
        return 'FAILED';
    }
        }

/*** function to get the orderID ****/
/***###################
 This function is used in case of recurring billing as in case of  recurrring billing we get OrderID instead of Transaction ID
 #######################
***/
function getRecurrringOrderID($result)
{
    $varPos = strpos($result, '<fdggwsapi:OrderId>');
    $varPos2 = strpos($result, '</fdggwsapi:OrderId>');
    if($varPos !== false)
    {
        $varPos = $varPos + 19;
        $varLen = $varPos2 - $varPos;
        return substr($result,$varPos,$varLen);
    }
    else
    {
        return '';
    }
}
//end firstdata_cfg.php code
?>


<?php
// set the fdggwsapi request - XML String-we have broken it down for viewing purposes
$body = "<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"><SOAP-ENV:Header/>

<SOAP-ENV:Body>
<fdggwsapi:FDGGWSApiActionRequest xmlns:v1="http://secure.linkpt.net/fdggwsapi/schemas_us/v1" xmlns:a1="http://secure.linkpt.net/fdggwsapi/schemas_us/a1" xmlns:fdggwsapi="http://secure.linkpt.net/fdggwsapi/schemas_us/fdggwsapi">

<a1:Action>

<a1:RecurringPayment>

<a1:RecurringPaymentInformation>
<a1:RecurringStartDate>20110616</a1:RecurringStartDate>
<a1:InstallmentCount>12</a1:InstallmentCount>
<a1:InstallmentFrequency>1</a1:InstallmentFrequency>
<a1:InstallmentPeriod>month</a1:InstallmentPeriod>
<a1:MaximumFailures>1</a1:MaximumFailures>
</a1:RecurringPaymentInformation>

<a1:TransactionDataType>
<a1:CreditCardData>
<v1:CardNumber>4012000033330026</v1:CardNumber>
<v1:ExpMonth>12</v1:ExpMonth>
<v1:ExpYear>12</v1:ExpYear>
</a1:CreditCardData>
</a1:TransactionDataType>

<v1:Payment>
<v1:ChargeTotal>10.00</v1:ChargeTotal>
<v1:SubTotal>10.00</v1:SubTotal>
</v1:Payment>

<v1:Shipping>
<v1:Address1>123 Test Street</v1:Address1>
<v1:Carrier>3</v1:Carrier>
<v1:City>Test</v1:City>
<v1:Country>United States</v1:Country>
<v1:Items>1</v1:Items>
<v1:State>Maryland</v1:State>
<v1:Total>1</v1:Total>
<v1:Weight>5</v1:Weight>
</v1:Shipping>

<v1:Billing>
<v1:Address1>234 Main Ave.</v1:Address1>
<v1:City>Brooklyn</v1:City>
<v1:Country>United States</v1:Country>
<v1:State>Maryland</v1:State>
<v1:Zip>21740</v1:Zip>
</v1:Billing>

<v1:TransactionDetails>
<v1:InvoiceNumber>12345</v1:InvoiceNumber>
<v1:TransactionOrigin>ECI</v1:TransactionOrigin>
<v1:UserID>WSAPI_Recurring</v1:UserID>
</v1:TransactionDetails>

<a1:Function>install</a1:Function>

</a1:RecurringPayment>

</a1:Action>

</fdggwsapi:FDGGWSApiActionRequest>

</SOAP-ENV:Body>
</SOAP-ENV:Envelope>";

// initializing cURL with the IPG API URL:
// $ch = curl_init("https://www.staging.linkpointcentral.com/fdggwsapi/services/order.wsdl");

// initializing cURL with the IPG API URL (OLD URL):
$ch = curl_init(FDAPI_URL);



// setting the request type to POST:
curl_setopt($ch, CURLOPT_POST, 1);

// setting the content type:
curl_setopt($ch, CURLOPT_HTTPHEADER, array("Content-Type: text/xml"));

// setting the authorization method to BASIC:
curl_setopt($ch, CURLOPT_HTTPAUTH, CURLAUTH_BASIC);

// supplying your credentials:
curl_setopt($ch, CURLOPT_USERPWD, FD_USERPWD);

// filling the request body with your SOAP message:
curl_setopt($ch, CURLOPT_POSTFIELDS, $body);

// telling cURL to verify the server certificate:
curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, 0);

// setting the path where cURL can find the certificate to verify the
// Info directly from the API Manual Below:
 curl_setopt($ch, CURLOPT_SSLCERT, FD_SSLCERT);
 curl_setopt($ch, CURLOPT_SSLKEY, FD_SSLKEY);
 curl_setopt($ch, CURLOPT_SSLKEYPASSWD, FD_SSLKEYPASSWD);
// telling cURL to return the HTTP response body as operation result
// value when calling curl_exec:
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);

// calling cURL and saving the SOAP response message in a variable which
// contains a string like "<SOAP-ENV:Envelope ...>...</SOAP-ENV:Envelope>":
$result = curl_exec($ch);  //if the curl executed successfully then it will return the <saop> XML response with getTransactionResult

if (getTransactionResult($result) == 'FAILED') {
        s$res = 2;
}
else{
      $res = 1 ;
   $varRecurringOrderID = getRecurrringOrderID($result);
}
curl_close($ch);
# end code
print("The response is $result");
if($res == 1)
{
   echo 'success';
}
else
{
  echo 'fail';
}
?>
 

//sample script ends here.

 //depending on the value return user may take appropriate action.

Comment (3)

Highlights

- Article: Introduction to MySQL 5.5
- Event: MySQL Sessions at UKOUG Conference Series Technology and E-Business Suite 2010
- Call for MySQL Participation at Collaborate 11 (April 10 - 14, 2011)
- Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements (October 12)
- Live Webinar: MySQL Essentials Part 5: How to Develop Simple PHP Applications for MySQL (October 19)

New Product Releases

- New Release of MySQL Community Server 5.5.6 (RC)
- New Release of MySQL Community Server 5.1.51 (GA)
- New Release of MySQL Workbench 5.2.28 (GA)
- New Release of MySQL Connector/Net 6.3.4 (GA)
- New Release of MySQL Proxy 0.8.1 (Alpha)

Hints & Tips

- White Paper: Building Carrier-Grade Subscriber Databases Using MySQL Cluster
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL 5.5: InnoDB Performance Improvements on Windows
  - PlanetMySQL Blog: Online Schema Change for MySQL
  - PlanetMySQL Blog: MySQL 5.5: InnoDB as Default Storage Engine
  - PlanetMySQL Blog: Multiple Buffer Pools in MySQL 5.5
  - PlanetMySQL Blog: MySQL Performance: 5.5 Notes
  - PlanetMySQL Blog: MySQL 5.5: InnoDB adaptive_flushing - How it works?
  - PlanetMySQL Blog: MySQL 5.5: InnoDB Change Buffering
  - PlanetMySQL Blog: InnoDB Revision History
  - PlanetMySQL Blog: Resolving the "Can't create IP socket: No such file or directory" Error on Windows
  - PlanetMySQL Blog: MySQL Workbench Plugin: mforms example and slow query log statistics
  - PlanetMySQL Blog: Tracking mutex locks in a process list, MySQL 5.5's PERFORMANCE_SCHEMA
  - PlanetMySQL Blog: Testing Drupal 7 on a virtual appliance with MySQL 5.1 and the InnoDB plugin
  - PlanetMySQL Blog: Farewell CHM, hello EPUB!
  - PlanetMySQL Blog: How to speed up Sysbench on MySQL Cluster by 14x
  - PlanetMySQL Blog: Spins and Contentions in MySQL Cluster

Events

- Live Webinar: What's New with MySQL (October 14) - Italian
- Live Webinar: Designing MySQL Databases (October 14 & 15) - EMEA
- Live Webinar: Practical Partitioning With MySQL: When, Why and How (October 26)

-------------------------------------------------------------------

Highlights

Article: Introduction to MySQL 5.5

It's been a busy year for MySQL. Perhaps you've heard. Here are some recent improvements to the speed, scalability, and user-friendliness of the MySQL database and the InnoDB storage engine that we think deserve their own headlines. Now is a great time to test the 5.5 release and give feedback to the MySQL engineering team.

Read this Article:
  http://dev.mysql.com/tech-resources/articles/introduction-to-mysql-55.html


Event: MySQL Sessions at UKOUG Conference Series Technology and E-Business Suite 2010

UK Oracle User Group's annual Technology & E-Business Suite conference is taking place from November 29th to December 1st at the ICC in Birmingham. There will be numerous MySQL sessions aiming to help you further improve your MySQL deployment. Join the 1,500 attendees to learn and share the latest product information.

Learn More and Register:
  http://www.oug.org/techebs


Call for MySQL Participation at Collaborate 11 - Submit Your Proposal by October 11

The Independent Oracle User Group, focused on Oracle technology including database, security, and virtualization, will hold its annual conference in Orlando, Florida, on April 10 to 14, 2011. In Collaborate 11 there will be dedicated MySQL technical tracks to host talks from worldwide MySQL experts, including customers, partners and engineers. Submit your proposals by October 11 to participate this community driven event!

Learn More:
  http://collaborate11.ioug.org/tabid/153/Default.aspx


Live Webinar: Delivering Scalability and High Availability with MySQL 5.5 Replication Enhancements Tuesday, October 12, 2010 - 9:00am PT

This session explains how to use MySQL replication for scalability and high availability, focusing on the new MySQL Release 5.5 features that have been implemented to support and simplify maintenance of such installations. Features include replication heartbeating, semi-synchronous replication, fsync tuning, and relay log corruption recovery.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-572.html?p=newsletter


Live Webinar: MySQL Essentials Part 5: How to Develop Simple PHP Applications for MySQL Tuesday, October 19, 2010 - 9:00am PT

In this technical webinar, MySQL developer Johannes Schlüter will show you the essentials for creating dynamic web content using MySQL and PHP. He will also discuss many of the fundamental elements used when developing PHP applications with MySQL, including the frameworks, APIs, security features, and asynchronous queries.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-575.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.5.6-rc (RC)

MySQL Server 5.5.6-rc, a new version of the popular Open Source Database Management System, has been released. The "-rc" suffix indicates this is a "release candidate". MySQL 5.5 includes several high-impact changes to address scalability and performance issues in MySQL Server. These changes exploit advances in hardware and CPU design and enable better utilization of existing hardware.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/news-5-5-6.html

Read the Documentation:
  http://dev.mysql.com/doc/refman/5.5/en/mysql-nutshell.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.5.html#downloads


New Release of MySQL Community Server 5.1.51 (GA)

MySQL Community Server 5.1.51, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.51 is recommended for use on production systems.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-51.html

Download Now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Workbench 5.2.28 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.28. This maintenance release features improvements to the Workbench scripting Shell as well as various fixes. The enhancements to the Scripting Shell make it easier to develop and use Workbench Scripts and Plug-ins.

View the Complete List of Changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-28.html

Download Now:
  http://dev.mysql.com/downloads/workbench/

Learn More about Workbench Scripting and Plug-in:
  http://wb.mysql.com/?page_id=664


New Release of MySQL Connector/Net 6.3.4 (GA)

We're proud to announce the next release of MySQL Connector/Net version 6.3.4. This release is GA (Generally Available). We hope you will make MySQL Connector/Net your preferred set of .NET components including our ADO.Net library and other Microsoft .NET frameworks components such as our Visual Studio plug-in and Entity Framework for MySQL. New features include:

- The ability to dynamically enable/disable query analysis at runtime
- Visual Studio 2010 compatibility
- Improved compatibility with Visual Studio wizards using our new SQL Server mode
- Support for Model-First development using Entity Framework
- Nested transaction scopes

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/connector-net-news-6-3-4.html

Download Now:
  http://dev.mysql.com/downloads/connector/net/6.3.html

Read the Tutorial:
  http://dev.mysql.com/doc/refman/5.1/en/connector-net-tutorials.html


New Release of MySQL Proxy 0.8.1 (Alpha)

We are pleased to announce MySQL Proxy 0.8.1, an alpha release. It makes the admin plug-in more useful by reporting better errors and explicitly enforces the options --admin-username, --admin-password and --admin-lua-script. We also bundle a simple admin script that you can use as a starting point for your own developments in lib/admin.lua.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/mysql-proxy-news-0-8-1.html

Download Now:
  http://dev.mysql.com/downloads/mysql-proxy/

-------------------------------------------------------------------

Hints & Tips

White Paper: Building Carrier-Grade Subscriber Databases Using MySQL Cluster

In this paper we describe how MySQL Cluster Carrier Grade Edition can be used to build a scalable, highly available, geographically replicated Subscriber Database. We show how user-defined partitioning and distribution keys help a subscriber database to scale its performance linearly with cluster size, while maintaining the benefits of a relational database, accessed via an SQL API.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_subscriber_db.php


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL 5.5: InnoDB Performance Improvements on Windows Calvin Sun

At MySQL, we know our users want Performance, Scalability, Reliability, and Availability, regardless of the platform they choose to deploy. We have always had excellent benchmarks on Linux, and with MySQL 5.5, we are also working hard on improving performance on Windows.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-performance-improvements-on-windows/


PlanetMySQL Blog: Online Schema Change for MySQL Mark Callaghan

It is great to be able to build small utilities on top of an excellent RDBMS. Thank you MySQL. This is a small but complex utility to perform online schema change for MySQL.

Read the PlanetMySQL BlogPost - Part I:
  http://www.facebook.com/notes/mysql-at-facebook/online-schema-change-for-mysql/430801045932

Read the PlanetMySQL BlogPost - Part II:
  http://www.facebook.com/note.php?note_id=431123910932


PlanetMySQL Blog: MySQL 5.5: InnoDB as Default Storage Engine John Russell

MySQL has a well-earned reputation for being easy-to-use and delivering performance and scalability. In previous versions, MyISAM was the default storage engine. In our experience, most users never changed the default settings. With MySQL 5.5, InnoDB becomes the default storage engine. Again, we expect most users will not change the default settings. But, because of InnoDB, the default settings deliver the benefits users expect from their RDBMS - ACID Transactions, Referential Integrity, and Crash Recovery.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-as-default-storage-engine/


PlanetMySQL Blog: Multiple Buffer Pools in MySQL 5.5 Mikael Ronstrom

In our work to improve MySQL scalability we tested many opportunities to scale the MySQL Server and the InnoDB storage engine. The InnoDB buffer pool was often one of the hottest contention points in the server. This is very natural since every access to a data page, UNDO page, index page uses the buffer pool and even more so when those pages are read from disk and written to disk.

Read the PlanetMySQL BlogPost:
  http://mikaelronstrom.blogspot.com/2010/09/multiple-buffer-pools-in-mysql-55.html


PlanetMySQL Blog: MySQL Performance: 5.5 Notes Dimitri Kravtchuk

Since 5.5 is announced as Release Candidate now, I'll not compare it with 5.1 anymore - I think there was written enough about the performance gain even since introduction of 5.4. From the other side, we want to be sure that the final 5.5 will be at least as good as 5.5.4 release, and here the feedback from real users with real workloads will be very precious! So, please, don't keep quiet!

Read the PlanetMySQL BlogPost:
  http://dimitrik.free.fr/blog/archives/2010/09/mysql-performance-55-notes.html


PlanetMySQL Blog: MySQL 5.5: InnoDB adaptive_flushing - How it works?
Inaam Rana

Write-heavy workloads can reach a situation where InnoDB runs out of usable space in its redo log files. When that happens, InnoDB does a lot of disk writes to create space and you can see a drop in server throughput for a few seconds. From InnoDB plugin 1.0.4 we have introduced the 'innodb_adaptive_flushing' method that uses a heuristic to try to flush enough pages in the background so that it is rare for the very active writing to happen.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-adaptive_flushing-how-it-works/


PlanetMySQL Blog: MySQL 5.5: InnoDB Change Buffering Marko Mäkelä

To speed up bulk loading of data, InnoDB implements an insert buffer, a special index in the InnoDB system tablespace that buffers modifications to secondary indexes when the leaf pages are not in the buffer pool. Batched merges from the insert buffer to the index pages result in less random access patterns than when updating the pages directly. This speeds up the operation on hard disks.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/wp/2010/09/mysql-5-5-innodb-change-buffering/


PlanetMySQL Blog: InnoDB Revision History Vasil Dimov

This is a brief overview of the history of InnoDB with respect to the Version Control Systems (VCS) that were used for developing. It could be useful to people who want to trace back in time to find the origins of bugs or features.

Read the PlanetMySQL BlogPost:
  http://blogs.innodb.com/2010/09/innodb-revision-history/


PlanetMySQL Blog: Resolving the "Can't create IP socket: No such file or directory" Error on Windows Chris Calender

Every now and again, when installing or upgrading MySQL on Windows, mysqld will not start, and it's not due to any changes in the config file, using some old config option, permissions, something changed/removed, or anything else. It just simply fails, when you know it should work.

Read the PlanetMySQL BlogPost:
  http://www.chriscalender.com/?p=140


PlanetMySQL Blog: MySQL Workbench Plugin: mforms example and slow query log statistics Lee Stigile

As an update to my prior post, I've added a form to the workbench plugin. Now, the user can select a slow query log file and generate statistics from it. The plugin scans the slow query log, aggregates similar queries, and provides summary statistics for each group. It's very similar to the mysqldumpslow perl utility, which is included in the mysql bin folder. However, as a plugin, it's easier to use on a Windows server as it doesn't require you to install perl.

Read the PlanetMySQL BlogPost:
  http://lstigile.wordpress.com/2010/09/29/mysql-workbench-plugin-mforms-example-and-slow-query-log-statistics/


PlanetMySQL Blog: Tracking mutex locks in a process list, MySQL 5.5's PERFORMANCE_SCHEMA Mark Leith

Internally MySQL uses various methods to manage (or, block) concurrent access to shared structures within the server - the most common being mutexes (or Mutual Exclusion locks), RW Locks, or Semaphores. Each have slightly different properties on how different threads are allowed to interact when trying to access these synchronization points.

Read the PlanetMySQL BlogPost:
  http://www.markleith.co.uk/?p=377


PlanetMySQL Blog: Testing Drupal 7 on a virtual appliance with MySQL 5.1 and the InnoDB plugin Lenz Grimmer

The Drupal community just recently released another alpha test release of their upcoming Drupal 7 version, to shake out the remaining bugs and to encourage more users to test it.

If you would like to give it a try, but you don't have a free server handy, how about using a virtual machine instead? Using the fabulous SuSE Studio, I've created an appliance based on openSUSE 11.3, Drupal 7.0-alpha7 and MySQL 5.1 with the InnoDB plugin and strict mode enabled (both for the SQL mode and InnoDB mode).

Read the PlanetMySQL BlogPost:
  http://www.lenzg.net/archives/314-Testing-Drupal-7-on-a-virtual-appliance-with-MySQL-5.1-and-the-InnoDB-plugin.html


PlanetMySQL Blog: Farewell CHM, hello EPUB!
Stefan Hinz

For a long time, the MySQL Documentation Team has been providing CHM files for most MySQL documentation we publish.

With the increasing complexity and size of our documentation (the MySQL 5.1 Manual contains more than 1.6 million words now!), providing CHM has become more and more of a pain, because builds tend to break more often.

Read the PlanetMySQL BlogPost:
  http://blogs.sun.com/mysqlf/entry/farewell_chm_hello_epub


PlanetMySQL Blog: How to speed up Sysbench on MySQL Cluster by 14x Mikael Ronstrom

During the summer I had the opportunity to get some work done on scalability of the MySQL Cluster product. Given that I once was the founder of this product it was nice to return again and check where it stands in scalability terms. The objective was to compare MySQL Cluster to the Memory engine.

Read the PlanetMySQL BlogPost:
  http://mikaelronstrom.blogspot.com/2010/09/how-to-speed-up-sysbench-on-mysql.html


PlanetMySQL Blog: Spins and Contentions in MySQL Cluster Johan Andersson

I get a number of question about contentions/stuck in. So here comes some explanation to contention, thread stuck in, and what you can do about it.

Read the PlanetMySQL BlogPost:
  http://johanandersson.blogspot.com/2010/09/cluster-spinscontentions-and-thread.html

-------------------------------------------------------------------

Events

Live Webinar: What's New with MySQL - Italian Thursday, October 14, 2010 - 10:00 CET

Join us for this webinar to better understand what's new with MySQL! You will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle's investment in MySQL technology and community, aiming to make MySQL even a better MySQL.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-574.html?p=newsletter


Live Webinar: Designing MySQL Databases - EMEA Thursday, October 14, 2010 - 10:00 CET

Join us for this webinar to learn the design dos and don'ts for MySQL. We will show you how to design, forward and reverse engineer databases including discussions on datatypes, indexes, and foreign keys for various application scenarios.

Register for the French Webinar on October 14 at 10 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-576.html?p=newsletter

Register for the German Webinar on October 15 at 11 CET:
  http://dev.mysql.com/news-and-events/web-seminars/display-573.html?p=newsletter


Live Webinar: Practical Partitioning With MySQL: When, Why and How Tuesday, October 26, 2010 - 9:00am PT

MySQL Partitioning can dramatically improve the performance and scaling of your MySQL database; it can also cause heartaches and pain if implemented incorrectly. Focusing more on partitions and less on indexes may be what's needed in designing and implementing a large scale data warehouse. Partitioning can also be used in other, non data warehouse solutions to greatly improve both performance and uptime of common OLTP systems.

Join us for this technical webinar and learn when and how to implement MySQL Partitioning correctly and dramatically improve your application's performance and lower the load on your system.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-571.html?p=newsletter

Read the White Paper: Guide to MySQL 5.1 Partitioning:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_partitioning.php


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

Problems reading the newsletter in your email client? View the newsletter on the web.
  http://dev.mysql.com/news-and-events/newsletter/2010/2010-08.html

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)

MySQL Newsletter
September 2010
mysql-newsletter@sun.com

Articles in this newsletter:

Highlights

- Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)
- Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)
- Announcing the MySQL Japanese Newsletter
- Quickpoll: What concerns you most about your current MySQL backup solution?
- The MySQL Community Team is Hiring
- White Paper: Session Management with MySQL
- White Paper: Guide to Optimizing Performance of the MySQL Cluster Database
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer
- Case Study: MySQL Cluster Powers Leading Document Management Web Service
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics (Wednesday, September 15)
- Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL (Thursday, September 30)

New Product Releases

- New Release of MySQL Community Server 5.1.50 (GA)
- New Release of MySQL Connector/ODBC 5.1.7 (GA)
- New Release of MySQL Workbench 5.2.27 (GA)

Hints & Tips

- CEO Interview: AlSego develops financial applications with MySQL
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL Cluster on Windows
  - PlanetMySQL Blog: MySQL Master High Availability at Yahoo
  - PlanetMySQL Blog: Binary Log Group Commit - Recovery
  - PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins
  - PlanetMySQL Blog: Improving InnoDB Transaction Reporting
  - PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe
  - PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine
  - PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output
  - PlanetMySQL Blog: Upcoming MySQL Conferences
  - PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster
  - PlanetMySQL Blog: Why GRANT ALL is bad
  - PlanetMySQL Blog: Tips for taking MySQL backups using LVM

Events

- Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German (Wednesday, September 8)
- Live Webinar: Scaling Web Services with MySQL Cluster - Italian (Thursday, September 9)
- Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese (Tuesday, September 14)
- Live Webinar: Getting Started with MySQL on Windows - Japanese (Thursday, September 30)

-------------------------------------------------------------------

Highlights

Event: MySQL Sunday at Oracle OpenWorld - Last Chance to Register! (September 19)

MySQL Sunday is a half-day conference with 4 highly technical tracks, covering the latest on MySQL High Availability, Scalability, MySQL Performance Tuning, and more. Don't miss this great opportunity to learn from the MySQL experts and hear the keynotes from Edward Screven, Oracle's Chief Corporate Architect, and Marten Mickos, CEO of Eucalyptus. MySQL Sunday is happening as part of Oracle OpenWorld in San Francisco, one of the largest IT events worldwide.

Learn More:
  http://blogs.sun.com/datacharmer/entry/marten_mickos_strikes_back

View the Sessions and Speakers:
  http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


Event: MySQL Sessions at DOAG Conference 2010 - Nuremberg, Germany (November 16-18)

The DOAG is the German association of users for Oracle products. In November 16-18, they will hold their annual Oracle Users Conference 2010, which will take place in Nuremberg, Germany. For the first time, this year's conference will also have a dedicated stream of sessions about MySQL.

View the full list of MySQL sessions:
  http://www.lenzg.net/archives/306-Speaking-at-the-DOAG-Conference-in-Nuremberg.html


Announcing the MySQL Japanese Newsletter

MySQL Newsletter is now available in Japanese, in addition to the English and German versions. You can subscribe to the Japanese Newsletter by editing newsletter subscriptions in your MySQL account profile.

Edit your MySQL Account (Log-in Required):
  http://dev.mysql.com/profile/


Quickpoll: What concerns you most about your current MySQL backup solution?

A new quickpoll is posted on the MySQL Developer Zone about your MySQL backup solution.

Take the Quickpoll:
  http://dev.mysql.com/tech-resources/quickpolls/


The MySQL Community Team is Hiring!

Our team at Oracle needs to grow in order to better serve the growing MySQL Community, and we are starting by filling the position for MySQL Community Manager in a place with a significantly large MySQL user base: North America.

Learn More:
  http://blogs.sun.com/MySQL/entry/the_mysql_community_team_is


White Paper: Session Management with MySQL

An inherent characteristic about the web and one of the most common technical issues when designing and maintaining the web infrastructure, is addressing the stateless interaction between the user's browser and the web server from which the pages are requested. In this paper we explore how MySQL and MySQL Cluster can be used as part of a cost-effective, high-performance, open-source solution for database-centric session management.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_session_mngmnt.php


White Paper: Guide to Optimizing Performance of the MySQL Cluster Database

This guide explores how to tune and optimize the MySQL Cluster database to handle diverse workload requirements. It discusses data access patterns and how to build distribution awareness into applications, exploring schema and query optimization, tuning of parameters and how to get the best out of the latest innovations in hardware design.

Read the English White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php

Read the French White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_perfomance.php.fr


Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the MySQL Query Analyzer.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php


Case Study: MySQL Cluster Powers Leading Document Management Web Service

The DocQ web service eliminates the limitations of sharing physical documents by offering a complete paperless business solution; providing a single place where customers can manage, archive, and send their important documents.

MySQL Cluster was selected as it met all of the requirements of the service with one, integrated solution out of the box. MySQL Cluster is handling 1 million queries on average per day across both in-memory and disk-based tables, with the database growing at up to 2% daily.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-cluster_docudesk_WebServices.php


Live Webinar: Getting the Best MySQL Performance in Your Products: Part 2, Beyond the Basics Wednesday, September 15, 2010 - 9:00am PT

In Part 2 of a three-part performance series, MySQL performance expert Brian Miezejewski will take you beyond the basics and show you the next set of steps to take when architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

In this session, Brian will build on the steps he covered in Part 1, the Fundamentals and will review more advanced topics, including monitoring, data and key caches, sessions, tuning, sorting and other server tuning tips.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-567.html?p=newsletter


Live Webinar: MySQL Essentials Part 4: How to Develop Simple .NET Applications for MySQL Thursday, September 30, 2010 - 9:00am PT

In this webinar we will explore the use of MySQL as the underlying database for .NET applications. Using several example programs, we will dive into how to develop a few starter applications for MySQL in C# and ASP.Net using Visual Studio. We will also guide you through the process from installing MySQL Connector/NET, setting up Visual Studio, starting a project, designing, coding and running these simple .NET applications.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-568.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.50 (GA)

MySQL Community Server 5.1.50, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.50 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-50.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/ODBC 5.1.7 (GA)

MySQL Connector/ODBC 5.1.7, a new version of the ODBC driver for the MySQL database management system, has been released. This release is the latest release of the 5.1 series and is suitable for use with any MySQL version since 4.1.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/connector-odbc-news-5-1-7.html

Download now:
  http://dev.mysql.com/downloads/connector/odbc/5.1.html


New Release of MySQL Workbench 5.2.27 (GA)

We're proud to announce the next release of MySQL Workbench, version 5.2.27. This is the second maintenance release for 5.2 GA (Generally Available) and focuses on general product improvement and usability. We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications.

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-27.html

Download now:
  http://dev.mysql.com/downloads/workbench/

-------------------------------------------------------------------

Hints & Tips

CEO Interview: AlSego develops financial applications with MySQL Enterprise

AlSego, based in Luxembourg, builds business intelligence reporting and integration solutions with MySQL Enterprise. Marc Van Oost, the CEO of AlSego, shares how MySQL addresses the flexibility, security and performance challenges of AlSego's financial applications.

Read the Interview:
  http://dev.mysql.com/tech-resources/interviews/marc-van-oost-alsego.html


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL Cluster on Windows Anders Karlsson

So you thought that just because MySQL Cluster 7.1 is GA on Windows that NDB API was available and you could just download the MySQL Cluster 7.1 binary for Windows and start hacking the NDB API. Nope. But fear not, there is help!

Read the PlanetMySQL BlogPost - Part 1: NDB API:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-1.html

Read the PlanetMySQL BlogPost - Part 2: Set up a dev environment:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-not-so-ndb.html

Read the PlanetMySQL BlogPost - Part 3: The Code:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-3.html

Read the PlanetMySQL BlogPost - Part 4: Finishing it up:
  http://karlssonondatabases.blogspot.com/2010/08/mysql-cluster-on-windows-ndb-api-part-4.html


PlanetMySQL Blog: MySQL Master High Availability at Yahoo Jay Janssen

I was asked to write a blog post about MySQL High Availability at Yahoo, particularly for writes. Our standard practice is not particularly high-tech, but we've been using it for over 4 years now and it has become a company-wide standard with a few exceptions.

Read the PlanetMySQL BlogPost:
  http://mysqlguy.net/blog/2010/08/03/mysql-master-ha-yahoo


PlanetMySQL Blog: Binary Log Group Commit - Recovery Mats Kindahl

In the previous article, an approach was outlined to handle the binary log group commit. The basic idea is to use the binary log as a ticketing system by reserving space in it for the transactions that are going to be written. This will provide an order on the transactions as well as allowing writing the transactions in parallel to the binary log, thereby boosting performance.

Read the PlanetMySQL BlogPost:
  http://mysqlmusings.blogspot.com/2010/08/binary-log-group-commit-recovery.html


PlanetMySQL Blog: PHP @ FrOSCon: the power of mysqlnd plugins Ulf Wendel

Slowly the power of mysqlnd plugins becomes visible. Mysqlnd plugins challenge MySQL Proxy and are often a noteworthy, if not superior, alternative to MySQL Proxy for PHP users.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=293


PlanetMySQL Blog: Improving InnoDB Transaction Reporting Mark Leith

Everybody knows that parsing the output of SHOW ENGINE INNODB STATUS is hard, especially when you want to track the information historically, or want to aggregate any of the more dynamic sections such as the TRANSACTIONS one.

Read the PlanetMySQL BlogPost:
  http://www.markleith.co.uk/?p=367


PlanetMySQL Blog: No, DRBD doesn't magically make your application crash safe Florian Haas

It is a common misconception that DRBD (or any block-level data replication) solution can magically make an application crash-safe that intrinsically isn't.

Read the PlanetMySQL BlogPost:
  http://fghaas.wordpress.com/2010/08/17/no-drbd-doesnt-magically-make-your-application-crash-safe/


PlanetMySQL Blog: Easy MySQL: how to backup databases to a remote machine Matt Reid

Here's a simple answer to a simple question. "How do I run a backup of MySQL to another machine without writing to the local server's filesystem?" - this is especially useful if you are running out of space on the local server and cannot write a temporary file to the filesystem during backups.

Read the PlanetMySQL BlogPost:
  http://themattreid.com/wordpress/2010/08/13/easy-mysql-how-to-backup-databases-to-a-remote-machine/


PlanetMySQL Blog: MySQL Workbench Plugin: Execute Query to Text Output Alfredo Kojima

In MySQL Workbench 5.2.26 a new query execution command is available, where query output is sent as text to the text Output tab of the SQL Editor. Some MySQL Workbench users liked the "Results to Text" option available in Microsoft SQL Server Management Studio. Cool thing is with a few lines of Python we implemented this command using the SQL Editor scripting API.

Read the PlanetMySQL BlogPost:
  http://wb.mysql.com/?p=677


PlanetMySQL Blog: Upcoming MySQL Conferences Ronald Bradford

Unlike previous years when the number of conferences with MySQL content diminishes after the O'Reilly MySQL and OSCON conferences (Open SQL Camp excluded), this year has a lot to offer.

Read the PlanetMySQL BlogPost:
  http://ronaldbradford.com/blog/upcoming-mysql-conferences-2010-08-09/


PlanetMySQL Blog: Managing load-balanced Connector/J deployments with MySQL Cluster Todd Farmer

Connector/J has long provided an effective means to distribute read/write load across multiple MySQL server instances for Cluster or master-master replication deployments, but until version 5.1.13, managing such deployments frequently required a service outage to redeploy a new configuration.

Read the PlanetMySQL BlogPost:
  http://mysqlblog.fivefarmers.com/2010/08/03/managing-load-balanced-connectorj-deployments-2/


PlanetMySQL Blog: Why GRANT ALL is bad
Ronald Bradford

A common observation for many LAMP stack products is the use of poor MySQL security practices. Even for more established products such as Wordpress don't always assume that the provided documentation does what is best for you.

Read the PlanetMySQL BlogPost:
  http://ronaldbradford.com/blog/why-grant-all-is-bad-2010-08-06/


PlanetMySQL Blog: Tips for taking MySQL backups using LVM Shlomi Noach

LVM uses copy-on-write to implement snapshots. Whenever you're writing data to some page, LVM copies the original page to the snapshot volume. The snapshot volume must be large enough to accommodate all pages written to for the duration of the snapshot's lifetime. In other words, you must be able to copy the data somewhere outside in less time than it would take for the snapshot to fill up.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/tips-for-taking-mysql-backups-using-lvm

-------------------------------------------------------------------

Events

Live Webinar: MySQL Cluster: 5 Steps to Getting Started, then 5 More to Scale for the Web Wednesday, September 8, 2010 - 9:00am PT

This session will demonstrate how to start an evaluation of the MySQL Cluster database in 5 easy steps, and then how to expand your deployment for web and telecoms-scale services.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-566.html?p=newsletter


Live Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached - German Wednesday, September 8, 2010 - 15:00 CET

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services, however, that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

This webinar will discuss the use-cases for both approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

Register for this German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-563.html?p=newsletter


Live Webinar: Scaling Web Services with MySQL Cluster - Italian Thursday, September 9, 2010 - 10:00 CET

There are two common choices to power web applications. MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. The MEMORY storage engine has also been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management.

The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address increased web service demands. This webinar will discuss the use-cases for all three approaches, and provide an insight into how MySQL Cluster is enabling users to scale their update-intensive web services.

Register for this Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-564.html?p=newsletter


Live Webinar: Oracle Outlines Strategy for MySQL - Portuguese Tuesday, September 14, 2010 - 9:30am Brazil Time

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume websites, critical business systems, and packaged software - including industry leaders such as Yahoo, Globo, TRF4, Google, Facebook, Paggo and Banco de Republica.

In this webinar you will learn more about the current and future state of MySQL, now part of the Oracle family of products. We will also cover Oracle's investment in MySQL technology and community, directed toward making MySQL an even better MySQL.

Register for this Portuguese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-569.html?p=newsletter


Live Webinar: Getting Started with MySQL on Windows - Japanese Thursday, September 30, 2010 - 14:00 JST

MySQL has been widely adopted and popular on Windows, with 45,000 downloads per day for Windows packages. Its ease of use allows you to download, configure and start using MySQL very quickly.

In this webinar, you will learn the basic "How-To's" for MySQL installation, security and configuration. We will also show you how to get started using MySQL tools on Windows.

Register for this Japanese Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-562.html?p=newsletter


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

Problems reading the newsletter in your email client? View the newsletter on the web.
  http://dev.mysql.com/news-and-events/newsletter/2010/2010-08.html

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)

After four months of beta availability and testing, SugarCRM today officially announced the general availability of its Sugar 6 CRM customer relationship management platform. Sugar 6 includes an open source community edition as well as commercially licensed professional and enterprise editions.

With Sugar 6, SugarCRM is expanding its partnership base with enhanced extensibility that enables partner solutions. There is a new user interface that aims to make CRM users more productive with fewer keystrokes. While the Sugar 6 solution has open source technology at its core, users that download the open source community edition will get a different interface than users of the commercial professional and enterprise editions. For SugarCRM, the issue of being an open source company is all about being open to users.

"As an open source project, we've given people a lot, and Community edition has helped us to get where we are today," Martin Schneider, senior director of communications at SugarCRM, told InternetNews.com.

Schneider added that in his experience, he would go to conferences and users of SugarCRM's professional solution were not aware of the community edition and vice versa. As such, the new version takes pains to show the Sugar user base that there is a difference between the freely available community edition and the paid versions of Sugar.

With Sugar 6, professional and enterprise customers get a new global search option for CRM records as well as the ability to more rapidly create contact records. When Sugar 6 was first announced as a beta in April, SugarCRM co-founder Clint Oram told InternetNews.com that the goal was to reduce the number of click users needed to accomplish tasks.

Schneider explained that with Sugar 6, the company is delivering a 'Go Pro' message to community users. The new user interface for the professional and enterprise versions is the front-end for other commercial enhancements, including better security, mobile and reporting features in the paid versions. He emphasized that overall, Sugar 6 is an open source product from an open source company.

Open source doesn't mean free

"Open source doesn't mean free and was never really meant to mean free," Schneider said. "Open source runs through everything we do, it enables us to be transparent and gives customers more power. We are an open source company and it's why we're better than proprietary companies."

Though the community edition is not getting the same new user interface as the commercial versions, all three versions of Sugar 6 will benefit from an improved Sugar module builder. The module builder has been improved for all users of Sugar 6 to provide users with more integrated data views into the system. For example, a user can choose to integrate a contact's Twitter feed into a CRM record or an adjacent record tab. Schneider explained that any website can be exposed inside of a contact record to provide additional visibility.

From an extensibility perspective, Sugar 6 supports both SOAP and REST Web services, providing data integration points for partners. Sugar 6 is also being enabled to run on Microsoft's Azure cloud operating system.

Schneider said that to date, 70 percent of SugarCRM's customers run Sugar in either a cloud or hosted environment, while only 30 percent run Sugar onsite. SugarCRM offers its own on-demand hosted offering, though Schneider stressed that hosting isn't SugarCRM's core business.

"We want to empower other people to have cloud deployments and help customers get up and running," Schneider said. "We don't want to be in the hosting business, we want to be everywhere and run everywhere.

Comment (0)

SugarCRM, the open source CRM company founded in 2004, has announced the release of their latest version, Sugar 6. With this release, SugarCRM is trying to focus on making it easier and flexible for users to use CRM systems. In fact, many users are completely lost when it comes to using CRM. The complexity and lack of good user experience are considered to be the main reasons for this. This release focusses on substantially improving the user experience by offering a clean, bold look with new buttons and icons that allow users to perform tasks more easily while increasing the information density of each screen. In short, the idea is to make the CRM be flexible and convenient to users needs than users spending time to understand the UI and the complexities associated with it. They have achieved this by focusing on the user friendliness of their menu bars.

This new release also brings more social aspects to SugarCRM. Now Sugar users can leverage information from social networks like Twitter, LinkedIn and other data sources from inside the CRM. This makes SugarCRM more social than before, positioning themselves to compete with other sCRM offerings. This release also has support for more cloud providers making it easy to deploy SugarCRM on the cloud.

 SugarCRM also announced partnerships with two cloud service providers, a topic that may be of some interest to Cloud Ave audience. At the Microsoft Worldwide Partners Conference at Washington DC, SugarCRM announced that Sugar 6 is now certified for deployment on Microsoft’s Windows Azure platform. What it essentially means is that one can install SugarCRM on Windows Azure and it will work as promised without any issues. This increases the number of cloud partners for SugarCRM. Interestingly, SugarCRM has embraced the cloud era with a different approach from companies like Salesforce.com, Zoho CRM (disclaimer: Zoho is the exclusive sponsor of this blog but it is my independent opinion), etc.. While the latter companies take a multi-tenant SaaS approach, SugarCRM is trying to push for cloud apps instead. They certify SugarCRM with different cloud vendors and when it is installed on these clouds, it will work flawlessly. I asked Martin Schneider, Senior Director, Communications at SugarCRM, if SugarCRM will scale out in the Azure environment like the underlying cloud platform, he said it will scale seamlessly without any efforts on the user's side. He also pointed out that the users of SugarCRM on Azure can use either MySQL or SQL Azure.

Comment (0)

Highlights

- Tutorial: Getting Started with MySQL Workbench
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- White Paper: Guide to MySQL for Microsoft Windows
- Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup
- Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials (Thursday, July 22)

New Product Releases

- New Release of MySQL Workbench 5.2.25 (GA)
- New Release of MySQL Community Server 5.1.48 (GA)
- New Release of MySQL Connector/J 5.1.13 (GA)

Hints & Tips

- Documentation: InnoDB INFORMATION_SCHEMA Tables
- Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010
  - PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster
  - PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes
  - PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
  - PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions
  - PlanetMySQL Blog: Running MySQL Cluster as a service on Windows
  - PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits
  - PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening
  - PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance
  - PlanetMySQL Blog: How many IOPs can InnoDB do?
  - PlanetMySQL Blog: Lock wait timeout on slaves

Spotlight: MySQL Embedded Server in Network Management

- On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine
- Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL
- Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server
- Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

Events

- Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine (Wednesday, July 14)
- Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals (Thursday, July 15)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA
- Live Webinar: What's New in MySQL - Japanese (Thursday, July 22)
- On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL
- On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

-------------------------------------------------------------------

Highlights

Tutorial: Getting Started with MySQL Workbench

This tutorial provides a quick hands-on introduction to using MySQL Workbench for beginners. In order to complete this tutorial you will need to have a locally installed MySQL Server. This tutorial requires MySQL Workbench version 5.2.16 or above.

View the Tutorial:
  http://dev.mysql.com/doc/workbench/en/wb-getting-started-tutorial.html


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how MySQL Workbench can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


White Paper: Guide to MySQL for Microsoft Windows

As we will discover over the course of this paper, MySQL on Windows continues to be a popular choice for independent software vendors, original equipment manufacturers, hosting providers and organizations developing custom web, departmental and enterprise applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_onwindows.php


Case Study: MySQL Cluster Scores at the 2010 FIFA World Cup

The Pyro Group has selected the MySQL Cluster database to power their InRoam SDP (Service Delivery Platform). InRoam enables Cell C and their network partners to provide low cost, border-less mobile communications services to hundreds of thousands of football fans from around the world as they descend on South Africa for the 2010 FIFA World Cup tournament.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-pyro_telecoms.php


Live Webinar: MySQL Essentials Series - Part 2: SQL Scripting Essentials Thursday, July 22, 2010 - 9am PT

Join us for Part 2 of the "MySQL Essentials" webinar series with Mike Frank from the MySQL Product Management group at Oracle. In this presentation, we'll demonstrate the fundamentals of SQL scripting with MySQL. We will cover SELECTs, JOINs, CREATE, DELETE, INSERTs and a host of other DML and DDL operations. Also covered will be essential management commands for administering and monitoring MySQL. We will be demonstrating how to accomplish these tasks both at the command line and in an automated fashion using MySQL's built-in scheduler, MySQL Workbench and MySQL Enterprise Monitor.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-553.html?p=newsletter

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Workbench 5.2.25 (GA)

We're pleased to announce the release of MySQL Workbench 5.2.25. This release is GA (Generally Available). We hope you will make MySQL Workbench your preferred tool for Design, Development, and Administration of your MySQL database applications. MySQL Workbench 5.2 GA provides:

- Database Design & Modeling
- SQL Development (replacing MySQL Query Browser)
- Database Administration (replacing MySQL Administrator)

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-25.html

Download now:
  http://dev.mysql.com/downloads/workbench/

Read the Documentation:
  http://dev.mysql.com/doc/workbench/en/index.html


New Release of MySQL Community Server 5.1.48 (GA)

MySQL Community Server 5.1.48, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.48 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-48.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Connector/J 5.1.13 (GA)

MySQL Connector/J 5.1.13, a maintenance release of the production 5.1 branch has been released. Connector/J is the Type-IV pure-Java JDBC driver for MySQL. Version 5.1.13 is suitable for use with any MySQL version including MySQL-5.0, MySQL-5.1 or MySQL-5.5.

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.1/en/cj-news-5-1-13.html

Download Now:
  http://dev.mysql.com/downloads/connector/j/5.1.html

-------------------------------------------------------------------

Hints & Tips

Documentation: InnoDB INFORMATION_SCHEMA Tables

There are seven INFORMATION_SCHEMA tables that contain live information about compressed InnoDB tables, the compressed InnoDB buffer pool, all transactions currently executing inside InnoDB, the locks that transactions hold and those that are blocking transactions waiting for access to a resource.

Read the Documentation:
  http://dev.mysql.com/doc/innodb-plugin/1.0/en/innodb-information-schema-overview.html


Case Study: MySQL Enterprise Powers 2 Million Referrals in Central Hospital Registry

Sahlgrenska University Hospital (SU) is one of the major hospitals in Europe and was founded in 1997 when three hospitals in Sweden merged. Every year, Sahlgrenska University Hospital records two million referrals and comments through the Central Registry system which is powered by MySQL.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs-enterprise-sahlgrenska_hospital.php


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL Sunday tracks at Oracle OpenWorld 2010 Giuseppe Maxia

Oracle OpenWorld is the conference of everything related to Oracle. This year's edition, running from September 19th to 23rd, is expected to have more than 45,000 attendees, making it one of the biggest IT events worldwide.

Now that MySQL is part of the Oracle portfolio, it is going to be part of the Oracle OpenWorld show. In the spirit of the user groups events, there will be a MySQL Sunday event on Sunday afternoon, with four highly technical tracks, with well known speakers.

Read the PlanetMySQL BlogPost:
  http://blogs.sun.com/MySQL/entry/mysql_sunday_tracks_at_oracle


PlanetMySQL Blog: MySQL Workbench 5.2 goes GA - partial support for MySQL Cluster Andrew Morgan

The new version of MySQL Workbench (5.2.25) has just gone GA - see the Workbench Blog for details. So what's the relevance to MySQL Cluster? If you have a Cluster that uses MySQL Servers to provide SQL access then you can now use MySQL Workbench to manage those nodes.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/mysql-workbench-5-2-goes-ga-partial-support-for-mysql-cluster/


PlanetMySQL Blog: 5 Steps to Get Started with MySQL Cluster in less than 15 minutes Andrew Morgan

A series of quick-start guides are now available to get you up and running with MySQL Cluster in as little time as possible; they are available for LINUX/Mac OS X, Windows and Solaris. The configuration is intentionally a simple 1 - 2 data nodes, 1 management node and 1 MySQL Server. Once you have this up and running, your next experiment may be to extend this over multiple hosts.

Read the PlanetMySQL BlogPost:
  http://www.clusterdb.com/mysql/download-install-configure-run-and-test-mysql-cluster-in-under-15-minutes/


PlanetMySQL Blog: mysqlnd plugins: alternative to MySQL Proxy?!
Ulf Wendel

The mysqlnd plugin API is a well hidden gem of mysqlnd. Mysqlnd plugins operate on a layer between PHP applications and the MySQL server. This is comparable to MySQL Proxy. MySQL Proxy operates on a layer between any MySQL client application, for example, a PHP application, and the MySQL server.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=284


PlanetMySQL Blog: PHP: Client side caching for all MySQL extensions Ulf Wendel

The first public mysqlnd plugin adds client side query result caching to all MySQL extensions of PHP. The cache is written in C. It does not change any of the PHP MySQL APIs and works with any PHP application using MySQL. Query results are stored on the client.

Read the PlanetMySQL BlogPost:
  http://blog.ulf-wendel.de/?p=286


PlanetMySQL Blog: Running MySQL Cluster as a service on Windows Anders Karlsson

The MySQL Cluster daemon for MySQL Cluster (ndbd and ndb_mgmd) doesn't by themselves yet let them run as a service. But there are ways to fix this, using some simple Windows tools and some registry hacking.

Read the PlanetMySQL BlogPost:
  http://karlssonondatabases.blogspot.com/2010/06/running-mysql-cluster-as-service-on.html


PlanetMySQL Blog: Ease of Switching to the InnoDB Plugin and the Numerous Benefits Chris Calender

There are many advantages to using the plugin as opposed to the built-in version (aside from just the new I_S tables, and more importantly, numerous performance enhancements), and it's breeze to set up, so I wanted to provide a quick start guide to using the new InnoDB plugin.

Read the PlanetMySQL BlogPost:
  http://www.chriscalender.com/?p=99


PlanetMySQL Blog: Oracle MySQL Storage Engine Advisory Board - It's Happening Bob Zurek

Over a month ago, Infobright was invited to join the Oracle MySQL Storage Engine Advisory Board and last week was the first in a series of meetings that Oracle will be hosting for the Advisor Board members. Oracle did a terrific job stepping up to the task of assembling a well known group of companies as part of the board. The meeting last week was clearly a sign of commitment by Oracle to work closely with the storage engine vendors in the market. This resonated very well with the advisory board members.

Read the PlanetMySQL BlogPost:
  http://www.infobright.org/Blog/Entry/oracle_mysql_storage_engine_advisory_board_-_its_happening/


PlanetMySQL Blog: How read_buffer_size Impacts Write Buffering and Write Performance Venu Anuganti

Even though the name read_buffer_size implies that the variable controls only read buffering, but it actually does dual purpose by providing sequential IO buffering for both reads and writes.

Read the PlanetMySQL BlogPost:
  http://venublog.com/2010/06/23/how-read_buffer_size-impacts-write-buffering-and-write-performance/


PlanetMySQL Blog: How many IOPs can InnoDB do?
Mark Callaghan

I previously tested InnoDB on an 8-core server to determine how many IOPs it can do for a simple IO-bound workload. The limits were ~12k disk reads/second for MySQL 5.0 and ~18k reads/second for MySQL 5.1. I just repeated the tests using a 16-core server and the results are much better. I can get 20,000 to 30,000 disk reads/second using InnoDB 5.1.

Read the PlanetMySQL BlogPost:
  http://www.facebook.com/note.php?note_id=403975340932


PlanetMySQL Blog: Lock wait timeout on slaves Alex Lurthu

We had one of our slave servers frequently stops replicating with the "Innodb Lock Wait Timeout" error. The slave IO thread would continue to fetch the binlogs while the slave SQL thread kept stopping with the above mentioned error.

Read the PlanetMySQL BlogPost:
  http://alexlurthu.wordpress.com/2010/06/07/lock-wait-timeout-on-slaves/

-------------------------------------------------------------------

Spotlight: MySQL Embedded Server in Network Management

Many new technologies and applications are creating a significant increase in network traffic volume and complexity, making it more difficult to maintain a high performance network that doesn't disrupt application availability. MySQL enables ISVs and OEMs to overcome these limitations and build modern network management products by providing high performance, cost-effectiveness, ease of installation, zero administration, and much more.


On Demand Webinar: Inserts at Drive Speed: Designing a Custom Storage Engine

MySQL offers a variety of storage engines that can be matched to application requirements. Data can be integrated seamlessly between storage engines. When none of the existing engines look like a perfect match to your requirements, you can add your own. MySQL provides a SQL stack for your data. By leveraging the integration between storage engines, you are free to concentrate on just the design of key tables.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-424.html


Case Study: NetQoS Delivers Distributed Network Management Solution with Embedded MySQL

NetQoS delivers products and services that enable some of the world's most demanding enterprises, including American Express, Boeing, and Chevron, to improve network performance. NetQoS ReporterAnalyzer relies on MySQL and tells IT organizations which applications and users are consuming bandwidth, and when, so they can optimize the wide area network and improve IT service delivery.

NetQoS found that MySQL provided the ideal combination of performance, reliability, and ease of administration for ReporterAnalyzer. In addition, MySQL's affordable licensing model enabled NetQoS to reduce its database costs by several thousand dollars per network appliance.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_netqos.php


Case Study: CONCEIVIUM Relies on MySQL to Perform Real-Time Analytics for BlackBerry Enterprise Server

CONCEIVIUM Business Solutions ensures that BlackBerry Enterprise Servers are up and performing optimally 24X7 for three of the world's top five banks, The Coca Cola Company, IBM Global Services and many other primarily Fortune 500 organizations. With MySQL Embedded Server, CONCEIVIUM's Mobile Monitor/Analyzer Agents have achieved a 70% performance gain and are now able to analyze over two gigabytes of data per day and perform thousands of transactions per second.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_conceivium.php


Case Study: ScienceLogic Relies on MySQL to Deliver Integrated Network Management Appliance

To give the entire IT organization better visibility and control over the performance and availability of their networks, systems and applications, ScienceLogic relies on the performance and scalability of MySQL to process real-time information from thousands of networked devices.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_sciencelogic.php

-------------------------------------------------------------------

Events

Live Webinar: Scaling Web Services with MySQL Cluster, Part 2: An Alternative to the Memory Storage Engine Wednesday, July 14, 2010 - 9am PT

The MEMORY storage engine has been widely adopted by MySQL users to provide near-instant responsiveness with use cases such as caching and web session management. The MySQL Cluster database, which itself can be implemented as a MySQL storage engine, is a viable alternative to address these evolving web service demands.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-551.html?p=newsletter


Live Webinar: Getting the Best MySQL Performance in Your Products: Part 1, The Fundamentals Thursday, July 15, 2010 - 9am PT

In Part I of a three-part performance series, MySQL performance expert Brian Miezejewski will take you through the fundamentals of architecting your product's MySQL embedded or bundled database for higher performance and customer satisfaction.

In this session, Brian will go through the first steps to take when designing your database for high performances. He will also show you how to spot and quickly resolve the most common performance bottlenecks.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-552.html?p=newsletter


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA - EMEA

Join this technical webinar for an overview of MySQL's internal architecture including storage engines, security and datatypes. Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access.

Register for the German Webinar on July 16:
  http://dev.mysql.com/news-and-events/web-seminars/display-554.html

Register for the Italian Webinar on July 22:
  http://dev.mysql.com/news-and-events/web-seminars/display-555.html


Live Webinar: What's New in MySQL - Japanese Thursday, July 22, 2010 - 2pm JST

As a result of the acquisition of Sun Microsystems and Oracle, MySQL is now part of Oracle's product portfolio. Oracle invests in MySQL, the world's most popular open source database, and further drives its innovation.

The latest release of MySQL Enterprise includes many new features and improvements, which are designed to save DBAs and Developers time and effort in keeping MySQL systems running at the highest levels of security, performance and availability. In this webinar, we will share the latest updates from MySQL, including exciting new product development.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-556.html


On Demand Webinar: MySQL Essentials Series - Part 1: Building, Installing and Configuring MySQL

In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-538.html?p=newsletter


On Demand Webinar: Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached

MySQL and memcached has become, and will remain, the foundation for many dynamic web services with proven deployments in some of the largest and most prolific names on the web. There are classes of web services, however, that are update-intensive, demanding real-time responsiveness and continuous availability. In these cases, MySQL Cluster provides the familiarity and ease-of-use of the regular MySQL Server, while delivering significantly higher levels of write performance with less complexity, lower latency and 99.999% availability.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-545.html?p=newsletter

Read the White Paper "Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached":
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

You can unsubscribe from this newsletter online:
  http://dev.mysql.com/unsub?email=sanjay.ujina@gmail.com

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)

Articles in this newsletter:

Highlights

- Oracle Outlines Strategy for MySQL
- MySQL track at Oracle Development Tools User Group Conference
- White Paper: How MySQL Powers Web 2.0
- White Paper: MySQL 5.1 for ISV/OEM Solutions
- Evaluation Guide: Evaluating MySQL Cluster 7.1
- Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of 1.5 Million Patients
- Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise
- Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL (Tuesday, May 18)
- Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA (Thursday, May 20)
- Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL (Thursday, May 27)
- Upcoming MySQL University Sessions

New Product Releases

- New Release of MySQL Community Server 5.1.46 (GA)
- New Release of MySQL Workbench 5.2.21 (RC)
- New Release of MySQL Connector/Net 6.1.4 (GA)

Hints & Tips

- White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL
- White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server
- White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs
- Tutorial: Developing Database Applications Using MySQL Connector/C++
- Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer
- Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information
- PlanetMySQL Blog Posts
  - PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting
  - PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions
  - PlanetMySQL Blog: MySQL: The maximum value of an integer
  - PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome
  - PlanetMySQL Blog: Trying out MySQL Push-Down-Join (SPJ) preview
  - PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python
  - PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group
  - PlanetMySQL Blog: Reducing locks by narrowing primary key
  - PlanetMySQL Blog: MySQL Performance: Improving Stability
  - PlanetMySQL Blog: MySQL Random Data Selection
  - PlanetMySQL Blog: A backup today saves you tomorrow
  - PlanetMySQL Blog: Choosing the right data type makes a big difference

Events

- Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features (Tuesday, May 25)
- Live Webinar: Getting started with MySQL Replication - Italian (Tuesday, May 25)
- Live Webinar: MySQL Performance Tuning Best Practices - French (Wednesday, May 26)
- Live Webinar: MySQL Replication - Part 2 - German (Thursday, May 27)
- On-Demand Webinar: Introducing MySQL Cluster 7.1
- On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

-------------------------------------------------------------------

Highlights

Oracle Outlines Strategy for MySQL

Edward Screven, Oracle's Chief Corporate Architect, discussed the current and future state of MySQL in his keynote at the MySQL Conference & Expo.

Watch the Video:
 
http://www.youtube.com/watch?v=C0OkjtlbqVs&feature=PlayList&p=57E661D0569B26
EE&playnext_from=PL&index=0


MySQL track at Oracle Development Tools User Group Conference

The Oracle Development Tools Users Group (ODTUG) is holding its annual conference in Washington, DC, from June 27th to July 1st. By popular demand, there will be a MySQL track organized by the MySQL community. The event includes free sessions. Join us and meet with the MySQL experts!

Learn more:
  http://blogs.sun.com/MySQL/entry/mysql_track_with_free_event


White Paper: How MySQL Powers Web 2.0

MySQL enables up-and-coming Web 2.0 sites like Wikipedia, Facebook and Twitter, as well as established web properties like Craigslist, Google and Yahoo!, to scale out and meet the ever-increasing volume of users, transactions and data.

You will gain an understanding of how MySQL can be used in conjunction with other open source components to deliver low-cost, reliable, scalable, high performance Web 2.0 applications.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_web20.php


White Paper: MySQL 5.1 for ISV/OEM Solutions

The MySQL 5.1 server continues to move MySQL ahead in its mission to make sophisticated database management available and affordable to all. With the release of MySQL 5.1, the MySQL database server provides more enterprise-caliber enhancements that greatly assist those wanting to use MySQL for:

- Managing larger volumes of data
- Applications that have high-availability requirements
- Systems needing a powerful but autonomous-running database

that requires little attention and continually services anywhere from one to thousands of user requests per second.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_51_OEM.php


Evaluation Guide: Evaluating MySQL Cluster 7.1

In this white paper learn the fundamentals of how to design and select the proper components for a successful MySQL Cluster evaluation. We explore hardware, networking and software requirements, and work through basic functional testing and evaluation best practices.

Read the Evaluation Guide:
  http://dev.mysql.com/why-mysql/white-papers/mysql_cluster_eval_guide.php


Case Study: UCR Selects MySQL Enterprise to Power the Medical Registries of
1.5 Million Patients

Uppsala Clinical Research Center, UCR, is a national center of competence for healthcare quality registries in Sweden, and is an independent unit under Uppsala University Hospital and the Disciplinary Domain of Medicine and Pharmacy at the University of Uppsala. UCR's National Quality Registries include treatment and outcome data based on all hospital patients in Sweden, and is used by thousands of doctors, nurses, medical secretaries and representatives within county councils.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_ucr.php


Case Study: ContactLab Supports its High-Performance e-marketing tools with MySQL Enterprise

ContactLab is a leading Italian provider of digital direct marketing services, with offices in Milan, Madrid, Paris, London and Munich.
ContactLab chose to subscribe to MySQL Enterprise to help support the security, availability and scalability of its market-leading platform. Today ContactLab manages more than 3 Terabytes of data with MySQL for sending, tracking and analyzing hundreds of millions of messages every month.

Read this Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_contactlab.php


Live Webinar: Building an Architecture for Scalability: myLifetime.com on MySQL Tuesday, May 18, 2010 - 9:00am PT

Among the top 500 most visited sites on the Internet, myLifetime.com, which is built on Drupal, receives 6.5 million visitors (3.6 million unique) and 50 million page views per month. Because of online campaigns, and the popularity of associated television shows, the Lifetime family of sites must be prepared to accommodate significant volume spikes.

Nathan Potter, VP of Digital Media Technology at myLifetime.com, cites show-related volume spikes of 150,000 page views per hour as within the normal range of traffic. In this webinar, Nathan will cover the architecture they've developed for scalability as well as the techniques they've used for optimizing their site, including MySQL, for scalability and performance.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-535.html


Live Webinar: Windows and MySQL - MySQL for the SQL Server DBA Thursday, May 20, 2010 - 9:00am PT

Join Jimmy Guerrero and Mike Frank of Oracle for an overview of MySQL's internal architecture including storage engines, security and datatypes.
Also covered will be replication, migration strategies, tools and product comparisons to SQL Server, SQL Server Express and Access. If you are a SQL Server DBA interested in learning how to leverage your current knowledge against MySQL, this webinar is for you.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-536.html


Live Webinar: MySQL Essentials Series - Part 1:  Building, Installing and Configuring MySQL Thursday, May 27, 2010 - 9:00am PT

Join us for Part 1 of the "MySQL Essentials" webinar series with Jimmy Guerrero and Mike Frank from the MySQL Product Management group at Oracle.
In this presentation we'll demonstrate how to setup an environment for building MySQL from source on Windows and Linux, leveraging free or open source tools in the build environment. We'll also examine the various MySQL downloads, packages, distributions and installers available to get up and running in 15 minutes or less. Finally, we'll cover the initial configuration of MySQL including memory allocation, connection limits, security and other options.

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-538.html


Upcoming MySQL University Sessions

MySQL University is a free educational online program for engineers and developers who are interested in MySQL development and internals. MySQL University sessions are open to anyone, not limited to Oracle employees.
Sessions are recorded with slides and audio, so if you can't attend the live session you can review the recording anytime after the session.

View Upcoming and Previous Sessions:
  http://forge.mysql.com/wiki/MySQL_University

-------------------------------------------------------------------

New Product Releases

New Release of MySQL Community Server 5.1.46 (GA)

MySQL Community Server 5.1.46, a new version of the popular Open Source Database Management System, has been released. MySQL 5.1.46 is recommended for use on production systems.

View the complete list of changes:
  http://dev.mysql.com/doc/refman/5.1/en/news-5-1-46.html

Download now:
  http://dev.mysql.com/downloads/mysql/5.1.html#downloads


New Release of MySQL Workbench 5.2.21 (RC)

We're announcing the first Release Candidate of MySQL Workbench. MySQL Workbench 5.2 RC provides:

1. Data Modeling
2. Query (upgrade from MySQL Query Browser) 3. Admin (upgrade from MySQL Administrator)

If you are a current user of MySQL Query Browser or MySQL Administrator, we look forward to your feedback on all the new capabilities we are delivering in a single unified MySQL Workbench.

View the complete list of changes:
  http://dev.mysql.com/doc/workbench/en/wb-news-5-2-21.html

Download now:
  http://dev.mysql.com/downloads/workbench/5.2.html


New Release of MySQL Connector/Net 6.1.4 (GA)

MySQL Connector/Net 6.1.4, a new version of the all-managed .NET driver for MySQL has been released. This is our latest GA release and is suitable for use in all scenarios against MySQL servers ranging from version 4.1 to 5.5!

View the Complete List of Changes:
  http://dev.mysql.com/doc/refman/5.5/en/connector-net-news-6-1-4.html

Download Now:
  http://dev.mysql.com/downloads/connector/net/6.1.html#downloads

-------------------------------------------------------------------

Hints & Tips

White Paper: Designing and Implementing Scalable Applications with Memcached and MySQL

Memached is an open-source, distributed memory caching system designed to tackle today's web-scale performance and scalability challenges. Many of the largest and most heavily trafficked web properties on the Internet like Facebook, Fotolog, YouTube, Mixi.jp, Yahoo, and Wikipedia deploy Memcached and MySQL to satisfy the demands of millions of users and billions of page views every month. By integrating a caching tier into their web-scale architectures, these organizations have improved their application performance while minimizing database load.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_memcached.php


White Paper: A Guide for ISVs and OEMs: Migrating From Microsoft Access To MySQL Embedded Server

Many ISVs and OEMs have seen that MySQL Embedded Server's superior scalability -- in both concurrent userload and overall data volume, cost-savings, platform freedom, and feature set combine to provide a compelling business case to move some or all of their Access applications to MySQL Embedded Server. This paper provides insight into what is needed when considering a move from Microsoft Access to MySQL Embedded Server and presents a number of options that ease the transition.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql_wp_msaccess_to_oem.php


White Paper: MySQL Workbench: A Data Modeling Guide for Developers and DBAs

This paper looks at the various types of data that modern businesses need to manage, examines the reasons why a model-driven approach to data management is necessary, and outlines the benefits such an approach provides. It also highlights how the MySQL Workbench product from MySQL can be an indispensable aid in the hands of experienced data modelers, developers, and DBAs who are tasked with managing the complex data management infrastructure of a dynamic and growing business.

Read this White Paper:
  http://dev.mysql.com/why-mysql/white-papers/mysql-wp-workbench.php


Tutorial: Developing Database Applications Using MySQL Connector/C++

This tutorial will show you the essential steps to build and install the new, elegant MySQL Connector/C++ driver, with simple examples to connect, insert, and retrieve data from a MySQL database. Application developers who are new to MySQL Connector/C++ but not to C++ programming and the MySQL database, are the target audience of this tutorial. Because the focus is on database connectivity from a C++ application, this document assumes that some kind of MySQL database is already up and accessible from the client machine.

Read this Tutorial:
 
http://dev.mysql.com/why-mysql/white-papers/mysql_wp_dbapps_connector-c.php


Case Study: Promovacances.com boosts its performance with MySQL Enterprise and the MySQL Query Analyzer

Launched in 1998, Promovacances is a brand of the Karavel group, the leading provider of vacation packages online in France. Promovacances.com gets about 40 million individual visitors per year and 250,000 per day during the high season.

The MySQL Enterprise Platinum subscription gives Karavel access to 24/7 technical support as well as to the MySQL Enterprise Monitor including the new MySQL Query Analyzer.

Read the Case Study:
 
http://dev.mysql.com/why-mysql/case-studies/mysql_cs_karavel_travelling.php


Case Study: Aito Technologies Selects MySQL to Manage Mobile Traffic Data and Customer Information

Aito Technologies has chosen to employ the MySQL Embedded Database Server in order to successfully analyze up to billions of daily phone calls, text messages and mobile data sessions.

With reference clients such as Nokia, TDC, Blyk, Elisa and Muxlim, Aito's daily traffic load entails several terabytes of data. Consequently, the vendor's application has strict requirements for high database performance and scalability on a multiprocessor architecture.

Read the Case Study:
  http://dev.mysql.com/why-mysql/case-studies/mysql_cs_Aito.php


PlanetMySQL Blog Posts

The following blog posts are from PlanetMySQL. PlanetMySQL is an aggregation of blogs and news from MySQL developers, users and employees. It is an excellent source of all things about MySQL, including technical tips and best practices.

Visit PlanetMySQL:
  http://planet.mysql.com/

Submit Your Blog Feed:
  http://planet.mysql.com/new


PlanetMySQL Blog: MySQL 5.5.4 is Very Exciting Jeremy Zawodny

Yesterday at the MySQL Conference, I spent time in a few sessions discussing the performance enhancements in the MySQL 5.5.3 and 5.5.4 milestone releases. What I saw made me very, very happy. In fact, the timing couldn't be better.

Read the PlanetMySQL BlogPost:
  http://blog.zawodny.com/2010/04/14/mysql-5-5-4-is-very-exicting/


PlanetMySQL Blog: Two quick performance tips with MySQL 5.1 partitions Giuseppe Maxia

While I was researching for my partitions tutorial, I came across two hidden problems, which may happen often, but are somehow difficult to detect and even more difficult to fix, unless you know what's going on, and why. I presented both cases during my tutorial, but there were no pictures to convey the mechanics of the problem. Here is the full story.

Read the PlanetMySQL BlogPost:
 
http://datacharmer.blogspot.com/2010/05/two-quick-performance-tips-with-mysq
l.html


PlanetMySQL Blog: MySQL: The maximum value of an integer Roland Bouman

Did you ever have the need to find the maximum value of an integer in MySQL?
Yeah, me neither. Anyway, some people seem to need this, and this is what I came up with.

Read the PlanetMySQL BlogPost:
  http://rpbouman.blogspot.com/2010/05/mysql-maximum-value-of-integer.html


PlanetMySQL Blog: MySQL Cluster - SPJ Preview - Feedback welcome Johan Andersson

SPJ (preview, not production ready) is a new feature allowing some types of JOINs to be pushed down and executed inside the data nodes! This allows for, in many cases, much faster JOIN execution.

Read the PlanetMySQL BlogPost:
 
http://johanandersson.blogspot.com/2010/04/mysql-cluster-spj-preview-feedbac
k_27.html


PlanetMySQL Blog: Trying out MySQL Cluster Push-Down-Join (SPJ) preview Andrew Morgan

At the 2010 MySQL User Conference, Jonas Oreland presented on the work he's been doing on improving the performance of joins when using MySQL Cluster - the slides are available for download. While not ready for production systems, a preview version is available for you to try out. The purpose of this blog is to step through testing an example query as well as presenting the results.

Read the PlanetMySQL BlogPost:
 
http://www.clusterdb.com/mysql-cluster/trying-out-mysql-push-down-join-spj-p
review/


PlanetMySQL Blog: Simulating server-side cursors with MySQL Connector/Python Geert JM Vanderkelen

Last week, my colleague Massimo and I discussed how to handle big result sets coming from MySQL in Python. The problem is that MySQL doesn't support server-side cursors, so you need to select everything and then read it. You can do it either buffered or not. MySQL Connector/Python defaults to non-buffered, meaning that you need to fetch all rows after issuing a SELECT statement. You can also turn on the buffering, mimicking what MySQL for Python (MySQLdb) does.

Read the PlanetMySQL BlogPost:
 
http://geert.vanderkelen.org/2010/04/simulating-server-side-cursors-with.htm
l


PlanetMySQL Blog: The MySQL Community meets the Independent Oracle Users Group Giuseppe Maxia

Collaborate10 is the conference of the Oracle Users Groups. I had been asked to participate with a few talks on MySQL, and I was curious of meeting, for me, a new organization. I prepared three talks, one introduction to MySQL and two advanced ones, and thus equipped I ventured along the immense corridors of the Mandalay Bay convention center.

Read the PlanetMySQL BlogPost:
 
http://blogs.sun.com/datacharmer/entry/mysql_community_meets_the_independent


PlanetMySQL Blog: Reducing locks by narrowing primary key Shlomi Noach

In a period of two weeks, I had two cases with the exact same symptoms.
Database users were experiencing low responsiveness. DBAs were seeing locks occurring on seemingly normal tables. In particular, looking at Innotop, it seemed that INSERTs were causing the locks.

Read the PlanetMySQL BlogPost:
  http://code.openark.org/blog/mysql/reducing-locks-by-narrowing-primary-key


PlanetMySQL Blog: MySQL Performance: Improving Stability Dimitri Kravtchuk

Huge performance improvement has come with MySQL 5.5.4, and looking at the following picture it's very easy to see why.

Read the PlanetMySQL BlogPost:
 
http://dimitrik.free.fr/blog/archives/2010/05/mysql-performance-improving-st
ability.html


PlanetMySQL Blog: MySQL Random Data Selection Mahmud Ahsan

Some days ago I was working in a vocabulary game and dictionary. The dictionary contains 1,10,000 words and meanings. I developed a vocabulary game where I had to randomly choose 10 words out of 1,10,000 dataset. Here I'm describing the possible solutions for this problem and which solution I used.

Read the PlanetMySQL BlogPost:
  http://thinkdiff.net/mysql/mysql-random-data-selection/


PlanetMySQL Blog: A backup today saves you tomorrow Ben Mildren

Whether you're working with MySQL, MySQL Cluster, or any other RDBMS, every database with a requirement for persistent data should always have a backup.
As a Production DBA you're the insurance policy to safeguard the data. Bad things do happen. Backups are your safety net to ensure you always have a way to recover should the worst happen and the database becomes irreparable.

Read the PlanetMySQL BlogPost:
  http://www.productiondba.com/2010/04/a-backup-today-saves-you-tomorrow/


PlanetMySQL Blog: Choosing the right data type makes a big difference Venu Anuganti

Today evening one of my friend asked me in the IM to look into one of his production server where a query was taking about 11 seconds to run on 20 million row table, even though the query is using the right index and the plan as shown below.

Read the PlanetMySQL BlogPost:
 
http://venublog.com/2010/04/19/choosing-the-right-data-type-makes-a-big-diff
erence/

-------------------------------------------------------------------

Events

Live Webinar: Better Java Application Scalability and Reliability Using MySQL Connector/J Features Tuesday, May 25, 2010 - 9:00am PT

Join MySQL and Java experts, Mark Matthews and Todd Farmer, for an encore performance of their MySQL 2010 User Conference Session. In this technical presentation they will explain how to use the scalability and reliability features that are built into MySQL Connector/J to do

- Fault tolerant load balancing
- Replication-aware load balancing with slave fail-over
- Custom exception handling
- Sharding through some creative use of statement interceptors mixed with the built-in load balancer

Register for this Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-537.html


Live Webinar: Getting started with MySQL Replication - Italian Tuesday, May 25, 2010 - 10:00 CET/8:00 UTC

MySQL Replication is widely used to deploy scalable and highly available database architecture. In this presentation we will demonstrate how to get started with configuring MySQL Replication. We will also cover how replication works, supported replication topologies and how to perform management and administration tasks.

Register for this Italian Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-540.html


Live Webinar: MySQL Performance Tuning Best Practices - French Wednesday, May 26, 2010 - 10:00 CET/8:00 UTC

You will get expert insight and learn best practices from the experts at MySQL to help you improve performance! We will discuss the main performance optimization opportunities, including schema optimization, server options tuning, storage engine selection, and more.

Register for this French Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-543.html


Live Webinar: MySQL Replication - Part 2 - German Thursday, May 27, 2010 - 15:00 CET/13:00 UTC

In this presentation we will look at more advanced MySQL Replication techniques. We will cover master-master configurations, semi-synchronous replication, fail-over and resynchronization.

Register for this German Webinar:
  http://dev.mysql.com/news-and-events/web-seminars/display-539.html


On-Demand Webinar: Introducing MySQL Cluster 7.1

In blazing speed we will cover the most important features of MySQL Cluster
7.1: NDB$INFO; MySQL Cluster Connector/Java and other features that push the limits of MySQL Cluster into new workloads and communities.

Watch the On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-527.html


On-Demand Webinar: Using the latest Java Persistence API 2.0 features with MySQL

The Java Persistence API is the Java API for the management of persistence for Java EE and Java SE applications. It provides an object/relational mapping facility for the Java application developer using a Java domain model to manage a relational database. The release 2.0 has been expanded to include several key new features.

This session will provide an introduction to the Java Persistence API and then a presentation of some of the new features available in Java Persistence 2.0. The talk will provide an overview of the object-relational mapping and modeling additions, the query language facilities, the new criteria API, pessimistic locking, and support for validation.

Watch this On-Demand Webinar:
 
http://dev.mysql.com/news-and-events/on-demand-webinars/display-od-504.html


More free MySQL webinars are scheduled and added between each Newsletter edition, so visit our website frequently for the most updated information.

View the full list of webinars:
  http://dev.mysql.com/news-and-events/web-seminars/index.html

-------------------------------------------------------------------

Want to receive the latest MySQL updates and interact with the MySQL community?

Follow MySQL on Twitter:
  http://twitter.com/mysql

Follow MySQL Community on Twitter:
  http://twitter.com/mysql_community

-------------------------------------------------------------------

About the Newsletter

You can send us queries and give us feedback online.
  http://dev.mysql.com/contact/

Read more about the newsletter and view previous issues.
  http://dev.mysql.com/news-and-events/newsletter/

--
Copyright (c) 2010, Oracle Corporation and/or its affiliates.
You are free to distribute this newsletter, as long as you don't make any changes.

Comment (0)