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 58

Displaying posts with tag: LAMP (reset)

First Olio Release
Employee +0 Vote Up -0Vote Down

We have just released the first binary version of Apache Olio for both the PHP and Rails implementation. Both implementations have been tested quite thoroughly now and we think they are robust enough for serious use - especially for performance testing the workloads.


I introduced Olio in a previous post. It is a toolkit that includes a sample web2.0 application implemented in both PHP and Rails that includes a load generator to drive load against the application.


Please visit the Olio site and download the kits. If you find it interesting, I invite you to come join the project.

First Olio Release
Employee +0 Vote Up -0Vote Down

We have just released the first binary version of Apache Olio for both the PHP and Rails implementation. Both implementations have been tested quite thoroughly now and we think they are robust enough for serious use - especially for performance testing the workloads.


I introduced Olio in a previous post. It is a toolkit that includes a sample web2.0 application implemented in both PHP and Rails that includes a load generator to drive load against the application.


Please visit the Olio site and download the kits. If you find it interesting, I invite you to come join the project.

There is no L in Sun’s LAMP
+0 Vote Up -0Vote Down

Yesterday Sun introduced Glassfish Portfolio. Its a new stack of open source middleware products including Glassfish Enterprise Server, Glassfish ESB, Glassfish Web Space Server, and the new Glassfish Web Stack, which includes support for projects such as Tomcat, Memcached, Apache, PHP, Ruby and Python and a copy of MySQL Community.

It’s a pretty complete infrastructure stack. What it is not, however, is an integrated LAMP stack, despite Sun’s reference to it as such not once but twice on its press announcement.

Glassfish Portfolio runs on Linux of course, as well as Solaris, but it does not contain Linux (integrated or otherwise) or Linux services (although that is available

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

Red Hat’s chairman wins enterprising award. Sun updates StarOffice. Barracuda Networks acquires 3SP. Reaction to Sun’s reorganization. Barack Obama’s laptop. And more.

Press releases
Red Hat, Inc.’s Matthew Szulik Named Ernst & Young Entrepreneur Of The Year 2008 Overall National Winner Ernst & Young

Ingres Launches Ingres Database 9.2 Ingres

Sun Microsystems Unveils StarOffice 9 Software Sun Microsystems

Red Hat Increases Authorization to Repurchase Common Stock Red


  [Read more...]
Scaling WikiPedia with LAMP: 7 billion page views per month
Employee +0 Vote Up -0Vote Down

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month. The highlights from the talk are listed below that included the architecture of the site infrastructure to scale up to the traffic that is received. They are ranked amongst the Top 10 sites in terms of traffic.

The site runs on the LAMP stack and you know what that is:

  • Linux
  • Apache
  • MySQL from Sun
  • Perl/PHP/Python/Pwhatever :-)

WikiMedia runs the site on about 400 x86 servers. Of those, about 250 run the webservers



  [Read more...]
Scaling WikiPedia with LAMP: 7 billion page views per month
Employee +0 Vote Up -0Vote Down

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month. The highlights from the talk are listed below that included the architecture of the site infrastructure to scale up to the traffic that is received. They are ranked amongst the Top 10 sites in terms of traffic.

The site runs on the LAMP stack and you know what that is:

  • Linux
  • Apache
  • MySQL from Sun
  • Perl/PHP/Python/Pwhatever :-)

WikiMedia runs the site on about 400 x86 servers. Of those, about 250 run the webservers



  [Read more...]
Scaling WikiPedia with LAMP: 7 billion page views per month
Employee +0 Vote Up -0Vote Down

I recently attended an interesting talk by Brion Vibber, CTO of WikiMedia Foundation, a non-profit organisation that runs the infrastructure for Wikipedia. He described how his team of 7 engineers manages the Wikipedia site that gets on an average of 7 billion page views per month. The highlights from the talk are listed below that included the architecture of the site infrastructure to scale up to the traffic that is received. They are ranked amongst the Top 10 sites in terms of traffic.

The site runs on the LAMP stack and you know what that is:

  • Linux
  • Apache
  • MySQL from Sun
  • Perl/PHP/Python/Pwhatever :-)

WikiMedia runs the site on about 400 x86 servers. Of those, about 250 run the



  [Read more...]
sshfs: How do you install sshfs and fuse? [CentOS/Linux/Redhat]
+0 Vote Up -0Vote Down

One may wonder what is sshfs and why would you want it?  Well simply put, sshfs allows you to mount another server’s filesystem into a folder on your local system which in the background is doing ssh commands and transfers.  As a mounted folder, you are able to move about and copy files back and forth as everything was on local server.  As you can see this makes it very easy for you to work with files on multiple servers.

Note:  you only have to do the following installations on the server where you are doing the mounts on.

Let us download and install the filesystem framework which is a requirement for sshfs called fuse.

wget http://voxel.dl.sourceforge.net/sourceforge/fuse/fuse-2.7.4.tar.gz
tar zxpfv fuse-*.gz
cd fuse*
./configure

If you get the following error, you will either have to point to the




  [Read more...]
Zmanda Recovery Manager for MySQL - Detailed Review by Linux Journal
+0 Vote Up -0Vote Down

This month’s (September 2008) edition of Linux Journal has an in-depth review of Zmanda Recovery Manager for MySQL (written by Alolita Sharma a veteran of Open Source). Oh, and we made it on the cover as well! If you are browsing Magazines section of your local bookstore, do look us up..

Linux: How do you find out what your server’s outgoing ip is?
+0 Vote Up -0Vote Down

There are many times when I needed to find out my outgoing (or external) IP for the servers which are behind load balancers or firewalls.  I used to just login to another external server from the server in question and find out by looking at “who” what my external ip is.  Even though it works and I am so used to it, today I decided to figure out a more graceful way of finding my outgoing ip.  As most of us already know, whatismyip.com is the quickest way to find out your outgoing ip from the browser.  So I decided to use the same way on the servers.  So I issued a wget:

wget http://www.whatismyip.org

Well that does the trick.  But being lazy as I am, I did not want to have to cat the output file to find out the ip (plus there is no point of creating extra files and

  [Read more...]
MAS saves millions with LAMP stack
+0 Vote Up -0Vote Down

Malaysian Airlines has impressed me, yet again. Last week, in The Star, they reported that Sharul Isahak, a MAS employee, has helped save the airlines close to RM70 million (about USD$21 million), thanks to his use of open source software.

The software is meant to help airline maintenance, i.e. to keep track of parts and records of maintenance works. The web-based solution, is E-Promis (read the blog entry, its pretty interesting, as he takes you through the planning stages - it also seems like he’s still the only developer).

?This meant looking at open-source solutions. Instead of platforms such as Microsoft or Sun, we chose LAMP (Linux,

  [Read more...]
Mycat beta 0.3.0 released
+0 Vote Up -0Vote Down
After a very long time distracted with other projects, I finally added the third component of the MyCAT project: binlog_mon, a binary log manager for MySQL.

The main feature of this tool is that it has two disk usage thresholds which determine when it purges your binary logs:
  • a lower, "nominal", threshold above which binary logs will be purged if-and-only-if none of the replication slaves are still reading it,
  • and a higher, "critical", threshold at which the behavior is configurable.
It can simply send you an alert if disk usage is above critical and the oldest file is still needed - or it can purge 1 file, all files until usage below critical, or all files until usage below nominal levels. (Other options could be added fairly easily.) The "critical" option is so configurable because



  [Read more...]
Slides from Red Hat Summit “Open Source Backup” Presentation
+0 Vote Up -0Vote Down

Here are my slides used for presentation at Red Hat Summit in Boston last week:

Zmanda: Open Source Backup (.odp open office format, 1.7MB)

Poll of MySQL Quickpolls
+0 Vote Up -0Vote Down

MySQL Quickpolls might be insightful for people who develop products and services for MySQL. Recently I was looking again at “How do you backup your production database” poll. To interpret the results, I wanted to know who are the people answering that and other Quickpolls. Are they the DBAs responsible for running MySQL in production or the developers writing applications that use MySQL? For a backup guy like me knowing that makes a difference.

Every Quickpoll gets a time stamp when opened and tells how many people answered the poll. It occurred to me that the normalized number of people (MySQL polls run for different periods of time) answering each poll could give me some insight. The graph below shows the daily number of people answering each poll in the last 24 months.

  [Read more...]
MySQL Conference, Chapter 2
+0 Vote Up -0Vote Down

The team just finished our second successful MySQL Con. Many thanks to Marten & Zack and all the folks at O’Reilly that put on such a great conference.

This year definitely had a different feel, and of course that had a lot to do with Sun’s influence. It felt like it was almost a new event, a chapter 2 for MySQL, and its ecosystem of vendors and customers. There were more people - I don’t know exact numbers, but it felt appeared to be twice as packed. The exhibit hall was the same, but we took up a bit more space than last year and certainly there were much fancier booths - ours included! We even gave away multiple prizes this year - our fun 8-ball tshirts, and a couple remote control helicopters. Scott Baird and Mike Hogan were the lucky winners this year.

The one


  [Read more...]
Slides from Zmanda keynote today (Online MySQL Backup)
+0 Vote Up -0Vote Down

Final slides from keynote delivered this morning at the MySQL user conference. Topic was protecting live MySQL databases.

(Slides render well in both OpenOffice and PowerPoint)

Wow! What a Great First Day at MySQL UC
+0 Vote Up -0Vote Down

You have to have been living under a rock, if you did not know that today is the first day of MySQL Users’ Conference and Expo. We at Zmanda are so proud and privileged to have been awarded the “Partner of The Year”. The award is very meaningful to our vision of Simplified, Easy to use, commercial Open Source Backup and Recovery. We appreciate the award and are committed to making the life of the MySQL DBA hassle free. We have had a ton of visitors from all walks of MySQL user community talk to us today. Its fascinating to talk to customer and prospects on how they leverage the power of MySQL. To learn more about how Zmanda provides the Best in Class Backup and Recovery solution for MySQL, you can attend Zmanda’s sessions at the MySQL Conference & Expo include:
What: “Radically Simple

  [Read more...]
Protecting CFD (and making more money as a MySQL DBA)
+0 Vote Up -0Vote Down

No, this is not a blog about Computational Fluid Dynamics - my least favorite subject in college. This is about a more exciting (sorry mechanical engineers!) CFD: Customer Facing Data. This is the data that is typically available on the website of an organization that their customers interact with. CFD can range all the way from profiles of users on a social networking site such as Facebook to the customer information database of an e-commerce company such as Travelocity.

CFD represents today’s data protection challenge. Probably the biggest challenge while planning a backup solution for CFD is that it is very hard to figure out what to plan for. You might be starting with a very small database which might grow much more rapidly than what you think. If the data can be segmented based on users or some other characteristic,

  [Read more...]
Highly Scalable MySQL Backups using Snapshots (ZFS or NetApp)
+0 Vote Up -0Vote Down

We have been focusing on providing the best possible backup solution for following scenario: 100 GB+ of data stored in MySQL database, Transaction intensive workload (i.e. rapid rate of change of data), with a business requirement to be able to perform point-in-time restoration of the MySQL database. Oh, the solution also needs to take into account that the database can grow to 1TB or more very quickly.

For such a scenario, we believe that the best possible solution today is a combination of:

  • Storage level snapshots - a capability built into ZFS (Solaris), NetApp, LVM (Linux), VxFS, and VSS (Windows)
  • Transaction logs generated by MySQL
  • Point-and-click restore capability provided by Zmanda Recovery Manager for MySQL
  • Two reports came out today which go into nitty-gritty of above. First is a joint report written by NetApp

      [Read more...]
    Sun/MySQL to resell Zmanda Recovery Manager for MySQL
    +0 Vote Up -0Vote Down

    Today Sun and Zmanda announced our agreement to deliver a comprehensive, global data backup and recovery solution for MySQL Enterprise subscribers. Starting April 1st, MySQL Enterprise customers will be able to purchase ZRM for MySQL directly from Sun worldwide.

    I think Zack’s comment in the press release captures the rationale for the deal:

    “Protecting corporate data through effective backup and recovery is one of the most crucial tasks for a database administrator, and it can be a complex undertaking — especially for today’s large Web-scale applications,” said Zack Urlocker, VP of products, Sun Microsystems database group. “MySQL users have told us that global backup and recovery is very important to them, and we are thrilled that we can now offer ZRM for MySQL as an easy-to-use solution for protecting all of

      [Read more...]
    Zmanda Recovery Manager 2.1 - Keep those MySQL Databases Zipping
    +0 Vote Up -0Vote Down

    Today we announced a significant enhancement to our Zmanda Recovery Manager (ZRM) for MySQL product. Here are major highlights of this new version (2.1):

    End-to-end support for Solaris: We have had increasing number of requests from customers for supporting Solaris. While we always protected MySQL databases running on Solaris, we needed customers to run the ZRM core engine on a Linux box. Now we are able to run the ZRM core engine on Solaris itself. So a pure Solaris shop can use ZRM without getting a Linux server. The coinciding of this support with MySQL’s acquisition by Sun was not a planned thing

    Enhanced Snapshot support: One of the coolest features

      [Read more...]
    Congratulations to Sun and MySQL
    +0 Vote Up -0Vote Down

    Congratulations to Marten and team on Sun’s acquisition of MySQL today! This is a billion dollar stamp of approval on the importance of the LAMP stack. This also gives another strong backing to the business model which involves giving one’s software away for free to up to 99+% of users!

    This announcement comes at an interesting time for Zmanda. Just last week we announced support for the Solaris platform for our Amanda Enterprise product line. With our industry leading MySQL backup solution, we now have full coverage of operating systems and database software from the new Sun!

    A great day for open source software and business of open source software!

    The Growing Popularity of LAMP
    +0 Vote Up -0Vote Down
    LAMP is a proven software stack for developing and implementing multi-tiered web applications. Linux - operating system Apache - web server MySQL - database server PHP - programming language for dynamic web pages The nice part of this stack is that it an extremely low cost solution for implementing web based solutions. This stack is also interchangeable. The operating
    Data Protection for the LAMP Economy
    +0 Vote Up -0Vote Down

    The value of data stored in LAMP applications is increasing at an exponential pace. Indeed, the LAMP stack fuels an economy of its own - with its own currency, lingo and players. While e-commerce is the clear and present evidence of the LAMP powered economy, the currency for this economy is by no means just monetary. Value is manifested in many factors other than financial gains: personal reputation and legacy, karma points, creativity etc. The LAMP stack fires up innovation by enabling new ideas - you can quickly and cost-effectively prototype a concept which other’s may find bizarre.

    User generated content (UGC) is one key currency of the LAMP stack. UGC, even votes (ok, diggs) on other’s UGC store tangible and lasting value. While naming “You”, a proxy for UGC, the Time’s Person of the Year 2006, The Time magazine said: “It’s a story about community and

      [Read more...]
    SCALE 5x: The SoCal Linux Expo 2007
    +0 Vote Up -0Vote Down

    Ilan Rabinovitch let me know that the SCALE team is getting started on version 5x of the SoCal Linux Expo.

    In past years, SCALE has been a great community event - the ratio of promoters to real Linux enthusiasts is low and the attendees are friendly. Also, like most other Linux conferences, attendees have a strong interest in many other FLOSS community issues and technologies, like BSD, Firefox, Apache, PHP, MySQL, Free Software licensing and so on. Hopefully I can attend this year (and can wear both my eZ hat and my Mozilla hat for the event).

    The event will happen from February 10-11 and will be held at the Westin Los Angeles Airport hotel.

    Get more details at:

      [Read more...]
    ApacheCon Europe Deal: See great speakers, get great books
    +0 Vote Up -0Vote Down

    My friends Theo Schlossnagle, Laura Thomson and Chris Shiflett are each presenting at ApacheCon Europe. They are each excellent presenters with solid content - I have seen Theo present at a previous ApacheCon, caught Laura at several OSCONs and finally saw Shiflett speak at the PHP Quebec conference earlier this year.

    The deal is simple - sign up for any of their tutorials before the early bird deadline for the conference closes (on June 6th) and get complementary copies of some of the speaker’s book(s).

    The sessions are:

      [Read more...]
    Audio for Copyright, Contracts and Licensing for PHP Developers session
    +0 Vote Up -0Vote Down

    The organizers of the PHP Québec Conference were gracious enough to give me an unedited copy of my Copyright, Contracts and Licensing for PHP Developers session.

    I cleaned the audio up last night, stripping out some of the more odious filler words (I seem to say “Umm” rather often), shortening pauses as I switched slides, removing redundant asides (like asking if there are any questions, when no questions then follow) and excising the introduction and applause.

    After a good deal of consideration, I did chose to leave the errors and other flaws in the content presented. These flaws were presented to the audience and they should stay in the recording.

    Of course, I don’t want people to be mislead by any of the flaws; to prevent

      [Read more...]
    Slides from PHP Québec Conf 2006
    +0 Vote Up -0Vote Down

    Slides from my presentations at the PHP Québec Conference are below:

    I will make the audio of the licensing session, along with a transcript, available as soon as possible.

    Update:

    Transcript now available.

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 58

    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.