Planet MySQL

Get the Best from Web, Cloud, and Embedded Applications as a MySQL DBA

+1

-0

posted by Oracle MySQL Group on Mon 20 May 2013 20:03 UTC
Tags:

(edit) mysql, Oracle, Training, DBA, mysql training

After taking this MySQL for Database Administrators course, you will be equipped to use all the features of MySQL to get the best out of your Web, Cloud, and embedded applications, whether you work with the command line or graphical tools such as MySQL Workbench and MySQL Enterprise Monitor, whether your application uses complex queries or the NoSQL API, and whether your preferred challenge is replicated servers or highly-tuned transactional systems.

You can take this 5-day live instructor-led course as a:

Live-Virtual Event: Take this course from your own desk, no travel required. You can choose from a wide selection of events on the schedule to suit different timezones.

+1

-0

posted by Oracle MySQL Group on Tue 02 Apr 2013 12:09 UTC
Tags:

(edit) mysql, Oracle, database, Training, DBA, administrator, mysql training

MySQL for Database Administrators is the foundation of the authentic MySQL Curriculum. By taking this live 5-day instructor-led course, you find out how MySQL enhancements increase performance, scalability, reliability and manageability of your Web, Cloud and embedded application requirements.

You will learn to:

Setup the server and databases
Maintain and secure data
Configure for performance and high availability
Explore real-world problems and discover best practices

You can take this course as a:

Live Virtual Event:

+0

-0

posted by IOUG Blogs on Sat 02 Mar 2013 01:02 UTC
Tags:

(edit) mysql, Technology, Oracle, Conferences, software, Security, database, conference, virtualization, Training, cloud, DBA, OEM, Education, management, collaborate, IOUG, IOUG General, 12c

Take 50% Off COLLABORATE 13 Now Through Wednesday But you’ve got to act fast! If you’re not already one of the many joining the IOUG at COLLABORATE 13 – IOUG Forum, sign up today for your chance at attending for … Continue reading →

Enhance Your MySQL Skills with Virtual Developer Day: MySQL

+6

-0

posted by Oracle MySQL Group on Wed 20 Feb 2013 01:13 UTC
Tags:

(edit) mysql, embedded, community, DBA, Developer, OTN, hol

MySQL is the world’s most popular open-source database, and powers websites and applications of numerous leading and fast-growing organizations. 

On March 12, we’re hosting the first Virtual Developer Day: MySQL at 9am PST to give you a one-stop shop to learn all the essential MySQL skills and the latest features in MySQL 5.6 GA. With a combination of presentations and hands-on lab experience, you’ll have the opportunity to practice in your own environment and gain more in-depth knowledge to successfully design, develop, and manage your MySQL databases. 

[Read more...]

Efficient Partial Table Scans

+0

-0

posted by Gavin Towey on Mon 11 Feb 2013 22:49 UTC
Tags:

(edit) mysql, sql, performance, DBA

There's a pretty common MySQL recipe for performance that if you want to efficiently scan through lots of rows in small chunks that LIMIT with OFFSET is right out. Using OFFSET, MySQL will have to scan all the rows until it finds the starting position before it starts reading results to return. Just to be clear, these statements look like:

SELECT id FROM foo ORDER BY id LIMIT 10 OFFSET 1000;

If you were trying to read all rows in table then this would be a very slow and expensive way to do that (in terms of MySQL resources.) The most common optimization is to switch to an algorithm where you remember the last highest id value for each chunk of rows, and then add that to the WHERE clause.

SELECT id FROM foo WHERE id > 100000  ORDER BY id LIMIT 10;

This would be a much more efficient way

[Read more...]

New MySQL Administrator Training on MySQL 5.6

+5

-0

posted by Oracle MySQL Group on Mon 11 Feb 2013 11:32 UTC
Tags:

(edit) mysql, Oracle, Training, DBA, administrator, mysql training

Get the most out of the great new release, MySQL 5.6, by taking the MySQL for Database Administrators training course.

During this 5 day instructor-led course you configure replication between multiple instances, design advanced replication topologies and recover from replication, network, or hardware failure taking advantage of MySQL 5.6 replication performance.

You also gain knowledge on the following:

Set up the Server and Databases

This course teaches you how to install, configure, maintain and tune databases for a wide variety of workloads and environments. You will install and configure MySQL and set appropriate configuration options. You

+0

-0

posted by Oracle MySQL Group on Fri 04 Jan 2013 21:39 UTC
Tags:

(edit) Oracle, Training, DBA, mysql training

As 2013 begins, MySQL is way ahead for job openings in the data area. So perfect your MySQL database administration skills with the authentic MySQL for Database Administrator course.

In this 5 day course, you learn to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL database.

You can take this course through one of the following delivery methods

Training-on-Demand: Take the course at your pace from your own desk, following the instructor delivery of lecture material through streaming video and scheduling your lab exercises at a time that suits you.
Live-Virtual:

+6

-5

posted by SkySQL on Thu 20 Dec 2012 09:39 UTC
Tags:

(edit) mysql, Open Source, database, jobs, DBA, developers, mariadb, skysql

The Queen of Evil is back … and she wants your MySQL database skills!

She hired the 400+ original MySQLers … and sets out to hire the SkySQLers of tomorrow!

Boel Larsen blogs about open positions & life at SkySQL - and wants you to join the fun!

2nd release of SkySQL™ Cloud Data Suite provides users with customisation capabilities for free cloud database deployments

Update release: SkySQL™ Cloud Data Suite

+2

-1

posted by Oracle MySQL Group on Mon 19 Nov 2012 22:00 UTC
Tags:

(edit) mysql, Training, DBA, mysql training

MySQL is the world's number one open source database and the number one database for the Web. Join top companies by developing your MySQL Database Administrator skills.

The MySQL for Database Administrators course is for DBAs and other database professionals who want to install the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

You can take this 5 day course as

Training on Demand: Start training within 24 hours of registration. You will follow the lecture material via streaming video and perform hands-on activities at a date and time that suits you.
Live-Virtual Event: Take this instructor-led course from your own desk. Choose from the 19 events currently on the schedule and find an event that suits you in terms of timezone and date.

[Read more...]

#DBHangOps

+0

-0

posted by Geoffrey Anderson on Thu 08 Nov 2012 02:29 UTC
Tags:

(edit) mysql, Linux, database, DBA, computing, #DBHangOps, mysql_planet, HangOps

Woooo, just wrapped up another night of #DBHangOps, check out the video:

For those of you who aren’t familiar with this awesome series of videos, it’s a bi-weekly meeting of MySQL DBAs via a Google Hangout to simply talk about databases (specifically MySQL). The discussions range anywhere from silly stories to awesome learnings and even little gotchas to know about when working with MySQL operationally. If you’re interested in catching when the next #DBHangops will happen, check MySQL planet for a blog post about it, or check this twitter search.

We look forward to talking with you!

A CTO Must Never Do This…

+0

-4

posted by Sean Hull on Thu 05 Jul 2012 20:19 UTC
Tags:

(edit) tuning, DBA, startups, troubleshooting, aws, War stories, All, CTO/CIO

Read the original article at A CTO Must Never Do This…

A couple years back I was contacted to look at a very strange problem.

The firm ran flash sales. An email goes out at noon, the website traffic explodes for a couple of hours, then settles back down to a trickle.

Of course you might imagine where this is going. During that peak, the MySQL database was brought to its knees. I was asked to do analysis during this peak load, and identify and fix problems. Make it go faster, please!

First day on the job I’m working with a team of outsourced DBAs. I was also working

+5

-0

posted by Oracle MySQL Group on Mon 25 Jun 2012 22:59 UTC
Tags:

(edit) mysql, community, DBA, Utilities, chuck_bell, mysql_utilities, wei-chen_chiu

Managing a MySQL database server can become a full time job. In many occasions, one MySQL DBA needs to manage multiple, even tens of, MySQL servers, and tools that bundle a set of related tasks into a common utility can be a big time saver, allowing you spend more time improving performance and less time executing repeating tasks. While there are several such utility libraries to choose, it is often the case that you need to customize them to your needs. The MySQL Utilities library is the answer to that need. It is open source so you can modify and expand it as you see fit.

In the latest episode of the "Meet the MySQL Experts" podcast series, Chuck Bell, Sr. MySQL Software Developer at Oracle, introduces a variety of recently

[Read more...]

7 essential tools for MySQL DBA

+2

-0

posted by Jagbir Singh on Mon 28 May 2012 12:19 UTC
Tags:

(edit) mysql, General, Tools, database, DBA, server

1. Percona Toolkit
Percona Toolkit (aka Maatkit and Aspersa) is must have collection of advanced command-line tools which helps in performing tasks that are too difficult or complex to perform manually.

2. Mydumper
Mydumper is a high-performance multi-threaded backup/restore tool for MySQL. It’s up to 10x faster compared to mysqldump, can take consistent snapshots and provides File compression on-the-fly. Though it’s still under active development but is well tested/used in production on some large installations.

3. MySQL Master HA
This tool helps to maintain your Master-Slave

+2

-0

posted by Chris Calender on Tue 17 Apr 2012 19:08 UTC
Tags:

(edit) mysql, innodb, DBA, skysql, Palomino, palominodb, MySQL Support, skysql support, hastexo

Last week was full of exciting news for all things MySQL.

However, SkySQL also had some great individual news in that it announced 2 new partners:

I just wanted to take a moment and officially welcome both to the SkySQL fold!

PalominoDB and hastexo, it’s great to be partnered with you!

And we’re looking forward to all the exciting things the future has to hold!

For those interested, you can read more about each partnership here:

+0

-0

posted by Jonathan Levin on Tue 20 Mar 2012 19:03 UTC
Tags:

(edit) mysql, DBA

When I thought to start to write this post, I was thinking about all the logical reasons why you would consider hiring a part-time remote MySQL database administrator or MySQL expert.
It then occurred to me that most of the readers, who are reading this post now, already know or can imagine the benefits of hiring a DBA to take care of their system.

So what I want to offer is a case based on the emotional benefits and value a part-time DBA can offer you and your business.

1) Peace of Mind

A DBA can offer you peace of mind that one of your core business components is being taken care of.

[Read more...]

Collaborate 2012 Registration is Now Open!

+3

-0

posted by IOUG Blogs on Thu 02 Feb 2012 18:11 UTC
Tags:

(edit) mysql, Oracle, sql, virtualization, cloud, DBA, Developer, OEM, Oracle Enterprise Manager, VMWare, 11g, exadata, IOUG, IOUG General, 12c, collaborate 2012, Las Vegas, Mandalay Bay

http://collaborate12.ioug.org Double Down at COLLABORATE 12- The IOUG Forum with Two Ways to Save- and a Chance to Win! The user-driven Oracle event of the year is fast-approaching, and IOUG wants you to make youreducational experience a sure bet. Between … Continue reading →

For People That Have Managers

+1

-0

posted by Jeff Hunter on Tue 10 Jan 2012 02:00 UTC
Tags:

(edit) mysql, Oracle, DBA

Interesting take on what managers are thinking: http://quickbase.intuit.com/blog/2012/01/09/10-things-your-boss-isnt-telling-you/

MongoDB for MySQL folks part 3 - More on queries and indexes

+1

-0

posted by Anders Karlsson on Wed 02 Nov 2011 08:44 UTC
Tags:

(edit) mysql, DBA, mongodb

Last time I wrote about MongoDB for MySQL DBAs I described some of the basics of MongoDB querying, and this time I'll follow that up with some more on querying.

As we saw last time, the basic format of a MongoDB query is:
db.find(<query>,<attributes>)
Note that you do NOT replace db with the name of the database you want to query here, you just make the database you want to use the current one and issue the query, such as:
> use test
> db.mycoll.find()
The example above will find all objects in the mycoll collection, and will include all the object attributes and also the key (_id), like this:
{ "_id" : ObjectId("4eb0634807b16556bf46b214"), "c1" : 1 }
{ "_id" : ObjectId("4eb0634a07b16556bf46b215"),

[Read more...]

MongoDB for MySQL folks part 3 - More on queries and indexes

+0

-0

posted by Anders Karlsson on Thu 27 Oct 2011 08:57 UTC
Tags:

(edit) mysql, DBA, mongodb

Last time I wrote about MongoDB for MySQL DBAs I described some of the basics of MongoDB querying, and this time I'll follow that up with some more on querying.

As we saw last time, the basic format of a MongoDB query is:
db.find(,)
Note that you do NOT replace db with the name of the database you want to query here, you just make the database you want to use the current one and issue the query, such as:
> use test
> db.mycoll.find()
The example above will find all objects in the mycoll collection, and will include all the object attributes and also the key (_id), like this:
{ "_id" : ObjectId("4eb0634807b16556bf46b214"), "c1" : 1 }
{ "_id" : ObjectId("4eb0634a07b16556bf46b215"), "c2" : 1 }
{ "_id" :

[Read more...]

TIL: Lookout For DEFINER

+0

-0

posted by Gerardo Narvaja on Wed 12 Oct 2011 23:08 UTC
Tags:

(edit) mysql, Replication, code, tips, DBA, permissions

The Issue

I haven't blogged in a while an I have a long TODO list of things to publish: The repository for the SNMP Agent, video and slides of my OSCON talk and a quick overview of MHA master-master support. In the meantime, here's a little fact that I didn't know from MySQL CREATE VIEW documentation:

Although it is possible to create a view with a nonexistent DEFINER account, an error occurs when the view is referenced if the SQL SECURITY value is DEFINER but the definer account does not exist.

How can this be possible?

The Problem

For a number of reasons we don't have the same user accounts on the master than we have on the slaves (ie: developers shouldn't be querying the

[Read more...]

MySQL HA Agent Mini HowTo

+1

-0

posted by Gerardo Narvaja on Thu 18 Aug 2011 01:17 UTC
Tags:

(edit) mysql, Replication, code, Tools, Linux, DBA, Scripts, High Availability

Why This Post

While testing Yoshinori Matsunobo's MHA agent I found that although the wiki has a very complete documentation, it was missing a some details. This article intends to close that gap and bring up some issues to keep in mind when you do your own installation. At the end of the article I added a Conclusions section, if you're not interested in the implementation details, but to read my take on the project, feel free to jump straight to the end from here.

My Test Case

Most of our production environments can be simplified to match the MHA's agent most simple use case: 1 master w/ 2 or more slaves and at least one more slave in an additional

[Read more...]

MySQL Global status difference using MySQL procedures / functions

+2

-0

posted by Anders Karlsson on Fri 12 Aug 2011 11:56 UTC
Tags:

(edit) mysql, DBA, status, procedure

As a MySQL DBA, I guess you use the SHOW GLOBAL STATUS command or the corresponding INFORMATION_SCHEMA.GLOBAL STATUS table to show current mySQL status quite often. And many of us use different tools to collect that data and view it.

But sometimes we use same command from the SQL prompt, because we have to, because it's the only option or just because that is the most convenient way. And often you kick of two such command in a row, a few seconds apart, just to see how things are moving:
SHOW GLOBAL STATUS LIKE 'innodb%rows%';
... DBA picks his or her nose for a few seconds ...
SHOW GLOBAL STATUS LIKE 'innodb%rows%';

And then you can see how things are advancing. But how much? To figure of how much, you have to calculate the differnce between the values returned by those two statements. And then there is another

[Read more...]

My MySQL SNMP Agent

+1

-0

posted by Gerardo Narvaja on Thu 21 Jul 2011 22:24 UTC
Tags:

(edit) mysql, Replication, oscon, Tools, monitoring, DBA, snmp, opennms, mariadb, diagnosis

Back in February I wrote an article titled A Small Fix For mysql-agent. Since then we did a few more fixes to the agent and included a Bytes Behind Master (or BBM) chart. For those who can't wait to get their hands on the code, here's the current version: MySQL SNMP agent RPM. For those who'd like to learn about it's capabilities and issues, keep reading.

What to Expect From this Version

The article I quoted above pretty much describes the main differences with the original project, but we went further with the changes while still relying on Masterzen's code for the data collection piece.

The first big change is that we transformed

[Read more...]

MySQL: Using Views as Performance Improvement Tools

+0

-0

posted by Ovais Tariq on Mon 30 May 2011 19:16 UTC
Tags:

(edit) mysql, sql, database, performance, views, DBA, joins, planning, slow log, dataset, patterns, mysql resources, data access, suboptimal

The most basic and most oft-repeated task that a DBA has to accomplish is to look at slow logs and filter out queries that are suboptimal, that consume lots of unnecessary resources and that hence slow down the database server. This post looks at why and how VIEWs can help against such suboptimal operations.

On LVM: How to setup Volume Groups and Logical Volumes.

+0

-0

posted by Ovais Tariq on Sat 28 May 2011 11:46 UTC
Tags:

(edit) mysql, debian, Backup, ubuntu, lvm, DBA, partition, fdisk, lvs, filesystem, lvm2, disk, snapshot, ext4, mount, boot, create volume, df, fstab, logical volume, logical volume management, lvcreate, mkdir, partition table, physical volume, pvcreate, system startup, terminologies, vgcreate, vgs, volume group

LVM (Logical Volume Management) is a very important tool to have in the toolkit of a MySQL DBA. It allows you to create and extend logical volumes on the fly. This allows me to, say, add another disk and extend a partition effortlessly. The other very important feature is the ability to take snapshots, that you can then use for backups. All in all its a must have tool. Hence, this guide will allow you to understand various terminologies associated with LVM, together with setting up LVM volumes and in a later part will also show you how to extend...

MySQL Database cleaner 1.0 released

+2

-0

posted by Anders Karlsson on Wed 25 May 2011 11:48 UTC
Tags:

(edit) mysql, DBA, cleanup

If you ever, and I think many of use DBAs have, been in the situation where you are stuck with data in the database that isn't used and isn't accessed, data which may consist of rows that are no longer used, data rows that aren't references, because you don't use FOREIGN KEYs or they weren't applicable in this case. Or data that was once used, but no longer is.

And in many cases, this data is tucked in among your other good rows of data :-( One way of cleaning up the database in a case like this is to run standard DELETE statements, but there are a few issues with this:

You may be accessing a lot of data, so this may take a while.
You will be locking large amount of data for this.
The join statement to get the data that is no longer used and / or no longer referenced is complex.
There is no really good way to split

+0

-0

posted by Oracle MySQL Group on Wed 18 May 2011 22:28 UTC
Tags:

(edit) mysql, Certification, DBA, Developer, MySQL Certification

Effective June 1, 2011, MySQL certification exams will be offered exclusively through a new test delivery partner — Pearson VUE — and will no longer be available through Prometric. This will consolidate all Oracle Certification exams within the operations of a single testing vendor so we can provide better service and global testing coverage for these Oracle certification exams. Pearson VUE currently has over 5,000 test centers worldwide in 165 countries.

To help prepare you for this transition, here are some important dates for you to be aware of:

If you are currently following a certification path and are planning to take an exam on/after June 1: Registration has began at Pearson VUE on May 16, 2011 for all scheduled exams on or after June 1. Visit pearsonvue.com/oracle to create a new web account

[Read more...]

Some More Replication Stuff

+0

-0

posted by Gerardo Narvaja on Thu 05 May 2011 23:37 UTC
Tags:

(edit) mysql, Replication, Tools, tips, Backup, tuning, monitoring, DBA, schema updates

Listening to the OurSQL podcast: Repli-cans and Repli-can’ts got me thinking, what are the issues with MySQL replication that Sarah and Sheeri didn’t have the time to include in their episode. Here’s my list:

Replication Capacity Index

This is a concept introduced by Percona in last year’s post: Estimating Replication Capacity which I revisited briefly during my presentation at this year’s MySQL Users Conference. Why is this important? Very simple: If
[Read more...]

Handling Human Errors

+0

-0

posted by Alex Gorbachev on Wed 13 Apr 2011 15:25 UTC
Tags:

(edit) mysql, Oracle, DBA, ha, SQL Server, Technical Blog, Business Blog, mistakes, critical, human

Interesting question on human mistakes was posted on the DBA Managers Forum discussions today.

As human beings, we are sometimes make mistakes. How do you make sure that your employees won’t make mistakes and cause downtime/data loss/etc on your critical production systems?

I don’t think we can avoid this technically, probably working procedures is the solution.
I’d like to hear your thoughts.

I typed my thoughts and as I was finishing, I thought that it makes sense to post it on the blog too so here we go…

The keys to prevent mistakes are low stress levels, clear communications and established processes. Not a complete list but I think these are the top things to reduce the number of mistakes we make managing data infrastructure or for

[Read more...]

Search

Profile

Top Voted (Last Week)

Top Voted (Last Month)

MySQL Links

Top 20 Most Active Authors

Oracle MySQL Blogs

Top 10 Vendor Blogs

She hired the 400+ original MySQLers … and sets out to hire the SkySQLers of tomorrow!

Boel Larsen blogs about open positions & life at SkySQL - and wants you to join the fun!

2nd release of SkySQL™ Cloud Data Suite provides users with customisation capabilities for free cloud database deployments

Update release: SkySQL™ Cloud Data Suite

The Issue

The Problem

Why This Post

My Test Case

What to Expect From this Version

Replication Capacity Index