Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 142 10 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
    +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

    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

    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

    Showing entries 1 to 10 of 142 10 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.