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

Displaying posts with tag: Percona (reset)

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.

New Jenkins Bazaar plugin release! 1.18
+1 Vote Up -0Vote Down

From the desk of your new Bazaar plugin for Jenkins maintainer, I give you Version 1.18.

This release has two good bug fixes:

  • UI fix for checkout option (JENKINS-12261)
  • Auto-recover from corrupt BZR branches (e.g. bzr branch/checkout killed at inopportune moment) by cleaning the workspace and trying again (this is now default behaviour, best used with the Jenkins SCM retry count feature being > 1)

We’ve been running the same code as this release at Percona for about 2 months now (the second bugfix was one I wanted to test first before submitting upstream). This is the big fix that fixed all our problems with using bazaar with Jenkins in a large deployment.

  [Read more...]
Hacking the Jenkins BZR plugin
+2 Vote Up -0Vote Down

For Drizzle and for all of the projects we work on at Percona we use the Bazaar revision control system (largely because it’s what we were using at MySQL and it’s what MySQL still uses). We also use Jenkins.

We have a lot of jobs in our Jenkins. A lot. We build upstream MySQL 5.1, 5.5 and 5.6, Percona Server 5.1, Percona Server 5.5, XtraBackup 1.6, 2.0 and 2.1. For each of these we also have the normal trunk builds as well as parameterised ones that allow a developer to test out a tree before they ask for it to be merged. We also have each of these products across seven operating systems and for each of those both x86 32bit and 64bit. If we weren’t already in the

  [Read more...]
Scripting continued
+0 Vote Up -0Vote Down

Since I have been discussing scripting lately I thought I would continue with another topic I touched on briefly - backups.

I have written and modified the following script over the last few years. I have used it (and continue to use it) with multiple clients. It uses Percona's Xtrabackup to take the backup (although it can be easily modified to use mysqldump instead).

First the script

-----------------------------------------------------------------------------------------------------------------

#!/bin/bash
SAVEIFS=$IFS
IFS=$""
day_of_week=`date +%a`
backup_dir=/mysql-backup/
logfile=/root/backup_log.txt
report=/tmp/report.txt
servername=slave1
email=bmurphy@paragon-cs.com
password=`cat /root/.ssh/.backup_password`

# run backup
echo ' ' > $report
echo 'The backup is now beginning:'












  [Read more...]
The best MySQL multi-master solution gets even better
+1 Vote Up -4Vote Down
The best (and truly the only) MySQL multi-master, multi-site solution on the market gets even better! Continuent is happy to announce immediate availability of Continuent Tungsten 1.5.New Continuent Tungsten 1.5 allows you to build multi-site, disaster recovery (DR) and multi-master solutions with ease: Multi-Master Operations - Tungsten can support your multi-master operations today by linking
How having many tables affects MySQL memory usage?
+1 Vote Up -0Vote Down

 

You could say: what could be the reason for having really big number of tables? Just design the application properly! It’s not always that easy. And this post isn’t really about arguing whether having many tables is good or not, it’s about what happens in terms of memory usage if you already reached that point.

Btw what do I mean by *many*? From my experience it’s tens of thousends or even millions rather than hundreds.

The inspiration for me to write this post was strong desire to try out the latest declared improvements in that area announced to be done in MySQL 5.6. _1

What I did was a very simple

  [Read more...]
Tokutek Welcomes Gerry Narvaja!
+7 Vote Up -0Vote Down

We are excited to have Gerry Narvaja start today at Tokutek! Gerry has spent more than 25 years in the software industry, most of them working with databases for different kinds of applications, from embedded to large-scale web products. Gerry worked first at MySQL, and then Sun Microsystems supporting the Sales teams. In 2008 he transitioned into being a Senior MySQL DBA. Gerry graduated as an Electronic Engineer from I.T.B.A (Instituto Tecnológico de Buenos Aires) and has an M.B.A. from Universidad del Salvador in collaboration with S.U.N.Y.A (State University of NY at Albany).

Gerry enjoys helping users to solve complex database production issues. For almost a year he has been co-hosting the popular MySQL Community podcast, OurSQL, which was given the

  [Read more...]
Percona Live Slides and Video Available: The Right Read Optimization is Actually Write Optimization
+2 Vote Up -0Vote Down

In April, I got to give a talk at Percona Live, about why The Right Read Optimization is Actually Write Optimization. It was my first industry talk, so I was delighted when someone in the audience said “I feel like I just earned a college credit.”

Box offered to host everyone’s slides from the conference here (mine is here). A big thanks from me to Sheeri Cabral, for

  [Read more...]
Notes from MySQL Conference 2012 - Part 2, the hard part
+0 Vote Up -0Vote Down

This is the second and final part of my notes from the MySQL conference. In this part I'll focus on the technical substance of talks I saw, and didn't see.

More than ever before I was a contributor rather than attendee at this conference. Looking back, this resulted in seeing less talks than I would have wanted to, since I was speaking or preparing to speak myself. Sometimes it was worse than speaking, for instance I spent half a day picking up pewter goblets from an egnravings shop... (congratulations to all the winners again :-) Luckily, I can make up for some of that by going back and browse their slides. This is especially important whenever 2 good talks are scheduled in the same slot, or in the same slot when I was to speak. So I have categorized topics here along various axes, but also along the "things I did see" versus "things I missed"

  [Read more...]
Previous 30 Newer Entries Showing entries 61 to 90 of 255 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.