AMT Blog

MySQL Cluster 7.2 was released to public by Oracle on Wednesday, Feb 15, 2012. "MySQL Cluster 7.2 demonstrates Oracle’s investment in further strengthening MySQL’s position as the leading Web database,” said Tomas Ulin, vice president of MySQL Engineering, Oracle. “The performance and flexibility enhancements in MySQL Cluster 7.2 provide users with a solid foundation for their mission-critical Web workloads, blending the best of SQL and NoSQL technologies to reduce risk, cost and complexity.”

MySQL Cluster 7.2 release added improvements in autosharding the data and replication conflict resolution in addition to some scalability and reliability improvements that allow replication at different data centers. There was also some work in fixing issues with replicating user privileges and making the clusters easier to manage and administer. As well as some work done to certify and integrate the cluster nodes into the Oracle VM infrastructure to take advantage of increased elastic scalability for cloud deployments. MySQL Cluster 7.2 in now certified to run on Oracle Linux and Oracle Solaris.

Regarding the 70x improvement in complex query speed ("mind blowing numbers"), Tomas mentioned that this was accomplished with what they call "push down joins" or "distributed joins" which sound a lot like a MapReduce specific use case to do a distributed join on a heavily sharded relational database. The joins happen to the actual data nodes. They are done in parallel on all of the nodes, and then one node combines them. The parallels of the join is where the speed comes in. Tomas claims billion queries per minute with an 8 node cluster and near linear scalability in join processing by adding new nodes.

Read more

Don't like to miss out any of our posts? Do Subscribe to our Feed

After many years of web developing with PHP, 99% of my sites are using MySQL so that is why I decided to create DALMP.

I have been using ADOdb, pear DB, Zend DB, etc. they are excellent applications, but many times they are too much for what I need, so that is why I started creating DALMP, a data abstraction layer that just feet my needs , taking the best practice code out there and put it on a single simple file.

%0 fat and extremely easy to use, just one file, define some constants and you are ready to go.

Details

• redis support (http://code.google.com/p/redis/)
• memcache single or multiple hosts and socket support (http://code.google.com/p/memcached/)
• apc support (http://pecl.php.net/package/APC)
• Group caching cache by groups and flush by groups or individual keys
• Disk cache support.
• Prepared statements ready.
• Ability to use different cache types at the same time.
• Simple store of session on database (mysql/sqlite) or a cache like redis/memcache/apc.
• Easy to use/install/adapt DALMP is just a single file.
• Nested Transactions (SAVEPOINT / ROLLBACK TO SAVEPOINT).
• Common methods are named exactly like ADOdb in case you want to try DALMP with an existing code that uses ADOdb.
• sql queue.
• helpful methods, renumber('table') or renumber('table','uid') - renumbers a table, UUID - create an 'universally unique identifiers'
• http client + queue (for sending data via http to another server expecting an answer, if expected was ok then proceed other wise queue the http request).
• trace everything enabling the debugger by just setting something like $db->debug(1).

Read more…

Don't like to miss out any of our posts? Do Subscribe to our Feed

Oracle released a technology preview this week a new version of MySQL that adds support for a Memcached plugin daemon for accessing InnoDB, MySQL's default storage engine. It's available from MySQL Labs. The plugin daemon is only available for Linux at this time.

Memcached stores key-value queries in memory to achieve NoSQL performance. Memcached has always worked with MySQL, but has run independently. This plugin should speed up the process considerably by allowing Memcached to access the InnoDB API directly.

Here are the features, according to the InnoDB blog:

• Memcached as a daemon plugin of mysqld: both mysqld and memcached are running in the same process space, with very low latency access to data
• Direct access to InnoDB: bypassing SQL parser and optimizer
• Support standard protocol (memcapable): support both memcached text-based protocol and binary protocol; all 55 memcapable tests are passed
• Support multiple columns: users can map multiple columns into "value". The value is separated by a pre-defined "separator" (configurable).
• Optional local caching: three options - "cache-only", "innodb-only", and "caching" (both "cache" and "innodb store"). These local options can apply to each of four Memcached operations (set, get, delete and flush).
• Batch operations: user can specify the batch commit size for InnoDB memcached operations via "daemon_memcached_r_batch_size" and "daemon_memcached_w_batch_size" (default 32)
• Support all memcached configure options through MySQL configure variable "daemon_memcached_option"

Read the full story…

Don't like to miss out any of our posts? Do Subscribe to our Feed

The trend for NoSQL stores such as memcache for fast key-value storage should give us pause for thought: what have regular database vendors been doing all this time? An important new project, HandlerSocket, seeks to leverage MySQL's raw speed for key-value storage.

NoSQL databases offer fast key-value storage for use in backing web applications, but years of work on regular relational databases has hardly ignored performance. The main performance hit with regular databases is in interpreting queries.

HandlerSocket is a MySQL server plugin that interfaces directly with the InnoDB storage engine. Yoshinori Matsunobu, one of HandlerSocket's creators at Japanese internet and gaming company Dena, reports over 750,000 queries per second performance on commodity server hardware: compared with 420,000 using memcache, and 105,000 using regular SQL access to MySQL. Furthermore, since the underlying InnoDB storage is used, HandlerSocket offers a NoSQL-type interface that doesn't have to trade away ACID compliance...read more

We thank all our readers for the incredible support and valuable feedback you've provided over the years to make us better at what we do and hope it will continue the next year as well.

Wish you all a Happy & Prosperous 2011!

PHP Development

8 Experts Break Down the Pros and Cons of Coding With PHP

An Interesting & Insightful article which originally appeared on Mashable Network, on the strengths & weaknesses of coding with PHP. Check out the Opinion of these experts on questions like these: "What makes PHP a good language? What are some of PHP’s drawbacks? And what are the best apps or cleverest hacks you’ve seen made with and/or for PHP?"

10 Productive PHP Tools for Testing and Debugging

Despite the general notion that programming is a profession steeped in discipline and rigor, members of the programming community tend to be rather finicky folks who can be very particular when it comes to tooling. Thankfully PHP developers have a great deal to choose from when it comes to testing and debugging tools, and in this article I'll highlight 10 of my favorites.

PHP snippets to interact with Twitter

Twitter is an awesome tool for website owners, and you should definitely integrate it into your website if you want to attract more traffic and new visitors. Today, let’s take a look at some PHP snippets to interact with Twitter.

MYSQL

10 Command-line Time savers for MySQL Tasks

Although several great GUI-based MySQL clients exist, among them phpMyAdmin and SQLYog, I've always preferred to use the native mysql command-line client. It does take some time to get acquainted with using a command-line interface (CLI), particularly if you don't regularly work with an operating system offering a robust CLI environment. However, after some practice you'll be able to manage users, navigate your databases, and perform other tasks with incredible ease.

Top 10 MySQL Mistakes Made By PHP Developers

A database is a fundamental component for most web applications. If you’re using PHP, you’re probably using MySQL–an integral part of the LAMP stack. PHP is relatively easy and most new developers can write functional code within a few hours. However, building a solid, dependable database takes time and expertise. Here are ten of the worst MySQL mistakes I’ve made (some apply to any language/database)…

Web Design

520 Grid System: HTML/CSS Framework made for Facebook Page Developers

Nowdays there are milions of Facebook Pages almost about everyting. Facebook Page creators try to impress first-time-visitors but also fans with atractive and useful content in custom made FBML tabs. Because I am one of them also, I always need some quicker and more efficient way to make my FBML content and show it as soon as possible to fans of my Facebook pages.

Three Fresh CSS Frameworks

CSS Frameworks are those marvelous and innovative tools that will speed up your web development process by taking care of the multitude of repetitive processes you would have to cover for every project, and on top of that, they (mostly) take care of any cross-browser compatibility issues. They have also never been as popular, with new frameworks cropping out from week-to-week.

5 Design Trends That Small Businesses Can Use in 2011

In the past 12 months, we’ve seen a lot of changes in the world of web design. Growing popularity in the mobile device space — including smartphones and tablets like the iPad — have refined the way many users access and interact with content. Likewise, the formal adoption of web standards like HTML5, web fonts and CSS3 by browser makers means that more and more users are now able to take advantage of the latest and greatest features on the web.

UX

Decision Architecture: Helping Users Make Better Decisions

"What is it that makes a Web site great? In answering this question, it’s sometimes valuable to take a step back and consider anew why we create Web sites. … For the most part, we create Web sites to get users to do something…."

jQuery

50 Useful jQuery Plugins to Enhance your Forms

Here we present some useful plugins and tutorials that will let you create awesome forms for your websites — whether it’s a sign up form or contact us form. You can enhance its functionality and usefulness with these plugins. Since these forms are used by the visitors of your website to interact with you, they are of great importance and for this reason you cannot just ignore them as they play an important role in the success of your website. So here we have gathered a bunch of jQuery Plugins, Tutorials and Resources which will help you in improving the effectiveness and beauty of these forms

jQuery’s Data Method – How and Why to Use It

jQuery’s data method gives us the ability to associate arbitrary data with DOM nodes and JavaScript objects. This makes our code more concise and clean. As of jQuery 1.4.3 we also have the ability to use the method on regular JavaScript objects and listen for changes, which opens the doors to some quite interesting applications.