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 中文
Showing entries 1 to 23

Displaying posts with tag: hosting (reset)

A few great weeks for MariaDB
+2 Vote Up -4Vote Down

I think MariaDB has had a great few weeks recently and the timeline of these events are important.

  • 27 November 2012 – WiredTree Adds MariaDB for Faster MySQL Database Performance (well worth reading their motivations to switch)
  • 29 November 2012 – Monty Program & SkySQL release the MariaDB Client Library for C & Java
  • 4 December 2012 – MariaDB Foundation is announced, see ZDNet coverage.
  • mid-December 2012 – Wikimedia Foundation starts migrating
  •   [Read more...]
    Redehost Transforms Cloud & Hosting Services with MySQL Enterprise Edition
    Employee_Team +4 Vote Up -0Vote Down

    RedeHost are one of Brazil's largest cloud computing and web hosting providers, with more than 60,000 customers and 52,000 web sites running on its infrastructure.

    As the company grew, Redehost needed to automate operations, such as system monitoring, making the operations team more proactive in solving problems. Redehost also sought to improve server uptime, robustness, and availability, especially during backup windows, when performance would often dip.

    To address the needs of the business, Redehost migrated from the community edition of MySQL to MySQL Enterprise Edition (http://www.mysql.com/products/enterprise/), which has delivered a host of benefits:

    - Pro-active database management and monitoring using MySQL Enterprise Monitor (http://www.mysql.com/products/enterprise/monitor.html),

      [Read more...]
    MySQL replication monitoring on Ubuntu 10.04 with Nagios and NRPE
    +0 Vote Up -0Vote Down

    If you're using MySQL replication, then you're probably counting on it for some fairly important need. Monitoring via something like Nagios is generally considered a best practice. This article assumes you've already got your Nagios server setup and your intention is to add a Ubuntu 10.04 NRPE client. This article also assumes the Ubuntu 10.04 NRPE client is your MySQL replication master, not the slave. The OS of the slave does not matter.

    Getting the Nagios NRPE client setup on Ubuntu 10.04

    At first it wasn't clear what packages would be appropriate packages to install. I was initially misled by the naming of the nrpe package, but I found the correct packages to be:

    sudo apt-get install nagios-nrpe-server nagios-plugins

    The NRPE configuration is stored in /etc/nagios/nrpe.cfg, while the plugins are installed in


      [Read more...]
    What a Hosting Provider did Today
    +0 Vote Up -0Vote Down
    I found Dennis the Menace, he now has a job as system administrator for a hosting company. Scenario: client has a problem with a server becoming unavailable (cause unknown) and has it restarted. MySQL had some page corruption in the InnoDB tablespace. The hosting provider, being really helpful, goes in as root and first deletes ib_logfile* then ib* in /var/lib/mysql. He later says “I am sorry if I deleted it. I thought I deleted the log only. Sorry again.”  Now this may appear nice, but people who know what they’re doing with MySQL will realise that deleting the iblogfiles actually destroys data also. MySQL of course screams loudly that while it has FRM files it can’t find the tables. No kidding! Then, while he’s been told to not touch anything any more, and I’m trying to see if I can recover the deleted files on ext3 filesystem (yes there are tools  [Read more...]
    Multi-tenancy Drizzle
    +5 Vote Up -0Vote Down

    My previous post focused on some of the problems of doing multi-tenant MySQL.

    One of the reasons why I started hacking on Drizzle was that the multi-tenancy options for MySQL just weren’t very good (this is also the reason why I run my blog in a VM and not a shared hosting solution).

    What you really want is to be able to give your users access to a virtual database server. What you don’t want is to be administering a separate database server for each of your users. What you want are CATALOGs.

    A CATALOG is a collection of SCHEMAs (which have TABLEs in them). Each CATALOG is isolated from all the others. Once you connect to a catalog, that’s it. They are entirely separate units. There are no cross-catalog queries or CHANGE CATALOG commands. It is as

      [Read more...]
    How to test your WordPress Cache
    +0 Vote Up -0Vote Down

    How I lost 30 pounds in 2010 – a weight loss guide for developers

    Posted on December 30th, 2010 in blog, personal, zippykid.

    2010 was a great year for me, I started a new company, and it’s been profitable since month 2, I closed my consulting company, and most importantly, I lost 30 pounds, and am more mobile/agile than I was in college. I’m 32 and I feel better than I did when I was 24. I’ve talked [...]

    View  [Read more...]
    Speed Up Your Wedding Photography Website in less than 5 minutes.
    +0 Vote Up -0Vote Down

    If you have a wedding photography website, more than likely you want to showcase your work, or the work of your colleagues. You want to do this, without putting up low quality pictures, nor do you want to make your visitors wait 20 seconds before the page loads. Here are two plugins I use for my clients to help with this.

    • The Smush.it plugin. This plugin compresses your image using the Smush.it API from Yahoo!, I’ve used it to reduce a page size from 3MB to 1.3MB, which meant that visitors were able to see the site faster, and appreciate the photographs rather than their internet connection.
    • W3 Total Cache : This is a fairly advanced plugin that makes your site use MySQL less, and also helps you off load things onto a content delivery
      [Read more...]
    MySQL Ruby Gem CentOS RHEL 5 Installation Error Troubleshooting
    +1 Vote Up -0Vote Down

    Building and installing the Ruby mysql gem on freshly-installed Red Hat based systems sometimes produces the frustratingly ambiguous error below:

    # gem install mysql
    /usr/bin/ruby extconf.rb
    checking for mysql_ssl_set()... no
    checking for rb_str_set_len()... no
    checking for rb_thread_start_timer()... no
    checking for mysql.h... no
    checking for mysql/mysql.h... no
    *** extconf.rb failed ***
    Could not create Makefile due to some reason, probably lack of
    necessary libraries and/or headers.  Check the mkmf.log file for more
    details.  You may need configuration options.
    

    Searching the web for info on this error yields two basic solutions:

  • Install the mysql-devel package (this provides the mysql.h file in /usr/include/mysql/).
  • Run gem install
  •   [Read more...]
    Some friendly advice for bootstrapping your OSS project
    Employee +4 Vote Up -0Vote Down

    So you're a small startup company, ready to go live with your product, which you intend to distribute under an Open Source License. Congratulations, you made a wise decision! Your developers have been hacking away frantically, getting the code in good shape for the initial launch. Now it's time to look into what else needs to be built and setup, so you're ready to welcome the first members of your new community and to ensure they are coming back!

    Keep the following saying in mind, which especially holds true in the Open Source world: "You never get a second chance to make a first impression!". While the most important thing is of course to have a compelling and useful product, this blog post is an attempt to highlight some other aspects about community building and providing

      [Read more...]
    Decommissioning old servers, saving money…
    +0 Vote Up -0Vote Down

    Of course it’s not quite that simple. I’ve just decomissioned an old Red Hat 7.1 box (hosted dedicated server) that had been in service since 2002, so about 7 years. Specs? Celeron 1.3GHz, 512M, 60GB HD. Not too bad in the RAM and disk realm. It did a good job but goodness am I glad to be rid of it!

    Not having that box online is safer for the planet, although it (perhaps amazingly considering the age of some of the externally facing software components) has never been compromised – I consider that mostly luck, by the way, I’m not naive about that. But it’s not easy to move off old servers, it’s generally (and also has been in this case) a lot of work.

    Of course hosting has moved on since 2002, places like Linode offer more for less money/month. Of course they virtualise (Xen based in this case) and

      [Read more...]
    1,000 additional free servers
    +0 Vote Up -0Vote Down
    The success of the "Your server for free this summer!" operation is such that we have decided to have another promotion, which will be an extension of the previous one.

    The first 1,000 free servers were given out in less than one week! Given the number of requests that we have received, we have even opened 102 accounts in addition to what was planned. Only here is the problem: there are many of you on the waiting list and at Gandi, and we want to be able to please as many as possible

    The new promotion will therefore begin today. We are once more offering 1,000 free servers though this time, for only one month. The promotion remains, of course, without any purchase necessary, and you are free to keep your server by adding hosting



      [Read more...]
    Your server for free this summer!
    +0 Vote Up -0Vote Down
    Summer has come and this has put us in the mood to make you happy...

    So in this summer spirit, here are some things that we have come up with to please you:
    • Have you not yet tried our cloud hosting service? If not to help you make your change, we are going to give you a free server this summer! Yes, from now until August 31st (and by request from this form) you can have a totally free server (equal to one free share). And like any Gandi hosting share, you can expand the power/performance instantly with no downtime by adding additional shares at your convenience
    • Are you already a Gandi Hosting customer? If you feel like it is terribly unfair that you cannot benefit from this promo and are


      [Read more...]
    Your opinion on EC2 and other cloud/hosting options
    +0 Vote Up -0Vote Down

    EC2 is nifty, but it doesn’t appear suitable for all needs, and that’s what this post is about.

    For instance, a machine can just “disappear”. You can set things up to automatically start a new instance to replace it, but if you just committed a transaction it’s likely to be lost: MySQL replication is asynchronous, EBS which is slower if you commit your transactions on it, or EBS snapshots which are only periodic (you’d have to add foo on the application end). This adds complexity, and thus the question arises whether EC2 is the best solution for systems where this is a concern.

    When pondering this, there are two important factors to consider: a database server needs cores, RAM and reasonably low-latency disk access, and application servers should be near their database server. This means you shouldn’t split app and db servers to

      [Read more...]
    How to turn your website into a "Web Infrastructure"
    +0 Vote Up -0Vote Down
    Many websites start with a single server solution, a box acting as a web server and database server all in one. Simply, easy, cheap. The problem comes when traffic gets too high (a victim of their own success!). Many customers want a bigger box, but the answer is actually changing your architecture from "web server" to "web infrastructure". You can duplicate web servers, use the DNS to load balance them and ramp up your capacity very fast and very far.

    For simplicity's sake, let's take a real example. As some of you already know, we support the Millenium association in their promotion of online video games.

    The increasing success of the website, millenium.org, made us re-design the architecture of the website so that it could handle the



      [Read more...]
    Debian 5 Lenny and Ubuntu 9.04
    +0 Vote Up -0Vote Down
    Ubuntu 9.04, which was released at the end of April, and Debian 5 (Lenny), have just been added to the list of new Linux distributions that you can use when you create your Gandi server. We have taken this time to deactivate the creation of new servers under Ubuntu 7.10, a distribution that is no longer officially supported by its developers.

    As a reminder, here is the list of available distributions at present:
    • Ubuntu 8.04
    • Ubuntu 9.04
    • Debian 4
    • Debian 5
    • OpenSuse 10.3
    • Fedora Core 8
    • Mandriva 2008.0
    • Mandriva 2008.1
    • CentOS 5
    Give your data room to grow!
    +0 Vote Up -0Vote Down
    We are pleased to announce the release of a new feature that you've been eagerly anticipating for some time now : the ability to increase the size of your disks!

    You will need to perform two steps to do this:
  • Change the volume of your disk,
  • Run the necessary update on the file system itself.

  • This operation is totally automated for servers running under Gandi AI,  though it's only possible to do this on data disks for the moment.

    For expert servers, only the volume change phase of the operation is done via our website. You will need to manually run the file system update on your own.

    Please remember that you will need to have enough quota available in your account to expand your disk to the desired size.

    You can view our prices at the following page:









      [Read more...]
    Server performance statistics!
    +0 Vote Up -0Vote Down
    The best way to see if your server is doing well and check that you have optimized its power it so have server statistics!

    We finally have some nice graphs that let you see your server's CPU usage, network traffic, and your disk's read-write usage. These graphs will give you precious information on how your server is used, and when various usage peaks or low-points occur, so that you can optimize your services.

    Below is an example of a server that is rather "active". You can see that the processor is only using on average 16% to 18% of its power (over a 24-hour period), with a peak at 40%. The server is running on 2 shares, and is therefore clearly too powerful for its current needs.

    The following example shows the contrary. This server is in serious need of





      [Read more...]
    Using Subversion with Mosso
    +0 Vote Up -0Vote Down

    Thanks to Expandrive . You can now use Subversion (SVN) on websites hosted at Mosso . The idea of mounting a directory you’d normally ftp/sftp to, and then using SVN on it, at first seemed oddly implausible to me. But, I tried it recently, and got exactly the results I wanted. I even had the repository hosted at Unfuddle . I think this post is fairly obvious, but if you have any questions feel free to ask in the comments.

    Site is (almost) back...
    Employee +0 Vote Up -0Vote Down

    Sorry for the downtime of this site - until around a week ago I hosted my home page on a trusty Genesi Pegasos II system (powered by a PowerPC G4 Processor clocked at 1GHz, using Debian 4.0 PPC with 512 MB of RAM), serving these pages from my home DSL connection. Unfortunately this system provided no means of redundancy - the hard disk drive died.

    Luckily I perform frequent backups, so I moved most parts of the site to a shared hosting space now - the picture gallery is unfortunately too big to fit into the space that I have there. I'll try to move the pictures into my Flickr account instead, but this will take some time.

    Note that the primary domain name of this site is now lenzg.net - lenzg.org, (the domain

      [Read more...]
    Project Kenai: looking at the technology behind it
    Employee +0 Vote Up -0Vote Down

    While Colin beat me in blogging about Project Kenai, I think I can still provide some additional background information about this new project hosting service from Sun.

    If you are a maintainer of an Open Source project, you currently have plenty of choice when it comes to getting your project hosted for free. One criterion could be your software configuration management system (SCM) of choice.

    Some of the hosting services that I am currently aware of and the choice of SCM they offer include:

      [Read more...]
    Project Kenai
    +0 Vote Up -0Vote Down

    Sun is a huge company. So it comes as no surprise that I’m finding out about Project Kenai via Tim Bray, instead of some internal mailing list (believe me, there must be thousands).

    Tim’s got a Q&A with Nick Sieger, who’s one of the chieftains behind Kenai. I find it amusing that the comparison is made against Google Code and GitHub - has SourceForge hit irrelevancy? I’m surprised Launchpad isn’t mentioned.


    Very Cover Flow like UI, with slider, etc. That’s Elliot Murphy, ex-Dolphin, current Ubuntero in the pic

      [Read more...]
    ... Valves in GlassFish, OpenMQ and Mule ESB, Free Hosting and CrazyRails
    Employee_Team +0 Vote Up -0Vote Down

    The vast majority of Tomcat applications ran fin on GlassFish. Jan tell us that now even the ones using the Tomcat-style valves will run unmodified.

    Of at The ServerSide Pawan explains How to use OpenMQ with Mule ESB by configuring the Mule JMS connector. Added (by pelegri) - I've heard of a number of requests for this, please let us know if you use the combination so we can track OpenMQ

      [Read more...]
    I moved this blog to pairLite with zero downtime, and it was easy
    +0 Vote Up -0Vote Down

    Did you notice that I moved this blog from pair Networks to pairLite hosting?

    Probably not, unless you check the DNS of xaprb.com regularly!

    Don’t you hate it when people say “I’m moving my blog, I hope there won’t be more than a few days of downtime, blah blah…” Why is this ever necessary, I wonder? I wonder the same thing about a lot of hosting providers — recently I had a client in my consulting practice whose (very large, well-known) hosting provider tried to help them with some very simple MySQL work and ended up causing them an obscene amount of downtime, like many many days, and there was no end in sight. As I spoke on the phone with him and asked him about his

      [Read more...]
    Showing entries 1 to 23

    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.