The MySQL team will be presenting three sessions at Percona Live in 2 weeks:
In addition, Tomas will be presenting a not-to-be missed keynote on how MySQL just keeps getting better.
Please stop by and introduce yourself! …
[Read more]
To my fondest community, the time is near where we will meet
again, share ideas and relax in each other's company at the MySQL
Community Dinner in London. In my last post I directed you to an
Eventbrite page to register for your seat at
the dinner and today I want to make you aware that the Conference
provider, Percona are going to facilitate some transport between
the conference venue and the restaurant. So I want to thank Tom
and Kortney for organising this for us. There will be room for 72
of us so it's your task not to be the 73rd person in the
line.
INSERT INTO BUS (SELECT community_member
FROM confirmed_attendees LIMIT 72);
Here are the details for the Community Dinner once again;
…
October 21, 2014 By Severalnines
Galera is a MySQL replication technology that can simplify the design of a high availability application stack. With a true multi-master MySQL setup, an application can now read and write from any database instance without worrying about master/slave roles, data integrity, slave lag or other drawbacks of asynchronous replication.
And that all sounds great until it’s time to go into production. Throw in a live migration from an existing database setup and devops life just got a bit more interesting ...
So if you are in devops, then this webinar is for you!
Operations is not so much about specific technologies, but about the techniques and tools you use to deploy and manage them. Monitoring, managing schema changes and pushing them in production, performance optimizations, configurations, version upgrades, …
[Read more]Thank you to the MySQL Community, on behalf of the MySQL team @ Oracle. Your bug reports, testcases and patches have helped create a better MySQL 5.6.21.
In particular:
Autumn is a season of MySQL-related conferences and I’m about to hit the road to speak and attend quite a few of them.
This week I’ll participate in All Things Open, a local conference for me here in Raleigh, N.C. and therefore one I do not have to travel for. All Things Open explores open source, open tech and the open web in the enterprise. I’ll be speaking on SSDs for Databases at 3:15 p.m. on Thursday, Oct. 23 and I’ll also be participating in a book signing for the High Performance MySQL Book at 11:45 p.m. at the …
[Read more]MySQL 5.6 has seen a high level of adtoption. Now it the time to prove to your current or future employer your proficency in using MySQL Server by taking the MySQL 5.6 Database Administrator Oracle Certified Professional (OCP) certification exam.
If you previous passed the now retired MySQL 5 Database Administrator certifcation exam you can upgrade your certification by taking the MySQL 5.6 Database Administrator OCP. Reasons to upgrade your certification include that you:
The MariaDB project is pleased to announce the immediate availability of the following:
MariaDB 10.1.1 is an Alpha release.
Release Notes Changelog What is MariaDB 10.1?
…
[Read more]The MySQL Utilities are divided into five groups and this blog post covers the second group — General Operations. These include mysqldiskuseage, mysqlfrm, mysqlindexcehck, mysqlmetagrep, mysqlprocgrep, mysqluc, and mysqluserclone.
For checking the disk usage of your data, there is
mysqldiskusage. The following example is a on a fresh
install of 5.7.5 on Ubuntu.
mysqldiskusage --server=root:hidave@localhost -b -m
-i
[sudo] password for dstokes:
# Source on localhost: ... connected.
# Database totals:
+---------------------+-------------+
| db_name | total |
+---------------------+-------------+
| mysql | 13,851,103 |
| performance_schema | 721,458 |
| sakila | 31,865,975 |
| sys | 0 |
| world | 1,783,833 |
…
Upscene releases Database Workbench 5.0.4
Upscene Productions is proud to announce a new release of the
popular multi-DBMS development tool:
" Database Workbench 5 "
Version 5.0.4 introduces some small new features and a list of
fixes base on user feedback.
Version 5 added numerous improvements to existing tools and the
new, more consistent user interface is better than ever and works
fine under Wine on Linux.
Database Workbench now comes in multiple editions with different
pricing models, there's always a version that suits you!
"A few bugs popped up after the initial version 5 release, all
minor issues but also a lack of documentation showing in the
trial version. I'm proud of the team that thoroughly tested the
version 5 release", says Martijn Tonies, founder of Upscene
Productions. "The major …
Version 1.5 of the MySQL Utilities are divided into five groups — Database Operations, General Operations, High Availability Operations, Server Operations, and Specialized Operations.
The Database Operations are mysqldbcompare, mysqldbcopy, mysqldbexport, mysqldbimport, and mysqldiff.
mysqldbcopy is used to copy databases between servers (or clone them on the same server. The default is to copy (or clone) everything or the –exclude option to exclude an object, change the storage engine with –new-storage-engine, and locking of the source databse can be turned off with –locking. There is even a –rpl option to pass replication statements so the the new copy a clone of the source server or sync the new copy to the same master as that the slave used for the …
[Read more]
