|Showing entries 1 to 30 of 100||Next 30 Older Entries|
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[Read more...]
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...]
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[Read more...]
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:
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:
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...]
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:
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:
In addition to these[Read more...]
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 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:
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.
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:
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:
You can take this course as a:
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...]
SELECT id FROM foo ORDER BY id LIMIT 10 OFFSET 1000;
SELECT id FROM foo WHERE id > 100000 ORDER BY id LIMIT 10;
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...]
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
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.
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:
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
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!
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...]
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...]
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.
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
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:[Read more...]
|Showing entries 1 to 30 of 100||Next 30 Older Entries|