Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 618 10 Older Entries

Displaying posts with tag: database (reset)

Default users in MySQL 5.7
+0 Vote Up -0Vote Down

Among the many New features introduced by MySQL 5.7, we can notice a strong trend towards improving the server security by default. Two features stand out in this respect:

  • A password-less root is no longer the default for new installations. Unless you say otherwise, the default installers mysqld --initialize and the deprecated mysql_install_db will generate a random password which the user needs to change.
  • The anonymous …
  [Read more...]
MySQL-Docker operations. - Part 4: Sandboxes, virtual machines, containers.
+1 Vote Up -0Vote Down

Previous episodes:

We're …

  [Read more...]
MySQL-Docker operations. - Part 1: Getting started with MySQL in Docker
+2 Vote Up -0Vote Down

Docker is one of the fastest growing trends in IT. It allows fast deployment of services and applications on a Linux machine (and, with some limits, on other operating systems). Compared to other methods of deploying databases, such as virtual machines or application isolation, it offers faster operations and better performance.
Many people, surprised by the sudden advance of this technology, keep asking What is Docker? And why you should use it?
I will write soon an article with a …

  [Read more...]
MySQL 5.7 : Playing with mysqlpump
+1 Vote Up -0Vote Down

MySQL 5.7 comes with a new backup tool, named mysqlpump, which is almost the same as mysqldump with the ability of extracting data in parallel threads.

I tried a little experiment. Using a server containing 11 databases, with a total of 300 tables and about 20 million rows (roughly ≈ 10GB,) I used both mysqldump and mysqlpump to get a backup.

mysqldump --all-databases  > dump.sql
mysqlpump --all-databases \
--add-drop-database --add-drop-table --skip-watch-progress \
--default-parallelism=10 \ …

  [Read more...]
Improving Sakila database
+1 Vote Up -0Vote Down

The Sakila sample database was created almost 10 years ago, as a sample set of data for MySQL courses and examples.

The database was developed by MySQL employees, with substantial contributions form the community.

Recently, the database was updated to use some of the features in MySQL 5.7. As a result, we had two sets of samples, one to use with MySQL 5.0+, and one that only loads with MySQL …

  [Read more...]
Sample employees database migrated to GitHub
+0 Vote Up -0Vote Down

It's migration time. There was another project that I use often and was still in Launchpad. The Sample Employees Database is now on GitHub, under the same license it had before (CC A-SA 3).

Figure 1 - Employees database
This database is interesting because it is not too small (like Sakila) and not too big. It has enough data to allow you to test in a non trivial way.
Installation and testInstalling the database is easy:

$ git clone …

  [Read more...]
New! MySQL Connector/Arduino release-1.0.4 GA and Documentation
Employee +1 Vote Up -0Vote Down

After several iterations and a long period of community evaluation, I am happy to report I've released the newest, stable release of the MySQL Connector/Arduino. This library is designed to allow you to connect your Arduino via an Ethernet or WiFi shield to a MySQL database server running on your network (or the Internet!).

New Documentation!Best of all, I've written a reference manual that includes examples of how to use the connector in a variety of ways. Included in the document are advice on how to write your sketches, troubleshooting tips, and a long FAQ compiled from the many questions from my blogs.

Changes …

  [Read more...]
Yahoo at Percona Live
+0 Vote Up -0Vote Down

We had a great time meeting with folks from the industry and are excited about the innovations being pursued by the community and various companies. 

Videos of our keynote panel participation and talks are available now.

Percona Live 2015 Keynote Panel discussion - Ritesh Chhajer

High Availability using Percona XtraDB Cluster - Trey Raymond & Yashada …

  [Read more...]
Log Buffer #433: A Carnival of the Vanities for DBAs
+0 Vote Up -0Vote Down

This Log Buffer Edition covers Oracle, SQL Server and MySQL blogs of the running week.


  • While checking the sources of the Cassandra/NetBeans integration into GitHub yesterday, something went very badly wrong and ALL the source files in my Maven project that disappeared!
  • AWR Reports, Performance Hub, historisches SQL Monitoring in 12c
  • Oracle …
  [Read more...]
MySQL User Camp @ Bangalore on 26th June
Employee +1 Vote Up -0Vote Down

MySQL India team is back with another MySQL user camp.

The day of the week, time and venue remains the same:

Date: Jun 26th, 2015

Day : Friday

Time: 3-5:30 pm

Place: OC001, Block1, B wing, Kalyani Magnum Infotech Park, J.P Nagar, 7th Phase Bangalore, India

During our previous meetings we were requested by our attendees that they would like to hear about implementation of GTID by the MySQL community. We have listened to you and requested a community member to talk about their experience with the implementation of  GTID. Our first talk is :

  • MySQL Tools Usage in …
  [Read more...]
Showing entries 1 to 10 of 618 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.