This is the third post in the series on Write Set in MySQL. In the first post, we explore how Write Set allows to get better parallel replication in MySQL 8.0. In the second post, we saw how the MySQL 8.0 improvement is an extension of the work done in MySQL 5.7 to avoid replication delay/lag in Group Replication. In this post, we will see how Write Set is used in Group Replication to detect
10 Older Entries »
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.
For more information about the authentic MySQL curriculum, go to …[Read 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]
The MySQL 5.6 certification exams (Developer and DBA) are now GA! A big thanks to all those who sat for the extended length beta exams – and subsequently waited for several months for your results. Your feedback and the data collected from many beta testers helped ensure the final exams are high quality. A huge thanks also goes to the MySQL staff at Oracle who produced, edited and verified exam questions, in addition to their normal job responsibilities. In particular, these exams would have never materialized …[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]
MySQL is an excellent choice for a low cost embedded database. Over 3,000 ISVs, OEMs and VARs choose MySQL for this purpose and benefit from significant cost savings when compared to using a competing database product.
The MySQL for Developers training course teaches you how to plan, design and implement applications using MySQL. Expert Oracle University instructors teach you through realistic examples, interactive instruction and hands-on exercises.
This course brings you lots of interesting facts. For example, the 'libmysqld' library is effectively a MySQL server in its own right. it is shipped as part of the standard MySQL installation. Developers with C/C++ ability can embed this library easily within their applications and it can do most of what a …[Read more]
Thousands of people have testified to the value of the Oracle Certification Program as follows:
- 97% said they have benefited from certification.
- 96% would recommend the program to a professional colleague.
- 89% said they gained more confidence in their expertise after becoming certified.
You have until December 21st to take the new MySQL Server 5.6 Certification exams in their beta form. A reminder of what is on offer:
- Oracle Certified Professional, MySQL 5.6 Developer
- Oracle Certified Professional, MySQL 5.6 Database Administrator
Until December …[Read more]
We are announcing the new MySQL for Developers course. This training:
- Takes advantage of both SQL and NoSQL
- Shows you how to plan, design and implement applications
- Brings you realistic examples, interactive instruction and hands-on exercises using Java and PHP
- Covers MySQL 5.6 features including optimizer improvements
- Helps you prepare for the MySQL 5.6 Developer certification.
You can take this course as a:
- Live-virtual event: Take this course from your own office; no travel required. You can choose from a selection of events on the …
Today when I was studying for the MySQL 5.6 exams.
I was studying for these two items:
- Create and utilize table partitioning
- Obtain MySQL metadata from INFORMATION_SCHEMA tables
The first step is to create a table, partition it with a hash.
mysql> CREATE TABLE pfoo (id INT AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255))[Read more]
-> PARTITION BY HASH(id) PARTITIONS 4;
Query OK, 0 rows affected (0.04 sec)
mysql> INSERT INTO pfoo(name) VALUES('test01'),('test02'),('test03'),('test04'),
Query OK, 11 rows affected (0.00 sec)
Records: 11 Duplicates: 0 Warnings: 0
mysql> SELECT * FROM pfoo;
| id | name |
| 4 | test04 |
| 8 | test08 |
| 1 | test01 |
| 5 | test05 …
10 Older Entries »