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 30 of 142 Next 30 Older Entries

Displaying posts with tag: drupal (reset)

Drupal and MySQL Performance: Register now for Nov. 13 webinar
+0 Vote Up -0Vote Down

Drupal is one of the most popular open source CMS applications available – and it runs primarily on a MySQL backend.  Out of the box, the schema is well tuned and indexed.  However, there are some ways to tweak the default installation to get more out of the system right from start.  Similarly, there is a fair bit of hidden flexibility (especially in the latest version) in terms of database configuration.

In a free MySQL webinar on Wednesday, November 13th at 1pm EST, I’ll go over some of the improvements in Drupal 7 in terms of database connectivity and operation as well as profile the default installation

  [Read more...]
Percona celebrates its 7th anniversary by giving to open source ecosystem
+3 Vote Up -0Vote Down

Today we’re celebrating Percona’s 7th anniversary.  A lot has changed in these past 7 years – we have grown from a two-person outfit focused exclusively on consulting to a 100-person company with teammates in 22 different countries and 18 different states, now providing Support, Consulting, RemoteDBA, Server Development and

  [Read more...]
High Availability for Drupal Part 2 - The Contenders
+0 Vote Up -0Vote Down

When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for part or all of the solution is growing and can be daunting. We'll take a look at the various parts of a solution and what options we have.

Go Cloud?

It seems nearly every answer to every problem in IT these days is "The Cloud", but is it?

read more

High Availability for Drupal Part 2 - The Contenders
+0 Vote Up -0Vote Down

When looking at high availability for any CMS, and particularly for Drupal, the list of contenders for part or all of the solution is growing and can be daunting. We'll take a look at the various parts of a solution and what options we have.

Go Cloud?

It seems nearly every answer to every problem in IT these days is "The Cloud", but is it?

read more

Trip Report: DrupalCon Portland 2013
+0 Vote Up -0Vote Down

I have never been to a DrupalCon before so my first was DrupalCon Portland 2013 (with some 3,500+ attendees). My first DrupalCon happened to also be one that I spoke at, and I hope to return to Austin in 2014 (added bonus: I’ve never been to Texas before).

SkySQL had decided to get a booth at DrupalCon since I was speaking and I have to say that the booth was very successful. You may ask why and the simple reasons are:

  • Everyone at DrupalCon was a user of MySQL. Once they hit scale, they may need professional services or even just switch to MariaDB. This is a captive audience.
  • Everyone running Drupal at scale with many modules and nodes generally faced issues with database slowdowns. Hello
  •   [Read more...]
    High Availability for Drupal Part 1 - Investigating the Issues
    +2 Vote Up -0Vote Down

    Drupal is one of the most popular Content Management Systems (CMS) and is used increasingly in high-visibility sites, such as www.whitehouse.gov. This has brought a lot of attention on how to get the most performance out of Drupal and how to improve the availability of such sites. In this blog series I'll take you through the basics and on through to designing your own HA Drupal site.

    But first, we need to understand what the challenges are in getting Drupal (or indeed any CMS) working on multiple servers in such a way as to ensure high availability and performance.

    read more

    High Availability for Drupal Part 1 - Investigating the Issues
    +0 Vote Up -0Vote Down

    Drupal is one of the most popular Content Management Systems (CMS) and is used increasingly in high-visibility sites, such as www.whitehouse.gov. This has brought a lot of attention on how to get the most performance out of Drupal and how to improve the availability of such sites. In this blog series I'll take you through the basics and on through to designing your own HA Drupal site.

    But first, we need to understand what the challenges are in getting Drupal (or indeed any CMS) working on multiple servers in such a way as to ensure high availability and performance.

    read more

    Keeping your Drupal from Drooping — part 2
    Employee +1 Vote Up -0Vote Down

    So let’s clone our current Drupal 7.22 site from MySQL 5.1 that came with CentOS 6.4 and get it running on MySQL 5.6.

    Upgrading MySQL 5.1 -> 5.6 has an official recommendation of making sure the intermediate 5.5 update is performed too. Please review Section 2.11.1 while you make a backup of all your data. Yes, you do have to make a backup. When you run the upgrade, there are tables in the mysql scehma that will be tweaked and skipping a step can make for a very messy late night in an attempt to recover.

    An other thing to look for is that on occasion new reserved words are introduced that may conflict with column names in use in your schemas. So it pays to read through the release notes for new reserved words and then run a

      [Read more...]
    Keeping your Drupal from Drooping — part 1
    Employee +2 Vote Up -0Vote Down

    This is the first screen after a sucessful Drupal 7.22 install.

    Drupal is a content management system that runs at least 2.1% of all websites(1). It is easy to use, extensable with over 20,000 add-ons, and runs beautifully with a LAMP stack.

    At the heart of most Drupal sites is a MySQL database with, as of Version 7.22, 76 tables. Recently I was asked what needs to be done to a ‘generic’ Drupal to get it running on MySQL 5.6. It is a very easy update that provides better performance, security, and allows access to the newest MySQL 5.6 updates.

    For this example, the generic box is a two CPU Dell x86_64 box running Centos 6.4. This is fairly typical of what a

      [Read more...]
    Scaling Drupal on Multiple Servers with Galera Cluster for MySQL
    +0 Vote Up -0Vote Down
    April 26, 2013 By Severalnines

    This post shows you how to move from a single instance Drupal/MySQL to a multi-server environment. A well designed multi-server deployment not only allows Drupal to scale, but will also enhance redundancy by removing single points of failure. Components used are Apache, PHP, csync2, lsyncd, Keepalived, HAproxy, MySQL Galera Cluster and ClusterControl.

    read more

    Open Source Certification , Friend or Foe
    +0 Vote Up -1Vote Down

    With 2 of the bigger Open Source projects I care about talking about certifications programs questions pop up again ...

    Should we certify ourselves ?

    So let me tell you about my experiences in getting Open Source related Certifications ..

    Over a decade ago, (2001) when RedHat was still Redhat and not yet Fedora the company I was working for was about to partner with RedHat and needed to get a number of people certified for that.

    So I took the challenge, I bored myselve to death during a 4 day RedHat fast track training and set out to do the exam the next day. Obviosly I scored pretty well given my yearlong experience in the subject. Back then I was told that I scored the one but European Record on the exam which was actually held by another collegue (hey Ico) , our CTO however was not amused when I told that I could have scored better but I

      [Read more...]
    Devops in Munich
    +0 Vote Up -1Vote Down

    Devopsdays Mountainview sold out in a short 3 hours .. but there's other events that will breath devops this summer.
    DrupalCon in Munich will be one of them ..

    Some of you might have noticed that I`m cochairing the devops track for DrupalCon Munich,
    The CFP is open till the 11th of this month and we are still actively looking for speakers.

    We're trying to bridge the gap between drupal developers and the people that put their code to production, at scale.
    But also enhancing the knowledge of infrastructure components Drupal developers depend on.

    We're looking for talks both on culture (both success stories and failure) , automation,
    specifically looking for people talking about drupal deployments , eg using tools like Capistrano, Chef, Puppet,
    We want to hear where Continuous Integration fits in your deployment , do you do Continuous Delivery of a




      [Read more...]
    Site update with a welcome news
    +0 Vote Up -2Vote Down

    As I updated my website, migrating from Drupal to WordPress, a welcome news followed in the evening when Swansea beating Manchester City 1-0. The female assistant to the referee, Sian Massey, gladly judging Micah Richards for an offside. United had a rough time taking over WBA, but ensuring a relatively comfortable 2-0.

    New! Cloud-based MySQL Database Monitoring from Monitis
    +0 Vote Up -0Vote Down

    New feature provides significantly faster insight and root cause analysis

    SAN JOSE, Calif., February, 15, 2012Monitis, the leading cloud and web application monitoring software provider, today announces that it has added comprehensive MySQL database monitoring to its award-winning Application Performance Management & Monitoring platform. The robust Software-as-a-Service (SaaS) tool enables users to gain significantly faster insight when conducting root cause analysis.

    The MySQL monitoring feature includes 246 monitoring variables and more than 21 different metrics to provide one of the easiest to use, yet comprehensive database monitoring tools

      [Read more...]
    Adding dynamic fields to Signups on Drupal
    +0 Vote Up -0Vote Down

    In my day job at SkySQL I work with Drupal as our content management system.  One thing we often need to do is provide a way for people to sign up for events and the like.  One such event is the upcoming SkySQL and MariaDB: Solutions Day for the MySQL® Database and unlike other events we needed to take into account the dietary requirements of those wishing to attend.

    For events registration we use the Signup module and use a theme template function to provide a set of standard fields.  The code looks something like this:

    function ourtheme_signup_user_form($node) {
    $form = array();
    // If this function is providing any extra fields

      [Read more...]
    How to log all MySQL queries in Drupal
    +3 Vote Up -0Vote Down
    In order to benchmark a Drupal site performance you need to see all the database queries related to your Drupal site. In case you don’t have access to the my.cnf file If you don’t have access to the my.cnf file, you can log the queries from the Drupal code itself: cp includes/database.mysql-common.inc includes/database.mysql-common.inc.backup.orig vim includes/database.mysql-common.inc [...]
    Stop Disabling SELinux!
    +0 Vote Up -1Vote Down

    I see a lot of people coming by #centos and similar channels asking for help when they’re experiencing a problem with their Linux system. It amazes me how many people describe their problem, and then say something along the lines of, “and I disabled SELinux...”. Most of the time SELinux has nothing to do with the problem, and if SELinux is the cause of the problem, why would you throw out the extra security by disabling it completely rather than configuring it to work with your application?

    read more

    Open Query training at Drupal DownUnder 2012
    +0 Vote Up -0Vote Down
    DrupalDownUnder 2012 will be held in Melbourne Australia 13-15 January. A great event, I’ve been to several of its predecessors. People there don’t care an awful lot for databases, but they do realise that sometimes it’s important to either learn more about it or talk to someone specialised in that field. And when discussing general infrastructure, resilience is quite relevant. Clients want a site to remain up, but keep costs low. I will teach pre-conference training sessions on the Friday at DDU:   [Read more...]
    Integrating Aegir with Linux and FTP
    +0 Vote Up -0Vote Down

    Due to the insane cost of bandwidth (compared to the rest of the developed world) in Australia, I've recently decided to move some of our hosting clients to Linode. This means they can move more data more cheaply and I don't need to come up with (and administer) a bandwidth accounting system for my Australian based web VM.

    We pretty much exclusively use Drupal for hosting clients, so to make management a bit easier I decided to use Ægir on the new Linode. Installation was a relative breeze, after a quick google to find out how to specify that I didn't want to use Apache and wanted to use a separate server as dedicated MySQL host.

    The problem (there is always a problem) arose when I needed to give a hosting client access to their Drupal installation, so they could

      [Read more...]
    Slides from DrupalDownUnder2011 on Tuning for Drupal
    +0 Vote Up -0Vote Down
    By popular request, here’s the PDF of the slides of this talk as presented in January 2011 in brisbane; it’s fairly self-explanatory. Note that it’s not really extensive “tuning”, it just fixes up a few things that are usually “wrong” in default installs, creating a more sane baseline. If you want to get to optimal correctness and more performance, other things do need to be done as well.
    Footnotes for Drupal 7 released, announcing handover to new maintainer
    +1 Vote Up -1Vote Down

    I finally did the migration to Drupal 7 for the Footnotes module this weekend. See Release notes and project page for more information.

    With this release I also announced my intent to hand over the module to a new maintainer. Since I'm now increasingly active with affairs in the MySQL community, both hacking as well as other community tasks, it is prudent to not let old projects dangle without attention but to formally hand them over to fresh minds.

    read more

    Updated Drupal 7 appliances to version 7.0 final
    Employee +4 Vote Up -0Vote Down

    Congratulations to the Drupal community for getting version 7.0 released! This is a major mile stone and an excellent reason to celebrate!

    If you want to give Drupal 7 a try without having to install anything, I've now updated my Drupal 7 appliances on SuSE Studio to the latest release. The appliance is based on openSUSE Linux 11.3 and is available in two variants:

    • A text-mode only appliance to which you connect using your local web browser via the network.
    • A GUI version that starts

      [Read more...]
    Migrating users and content profiles
    +0 Vote Up -0Vote Down

    For some time now I've been working on a Drupal site that consists mainly of scraped content from a proprietary, ASP based CMS from the late nineties. The Simple HTML Dom Parser, used from within a drush script, has been invaluable. It made scraping the old site content and importing it as Drupal nodes a relative breeze. (No access to the database used by the CMS, boo!)

    Part of setting up the new site is importing users and their content profile nodes from a different Drupal site, that was setup a year or two ago to manage an event.

    I had hoped there would be a way for me to export these users and their profile nodes from one Drupal to the other, but though I found modules to export one or the other, I might still end up with profile nodes that

      [Read more...]
    Leaving MariaDB/Monty Program
    +5 Vote Up -0Vote Down

    Last week I announced internally that after my paternity leave ends next year, I will not be returning to Monty Program.

    When I joined the company over a year ago I was immediately involved in drafting a project plan for the Open Database Alliance and its relation to MariaDB. We wanted to imitate the model of the Linux Foundation and Linux project, where the MariaDB project would be hosted by a non-profit organization where multiple vendors would collaborate and contribute. We wanted MariaDB to be a true community project, like most successful open source projects are - such as all other parts of the LAMP stack.

    read more

    Call for Papers: "MySQL and Friends" Developer Room at FOSDEM 2011 (Feb. 5th, Brussels, BE)
    Employee +3 Vote Up -0Vote Down

    It's that time of the year again — the nice folks at FOSDEM have granted us a developer room at their upcoming conference (February 5+6 2011 in Brussels, Belgium)!

    As usual there were more applications than they were able to accommodate, so we are very grateful for this opportunity for collaboration. Titled "MySQL and Friends", our room next year will be H.2213 with a capacity of 100 seats. It will be at our disposal on Saturday 5th, from 13:00 till 19:00. Like last year, we would like to set up a schedule of talks related to the MySQL server and the various

      [Read more...]
    LAMP stack Halloween cake
    +3 Vote Up -0Vote Down
    Topic: DrupalMySQLAcquia

    Barry Jaspan and his wife Heather spent 20 hours creating this incredible cake for Acquia's Halloween party. Creative duo! Not only did it look great, it was yummy. Trick or treat!

    Drupal 7 test drive appliance updated to 7.0-beta2, now with GUI option
    Employee +2 Vote Up -0Vote Down

    Over the weekend I updated my Drupal 7 test appliance in SUSE Studio to the Drupal 7.0-beta2 release, which was released on Oct. 23rd. I also added phpMyAdmin upon a user request, to provide a web-based method to work with the MySQL instance, if needed.

    In addition to the lightweight "headless" appliance (which can only be accessed and configured via a remote network connection), I've now also created a

      [Read more...]
    Testing Drupal 7 on a virtual appliance with MySQL 5.1 and the InnoDB plugin
    Employee +4 Vote Up -0Vote Down

    The Drupal community just recently released another alpha test release of their upcoming Drupal 7 version, to shake out the remaining bugs and to encourage more users to test it.

    If you would like to give it a try, but you don't have a free server handy, how about using a virtual machine instead? Using the fabolous SuSE Studio, I've created an appliance based on openSUSE 11.3, Drupal 7.0-alpha7 and MySQL 5.1 with the

      [Read more...]
    MariaDB going places: Drupal, Zend Framework
    +7 Vote Up -1Vote Down

    MariaDB just released MariaDB 5.1.50. Linux, Solaris and Windows (32-bit) are supported. Go give it a twirl.

    Its also worth noting that today when you go install Drupal, and check out the documentation for requirements, you’ll see that MariaDB is now a recommended option.

    Via the new news page at Monty Program’s newly designed website, I also found out that MariaDB is now recommended in the documentation for the next release of the Zend Framework. See the

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

    The future of open source licensing. OpenSolaris governing board quits. And more.

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

    # Glyn Moody asked which open source software licensing is best for the future?

    # The OpenSolaris Governing Board has collectively and expectedly resigned.

    # OpenBravo has updated its rapid implementation ERP offering for small and mid-sized businesses, Openbravo QuickStart.

    # Red Hat has


      [Read more...]
    Showing entries 1 to 30 of 142 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.