Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 31 to 60 of 181 Next 30 Older Entries

Displaying posts with tag: memcached (reset)

Not only SQL - memcache and MySQL 5.6
Employee +2 Vote Up -0Vote Down

This week there are two big events for the MySQL community: The O'Reilly MySQL Conference and Oracle Collaborate run by the IOUG. At these events our Engineering VP, Tomas Ulin, announced the latest milestone releases for our main products. MySQL 5.6 and MySQL Cluster 7.1 as well as our new Windows Installer. There's lots of cool stuff in there but one feature really excited me: MySQL 5.6 contains a memcache interface for accessing InnoDB tables. This means you can access data stored in MySQL not only using SQL statements but also by using a well established and known noSQL protocol.

This works by having the memcache daemon running as plugin as part of the MySQL server. This daemon can then be configured in three ways: Either


      [Read more...]
    451 CAOS Links 2011.04.12
    +0 Vote Up -0Vote Down

    Groklaw declares victory. Cloudera updates Hadoop distro. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
    “Tracking the open source news wires, so you don’t have to.”

    # Groklaw claimed victory, will stop publishing new articles on May 16.

    # Cloudera released version 3 of its Hadoop distribution.

    # VoltDB released version 1.3 of its open source distributed in-memory database.

    # Black Duck grew sales by 51% in Q1.

    # eXo and Convertigo partnered to add


      [Read more...]
    MySQL Cluster 7.2 Development Milestone Release - NoSQL with Memcached and 20x Higher JOIN Performance
    Employee_Team +4 Vote Up -0Vote Down

    The announcements at the Oracle Collaborate and O'Reilly MySQL conferences mark an exciting milestone in the development of the MySQL Cluster database.

    MySQL Cluster is already proven as a write-scalable, real-time transactional database, combining 99.999% availability with the low TCO of open source. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware to serve read and write intensive workloads.

    With these enhancements announced in the Development Milestone Release, MySQL Cluster can be extended to serve a broader range of workloads.

    Summary of Key Enhancements

    The MySQL Cluster 7.2 Development Milestone Release and latest labs.mysql.com builds deliver enhancements based on input from the

      [Read more...]
    NoSQL to MySQL with Memcached
    Employee_Team +6 Vote Up -0Vote Down

    The ever increasing performance demands of web-based services has generated significant interest in providing NoSQL access methods to MySQL - enabling users to maintain all of the advantages of their existing relational database infrastructure, while providing blazing fast performance for simple queries, using an API to complement regular SQL access to their data.

    The HandlerSocket development at DeNA is a great example of community innovation, with a solution implemented as a custom plug-in and protocol for the MySQL server daemon.

    We are hearing the community say they want NotOnly SQL - they want their trusted SQL RDBMS - plus, they want NoSQL techniques to access that data. So, we are previewing our NotOnlySQL solution for MySQL - delivered via memcached - with implementations to

      [Read more...]
    MySQL Cluster 7.2 Development Milestone Release - NoSQL with Memcached and 20x Higher JOIN Performance
    Employee_Team +0 Vote Up -0Vote Down

    The announcements at the Oracle Collaborate and O'Reilly MySQL conferences mark an exciting milestone in the development of the MySQL Cluster database.

    MySQL Cluster is already proven as a write-scalable, real-time transactional database, combining 99.999% availability with the low TCO of open source. With a distributed, multi-master architecture and no single point of failure, MySQL Cluster scales horizontally on commodity hardware to serve read and write intensive workloads.

    With these enhancements announced in the Development Milestone Release, MySQL Cluster can be extended to serve a broader range of workloads.

    Summary of Key Enhancements

    The MySQL Cluster 7.2 Development Milestone Release and latest labs.mysql.com builds deliver enhancements based on input from the community

      [Read more...]
    NoSQL to MySQL with Memcached
    Employee_Team +0 Vote Up -0Vote Down

    The ever increasing performance demands of web-based services has generated significant interest in providing NoSQL access methods to MySQL - enabling users to maintain all of the advantages of their existing relational database infrastructure, while providing blazing fast performance for simple queries, using an API to complement regular SQL access to their data.

    The HandlerSocket development at DeNA is a great example of community innovation, with a solution implemented as a custom plug-in and protocol for the MySQL server daemon.

    We are hearing the community say they want NotOnly SQL - they want their trusted SQL RDBMS - plus, they want NoSQL techniques to access that data. So, we are previewing our NotOnlySQL solution for MySQL - delivered via memcached - with implementations to access

      [Read more...]
    innodb and memcached
    +3 Vote Up -0Vote Down

    I had a quick look at the source tree (I haven’t compiled it, just read the source – that’s what I do. I challenge any C/C++ compiler to keep up with my brain!) that’s got a tarball up on labs.mysql.com for the memcached interface to innodb. A few quick thoughts:

    • Where’s the Bazaar tree on launchpad? I hate pulling tarballs, following the dev tree is much more interesting from a tech perspective (especially for early development releases). I note that the NDB memcached stuff is up on launchpad now, so yay there. I would love it if the InnoDB team in general was much more open with development, especially with having source trees up on launchpad.
    • It embeds a copy of the memcached server engines branch into the MySQL tree. This is probably the correct way to go. There
      [Read more...]
    NoSQL to InnoDB with Memcached
    Employee +4 Vote Up -0Vote Down

    MySQL is the most popular open source SQL database. The ever-increasing performance demands of web-based services have generated significant interest in providing NoSQL access methods to MySQL. Today, MySQL is announcing the preview of the NoSQL to InnoDB via memcached. This offering provides users with the best of both worlds – maintain all of the advantages of rich SQL query language, while providing better performance for simple queries via direct access to shared data.

    In this preview release, memcached is implemented as a MySQL plugin daemon, accessing InnoDB directly via the native InnoDB API:

    Features provided in the current release:

    • Memcached as a daemon
      [Read more...]
    Brian Aker explains Memcached
    +2 Vote Up -0Vote Down

    Memcached is one of the technologies that holds the modern Internet together, but do you know what it actually does? Brian Aker has certainly earned the title of Memcached guru, and below he offers a peek under the hood. He'll also provide a deeper dive into Memcached in a tutorial at the upcoming 2011 MySQL Conference.

    What problem is Memcached meant to solve?

      [Read more...]
    MySQL caching methods and tips
    +2 Vote Up -0Vote Down
    “The least expensive query is the query you never run.”

    Data access is expensive for your application. It often requires CPU, network and disk access, all of which can take a lot of time. Using less computing resources, particularly in the cloud, results in decreased overall operational costs, so caches provide real value by avoiding using those resources. You need an efficient and reliable cache in order to achieve the desired result. Your end users also care about response times because this affects their work productivity or their enjoyment of your service. This post describes some of the most common cache methods for MySQL.

    Popular cache methods

    The MySQL query cache

    When the query cache is enabled, MySQL examines each query to see if the contents have been stored in the query cache. If the results have been cached they are


      [Read more...]
    Part 2 – Simple lessons in improving scalability
    +3 Vote Up -0Vote Down

    Given the popular response from my first lesson in improving scalability where I detailed simple ways to eliminate unnecessary SQL, let me share another common bottleneck with MySQL scalability that can be instantly overcome.

    Analyzing the writes that occur on a system can expose obvious potential bottlenecks. The MySQL Binary Log is a wealth of information that can be mined. Simple DML Counts per table can be achieved by a single line command.

    Let’s look at the following example output of a production system:

    mysqlbinlog /path/to/mysql-bin.000999 |  \
       grep -i -e "^update" -e "^insert" -e "^delete" -e "^replace" -e "^alter"  | \
       cut -c1-100 | tr
      [Read more...]
    Memcached Functions for MySQL 1.1 Released!
    +8 Vote Up -0Vote Down
    I just released Memcached Functions for MySQL, version 1.1. I'm very happy with this release since it has a new get_cas() and get_cas_by_key() function as well as my own shiny new string functions! See Blue Gecko's blog for details: http://www.bluegecko.net/mysql/memcached-functions-for-mysql-1-1-released/
    Memcached Functions for MySQL 1.1 released!
    +3 Vote Up -0Vote Down

    I’m pleased to announce the release of Memcached Functions for MySQL, version 1.1. It’s been a while since the 1.0 release, and I’ll use writing a book and having a baby as an excuse, but nevertheless, this release has several changes and new features:

    • Fixed all the calls to libmemcached that were broken when libmemcached changed. This release works with Libmemcached 0.44
    • Added my own string functions as the libmemcached string functions I relied on before were made local/private from the shared library
    • Added memc_get_cas() and memc_get_cas_by_key() functions. You can now obtain the CAS value of an item! For instance:
    mysql> select memc_servers_set('localhost:11211');
    +-------------------------------------+
    | memc_servers_set('localhost:11211') |
    +-------------------------------------+
    |
      [Read more...]
    On generating unique IDs using LAST_INSERT_ID() and other tools
    +1 Vote Up -0Vote Down

    There’s a trick for using LAST_INSERT_ID() to generate sequences in MySQL. Quoting from the Manual:

  • Create a table to hold the sequence counter and initialize it:
    mysql> CREATE TABLE sequence (id INT NOT NULL);
    mysql> INSERT INTO sequence VALUES (0);
    
  • Use the table to generate sequence numbers like this:
    mysql> UPDATE sequence SET id=LAST_INSERT_ID(id+1);
    mysql> SELECT LAST_INSERT_ID();
    
  • This trick calls for trouble.

    Contention

    A customer was using this trick to generate unique session IDs for

      [Read more...]
    Plugin Memcached 20 Study
    +0 Vote Up -0Vote Down
    Check out this SlideShare Presentation:
    Plugin Memcached%20 Study
    View more presentations from Liu Lizhi.


    MySQL and memcached Guide
    +0 Vote Up -0Vote Down
    Check out this SlideShare Presentation: MySQL and memcached GuideView more documents from webhostingguy.


    CB1 Ubuntu 10.10 Linux Development Setup
    +0 Vote Up -0Vote Down

    I use a MacBook Pro for my day-to-day operations here at CB1, INC. I’m a huge believer that a development environment should mimic the production environment, so I find myself running a couple virtual machines in VMware Fusion.

    The following guide is a reference for myself as well as possibly a helpful resource for setting up your own Linux development environment. Here’s an checklist of the tasks to perform and software to install:

    • Operating System
      • Ubuntu 10.10 64-bit: I use Ubuntu Desktop in dev and Ubuntu Server in production
      • Package updates and upgrades
      • Network configuration (at least 2 static IP addresses)
    • Development Tools
      • C/C++ development environment
      • Autotools
      • Sun Java JDK
      [Read more...]
    451 CAOS Links 2010.10.08
    +0 Vote Up -0Vote Down

    Patents! Patents! Patents! Canonical’s perfect 10. And more.

    Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
    “Tracking the open source news wires, so you don’t have to.”

    # Google responded to Oracle’s claims that its Android OS infringes copyrights and patents related to Java.

    # Matt Asay evaluated the various patent claims against Android and its related devices.

    # Microsoft licensed smartphone patents from ACCESS Co and a subsidiary of Acacia Research.

    # Glyn Moody assessed what Microsoft’s


      [Read more...]
    LCA Miniconf Call for Papers: Data Storage: Databases, Filesystems, Cloud Storage, SQL and NoSQL
    +3 Vote Up -0Vote Down

    This miniconf aims to cover many of the current methods of data storage and retrieval and attempt to bring order to the universe. We’re aiming to cover what various systems do, what the latest developments are and what you should use for various applications.

    We aim for talks from developers of and developers using the software in question.

    Aiming for some combination of: PostgreSQL, Drizzle, MySQL, XFS, ext[34], Swift (open source cloud storage, part of OpenStack), memcached, TokyoCabinet, TDB/CTDB, CouchDB, MongoDB, Cassandra, HBase….. and more!

    Call for Papers open NOW (Until 22nd October).

    More on dangers of the caches
    +4 Vote Up -0Vote Down

    I wrote couple of weeks ago on dangers of bad cache design. Today I’ve been troubleshooting the production down case which had fair amount of issues related to how cache was used.

    The deal was as following. The update to the codebase was performed and it caused performance issues, so it was rolled back but yet the problem remained. This is a very common case when you would see customer telling you everything is the same as it was yesterday… but it does not work today.

    When I hear these words I like to tell people computers are state machines and they work in predictable way. If it does not work same today as it worked yesterday something was changed… it is just you may not recognize WHAT was changed. It may be something subtle as change in query plan or

      [Read more...]
    Caching could be the last thing you want to do
    +6 Vote Up -0Vote Down

    I recently had a run-in with a very popular PHP ecommerce package which makes me want to voice a recurring mistake I see in how many web applications are architected.

    What is that mistake?

    The ecommerce package I was working with depended on caching.  Out of the box it couldn't serve 10 pages/second unless I enabled some features which were designed to be "optional" (but clearly they weren't).

    I think with great tools like memcached it is easy to get carried away and use it as the mallet for every performance problem, but in many cases it should not be your first choice.  Here is why:

    • Caching might not work for all visitors - You look at a page, it loads fast.  But is this the same for every user?  Caching can sometimes be an optimization that makes the average user have a


      [Read more...]
    As of late...
    +1 Vote Up -0Vote Down
    What I'm up to lately (giving love to some projects):

    * Fixing bugs in DBD::mysql, just released 4.015, 4.016, and next 4.017. I had a patch sent yesterday from a user/developer that I want to get out there
    * Memcached::libmemcached - 0.4201 version - now using latest libmemcached 0.42. This is the only Perl client that supports binary protocol!

    patg@patg-desktop:~/code_dev/perl-libmemcached$ PERL_DL_NONLAZY=1 /usr/bin/perl "-MExtUtils::Command::MM" "-e" "test_harness(0, 'blib/lib', 'blib/arch')" t/12-set-get-binary.t




      [Read more...]
    Webinar today – Scaling Web Services with MySQL Cluster, Part 1: An Alternative to MySQL Server & memcached
    Employee +7 Vote Up -2Vote Down

    The replay of this webinar is now available from http://www.mysql.com/news-and-events/on-demand-webinars/display-od-545.html (http://www.mysql.com/news-and-events/on-demand-webinars/display-od-545.html" target="_blank)

    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

      [Read more...]
    On Good Instrumentation
    +1 Vote Up -0Vote Down

    In so many cases troubleshooting applications I keep thinking how much more efficient things could be going if only there would be a good instrumentation available. Most of applications out there have very little code to help understand what is going on and if it is there it is frequently looking at some metrics which are not very helpful.

    If you look at the system from bird eye view - system needs to process transactions and you want it to successfully complete large number of transactions it gets (this is what called availability) and we want it to serve them with certain response time, which is what is called performance. There could be many variables in environment which change - load, number of concurrent users, database, the way users use the system but in the nutshell all what you really care is having predictable response time within certain range. So if we

      [Read more...]
    Introduction to memcached
    +0 Vote Up -0Vote Down

    These are the slides to a talk I did earlier this week for students of the professional bachelor in ICT course at KaHo St. Lieven. I wanted to give a clear and simple introduction to the memcached service, as I think it’s an invaluable tool in today’s web development.

    Scaling Web Services with MySQL Cluster: An Alternative Approach to MySQL & memcached
    Employee +6 Vote Up -0Vote Down

    A new white paper is available from http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php (http://www.mysql.com/why-mysql/white-papers/mysql_wp_cluster_ScalingWebServices.php" target="_blank)

    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 highly transactional and 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 whitepaper will discuss the

      [Read more...]
    Beyond great cache hit ratio
    +0 Vote Up -0Vote Down

    I worked with application recently which has great memcached hit ratio - over 99% but yet still has average page response time over 500ms. Reason ? There are hundreds memcached gets and even though they have some 0.4ms response time they add up to add hundreds of ms to the total response time.

    The great memcached hit ratio is great however even more than that you should target eliminating requests all together. Hit rate is very bad indicator to begin with. Imagine you have application which gets 90 memcache gets (hits) to retrieve some data plus there are 10 more requests which resulted in misses and caused MySQL queries. The hit ratio is 90%. Imagine now you have found a way to store the data which required 90 requests as the single object. You have 1 request (hit) now and 10 misses which drops your hit rate down to less than 10% but performance will

      [Read more...]
    MySQL Conference Review
    +1 Vote Up -0Vote Down
    I am back home from a good week at the 2010 O'Reilly MySQL Conference & Expo. I had a great time and got to see some old friends I had not seen in a while.

    Oracle gave the opening keynote and it went pretty much like I thought it would. Oracle said they will keep MySQL alive. They talked about the new 5.5 release. It was pretty much the same keynote Sun gave last year. Time will tell what Oracle does with MySQL.

    The expo hall was sparse. Really sparse. There were a fraction of the booths compared to the past. I don't know why the vendors did not come. Maybe because they don't want to compete with Oracle/Sun? In the past you would see HP or Intel have a booth at the conference. But, with Oracle/Sun owning MySQL, why even try. Or maybe they are not allowed? I don't know. It was just sad.

    I did stop by the Maatkit booth and was embarrassed to





      [Read more...]
    Expert PHP and MySQL published!
    +4 Vote Up -0Vote Down
    I'm very pleased to announce the publication of my book Expert PHP and MySQL, published by Wrox. This book was written by myself, Andrew Curioso and Ronald Bradford. The short of it is, upon finishing my previous book, Developing Web Applications with Apache, MySQL, memcached, and Perl, Wiley asked me if I knew of anyone who would like to write a MySQL/PHP book. I had worked with Andrew at Lycos and found him to be a brilliant PHP developer, having been the primary developer of Lycos's Webon product-- which has some excellent usage of PHP, Javascript and MySQL. When I friend of mine Bob Wilkins, who started MyVBO, was looking for a developer I suggested Andrew (he now works at MyVBO), and for this book  [Read more...]
    Interviewed by Scoble about Gear6 Memcached
    +0 Vote Up -0Vote Down
    Yesterday, while at the MySQL Conference, I was interviewed by Robert Scoble about my employer, Gear6 and our product, an enterprise memcached distribution.

    Previous 30 Newer Entries Showing entries 31 to 60 of 181 Next 30 Older Entries

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

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