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

Displaying posts with tag: mysql (reset)

5 great new features from Percona Cloud Tools for MySQL
+1 Vote Up -0Vote Down

It’s been three months since we announced anything for Percona Cloud Tools, not because we’ve been idle but because we’ve been so busy the time flew by!  Here’s the TL;DR to pique your interest:

  • EXPLAIN queries in real-time through the web app
  • Query Analytics for Performance Schema
  • Dashboards: customizable, shared groups of charts
  • Install and upgrade the agent with 1 command line
  • Unified UI: same time range, same host wherever you go

Percona Cloud Tools for MySQL is a hosted service providing access to query performance insights for all MySQL uses. After a brief setup, unlock new information about your database and how to improve your applications. There’s a lot more, but let’s just look at these five new

  [Read more...]
Measuring failover time for ScaleArc load balancer
+1 Vote Up -0Vote Down

ScaleArc hired Percona to benchmark failover times for the ScaleArc database traffic management software in different scenarios. We tested failover times for various clustered setups, where ScaleArc itself was the load balancer for the cluster. These tests complement other performance tests on the ScaleArc software – sysbench testing for latency and testing for WordPress acceleration.

We tested failover times for Percona XtraDB Cluster (PXC) and MHA (any traditional MySQL replication-based solution works pretty much the same

  [Read more...]
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...]
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...]
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...]
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...]
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...]
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...]
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...]
    Benchmarking IBM eXFlash™ DIMM with sysbench fileio
    +0 Vote Up -0Vote Down

    Diablo Technologies engaged Percona to benchmark IBM eXFlash™ DIMMs in various aspects. An eXFlash™ DIMM itself is quite an interesting piece of technology. In a nutshell, it’s flash storage, which you can put in the memory DIMM slots. Enabled by Diablo’s Memory Channel Storage™ technology, this practically means low latency and some unique performance characteristics.

    These devices are special, because their full performance potential is unlocked by using multiple devices to leverage the parallelism of the memory subsystem. In a modern CPU there is more than one memory controller (4 is typical nowadays) and spreading eXFlash™ DIMMs across them will provide maximum performance. There are quite some details about the device that are omitted in this post, they can be found in

      [Read more...]
    Top 10 Reasons to Attend MySQL Central @ OpenWorld
    Employee_Team +2 Vote Up -0Vote Down

    MySQL Central @ OpenWorld is less than 7 weeks away, have you registered?





      [Read more...]
    FATAL: failed to initialize database driver! with Sysnbech 0.4.X
    +0 Vote Up -0Vote Down
    Recently, I came through with this error. It was weird because I have never seen this error earlier. [root@percona-pxc55-1 nilnandan]# sysbench --test=oltp --oltp-table-size=1000000 --mysql-db=dbtest --mysql-user=msandbox --mysql-password=msandbox --mysql-socket=/tmp/mysql_sandbox5537.sock prepare sysbench 0.4.12: multi-threaded system evaluation benchmark FATAL: no database driver specified FATAL: Continue reading →   [Read more...]
    MariaDB 10.0.13 now available
    +0 Vote Up -0Vote Down

    Download MariaDB 10.0.13

    Release Notes Changelog What is MariaDB 10.0?

    MariaDB APT and YUM Repository Configuration Generator

    The MariaDB project is pleased to announce the immediate availability of MariaDB 10.0.13. This is a Stable (GA) release.

    See the Release Notes and

      [Read more...]
    Database Modelling is Key to Getting Started on the MySQL Database
    Employee_Team +0 Vote Up -0Vote Down

    Database modelling is the process of defining the logical structure of a database. This structure determines how data is stored, organized and manipulated. This enables you to:

    • Understand your data before building the database
    • Consider what questions your data must answer

    The entity relationship model (ERM) is the most common model for an RDBMS.

    Learn more about database modelling, design and much more in the MySQL for Beginners training course.

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

    • Training-on-Demand: Start training within 24 hours of registration. Follow lectures at your own pace through streaming
      [Read more...]
    libAttachSQL 0.1.0 alpha released!
    +0 Vote Up -0Vote Down
    As I briefly mentioned in my previous post, I have been working on a new project for HP's Advanced Technology Group called libAttachSQL.

    libAttachSQL is a lightweight C connector for MySQL servers.  It is Apache 2 licensed (and therefore compatible with many open source licenses as well as commercial use) and has a new asynchronous API.  With the new API you send a command which returns immediately and you poll until the library tells you there are results ready, this is very useful for applications that have many things going on that you do not want held up by waiting for the MySQL server to process a query.  In later posts I will give usage examples of this.

    I am a great believer in



      [Read more...]
    MySQLNoSQLCloud 2014 – Edition #3
    +0 Vote Up -0Vote Down

    I’ve enjoyed visiting Buenos Aires once a year for the MySQLNoSQLCloud event, put together by the awesome people at Binlogic (in particular, their proprietor Santiago Lertora). It’s happening again in 2014, which by my count is the third edition, and there’s a twist: Buenos Aires on 13 & 14 November, and Cordoba on 17 November. It’s never been held in Cordoba before (like an annex event), so I think this could be extremely exciting.

    If you’re looking to speak, send Santiago a note at events@binlogic.com (or leave a message here). I’ll put you in touch with him. If you’re looking to sponsor, you get attendees from all over Latin

      [Read more...]
    Bug marketing - fixing MongoDB replication bugs in TokuMX
    +0 Vote Up -0Vote Down
    Asynchronous replication is lossy by nature. It is also useful in production especially for replication across a WAN where the latency for one or two network roundtrips between replicas is too much. Latency is reduced when replicas are nearby but that greatly increases cost from using more replicas. In MySQL land we have work-in-progress that uses enhanced semi-sync replication and binlog archivers to make the binlog 2-safe within a datacenter and greatly reduce the chance that a committed transaction is lost (some people call this lossless). Even better, it can be done without running another local replica so it has a minor impact on the cost of the tier and the network latency overhead from it is very low.

    In a perfect world we could always afford the network latency and/or extra hardware cost from

      [Read more...]
    HowTo: Using the MySQL debugger inside the Visual Studio IDE
    Employee +0 Vote Up -0Vote Down
    One of the most used tools that we, developers look up for when finding bugs is: a good debugging tool. MySQL for Visual Studio offers a really good integration with all of the debugging tools that Visual Studio already delivers for the .NET framework code. A good interactive set of tools are available for debugging any application code. These same tools are ready to be used from a routine with MySQL code.
    In this post we will be showing how to use the debugger of MySQL for Visual Studio plugin in a very simple routine, but it will be more than enough to show all the tools that exists within this MySQL Debugging tool.
    Release Candidate Packages for Red Hat Enterprise Linux 7 and CentOS 7 now available
    +0 Vote Up -0Vote Down

    The Percona team is pleased to announce the Release Candidate for Percona Software packages for Red Hat Enterprise Linux 7 and CentOS 7.

    With more than 1 million downloads and thousands of production deployments at small, mid-size and large enterprises, Percona software is a industry leading distribution that enhances the performance, scale, management and diagnosis of MySQL deployments.

    This new packages bring the benefits of Percona Software to developers and administrators that are using Red Hat Enterprise Linux 7 and CentOS 7.

    The new packages are available from our testing

      [Read more...]
    Percona Toolkit 2.2.10 is now available
    +0 Vote Up -0Vote Down

    Percona is glad to announce the release of Percona Toolkit 2.2.10 on August 8, 2014 (downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series.

    Bugs Fixed:

    • Fixed bug 1287253: pt-table-checksum would exit with error if it would
      [Read more...]
    How cloud hosted services are helping open source
    +0 Vote Up -0Vote Down
    One big project I'm working on for HP's Advanced Technology Group right now is an Apache 2.0 licensed C connector for MySQL servers called libAttachSQL.  The whole process, not just the code itself, is helping us learn about new and current techniques in Open Source development.  Whilst I will be writing many posts about libAttachSQL in the future, today's post is about the free hosted services we are using around it.

    GitHub

    Almost all previous Open Source projects I have worked on in the past have been hosted on Canonical's Launchpad platform.  Over the last couple of years there has been a shift to using GitHub and almost everything I have worked on at HP has been hosted there.  Now
      [Read more...]
    How-to and Performance Impact of SSL-Encrypted Replication Traffic in Galera Cluster for MySQL
    +0 Vote Up -0Vote Down
    August 7, 2014 By Severalnines

     

    Deploying Galera Clusters across WAN environments might lead to concerns around data privacy and security - especially as more organisations are having to comply with national and international regulations. You would not want hackers eavesdropping or intercepting replication traffic. Encrypted replication hides what is sent between the Galera nodes, and makes sure each node is only communicating to the ones it trusts. But how expensive is encryption?

     

    In this blog, we will show you how to encrypt the replication traffic between your Galera nodes. We will also look into the performance impact of this

      [Read more...]
    Stupid and dangerous: SET GLOBAL sql_log_bin
    +4 Vote Up -0Vote Down

    It’s been almost 4.5 years since, during some code refactoring, it was decided (or accidentally changed?) that sql_log_bin should become a GLOBAL variable as well as a SESSION one. Almost 2 years ago, during MySQL 5.5 upgrades at Twitter, I filed MySQL Bug 67433 describing in detail how stupid and dangerous this change was, and asking for a reversal.

    Nothing has been changed or reversed, so SET GLOBAL sql_log_bin continues to be allowed. I continue to directly see, and hear about damage caused by incorrect use of SET GLOBAL sql_log_bin. So, let me describe just how stupid and dangerous it really is.

    What really happens when you run SET GLOBAL sql_log_bin?

    If you have a master-slave replication configuration, your master will have binary logging enabled (log_bin) and be recording each

      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 60 of 16238 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.