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 61 to 90 of 263 Next 30 Older Entries

Displaying posts with tag: Percona (reset)

Detecting if a MySQL server supports partitioning
+0 Vote Up -0Vote Down

This morning, this Percona XtraBackup bug came to my attention: https://bugs.launchpad.net/bugs/1170340 - basically, it’s now really quite tricky to determine if a MySQL server you’re connected to supports partitioning or not.

If you’re connected to anything less than MySQL 5.6, you can use have_partitioning variable. But since that’s gone in 5.6, you’re going to get a false negative if you’re connected to 5.6. You could use INFORMATION_SCHEMA.PLUGINS table, but that’s not there in 5.0, so you have some added workarounds to add there too.

A simple version check could be the solution… but what if you compiled the server without partitioning support?

The state of the MySQL ecosystem
+1 Vote Up -2Vote Down

I’ll be on a whistle-stop tour of California next week, including two presentations at the Percona Live MySQL Conference and Expo.

On day one at 1:20pm I’ll be presenting CAP Theorem: Two out of three ain’t right, in which I will be challenging the popular ‘two out of three’ explanation of CAP Theorem, examining the evidence from a variety of experts, including Dr Eric Brewer.

Then on day three at 9:00am I’m very honoured to be providing a keynote presentation, The State of the MySQL Ecosystem.

Here’s an overview of the presentation:

It

  [Read more...]
Upcoming talks in Santa Clara
+4 Vote Up -0Vote Down

I’m planning my calendar and thought I’d share what talks I’d be giving in Santa Clara in a couple of weeks for the Percona Live MySQL Conference & Expo 2013 and the MySQL & Cloud Database Solutions Day 2013. Its going to be a busy April 22-26 2013.

  • MariaDB Cassandra Interoperability with Sergei Petrunia on 23 April 1:20pm – 2:10pm @ Ballroom D
  • MariaDB BoF on 23 April 6:00pm – 7:00pm @ Ballroom F
  • MariaDB
  •   [Read more...]
    April is the Coolest Month
    +0 Vote Up -0Vote Down

    If T.S. Eliot were a MySQL DBA, I think he would have been more upbeat about April.

    We are gearing up for an incredible second half of April. We will be presenting three separate sessions at the Percona Live: MySQL Conference and Expo 2013, April 22-25, in Santa Clara, CA. In addition, we will be presenting at SkySQL’s MySQL & Cloud Database Solutions Day on Friday, April 26 at the same location.

    Come by to see us in Booth #114, or stop by one of our sessions:

      [Read more...]
    Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
    +1 Vote Up -0Vote Down

    Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

    Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

    read more

    Exciting Group of Speakers for MySQL & Cloud Solutions Day, Friday, April 26th in Santa Clara
    +0 Vote Up -0Vote Down

    Agenda includes speakers from Calpont, Codership/Galera, Craigslist, MariaDB, SkySQL and the OpenStack Foundation

    Today, SkySQL and MariaDB jointly announce an exciting lineup of speakers for their MySQL and Cloud Solutions Day on Friday, April 26th, at the Hyatt Regency Santa Clara. This year’s agenda will feature database and cloud tutorials, as well as keynotes, featuring speakers from Calpont, Codership, Craigslist, MariaDB, SkySQL and the OpenStack Foundation.

    read more

    How to fix the Percona repo failure when installing Percona Toolkit
    +0 Vote Up -0Vote Down

    Here’s a solution to the not-so-long-standing issue of the Percona yum repo being broken for the CentOS 6 x86_64 version of the Percona-toolkit package. The repo listing is reporting an older version of the RPM which is not available on the site, so to fix this you just have to download the newer file and tell yum to add it locally. The side benefit is that you can use Yum to manage the RPM without adding the Percona repo, since the default settings for their repo could/have/had caused conflicts with Base Repo versions of MySQL packages; the Percona repo instructions set ‘enabled=1′ — not a great idea if you’re not setup to use the Yum priorities method of repo weighting.

    So, if you see this after installing the repo via the instructions on their site:
    Downloading Packages:


      [Read more...]
    Sessions at Percona Live MySQL Conference 2013: fun, competition, novelties, and a free pass
    +3 Vote Up -0Vote Down

    The Percona Live MySQL Conference and Expo 2013 is almost 1 month away. It's time to start planning, set the expectations, and decide what to attend. This post will give a roundup of some of the sessions that I recommend attending and I look forward to.

    First, the unexpected!

    After much talk and disbelief, here they come! Oracle (http://www.mysql.com) engineers will participate to the Percona Live conference. This is wonderful! Their participation was requested by the organizers, by the attendees, and by community advocates, who all told the Oracle management how important it is to be in this conference. Finally, they have

      [Read more...]
    The Data Day, A few days: March 6-8 2013
    +0 Vote Up -0Vote Down

    Ayasdi emerges. Amazon slashes DynamoDB prices. And more

    For 451 Research clients: Ayasdi applies TDA, machine learning and Hadoop twist to advanced analytics bit.ly/XYG0fZ By Krishna Roy

    — Matt Aslett (@maslett) March 8, 2013

    For 451 Research clients: Software AG launches In-Genius take on in-memory operational intelligence bit.ly/XYFI8G

    — Matt Aslett (@maslett) March 8, 2013

    For 451 clients: Anaplan lands $30m to accelerate growth, sets out expansion strategy under new CEO bit.ly/YMQ6gF By Krishna Roy

    — Matt Aslett

      [Read more...]
    What to See & Do at Percona Live: MySQL Conference & Expo 2013
    +3 Vote Up -0Vote Down

    It’s not too soon to be thinking about what sessions you’ll be attending while at Percona Live: MySQL Conference & Expo 2013. SkySQL’s team of MySQL and MariaDB database experts will be headed to Santa Clara in full force as sponsors and speakers of this annual meeting for MySQL database users. As you plan out your week, be sure to check out some of SkySQL’s talks, including:

      [Read more...]
    Your chance to define the “state of MySQL”
    +0 Vote Up -0Vote Down

    We are very honoured to have been asked to give a “state of the MySQL” keynote presentation at the Percona Live MySQL Conference and Expo in April.

    While this will not be in any way an official “state of the dolphin” presentation, I think it is fitting given the expansion of the MySQL ecosystem that the Percona Live event includes an independent perspective on the state of MySQL. The full title of the presentation – MySQL, YourSQL, NoSQL, NewSQL – the state of the MySQL ecosystem – reflects that.

    We want to present an independent perspective on the health of the MySQL ecosystem in 2013, drawing on our research and analysis, as well as the views

      [Read more...]
    The Data Day, A few days: January 17-22 2013
    +0 Vote Up -0Vote Down

    DataStax and VoltDB launch their version 3.0s. And more

    For 451 Research clients: DataStax adds security and manageability to distributed NoSQL database bit.ly/Vb1IiT

    — Matt Aslett (@maslett) January 18, 2013

    For 451 clients: LogiXML serves up fresh cut of BI stack with an eye to more embedded analytics deals bit.ly/SppzsH By Krishna Roy

    — Matt Aslett (@maslett) January 21, 2013

    Inside H-P’s Missed Chance To Avoid a Disastrous Deal – WSJ.com on.wsj.com/Td7wrh via @

      [Read more...]
    Our 2013 Database survey is now live
    +0 Vote Up -0Vote Down

    451 Research’s 2013 Database survey is now live at http://bit.ly/451db13 investigating the current use of database technologies, including MySQL, NoSQL and NewSQL, as well as traditional relation and non-relational databases.

    The aim of this survey is to identify trends in database usage, as well as changing attitudes to MySQL following its acquisition by Oracle, and the competitive dynamic between MySQL and other databases, including NoSQL and NewSQL technologies.

    There are just 15 questions to answer, spread over five pages, and the entire survey should take less than ten minutes to complete.

    All individual responses are of course

      [Read more...]
    [Plus] readers choice 2012 : It’s time to vote!
    +2 Vote Up -0Vote Down

    Oh yes, 2012 was an incredible year for the MySQL Community!
    That’s why I would like to change the rules this year and I would like to offer you a new survey for this [Plus] reader’s choice 2012.

    Community users, bloggers and events made the whole community last year, tell us how you used this community?
    It will only take 5 minutes of your precious time, votes will be closed Jan. 31.

    Vote for what you used! (with your heart, again…)

    Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit the site to participate in this post's poll. Note: There is a poll embedded within this post, please visit

      [Read more...]
    Call for Nominations: MySQL Community Awards 2013
    +4 Vote Up -0Vote Down

    It is a new year and it's time again to start thinking of all the great people and companies that make the MySQL ecosystem so great. It is time to start thinking of this year's MySQL Community Awards.

    Last year we had a record number of winners, eleven goblets were handed out! But behind the scenes things were even more exciting, there were several ties that forced the panel to do extra tie-breaking voting rounds. In one category we even had a 6-way tie! All of this just testifies to how much is happening in the MySQL world nowadays.

    read more

    Slides from Percona Live UK posted
    +0 Vote Up -0Vote Down

    Percona Live UK took place this week. It was the second year in a row and once again a great conference. Thank you Percona for bringing the show to Europe, it means a lot for the European MySQL community - many people who don't visit the Santa Clara conference were present in London. It's kind of funny, I even meet more Finnish MySQL users in London than I do at home!

    I gave 2 talks. Slides are now posted on Slideshare:

    read more

    Solving replication problems with Tungsten replicator
    +1 Vote Up -0Vote Down

    On Monday afternoon, Neal Armitage and I will be speaking at Percona Live in London. It will be a three hours tutorial about Tungsten replicator.

    The contents of this tutorial are mostly new. We have released recently a new and easier way of installing different topologies, in the shape of cookbook scripts, which are distributed with the replicator tarball.

    Using this cookbook, any user can simply install multiple topologies, from the simple master/slave to all-masters, fan-in, and star.

    There are recipes for showing the replication cluster, switching roles between master and a chosen slave, taking over MySQL replication, installing direct slaves with parallel replication, testing each topology, and

      [Read more...]
    Industrial-strength MySQL applications using Percona and Continuent
    +0 Vote Up -0Vote Down
    MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we show you how to combine Percona Server and Percona XtraBackup with Continuent Tungsten to build business-critical systems capable of processing hundreds of millions of transactions per
    Percona Live UK, Santa Clara 2013, Fosdem and other conferences
    +0 Vote Up -0Vote Down

    The Winter season for conferences is catching up speed.

    DOAG

    As I write this the DOAG conference in Germany is happening. It is one of the biggest (or the biggest?) Oracle user group conferences outside of USA. Many of my European friends in the MySQL space are talking there. As you know I have been a big fan of Galera Cluster for MySQL for over a year now, but I was perhaps a bit of an early adopter. Lo-and-behold, I was surprised to see the DOAG related press-release from SkySQL puts the creators of Galera first in their headline: Codership, SkySQL und weitere Top-Experten rund um das Thema ‘MySQL Datenbanken” in Nürnberg

      [Read more...]
    Meet you in London - Percona Live MySQL Conference
    +0 Vote Up -0Vote Down
    Continuent is proud to sponsor Percona Live MySQL Conference: London 2012!  Don't miss these five (5) talks by our database replication and clustering stars: Keynote: Future-Proofing MySQL for the World-Wide Data Revolution, by Robert Hodges Why, What, and How of Data Warehouses for MySQL, by Robert Hodges Multi-master, Multi-site MySQL Databases Made Easy with Continuent Tungsten, by Robert
    Webinar: Industrial-Strength MySQL Applications Using Percona and Continuent
    +0 Vote Up -0Vote Down
    Wednesday, 11/28 @ 10 am PT/ 1 pm ET Register at http://www.percona.com/webinars/industrial-strength-mysql-applications-using-percona-and-continuent MySQL is the first choice for a large majority of web applications thanks to its ease of use and low cost of operation. However, running big apps on MySQL is still a challenge even for experts. In this webinar we will show you how to combine
    Don't miss these five (5) Continuent Tungsten talks at Percona Live London
    +0 Vote Up -0Vote Down
    Learn tips and tricks from the database replication and clustering stars: Future-Proofing MySQL for the World-Wide Data Revolution, by Robert Hodges Why, What, and How of Data Warehouses for MySQL, by Robert Hodges Multi-master. Multi-site  MySQL Databases Made Easy with Continuent Tungsten, by Robert Hodges and Giuseppe Maxia MySQL High Availability: Power, Magic and Usability, by Giuseppe
    Continuent expands in France
    +0 Vote Up -0Vote Down
    Continuent announced today its expansion in France. In a move to increase its presence in Europe and to strengthen relationships with existing and prospective contacts in France and Benelux, Axel Faux and Ludovic Launer have joined Continuent's team of database clustering and replication experts. The new sales office in Paris, France's largest economic center, is a continuation of Continuent's
    MySQL Conference & Expo Call for Papers - tips on submitting a great proposal
    +2 Vote Up -0Vote Down

    It's the time of the year again: You have 2 more weeks to submit a great proposal to the biggest and baddest MySQL Conference: Percona Live MySQL Conference and Expo 2013 (Santa Clara). Like many things in the MySQL community, this conference has also gone through a transformation over the past 3 years. But last year the growing pains and uncertainty ended with Percona putting up a great show. Attendance was up again (over 1000) and there was a sense of energy and excitement for the future of MySQL. If you are like me and like to dwell in nostalgia (so that you can get into the right mood for submitting great proposals) my coverage of last year's conference is found here: part 1,

      [Read more...]
    Percona Live NYC - It's a wrap
    +0 Vote Up -0Vote Down
    If you missed Percona Live MySQL Conference in NYC, download these Continuent Tungsten talks! FUTURE-PROOFING MYSQL FOR THE WORLD-WIDE DATA REVOLUTION by Robert Hodges SOLVING LARGE-SCALE DATABASE ADMINISTRATION WITH CONTINUENT TUNGSTEN by Robert Hodges and Neil Armitage CONSOLIDATE YOUR SHARDED DATABASE INDEXES IN REAL-TIME by Jeff Mace We are sponsoring the upcoming Percona Live events in
    Don't miss these four (4) Continuent Tungsten talks at Percona Live New York
    +0 Vote Up -0Vote Down
    - Future-Proofing MySQL for the World-Wide Data Revolution by Robert Hodges- Solving Large-Scale Database Administration with Continuent Tungsten by Robert Hodges and Neil Armitage  - MySQL Backup and Recovery Essentials by Ronald Bradford  - Consolidate Your Sharded Database Indexes in Real-time by Jeff Mace   Get 10% discount from your conference pass by using discount code Continuent
    Impact of MySQL slow query log
    +0 Vote Up -0Vote Down

    So, what impact does enabling the slow query log have on MySQL?

    I decided to run some numbers. I’m using my laptop, as we all know the currently most-deployed database servers have mulitple cores, SSDs and many GB of RAM. For the curious: Intel(R) Core(TM) i7-2620M CPU @ 2.70GHz

    The benchmark is going to be:
    mysqlslap -u root test -S var/tmp/mysqld.1.sock -q 'select 1;' --number-of-queries=1000000 --concurrency=64 --create-schema=test

    Which is pretty much “run a whole bunch of nothing, excluding all the overhead of storage engines, optimizer… and focus on logging”.

    My first run was going to be with the slow query log on. I’ll start the server with mysql-test-run.pl as it’s just easy:
    eatmydata


      [Read more...]
    Webinar 9/27: MySQL High Availability Realized
    +0 Vote Up -0Vote Down
    High availability is about more than just making sure that applications can get to your data, even if there is a failure: How about when you are upgrading your database schema What if you need to add memory to a database server or reconfigure/restart MySQL If your apps want to read data from a MySQL slave, how can you be sure they are not reading stale data without re-coding your apps What
    MySQL 5.6 replication gotchas (and bugs)
    +8 Vote Up -0Vote Down

    There has been a lot of talk about MySQL 5.6 replication improvements. With few exceptions, what I have seen was either marketing messages or hearsay. This means that few people have really tried out the new features to see whether they meet the users needs.

    As usual, I did try the new version in my environment. I like to form my own opinion based on experiments, and so I have been trying out these features since they have appeared in early milestones.

    What follows is a list of (potentially) surprising results that you may get when using MySQL 5.6.
    All the examples are made using MySQL 5.6.6.

    Gotcha #1 : too much noise

    I have already mentioned that MySQL 5.6 is too verbose when creating data directory. This also means that your error


      [Read more...]
    Jenkins Bazaar plugin 1.19
    +0 Vote Up -0Vote Down

    I recently released a new version of the Bazaar plugin for Jenkins. This release was inspired by a problem we noticed at Percona. It is:

    • run “bzr revert” after a pull, as if you have a directory that is removed and re-added while having unknown files in said directory (e.g. build artifacts), you would end up in a very bad place (this is a BZR bug, so we work-around it with a “bzr revert”).

    The update has already appeared in the Jenkins update centre, so you should already be able to upgrade to it.

    Previous 30 Newer Entries Showing entries 61 to 90 of 263 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.