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 中文
Showing entries 1 to 30 of 103 Next 30 Older Entries

Displaying posts with tag: DBA (reset)

Setting up and Using MySQL Replication
Employee_Team +1 Vote Up -0Vote Down

MySQL Replication allows servers to copy changes from one instance to another. Take the MySQL for Database Administrators course to learn about replication, including:

  • How to set up a replication environment
  • Complex topologies
  • Replication types
  • Global transaction IDs (GTIDs)
  • MySQL Utilities
  • Logs and threads

Replication is one of the many topics covered in the MySQL for Database Administrators course. You can take this 5-day instructor-led course as  

  [Read more...]
Save 20% With MySQL Training and Certification Packages
Employee_Team +2 Vote Up -0Vote Down

Get the best from both worlds with bundled packages: a training course and a certification exam voucher. You save 20% when you buy training and certification in discount packages.

Training helps you acquire product expertise. Certification proves this expertise to your future employers.

There are two MySQL Discount Packages: MySQL Database Administration and MySQL Developer.

For more information about the authentic MySQL curriculum, go to http://education.oracle.com/mysql.

Securing User Account Details with MySQL
Employee_Team +0 Vote Up -0Vote Down

Keeping user account details secure is always at the forefront of a Database Administrator's mind. However, users want to get up and running as soon as possible without complex login procedures.

You can learn more about this and many other topics in the MySQL for Database Administrator course.

For example, MySQL 5.6.6 introduced a new utility: mysql_config_editor, which makes secure access via MySQL client applications much easier to establish, while still providing a good measure of security.

The mysql_config_editor stores a user's authentication details in an encrypted login file called mylogin.cnf. This login file is readable and writable for the user who invokes the utility, and

  [Read more...]
If you use MySQL in the Amazon cloud, you need to ask yourself this question
+0 Vote Up -0Vote Down
Join 25,000 others and follow Sean Hull on twitter @hullsean. Are you serious about backups? If you’re just using Amazon EBS snapshots, that may not be sufficient. There’s a good chance it won’t protect you against your next data loss. That’s why I like to have a few different types of backups Also: 5 more […]
MySQL Utilities Make a DBA More Efficient and Productive
Employee_Team +0 Vote Up -0Vote Down

MySQL Utilities provide a collection of command line utilities that make it easy for database administrators to maintain and administer MySQL servers. The utilities perform a range of otherwise complex operations via a simple command, making DBAs more efficient and productive.

There are utilities for copying databases, comparing databases running on different servers, checking disk usage and for redundant or duplicate indexes, automatic failover, verifying replication configuration, cloning a running server, and working with audit logs. You can use all these utilities either standalone or with MySQL Workbench.

You can learn about MySQL Utilities and much more by taking the

  [Read more...]
DBAs, Learn about MySQL Where You Want, When You Want
Employee_Team +0 Vote Up -0Vote Down

If you have a busy schedule or too much going on to attend a live training session, Training-on-Demand is for you. With Training-on-Demand, you can watch recorded classroom sessions taught by top Oracle instructors and gain hands-on experience with a dedicated lab environment.

In viewing the classroom sessions, you access streaming lectures on your desktop or tablet, with the ability to fast-forward, pause, rewind and search.

MySQL for Database Administrators is available as training-on-demand. This course is designed for DBAs and other database professionals. Learn to configure the MySQL Server, set up replication and security, perform database backups and

  [Read more...]
Demonstrate Your Expertise with MySQL 5.6 Certifications
Employee_Team +2 Vote Up -0Vote Down

Demonstrate your expertise with MySQL 5.6, and improve your career prospects, by taking the new MySQL 5.6 certifications:

These certifications give you a competitive advantage, by proving you have a skill set that is in demand, worldwide, while demonstrating your commitment to continuous learning.You can sign up now for these certifications via PearsonsVue.

To pass these certifications you need to have a good knowledge of the relevant areas of MySQL and

  [Read more...]
Cleanup a MySQL Schema
+0 Vote Up -0Vote Down

My students required way to remove all their tables, views, and constraints from a MySQL database (or the alias schema). Since they’re using referential or foreign key constraints, I also wrote one procedure to drop all foreign key constraints from a database. There’s also another to drop views. The final stored procedure calls the procedure that drops foreign keys, then calls the procedure to drop views before dropping all the tables.

Here’s the dropForeignKeys stored procedure:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
-- Provide a log file debugging statement.
SELECT 'DROP PROCEDURE IF EXISTS dropForeignKeys';
 
-- Conditionally drop
  [Read more...]
How Important is the Performance of Your Database
Employee_Team +0 Vote Up -0Vote Down

Whether you are a database administrator, database application developer, web developer, system administrator or system architect, if you are working with a database system such as the MySQL Server, you will want to ensure the best possible performance. 

To learn about the great performance you can get from a MySQL Database, visit Dimitri's blog.

If you have experience maintaining a database server, can use MySQL tools and have knowledge of general SQL statements and SQL tuning principles, consider taking the MySQL Performance Tuning course. In this 4-day instructor-led course, you will learn about:

  • What to tune and why
  [Read more...]
Enhancing pt-kill to Better Protect your Servers
+2 Vote Up -0Vote Down
I believe in automation as much as possible, and I'm always working to make the day to day tasks of operations as smooth as possible.  Also I try not to be afraid to take good tools and make them better.

Here in Database Ops at Box, we use pt-kill running as a service to constantly monitor our servers and help protect against long running queries.  But our thresholds are pretty generous, and in some cases it's possible for unforeseen circumstances to cause enough queries to storm the database such that we can have problems before any of them hit the threshold for "busy time."  Ditto for idle connections.

The response is that someone has to be available to manually run another copy of pt-kill with much lower thresholds to clear out these thundering herds.  But what if we could let pt-kill handle both the "normal" mode and still protect



  [Read more...]
Improve Your DBA Career Prospects with MySQL Database Administrators Training
Employee_Team +0 Vote Up -0Vote Down

MySQL DBA skills are highly sought after in the market place. The MySQL for Database Administrators course is a highly popular course created by the MySQL experts to give you hands-on experience with tasks ranging from installing MySQL to investigating different replication scenarios and planning for disaster recovery.

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

  • Live-Virtual Event: Take this class from your own desk - no travel required. Choose from a selection of events on the schedule to suit different timezones.
  • In-Class Event: Travel to an education center to take this class. Below is a selection of the events already on the schedule for this course.

  [Read more...]
Get MySQL 5.6 Certified at a Much Reduced Price
Employee_Team +1 Vote Up -0Vote Down

You have already heard the great news that you can now prove your knowledge of MySQL Server 5.6 with the new MySQL certification exams:

Until December 21th 2013, these exams are beta phase so you get a fully-fledged certification at a much reduced price; for example $50 in the United States or 39 euros in the euro zone.

There is a lot of excitement around these new

  [Read more...]
Join Those Adopting the MySQL 5.6 Database
Employee_Team +0 Vote Up -1Vote Down

MySQL Server 5.6 has seen fast adoption - the list of performance improvements and features make a convincing argument all on their own.

Join those adopting the MySQL database by taking the MySQL for Database Administrators training course.

This 5-day course teaches you all the core dba skills including what MySQL Server 5.6 brings you in terms of Replication (http://www.mysql.com/products/enterprise/replication.html). You will learn about:

  • Managing the MySQL Binary Log
  • MySQL replication threads and files
  • Using MySQL Utilities for Replication
  • Designing Complex Replication Topologies
  • Multi-Master and
  [Read more...]
Flaghip Course of the Authentic MySQL Curriculum
Employee_Team +0 Vote Up -0Vote Down

The MySQL for Database Administrators training course is the flagship course of the authentic MySQL curriculum.

To bring this 5-day, instructor-led course to the largest number of students at their convenience, this course is not only available at a wide-selection of locations around the world, but also through two delivery methods where there is no travel required:

  • Training-on-Demand: Take this course from your own desk at your own pace, following lecture material through streaming video and setting your own schedule to perform lab exercises.
  • Live-Virtual Class: Attend a live class from your own desk.

In addition to these

  [Read more...]
New MySQL Certification Exams
Employee_Team +1 Vote Up -0Vote Down

Want to prove your expertise with MySQL? Why not get certified.

Oracle has just announced the release of the new MySQL Certification Path including the:

You can register for these certification exams from today. Learn more about these certifications on the Oracle University blog.

Successful candidates will require a strong MySQL experience. Although

  [Read more...]
MySQL Number One Skill for Linux Careers
Employee_Team +3 Vote Up -0Vote Down

MySQL is the number one IT skill demanded for Linux related jobs and continues to grow in importance according to the Linux Careers IT Skills Watch update 2013. So boost your career with the authentic MySQL Curriculum.

During the top selling course, the MySQL for Database Administrator, you will learn to install MySQL products, partition data, check and repair tables, perform backups and configure replication, create secured users and enable SSL security, and much more.

You can take this instructor-led course as a:

      [Read more...]
    Becoming an Expert MySQL DBA Across Five Continents
    Employee_Team +1 Vote Up -0Vote Down

    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

     Location

     Date

      [Read more...]
    Get the Best from Web, Cloud, and Embedded Applications as a MySQL DBA
    Employee_Team +1 Vote Up -0Vote Down

    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.
      [Read more...]
    Wide Selection of MySQL DBA Training Events
    Employee_Team +1 Vote Up -0Vote Down

    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:
      [Read more...]
    Saving $1,100 Simply by Clicking Faster – Collaborate 13 IOUG Forum Discounts exp. 3/6/2013
    +0 Vote Up -0Vote Down
    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
    Employee_Team +6 Vote Up -0Vote Down

    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 Vote Up -0Vote Down
    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
    Employee_Team +5 Vote Up -0Vote Down

    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

      [Read more...]
    Gain MySQL Database Administrator Skills to Access Top Data Jobs
    Employee_Team +0 Vote Up -0Vote Down

    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:
      [Read more...]
    The Queen of Evil is back … and she wants your MySQL database skills!
    +6 Vote Up -5Vote Down

    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

    Customisable Graphs for MySQL Database Administration in AWS & Dev Release for On-premise Administration Console
    +0 Vote Up -1Vote Down

    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
      [Read more...]
    Develop DBA skills with MySQL for Database Administrators course
    Employee_Team +2 Vote Up -1Vote Down

    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 Vote Up -0Vote Down

    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 Vote Up -4Vote Down

    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

      [Read more...]
    Meet The MySQL Experts Podcast: MySQL Utilities
    Employee_Team +5 Vote Up -0Vote Down

    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...]
    Showing entries 1 to 30 of 103 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.