Tue, 2016-04-19 11:56markusmakela

I was recently talking on the #mariadb channel on FreeNode and I got a question about the often overlooked PDF documentation generation. In this blog I will show how to create a set of PDF files of the MariaDB MaxScale's documentation - a good way to keep the documentation handy. I did this on Ubuntu 14.04, but it should also work on other platforms.

Installing Packages

Since we'll be configuring MariaDB MaxScale, we'll need to install a few dependencies for MariaDB MaxScale and also grab the MariaDB server tarball. We start by installing the following packages.

sudo apt-get install git build-essential libssl-dev libaio-dev ncurses-dev bison flex cmake perl libtool libcurl4-openssl-dev libpcre3-dev tcl tcl-dev

Then we'll get the MariaDB server tarball which contains all the required parts for MariaDB MaxScale and extract it into our home directory.

wget …

Today the first MariaDB 10.2 alpha popped up and for the first time there is support for window functions.

I'll describe what's been announced, what's been expected, comparisons to other DBMSs, problems (including crashes and wrong answers), how to prepare, what you can use as a substitute while you wait.

I assume some knowledge of what window functions are. If you'd prefer an introductory tutorial, I'd suggest reading articles like this one by Joe Celko before you continue reading this post.

What's been announced

The MariaDB sources are:

The release notes

The source code trees -- the feature tree up till now has been …

In Todays Social authentication is important to implement in website because nowdays most of the users or developer etc will connected with Social network like twitter facebook google gitbub etc So In this post i want to share with you how to do sign in with twitter and how to do sign up with

Percona is excited to announce the launch of Percona Monitoring and Management Beta!

Percona Monitoring and Management (PMM) is a fully open source solution for both managing MySQL platform performance and tuning query performance. It allows DBAs and application developers to optimize the performance of the Database Layer. PMM is an on-premises solution that keeps all of your performance and query data inside the confines of your environment, with no requirement for any data to cross the internet.

Assembled from a supported package of “best of breed” open source tools such as Prometheus, Grafana and Percona’s Query Analytics, PMM delivers results right out of the box.

With PMM, anyone with database maintenance responsibilities can get more visibility for actionable enhancements, realize faster issue resolution times, …

Sometimes we require to check the given argument or string is URL or not as specially i did need to check image column is url or not like i give you example how to do this If you also need to do this then you can use filtervarstrongExamplestrongpre classprettyprint langphpiffi

Mon, 2016-04-18 13:29martinbrampton

The MaxScale persistent connection feature has been available since version 1.3.0. It aims to reduce the load on the database servers in specific scenarios. Testing indicates benefits and feedback from live use has been positive.

A typical scenario where benefits will be obtained is a PHP web server application that uses a group of MariaDB databases to store information. HTTP is well known to be a connectionless protocol, and so each request from a browser is usually handled as a single invocation of a PHP program, which makes a fresh database connection and terminates it on completion. This is likely to happen in well under a second, many times per second. There are thus many instances of the relatively expensive operation of making a new database connection.

You might think that the obvious way to reduce this load is to use PHP persistent connections. But for a variety of technical …

The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.0. This is an alpha release. See the release notes and changelog for details on this release. Download MariaDB 10.2.0 Release Notes Changelog What is MariaDB 10.2? MariaDB APT and YUM Repository Configuration Generator Thanks, and enjoy MariaDB!

The post MariaDB 10.2.0 Alpha now available appeared first on MariaDB.org.

Whenever you require to get first element value then you can use bellow example I give you the way to get first element value in jquery So lets see following examplestrongExamplestrongpre classprettyprint langjsltscript typetextjavascriptgtbr var languages PHP

Laravel framework is awesome framework in todays Laravel provide sevaral good feature and thats why it is very popular framework in PHP Basically if we are work on big website project or ERP level project we always need to define some global variable like site title number of pagination footer

Whenever you require to get last element value then you can use bellow example I give you three way to get last element value in jquery So lets see following examplestrongExamplestrongpre classprettyprint langjsltscript typetextjavascriptgtbr var languages PHP