In this post, we’ll discuss how MySQL 5.7 handles the old temporal types during an upgrade.

MySQL changed the temporal types in MySQL 5.6.4, and it introduced a new feature: microseconds resolution in the TIME, TIMESTAMP and DATETIME types. Now these parameters can be set down to microsecond granularity. Obviously, this means format changes, but why is this important?

Are they converted automatically to the new format?

If we had tables in MySQL 5.5 that used TIME, TIMESTAMP or DATETIME are these fields are going to be converted to the new format when upgrading to 5.6? The answer is “NO.” Even if we …

Wed, 2016-04-27 14:20colin

While many are at the ongoing OpenStack Summit in Austin, it came to my attention that the OpenStack project has recently published their latest user survey. From there, it is clear that there is growth in the usage of MariaDB Server -- up 6 points from the previous survey. MariaDB Galera Cluster dropped by 1 point, but it's worth noting that in MariaDB Server 10.1, you're getting it all as an integrated download so it is quite likely that people are just referring to it as "MariaDB" now.

(Screenshot taken from the user …

We always need to dialog box in our project because modal is very interesting and specially for GUI Always we like to use modal for creating data or editing data and also for conformation So if you think how to set modal in my project then it is very easy you have to just copy bellow example and r

In this tutorial we are going to show you how to install Prosper202. Made by Tracking202, Prosper202 is a self-hosted application that lets you track and optimize all your marketing campaigns. It’s open source and easy to install on a Linux VPS. Follow the steps below to install Prosper202 on Ubuntu 14.04. The following are the minimum system requirements for Prosper202: – PHP version 5.4 or greater. – MySQL version 5.6 or greater. – MySQLi extension enabled in PHP Go ahead and connect to your server via SSH. The first thing you need to do is to upgrade all your […]

Thanks to everyone who participated in this week’s webinar on ‘Become a MongoDB DBA’! Our colleague Art van Scheppingen presented from the perspective of a MySQL DBA who might be called to manage a MongoDB database, which included a live demo on how to carry out the relevant DBA tasks using ClusterControl.

The replay and the slides are now available online in case you missed Tuesday’s live session or simply would like to see it again in your own time.

Watch the replay Read the slides

This was the first session of our new webinar series: ‘How to Become a MongoDB DBA’ to answer the question: ‘what does a MongoDB DBA do’?

In this initial webinar, we went beyond …

The most recent release of MySQL Server — 5.7.12 — ships with the X Plugin, which opens up an entirely new area of functionality: In addition to the classical relational approach to data management using SQL, MySQL can now also be used as a schemaless document store, something which is commonly referred to as a NoSQL database. In order […]

Wed, 2016-04-27 09:27colin

In a recent presentation by Balazs Pocze from Gawker Media LLC made clear that there are many automation strategies for server management that would be worth packaging up into an extended solution like MariaDB Enterprise.

Automation is good because there are way less "ops people" than "dev people" at many companies. Man-hours are expensive, so you don't want to waste them on routine tasks. Automated tasks also mean that there is a lot less possibility to make mistakes. "Everybody needs automation," says Pocze.

Gawker still uses physical infrastructure, powered by Linux, though there is some migration to the cloud. Cobbler is their Linux installation server of choice, where the hosts are defined, and there is no manual DHCP or DNS management; this tool not only …

A video session on "Intro to MySQL master slave Replication". Hope you enjoy it :)

Nowdays bootstrap is very famouse framework If you are macking design using bootstrap then you can easily use tooltip with better design If you think how to set right side tooltip or how to set left side tooltip or how to set top side tooltip and how to set bottom side tooltip then you can set e

If you need to check file is exixt or not on folder Normally we require to check image is exist or not video is exists or not etc In this example i use fileexists for determine file is available or not in given path So if you also need check then follow bellow examplestrongExamplestron