Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now!

Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database technologies have implemented a number of approaches, and data compression is by far the most common and important. Compression in open source databases is complicated, and there are a lot of different approaches – each with their own implications.

In this talk we will perform a survey of compression in some of the most popular open source database engines including: Innodb, TokuDB, MongoDB, WiredTiger, RocksDB, and PostgreSQL.

Important information: …

If you are working with laravel and you need to setup gmail configration for send email if you want to set configration of gmail then first go to mailphp file you are work on laravel 4 and laravel 5 its not issue because you can set comman setting for both version of laravel framworkstrongM

The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend.

Percona Live is the premier event for the rich and diverse open source community and businesses that thrive in the MySQL and NoSQL marketplaces. Attendees include DBAs, sysadmins, developers, architects, CTOs, and CEOs representing organizations from industry giants such as Oracle to start-ups. Vendors increasingly rely on the conference as a major opportunity to connect with potential high-value customers from around the world.

Below are some highlights for the upcoming conference regarding the conference schedule, Tutorial sessions, Birds of a Feather talks, and Lightning talks.

Conference Schedule

Percona Live is packed with engaging sessions, helpful …

Error Message:
Error Code: 1215. Cannot add foreign key constraint
Example:
Error Code: 1215. Cannot add foreign key constraint
  Possible Reason: Case 1: MySQL storage engine. MySQL supports several storage engines, comparing features of the different mysql storage engines are given below. Note that only InnoDB storage engine supports foreign key, when you are using different mysql storage engine you may get the error code: 1215 cannot add foreign key constraint.

Case 2: Key does not exist in the parent table. When …

If you want to set vertical align middle text image div etc then you can set easily by using following example you can give vertical align middle by saveral way i also give you example with output you use any of the example of vertical align middle by css I also provide saveral example with di

FOSDEM is once again descending on the ULB in Brussels, and so again will there be a MySQL and Friends Devroom. Tradition calls for a MySQL and Friends Community Dinner, and we certainly aim not to disappoint this year!

Like last year, we’ll be renting the same private space to allow for easy socializing (at ICAB , more detailed directions below).

As such, prepare for an evening of food, drink and jolly conversation rivaling the great feasts of old. Disclaimer: Apart from jolliness, overindulgence on any account can not be blamed on the organizers of this event.

The …

If you are working on PHP or other PHP framework and you want to create array of another array value now you can see on following example how can you make array form another multidimensional array keys For example you have array like pre classlanguagephp multi array 1 ar

Most of you know, that it is possible to synchronize MySQL and MariaDB servers using replication. But with the latest releases, it is also possible to use more than just two servers as a multi-master setup.

Most of you know that both MySQL and MariaDB support replication in a hierarchical master-slave-setup, to propagate changes across all connected servers.

But with the latest releases, a slave can have more than one master.

The keyword: Multi-Source replication

It is supported from MySQL 5.7 and MariaDB 10.0 on, and this article describes how to set it up.

What does Multi-Source mean?

Multi-Source means, that you can take two or more masters and replicate them to one slave, where their changes will be merged. This works just like the regular MySQL/MariaDB …

Transport Layer Security (TLS, also often referred to as SSL) is an important component of a secure MySQL deployment, but the complexities of properly generating the necessary key material and configuring the server dissuaded many users from completing this task.  MySQL Server 5.7 simplifies this task for both Enterprise and Community users. …

In the previous releases of the Group Replication plugin for MySQL we introduced support for several operating systems like Mac OS X, Solaris, and FreeBSD. But why stop there? So here it is, the 0.7.0 version of Group Replication is now also available on Windows!…