When you're testing out a new version of MySQL in a
non-production environment there is a temptation to go wild and
turn on all kinds of new features. Especially if you're
reading the changelogs or the manual and scanning through
options. You want to start with the most reasonable set of
defaults, right? Maybe you're even doing benchmarks to
optimize performance using all the new bells and whistles.
Resist the temptation! If your goal is to upgrade your
production environment then what you really want is to isolate
changes. You want to preform the upgrade with as little to
no impact as possible. Then you can start turning on
features or making changes one-by-one.
Why? Anytime you're doing a major upgrade to something as
fundamental as your core RDBMS, there are many ways things can go
wrong. Performance regressions & incompatible changes,
client/server incompatibilities …
The MySQL for Database Administrators training course is one of the most popular courses at Oracle. This is not surprising since it provides a comprehensive range of administration skills to those using the world's most popular open source database.
You can travel to an education center to take this 5-day instructor-led course, and as shown in the table below, events are currently scheduled for delivery in 8 languages (Arabic, Brazilian Portuguese, English, French, Hebrew, Italian, Spanish, Turkish).
If you want to take this training from your own desk, you have two options:
- Training-on-Demand: Start training within 24 hours of registration, following training at your own pace.
- Live-Virtual Event: Follow a live event …
August 25, 2014 By Severalnines
Are you going in production with Galera Cluster for MySQL? Here are 9 tips to consider before going live. These are applicable to all 3 Galera versions (Codership, Percona XtraDB Cluster and MariaDB Galera Cluster).
1. Galera strengths and weaknesses
There are multiple types of replication and cluster technologies for MySQL, make sure you understand how Galera works so you set the right expectations. Applications that run on single instance MySQL might not work well on Galera, you might need to make some changes to the application or the workload might not be appropriate. We’d suggest you have a look at these resources:
[Read more]
We've all heard the hype. MySQL 5.6 is packed with amazing
new features that address all our database problems. 5.6
deals with replication and HA and performance and monitoring and security and features. It just may cure cancer.
In fact it's been out for ages. It went GA …
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
- Training-on-Demand: Start …
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 …
[Read more]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 invisible to everyone else. You can use it to collect all your …
[Read more]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 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]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 performance tuning and protect MySQL …
[Read more]