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 41 to 70 of 32938 Next 30 Older Entries
Getting my hands dirty on an OpenStack lab
+1 Vote Up -0Vote Down

Like you all may know, OpenStack is currently one of the coolest open source projects, so I was thrilled when I was asked to manage the deployment of an OpenStack lab for internal Percona use. Starting from basically zero, I created tasks in our Jira and assigned them to a pool of volunteer consultants. As usual in a service company, billing is the priority so I ended up losing the 2 senior guys but fortunately most of my time was with a customer that wasn’t very demanding and I could easily multitask with the project and fill the gap. So, here it goes…

Hardware

To deploy the OpenStack lab we were given 8 similar servers in our Durham, N.C. offices. The specs

  [Read more...]
How to Install ClusterControl on Servers without Internet Access
+0 Vote Up -0Vote Down
August 18, 2014 By Severalnines

There are several ways to get ClusterControl installed on your database infrastructure, as described in the ClusterControl Quick Start Guide. One simple way is to use an installation script, install-cc.sh. This script automates the whole process, and is executed on the host where you want to install ClusterControl. By default, it assumes the host has internet connectivity during the installation process.

 

For users who are not able to have their

  [Read more...]
Enabling GTIDs for server replication in MariaDB 10.0
+0 Vote Up -0Vote Down
Mon, 2014-08-18 08:55gerrynarvaja

Replication has been one of the most popular MySQL features since it made its way into the application more than a decade ago. However, as replication implementations became more complex over time, some limitations of MySQL’s original replication mechanisms started to surface. To address those limitations, MySQL v5.6 introduced the concept of Global Transaction IDs, which enable some new, advanced replication features. MySQL DBAs were happy with this, but complained that in order to implement GTIDs you needed to stop all the servers in the replication group and restart them with the feature enabled. There are workarounds – for instance, Booking.com

  [Read more...]
Items Affecting Performance of the MySQL Database
Employee_Team +1 Vote Up -0Vote Down

To learn about the many factors that can affect the performance of the MySQL Database, take the MySQL Performance Tuning course.

You will learn:

  • How your hardware and operating system can affect performance
  • How to set up and logging to improve performance
  • Best practices for backup and recovery
  • And much more

You can take this 4-day instructor-led course through the following formats:

  • Training-on-Demand: Start training within 24 hours of registering for training, following lectures at your own pace through streaming video and booking time on a lab environment to suit your schedule.
  • Live-Virtual Event: Attend a live
  [Read more...]
Take image from corrupted hard drive
+0 Vote Up -0Vote Down

There are at least two cases when it makes sense to take an image from a corrupted hard drive as soon as possible: disk hardware errors and corrupted filesystem. Faulty hard drives can give just one chance to read a block, so there is no time for experiments. The similar picture with corrupted filesystems. Obviously something went wrong, it’s hard to predict how the operating system will behave next second and whether it will cause even more damage.

Save disk image to local storage

Probably the best and fastest way is to plug the faulty disk into a healthy server and save the disk image locally:

# dd if=/dev/sdb of=/path/on/sda/faulty_disk.img  conv=noerrror

Where /dev/sdb is the faulty disk and faulty_disk.img is the image on

  [Read more...]
The new cloud backup option of MySQL Enterprise Backup
+1 Vote Up -0Vote Down
MySQL Enterprise Backup 3.10 support backups to the cloud. The only supported cloud service is Amazon S3.

When the cloud destination is used mysqlbackup will upload the backup as an image file.

You can specify all options on the commandline:
mysqlbackup --cloud-service=s3 --cloud-aws-region=eu-west-1 \
--cloud-access-key-id=AKIAJLGCPXEGVHCQD27B \
--cloud-secret-access-key=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 \
--cloud-bucket=meb_myserver --cloud-object-key=firstbackup --cloud-trace=0 \
--backup-dir=/tmp/firstbackup --backup-image=- --with-timestamp backup-to-image

But you can also put the settings in the my.cnf
[mysqlbackup_cloud]
cloud-service=s3
cloud-aws-region=eu-west-1
cloud-access-key-id=AKIAJLGCPXEGVHCQD27B










  [Read more...]
libAttachSQL 0.2.0 alpha released!
+0 Vote Up -0Vote Down
Hot on the heals of last week's release we have released version 0.2.0 alpha of libAttachSQL.  For those who have missed my previous blog posts, libAttachSQL is a lightweight C connector for MySQL servers I'm creating with HP's Advanced Technology Group.  It has an Apache 2 license so is good for linking with most Open Source licenses as well as commercial software projects.

Changes in this release:

  • Added support for query result buffering
  • Passive connect on first query is now asynchronous
  • Improved memory handling
  • Many documentation changes, including API examples
  • Many other smaller fixes
For more information see the libAttachSQL



  [Read more...]
Refreshing imported MySQL data with MySQL for Excel
Employee +1 Vote Up -0Vote Down

Welcome to another blogpost from the MySQL for Excel Team. This time we're going to talk about a new feature included since MySQL for Excel 1.3.0, now we maintain the link between imported Excel tables and its data source. Now, with this new feature we'll show you how easy is to work with the latest available information at all times.

We would like to remind you, our latest GA or maintenance version can be installed using the MySQL Installer or optionally you can download directly any GA or non-GA version from the MySQL Developer



  [Read more...]
MySQL Performance: Analyzing LinkBench Workload on MySQL 5.7 and MariaDB 10.1
Employee +5 Vote Up -1Vote Down

Reading the article published on MariaDB site about performance evaluation of MySQL 5.7 -vs- MariaDB 10.1 I've got a double feeling: from one side I have no any reason to have a doubt in obtained results, and from another side - my feeling says me there is something going odd.. But well, I don't have any attention to blame anybody (and sorry if you think so) -- my willing here is only to understand what is going on, why, and what are the challenges on the observed test workload(s). I'll cover here only my observations on the LinkBench workload as it was not yet enough tested and involving many questions around..

LinkBench Benchmark :

  • developed by Facebook Team, so represents a true real life workload


  [Read more...]
How To: Using SimpleMembserhipProvider with MySql Connector/Net.
Employee +1 Vote Up -0Vote Down
How to configure SimpleMembership with MySql is explained in this post, as well as how to use OAuth with external providers to access an application providing external credentials.
Script to manage MaxScale
+0 Vote Up -0Vote Down
Fri, 2014-08-15 11:00anderskarlsson

MaxScale 1.0 from SkySQL is now in Beta and there are some cool features in it, I guess some adventurous people has already put it into production. There are still some rough edges and stuff to be fixed, but it is clearly close to GA. One thing missing though are something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.

I have developed two simple scripts that should help you manage MaxScale in a reasonable way, but before we go into the actual scripts, there are a few things I need to tell you. To begin with, if you haven't yet downloaded MaxScale 1.0 beta, you can get it from MariaDB.com, just go to Resources->MaxScale and to get to the downloads you first need to register (which is free). Here are downloads to rpms and source, but if you are currently looking

  [Read more...]
We’re Hiring! And Looking to Add More 9s to the Severalnines Team!
+1 Vote Up -0Vote Down
August 15, 2014 By Severalnines

 

 

We're looking for an energetic and talented web developer to join our small but agile web team. This position is full-time and pay is negotiable. The hours are flexible and work can be done remotely.

 

Severalnines is a self-funded startup with a dozen employees; headquartered in Stockholm, Sweden and with a globally distributed, home-office based team. We provide automation and

  [Read more...]
Make a difference! See the world! Speak at Percona Live London; Santa Clara!
+0 Vote Up -0Vote Down

Twice each year members of the global open-source community converge on London in November and Santa Clara in April to network with, and learn from, some of the world’s most experienced and accomplished system architects, developers and DBAs.

And now it’s time for YOU to give back to this diverse and growing MySQL community. The Call for Speakers for Percona Live London (Nov. 3-4) closes Aug. 17 and the deadline for submitting talks for the ever-growing Percona Live MySQL Conference and Expo (April 13-16, 2015) expires Nov. 9.

If you like putting things off until the last minute, then it’s time

  [Read more...]
The Road to MySQL 5.6 -- A DBA Perspective
+4 Vote Up -0Vote Down
We've all heard the hype.  MySQL 5.6 is packed with amazing new features that address all our database problems.  5.6 deals with replication and HA and performance and monitoring and security and features.  It just may cure cancer.

In fact it's been out for ages.  It went GA 

  [Read more...]
Containing your MySQL Instances
Employee +1 Vote Up -0Vote Down

Virtual servers for MySQL are popular but are they the answer? Should we be containing our instances instead. An Updated Performance Comparison of
Virtual Machines and Linux Containers
is an interesting study of using containers over VMs by four brilliant folk from IBM Research in Austin. There are several benefits to containers that are detailed in the study.

So what is wrong with VMs? IBM has been using them since the 1970s. Well, VMs have a static number of virtual CPUs (vCPU) and a fixed amount of RAM that bound performance. And each vCPU can only use up to one real CPUs of clock cycles. Since each VM is a Linux process, resource management like the scheduler come into play.

Containers? They are built on the kernel


  [Read more...]
SET GLOBAL sql_log_bin - We need your feedback!
Employee +2 Vote Up -0Vote Down

Jeremy Cole recently blogged about the feature SET GLOBAL sql_log_bin. In his blog post, Jeremy suggested that there is no strong use-case for this feature, and that it is too easy to run accidentally (i.e. SET GLOBAL instead of SET [SESSION]). The result of this incorrect usage is that slaves will drift out of sync from masters.

We discussed Jeremy's request in the MySQL team, and we agree that the syntax should produce an error in MySQL 5.7. However, we have not yet determined which steps should be taken for MySQL 5.5 and MySQL 5.6. The two proposals we would like to float are:

  • The statement SET GLOBAL sql_log_bin=N produces a warning.
  • The statement SET GLOBAL sql_log_bin=N produces an error.
  •   [Read more...]
    Script to manage MaxScale
    +1 Vote Up -0Vote Down
    MaxScale 1.0 from SkySQL is now in Beta and there are some cool features in it, I guess some adventurous people has already put it into production. There are still some rough edges and stuff to be fixed, but it is clearly close to GA. One thing missing though are something to manage starting and stopping MaxScale in a somewhat controlled way, which is what this blog is all about.

    I have developed two simple scripts that should help you manage MaxScale in a reasonable way, but before we go into the actual scripts, there are a few things I need to tell you. To begin with, if you haven't yet downloaded MaxScale 1.0 beta, you can get it from MariaDB.com, just go to Resources->MaxScale and to get to the downloads you first need to register (which is free). Here are downloads to

      [Read more...]
    PHP 5.3 - Thanks for all the Fish
    Employee +1 Vote Up -0Vote Down

    A few moments ago I pushed the buttons and PHP 5.3.29 came out. As this is the final release for 5.3 it is a good time to look back. PHP 5.3's history starts somewhere in 2005. We knew what a pressure point of PHP was - a language made for solving The Web Problem needs a good Unicode story. So some developers went deep into that complex area and created a prototype version of PHP with Unicode support from deep within the engine. As this was a big and pressing issue and the need was obvious and the solution looked promising it was quickly areed on making that the base for a future PHP 6. And then time passed, initial enthusiasm passed and the sheer amount of work became obvious. Two years in we noticed that the ongoing PHP 6 work blocked other work - new features couldn't be added to 5.2, the current version at

      [Read more...]
    MySQL 5.6.20 Community Release Notes
    Employee +5 Vote Up -0Vote Down

    Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.20.

    In particular:

    • Thank you to Jeremy Cole for reporting a case where InnoDB's redo log could become corrupt with externally stored blobs. Jeremy also provided a testcase to demonstrate the problem. Bug #69477.
    • Thank you to Ronald Bradford for identifying that MySQL would continue to operate even though the binary log could not be written. Our team picked up Ronald's blog post, and filed a bug in response. Bug #51014.
    • Thank you to Daniël van Eeden, Andrew Garner, Detlef Ulherr and Bjoern
      [Read more...]
    The InnoDB Team is looking for your feedback!
    Employee +3 Vote Up -0Vote Down

    Restarting production database servers with gigabytes of memory is difficult. It can lead to cold caches and other operational complexities.

    The InnoDB team is looking to make improvements so that restarting MySQL is required as little as possible. Please help them out by answering which configuration settings you are most eager to see made dynamic.

    Thanks!

    Which SQL queries take all the time? Using MaxScale to answer that age old question.
    +0 Vote Up -0Vote Down
    Thu, 2014-08-14 10:49mriddoch

    Here we take a look at how one of the example filters supplied with the MaxScale 1.0 beta can answer that simplest of profiling questions - "Which of my database queries run within the MySQL server for the longest time?".

    Why A MaxScale Filter?

    MaxScale filters, although they can be thought of as simply a way to modify the SQL requests that pass through MaxScale, are also a good place to insert logging or monitoring. They have the advantage that that receive not just the SQL statements that are sent to the server, but they may also receive the returned results. This means that MaxScale can not just log the query information, but it can also record timestamps related to when it observes different parts of the request or response. As a way to demonstrate this a very simple example filter was constructed

      [Read more...]
    Please, Take a Seat - but Which One?
    +0 Vote Up -0Vote Down

    We recently researched furniture for our office transition and, in doing so, encountered a surprising number of seating options. Long gone are the days where every office chair is uniform; they have evolved to fit the needs of almost any seating preference. Here are the five we found most relevant to our search:

    Office Chairs

    These are the most common because they are practical and affordable. They adjust, swivel and roll, making them a versatile option for the workplace. If you want to upgrade, you can get ergonomic or mesh chairs - or ergonomic mesh chairs. Ergonomic chairs boast superior back support and maximum comfort, and mesh chairs provide relief to the generally over-heated through their porous material.

    Guest Chairs

    As the name implies,

      [Read more...]
    SBR vs RBR when using On Duplicate Key Update for High Availability
    +1 Vote Up -0Vote Down
    The other day, I was discussing high availability (HA) with other people.  The discussion was going in the direction of, as the application was only using INSERT ... ON DUPLICATE KEY UPDATE (ODKU) and traffic could be replayed, promoting a slave in case of the failure of the master was easy: replaying traffic would make all the slaves converge back to a common state.  It looks as this could work but it might not be as simple.  Before going into the details, let's take a step back and look into HA in general.

    tl;dr: be careful when using row-based replication when replicating ODKU as slaves will stop replicating if a row is present on the master and missing on slave (or vice-versa).

    High Availability by Promoting a Slave as



      [Read more...]

    New Webinar: Performance Tuning of HAProxy for Database Load Balancing
    +1 Vote Up -0Vote Down
    August 13, 2014 By Severalnines

     

    New Webinar: Performance Tuning of HAProxy for Database Load Balancing

    As a follow-up to our previous webinar on MySQL Load Balancing and HAProxy, we are glad to organize a new webinar on Performance Tuning of HAProxy. Tuning your HAProxy instances can significantly increase the performance of your application and decrease response times. Joint us for this special session to find out more!   [Read more...]
    libssl.so.6: cannot open shared object file with Debian/CentOS
    +0 Vote Up -0Vote Down
    Actually, I found this error many times, while installing MySQL/Percona servers with MySQL Sandbox. To resolve this issue, first, you have to make sure that, SSL is installed /update properly. sudo apt-get update sudo apt-get install libssl1.0.0 libssl-dev After installing Continue reading →   [Read more...]
    What InnoDB specific options are you most eager to see made dynamic?
    +0 Vote Up -0Vote Down
    What InnoDB specific options are you most eager to see made dynamic?
    +0 Vote Up -0Vote Down
    Putting Virtual Columns to good use
    +1 Vote Up -0Vote Down
    Tue, 2014-08-12 19:25anderskarlsson

    We all know that in general it's a bad idea to have columns values contain too much "hidden" information, and in particular for primary keys, this is a big no-no, although I know that not everybody agrees here. In some cases though, there is data that at it's heart contains several aspects and we just cannot avoid this, the prime example being data and time values. What I mean here is that a single datetime value has aspects that aren't always obvious from the datetime value itself. Examples include leap year information and weekday. Sometimes datetime value also contain the timezone, in which case you might want to ask if this is the timezone of the server or the client.

    Can you make a datetime unique? Let's assume you know that every row that contains a datetime value are at least 5 ms apart, from which you can determine that if the datetime is

      [Read more...]
    MariaDB 10.0.13 Overview and Highlights
    +0 Vote Up -0Vote Down

    MariaDB 10.0.13 was recently released, and is available for download here:

    https://downloads.mariadb.org/mariadb/10.0.13/

    This is the fourth GA release of MariaDB 10.0, and 14th overall release of MariaDB 10.0.

    This is primarily a bug-fix release.

    Here are the main items of note:

  • InnoDB upgraded to 5.6.19.
  • XtraDB upgraded to
  •   [Read more...]
    Clustering Moodle on Multiple Servers for High Availability and Scalability
    +0 Vote Up -0Vote Down
    August 12, 2014 By Severalnines

    Moodle is an open-source e-learning platform (aka Learning Management System) that is widely adopted by educational institutions to create and administer online courses. For larger student bodies and higher volumes of instruction, moodle must be robust enough to serve thousands of learners, administrators, content builders and instructors simultaneously. Availability and scalability are key requirements as moodle becomes a critical application for course providers. In this blog, we will show you how to deploy and cluster moodle/web, database and file-system components on multiple servers to achieve both high availability and scalability. 

      [Read more...]
    Previous 30 Newer Entries Showing entries 41 to 70 of 32938 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.