In MySQL a big portion of the problems you’re facing is different replication delays so there’s no surprise this is one of the most common interview questions on DBA interviews and I still found people having problems with explaining what they would do in a certain situation. This is why I decided to write a bit about the subject.

1. IO

99% of times the reason is IO. The slave cannot keep up with the amount of writes it gets from the binary logs while in parallel it has to return results of queries as well. In spite of the common belief in MySQL it’s much easier to saturate the disk subsystem (even a raid 10 with 8 SAS disk and cache) than the network.

In this situation all you can do is try to remove some pressure from the slaves.

One way to do this is setting innodb_flush_log_at_trx_commit  to 2 if it used to be 1. Usually this is enough.

You can take Oracle's MySQL Database Administrator training on five continents. In this 5-day, live, instructor-led course, you learn to install and optimize the MySQL Server, set up replication and security, perform database backups and performance tuning, and protect MySQL databases.

Below is a selection of the in-class events already on the schedule for the MySQL for Database Administrators course.

AFRICA

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.
• In-Class Event: Travel to an education center to attend …

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: Take this course from your own desk choosing from 15 events already on the schedule, delivered in English or Germany.
…

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 →

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.


Featuring speakers coming from Oracle’s MySQL …

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 will also connect to the server, using …

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: Follow a live event from your own desk - no travel …

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!

Those of you who know me also know that I spent over six years working for MySQL HR (for another couple of years I stayed on with Sun).  I joined as employee thirty-something, so running HR meant that I was more or less involved with hiring all of the 400 or so employees who joined after me. I knew pretty much everyone by name.

read more

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

SkySQL™ Cloud Data Suite is a collection of software components that provides a highly available database solution in a cloud environment based on MariaDB and 100% compatible with the MySQL database. It includes the following features:

• An automatic configurator
• An administrative console with ...
  • A graphical backup and recovery manager
  • The ability to deploy each instance securely within the user’s environment
  • Feature-rich, web-based query tools
  • An advanced monitoring tool
• A full set of HA solutions (synchronous and asynchronous)

…