Welcome to Planets9s, a weekly communication on all the latest resources and technologies that we create at Severalnines around automation and management of open source databases. I trust that these resources will be useful to you and would love to get your feedback on them.

Download our whitepaper on automation & management of open source databases

Whether you’re looking into ways to automate various aspects of administering your open source databases or to take better control of your data, this whitepaper covers what tools to build (or buy) for effective management, database deployment options beyond Chef or Puppet, important aspects of monitoring and managing open source database infrastructures and how ClusterControl enables a systematic approach to their operations.

Click here to …

Sometimes you need to get minimum key value of your array but you try to get with loop and any function etc but in bellow example you can see we can get smallest key value from our php array by using min and arraykeys So lets try to use in your code this waystrongExamplestrongpr

if you are work with large application which depend on large query and required large number of record at that time your application performence littel bit down that problem overcome with laravel Cache functionalityLaravel Cache provide to you store your large query in cache so your application

VividCortex is all about optimizing your queries. Many of our users asked us to analyse their queries, searching for common errors and mistakes.

It's true that there are some excellent tools out there to perform the same tasks, such as pt-query-advisor from the great Percona Toolkit. But having this information available right in our web application is something we always wanted to do, too. And today we released that!

Today we added Query Analysis to our Profiler tool, so as of now, you will have less trouble finding your bad queries. Query Analysis analyzes queries with heuristics. It can find bad application patterns, SQL bugs, and all kinds of other obvious and subtle issues.

The notifications count in the Profiler now …

This will be another post on using Percona Server via a Docker image. I want to follow up on my previous post regarding CPU/Network overhead in Docker “Measuring Percona Server Docker CPU/network overhead” by measuring  if there is any docker IO overhead on operations.

After running several tests, it appears (spoiler alert) that there is no Docker IO overhead. I still think it is useful to understand the different ways Docker can be used with data volumes, however. Docker’s philosophy is to provide ephemeral containers, but ephemeral does not work well for data – we do not want our data to disappear.

So, the first pattern is to create data inside a docker container. This …

This Log Buffer Edition covers blog posts from Oracle, SQL Server and MySQL for this week.

Oracle:

APEX shuttle item with one direction

Wondering about which tasks and work products are essential for your project?

Using Spark(Scala) and Oracle Big Data Lite VM for Barcode & QR Detection

Cloning 10.2.0.3 Oracle Home on fully patched 11.31 HP-UX hangs

An UNDO in a PDB in …

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.48 and MariaDB Connector/J 1.3.5. See the release notes and changelogs for details on these releases. Download MariaDB 5.5.48 Release Notes Changelog What is MariaDB 5.5? MariaDB APT and YUM Repository Configuration Generator Download MariaDB Connector/J 1.3.5 Release Notes Changelog About MariaDB Connector/J […]

The post MariaDB 5.5.48 and Connector/J 1.3.5 now available appeared first on MariaDB.org.

Performance Schema is a mechanism to collect and report run time statistics for running MySQL server. These statistics are stored-in and fetched-from internal memory buffers. In MySQL 5.6 GA, memory for these buffers is allocated during MySQL server startup with either user specified configuration values or with default values that autosize.…

Sometimes we need to set scroll bottom as default by using jquery in bellow example you can see i use scrollHeight for get the total height of scroll class div with scroll and at last i use animate with scrollTop attribute and set bottom So Basically when your page will load then automatically s

This is a repost of Otto Kekäläinen's blog of the MariaDB foundations work in 2015.

The mariadb.org website had over one million page views in 2015, a growth of about 9% since 2014. Good growth has been visible all over the MariaDB ecosystem and we can conclude that 2015 was a successful year for MariaDB.
Increased adoptionMariaDB was included for the first time in an official Debian release (version 8.0 "Jessie") and there has been strong adoption of MariaDB 10.0 in Linux distributions that already shipped 5.5. MariaDB is now available from all major Linux distributions including SUSE, RedHat, Debian and Ubuntu. Adoption of MariaDB in other platforms also increased, and MariaDB is now available as a database …