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 77 Next 17 Older Entries

Displaying posts with tag: zfs (reset)

Technical Webinars
Employee +0 Vote Up -0Vote Down

You want to use or to know more about Sun technologies? Join these Webinars to improve your knowledge and skills. You will be able to ask questions to Sun's experts.

  • Mercredi 10 Février : Securité pour les applications Web. Pour les startups du Web, la protection et la sécurisation de leurs applications, de leurs données, et de celles de leurs clients est un véritable facteur clé de succès.  Ce Webinar couvre les différents challenges liés à la sécurité ainsi que les solutions associées telles que l'encryption, l'authentification, les certificats, la sécurisation du stockage et le stockage à tolérance de panne, les environnements étanches. Les architectes de Sun Startup Essentials présenteront des implémentations économiques basées sur des composents standards et ouverts tel qu'Apache,

  [Read more...]
Technical Webinars
Employee +0 Vote Up -0Vote Down

You want to use or to know more about Sun technologies? Join these Webinars to improve your knowledge and skills. You will be able to ask questions to Sun's experts.

  • Mercredi 10 Février : Securité pour les applications Web. Pour les startups du Web, la protection et la sécurisation de leurs applications, de leurs données, et de celles de leurs clients est un véritable facteur clé de succès.  Ce Webinar couvre les différents challenges liés à la sécurité ainsi que les solutions associées telles que l'encryption, l'authentification, les certificats, la sécurisation du stockage et le stockage à tolérance de panne, les environnements étanches. Les architectes de Sun Startup Essentials présenteront des implémentations économiques basées sur des composents standards et ouverts tel qu'Apache,

  [Read more...]
Storage Miniconf Deadline Extended!
+0 Vote Up -0Vote Down

The linux.conf.au organisers have given all miniconfs an additional few weeks to spruik for more proposal submissions, huzzah!

So if you didn’t submit a proposal because you weren’t sure whether you’d be able to attend LCA2010, you now have until October 23 to convince your boss to send you and get your proposal in.

Backup MySQL in a Second with ZFS
Employee +1 Vote Up -1Vote Down

MySQL backup soon becomes an important matter when the database is used in production. The pain-point comes from the fact that while backuping the database is not available to respond to client requests anymore. With mysqldump - the standard tool for performing MySQL backups - and a large database the operation can go over many tenth of minutes if not hours. If I am running my business on line this is simply not acceptable.

The classical approach to workaround this problem is to take advantage of MySQL replication. I set up a master/slave configuration where the slave acts as copy of the master. Then, when needed, I run mysqldump on the slave without any service interruption on the master.

But ZFS snapshosts bring a new straightforward approach that avoids the pain and the complexity of a master/slave replication.



  [Read more...]
Storage for your Database
Employee +0 Vote Up -0Vote Down

Save the date - October 14th, 3pm Paris & Berlin, 2pm London, 4pm Jerusalem  -  for this free live webinar where you'll have a chance to ask questions to our experts.

This webinar focuses on how ZFS, SSDs and the Open Storage line of products from Sun are changing the rules in the database storage industry. You will learn how to increase data security, scalability, and reduce the price/performance ratio with these technologies. This webinar includes ZFS best practises for databases backup and performance.

To register, click here.

Recording: "ZFS + SSD tuning for databases"
Employee +0 Vote Up -0Vote Down

Just in case you missed the live event, we have a recording of the ZFS + SSD for databases webcast Listen Now

You can also download the slides from Slide share. Download Slides

ZFS & SSDs. Database Performance tuning webcast
Employee +1 Vote Up -0Vote Down
Over the last month I have been working on a ZFS Tuning for Databases presentation. I'll be presenting it live tomorrow 8/26/09 at 8 AM PST.

This based on a lot of work done at Sun as well as in the community. With the massive adoption of Solid State Devices (SSDs) (thank you iPOD) the storage market just got a whole lot more interesting. Incorporating SSDs into a ZFS pool is a breeze. This presentation is meant to help you get the best out of the ZFS + SSD combination for databases. We look into Postgres, MySQL and Oracle. I also provide a quick into into Sun's unified storage 7000 series systems.

If you are interested do Register Now

Recap of Southeast Linux Fest 2009
+0 Vote Up -0Vote Down

Last weekend, my brother and I attended SELF 2009. A few thoughts on it:

The mixture of sessions was interesting. There were some really good ones. I think the best session I attended was an OpenSolaris/NetBeans/Glassfish/Virtualbox/ZFS session, given by a Sun employee. He was an excellent presenter, and really showed off the strengths of the technologies in a nice way. He started up enough VMs to make his OpenSolaris laptop chew into swap, and I thought it was fun to see how it dealt with that. I’ve heard Solaris and OpenSolaris do a lot better at avoiding and managing swapping than GNU/Linux, but I couldn’t make any opinion from watching. I did think it was odd to have this session at a “Linux” (yes, they left off the GNU) conference. But I thought the session was a good addition to

  [Read more...]
MySQL Innodb ZFS Best Practices
Employee +2 Vote Up -0Vote Down

One of the cool things about talking about MySQL performance with ZFS is that there is not much tuning to be done Tuning with ZFS is considered evil, but a necessity at times. In this blog I will describe some of the tunings that you can apply to get better performance with ZFS as well as point out performance bugs which when fixed will nullify the need for some of these tunings.

For the impatient, here is the summary. See below for the reasoning behind these recommendations and some gotchas.

  • Match ZFS recordsize with Innodb page size (16KB for Innodb Datafiles, and 128KB for Innodb log files).
  • If you have a write heavy workload, use a
  •   [Read more...]
    MySQL Innodb ZFS Best Practices
    Employee +0 Vote Up -0Vote Down

    One of the cool things about talking about MySQL performance with ZFS is that there is not much tuning to be done Tuning with ZFS is considered evil, but a necessity at times. In this blog I will describe some of the tunings that you can apply to get better performance with ZFS as well as point out performance bugs which when fixed will nullify the need for some of these tunings.

    For the impatient, here is the summary. See below for the reasoning behind these recommendations and some gotchas.

  • Match ZFS recordsize with Innodb page size (16KB for Innodb Datafiles, and 128KB for Innodb log files).
  • If you have a write heavy workload, use a
  •   [Read more...]
    MySQL Innodb ZFS Best Practices
    Employee +0 Vote Up -0Vote Down

    One of the cool things about talking about MySQL performance with ZFS is that there is not much tuning to be done Tuning with ZFS is considered evil, but a necessity at times. In this blog I will describe some of the tunings that you can apply to get better performance with ZFS as well as point out performance bugs which when fixed will nullify the need for some of these tunings.

    For the impatient, here is the summary. See below for the reasoning behind these recommendations and some gotchas.

  • Match ZFS recordsize with Innodb page size (16KB for Innodb Datafiles, and 128KB for Innodb log files).
  • If you have a write heavy workload, use a
  •   [Read more...]
    Dear Oracle,
    +1 Vote Up -0Vote Down

    A couple of weeks ago I wrote a post titled Dear IBM , I was too late .. I was on holliday last week when people started sending me text messages , such as .. "Game Over MySQL , Long live Ingress" or "No Eclipse for IBM", etc ...

    I had ideas regarding the future of certain Sun products at IBM, now the game has changed .. it'ss how they will live on at Oracle :)

    Similar Questions arise .. like indeed the future of MySQL, the future of Solaris etc ...

    So regarding the future of MySQL , I don't worry at all, on the contrary ..
    Oracle tried buying mysql before they already have Innodb .. they didn't kill it .. the MySQL offering is complementary to the Oracle offering, now they can tackle both markets.
    And as already mentionned when writing my IBM letter ..


    As for MySQL, Jeremey has some



      [Read more...]
    GlassFish and More at MySQL Users Conference
    Employee_Team +0 Vote Up -1Vote Down

    Mon-Thu I'll be attending the MySQL User's Conference here in Santa Clara. The tone of the conference is noticeably different to that of its (even larger) sibling JavaOne in San Francisco, and the topics are very grounded in the practical needs of the Users of the technology. There are many very interesting talks, below is a small selection extracted from my Personal Schedule.

    Starting with those related to topics we normally cover here: Several BOFs:

      [Read more...]
    Sun's Cloud (4 of 4)
    Employee +0 Vote Up -0Vote Down
    In the last three updates to this blog, I've tried to set out a clear direction of where Sun's headed. I've talked about our three basic priorities:

    1. Technology Adoption
    2. Commercial Innovation
    3. Efficiently Connecting Adoption and Commercial Opportunity.

    I'm hoping you've got a clear picture surrounding the first of these two priorities - how and where we drive software adoption, and focus our commercial efforts.

    So now I'd like to talk about the linkages - while also addressing one of our biggest strategic challenges, our scale.

    Selling Scale
    First, why is scale a challenge for Sun? To be clear, I'm not talking about purchasing scale. As I've said before, we use innovation to drive product profitability, not simply bulk purchasing leverage. The scale to which I'm referring is selling and marketing scale. With Sun's current products, we could



      [Read more...]
    Sun's Network Innovations (3 of 4)
    Employee +0 Vote Up -0Vote Down
    As I referenced in my prior entry, I'm reviewing Sun's three major strategic imperatives, and our progress going in to next fiscal year. Our strategic imperatives, in order, are:

    1. Technology Adoption
    2. Commercial Innovation
    3. Efficiently Connecting 1. and 2.

    This entry focuses on the second, Commercial Innovation, and reviews our core revenue products, services and strategies.

    By now, you understand Sun's approach to growing the market - driving adoption of key technologies drives Sun's addressable market. Once you're using one of our fundamental technologies, Sun's innovations focused on those technologies are relevant to you.




      [Read more...]
    MySQL University: MySQL and ZFS
    Employee +0 Vote Up -0Vote Down

    This Thursday (March 12th, 14:00 UTC), Martin MC Brown will give a MySQL University session on MySQL and ZFS. MC works on the MySQL Documentation Team and has been involved with quite a few Solaris things, for example porting MySQL to openSolaris. MC has recently given MySQL University talks on developing MySQL on Solaris and about using DTrace with MySQL.

    For MySQL University sessions, point your browser to this page. You need a

      [Read more...]
    Technology Adoption (2 of 4)
    Employee +0 Vote Up -0Vote Down
    As I referenced in my prior entry, I'm reviewing Sun's three major strategic imperatives, and our progress going in to next fiscal year. Our strategic imperatives, in order, are:

    1. Technology Adoption
    2. Commercial Innovation
    3. Efficiently Connecting 1. and 2.

    This entry focuses on the first, Technology Adoption. Adoption is a non-economic phenomena, no money is spent, only time - yet it has extreme financial consequences. Let me give you an example.

    I was with a big customer of ours last year, and reading through my account briefing before the meeting, I knew we were doing well. An analysis of their download activity showed they were heavy users of Solaris and OpenSolaris, and they had a large internal community of MySQL users, as well. In the meeting, their CIO said "we love where




      [Read more...]
    Understanding Sun in Three Easy Steps (1 of 4)
    Employee +0 Vote Up -0Vote Down
    We've been making a fair number of announcements recently - on both the product and the partnering front. That's generated a lot of interest, and a fair number of questions. So I thought I'd take the opportunity to deliver this overview and the upcoming focused discussions on what makes Sun tick in a video format. Let me know if this is useful, or what else we can do to keep you informed via the comment field at the bottom.

    We're approaching the end of our fiscal year, and given all the swirl in the economy, I thought it worthwhile to restate where Sun's headed as a company, to let customers, partners, employees and investors see and understand where we're headed. Clarity's always useful, doubly so in times of uncertainty.

    Let me start by joining the chorus of those worried about the global economy. I am routinely talking to customers now partially owned by governments, whose

      [Read more...]
    Managing a Bestseller
    Employee +0 Vote Up -0Vote Down
    There are a couple of bookstores in my neighborhood. They could not be more different from one another.

    The first is known to focus on best seller lists, to promote popular books, and use displays and traditional retail techniques to drive business. They seem to do well, year in, year out. The other bookstore is more of a community treasure, beloved by the neighborhood, with a focus on the (thoughtful) insights of their staff. Those insights are delivered via small note cards appended to shelving throughout the store, where books are displayed alphabetically, with library-like neutrality.

    The first store is very market focused, changes with the season, and seems to be quite succesful. The latter store, beloved though it may be, struggles to stay in business.

      [Read more...]
    Great things afoot in the MySQL community
    +0 Vote Up -0Vote Down

    tl;dr: The MySQL community rocks. Percona, XtraDB, Drizzle, SSD storage, InnoDB IO scalability challenges.

    For anyone who lives and dies by MySQL and InnoDB, things are finally starting to heat up and get interesting. I’ve been banging the “MySQL/InnoDB scales poorly” drums for years now, and despite having paid Enterprise licenses, I haven’t been able to get anywhere. I was pretty excited when Sun

      [Read more...]
    (Another) Win for Open Storage...
    Employee +0 Vote Up -0Vote Down

    Wikipedia is one of the world's most visited web sites (8th in the top 10, in fact), delivering an enormous breadth of content to an audience as vast as the internet. But Wikipedia's evolved to become more than an on-line encyclopedia: they've become one of the world's largest search engines, they're a global source of real-time news, alongisde educational, political and health related content - and one of the world's most valuable brands and media properties.

    Wikipedia's also a great example of a "redshift" application: a segment of the market that's growing faster than the technology

      [Read more...]
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7
    Employee +0 Vote Up -0Vote Down
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

    A new era

    In the past few years, I published many articles using Oracle as a database server. As a former Sybase system administrator and former Informix employee, it was obviously not a matter of personal choice. It was just because the large majority of Sun's customers running databases were also Oracle customers.

    This summer, in our 26 Sun Solution Centers worldwide, I observed a shift. Yes, we were still seeing older solutions based on DB2, Oracle, Sybase or Informix being evaluated on new Sun hardware. But every customer project manager, every partner, every software engineer working on a new information system design asked us : Can we architect this solution with MySQL ?

    In many cases, if you dared to reply YES to this question, the next interrogation would be

      [Read more...]
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7
    Employee +0 Vote Up -0Vote Down
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

    A new era

    In the past few years, I published many articles using Oracle as a database server. As a former Sybase system administrator and former Informix employee, it was obviously not a matter of personal choice. It was just because the large majority of Sun's customers running databases were also Oracle customers.

    This summer, in our 26 Sun Solution Centers worldwide, I observed a shift. Yes, we were still seeing older solutions based on DB2, Oracle, Sybase or Informix being evaluated on new Sun hardware. But every customer project manager, every partner, every software engineer working on a new information system design asked us : Can we architect this solution with MySQL ?

    In many cases, if you dared to reply YES to this question, the next interrogation would

      [Read more...]
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7
    Employee +0 Vote Up -0Vote Down
    Scaling MySQL on a 256-way T5440 server using Solaris ZFS and Java 1.7

    A new era

    In the past few years, I published many articles using Oracle as a database server. As a former Sybase system administrator and former Informix employee, it was obviously not a matter of personal choice. It was just because the large majority of Sun's customers running databases were also Oracle customers.

    This summer, in our 26 Sun Solution Centers worldwide, I observed a shift. Yes, we were still seeing older solutions based on DB2, Oracle, Sybase or Informix being evaluated on new Sun hardware. But every customer project manager, every partner, every software engineer working on a new information system design asked us : Can we architect this solution with MySQL ?

    In many cases, if you dared to reply YES to this question, the next interrogation would

      [Read more...]
    You Have to Stop to Change Direction
    Employee +0 Vote Up -0Vote Down

    The bursting of the internet bubble was good for the computer industry.

    Many of us didn't like the medicine, but I can't remember a single customer upset at the idea of paying $20,000 for computing infrastructure that used to cost them $100,000. The price compression came from open source software, and a move toward general purpose servers, and resulted in companies formerly making 65% gross profit on products (Sun among them) facing a new reality.

    But what doesn't kill you makes you stronger.

    Since then, Sun's built the biggest open source software business around (see this report for

      [Read more...]
    Understanding Sun's Business - Q1 Results
    Employee +0 Vote Up -0Vote Down
    We announced our earnings today, and put specifics around our preannouncement from a week ago.

    We also greatly increased the transparency of Sun's business by providing line item detail surrounding our most important product categories (and we broke out core elements of our Software business for the first time). If you'd like to listen to our earnings call, just click here - in addition, here's a quick synopsis of the quarter and our business overall.

    At a corporate level in Q1, Sun's revenue was down 7% year over year. Growth in our emerging products was more than offset by declines in our traditional, high end products. We were surprised by the magnitude of the decline, which reflected a dramatic slowing in the US and Europe, and the effects the credit crisis is having on our

      [Read more...]
    Update from SmugMug: ZFS & MySQL/InnoDB Compression Update
    Employee +0 Vote Up -0Vote Down

    Don MacAskill at SmugMug updated his blog a while back on ZFS and MySQL to include information on compression.  From his tests, he found that LZJB was a better choice than gzip -- performance improved while still leaving room on the CPU.  This was using InnoDB tables. 

    See the full details here.

    Open Solaris + MySQL + ZFS Success Story in Production at SmugMug
    Employee +0 Vote Up -0Vote Down

    SmugMug , a photos and videos publishing site, goes into Production on Open Solaris + MySQL + ZFS. Check out this story on why a Linux geek decided to move his site from Linux To Open Solaris.

    Don MacAskill, chief geek and CEO of SmugMug says"  ZFS is the most amazing filesystem I’ve ever come across. Integrated volume management. Copy-on-write. Transactional. End-to-end data integrity. On-the-fly corruption detection and repair. Robust checksums. No RAID-5 write hole. Snapshots. Clones (writable snapshots). Dynamic striping. Open source software. " He is also excited about the CoolStack 5.1 stack available in Open

      [Read more...]
    Open Solaris + MySQL + ZFS Success Story in Production at SmugMug
    Employee +0 Vote Up -0Vote Down

    SmugMug , a photos and videos publishing site, goes into Production on Open Solaris + MySQL + ZFS. Check out this story on why a Linux geek decided to move his site from Linux To Open Solaris.

    Don MacAskill, chief geek and CEO of SmugMug says"  ZFS is the most amazing filesystem I’ve ever come across. Integrated volume management. Copy-on-write. Transactional. End-to-end data integrity. On-the-fly corruption detection and repair. Robust checksums. No RAID-5 write hole. Snapshots. Clones (writable snapshots). Dynamic striping. Open source software. " He is also excited about the CoolStack 5.1 stack available in

      [Read more...]
    Open Solaris + MySQL + ZFS Success Story in Production at SmugMug
    Employee +0 Vote Up -0Vote Down

    SmugMug , a photos and videos publishing site, goes into Production on Open Solaris + MySQL + ZFS. Check out this story on why a Linux geek decided to move his site from Linux To Open Solaris.

    Don MacAskill, chief geek and CEO of SmugMug says"  ZFS is the most amazing filesystem I’ve ever come across. Integrated volume management. Copy-on-write. Transactional. End-to-end data integrity. On-the-fly corruption detection and repair. Robust checksums. No RAID-5 write hole. Snapshots. Clones (writable snapshots). Dynamic striping. Open source software. " He is also excited about the CoolStack 5.1 stack available in

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 77 Next 17 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.