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]
Demonstrate your expertise with MySQL 5.6, and improve your career prospects, by taking the new MySQL 5.6 certifications:
- Oracle Certified Professional MySQL 5.6 Database Administrator
- Oracle Certified Professional MySQL 5.6 Developer
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 significant hands-on …[Read more]
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.
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 the procedure. DROP PROCEDURE IF EXISTS …
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
- Monitoring, benchmarking and stress tools …
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 us from herds?
That's what we've done by adding a …
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.
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:
- Oracle Certified Professional, MySQL 5.6 Developer
- Oracle Certified Professional, MySQL 5.6 Database Administrator
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]
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. 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 Circular Replication …