When i was working on my php project and i need to direct import mysql database in my phpmyadmin in Ubuntu 1404 system but my database size was 30MB so i cant upload my database thats why I need to change upload max file in phpini so try to find something how to change uploadmaxfilesize in

You can get location path of phpini file using phpiniloadedfile of PHP Sometimes we require to get phpini file path So if you need to get path of php confogration file then you can get following waystrongExamplestrongpre classprettyprint langphpprintrphpiniloadedfile

MariaDB 10.1 introduced Data at Rest Encryption. By default we provide a file_key_management plugin. This is a basic plugin storing keys in a file that can be itself encrypted. This file can come from a usb stick removed once keys have been brought into memory. But this remains a basic solution not suitable for security ...continue reading "MariaDB AWS Key Management Service (KMS) Encryption Plugin"

Thank you for the write up. I’m considering doing exactly what this article describes. Our developers are interested in setting up a mission critical JIRA instance for QA and bug tracking. This translates to 1000 active users and several million bugs (eventually).

You mention having 2000 active JIRA users. I was wondering if you could share additional infrastructure details about your JIRA instance. How large is the production DB in terms of disk space? What are you using to backup the DB (xtradump, mysqldump, SAN snapshot)?

I’ve previously evaluated MariaDB’s 10.1 implementation of data encryption at rest (https://www.pythian.com/blog/data-encryption-rest), and recently did the same for Oracle’s implementation (https://dev.mysql.com/doc/refman/5.7/en/innodb-tablespace-encryption.html) in their MySQL 5.7.

First, here’s a walkthrough of enabling encryption for MySQL 5.7:

1. Install keyring plugin.

1a. Add the following to the [mysqld] section of /etc/my.cnf:

View the code on Gist.

1b. Restart the server:

...
service mysqld restart

1c. Verify:

... …

When i was working on my php project and i need to direct import mysql database in my phpmyadmin in Ubuntu 1404 system but my database size was 30MB so i cant upload my database thats why I need to change upload max file in phpini so try to find something how to change uploadmaxfilesize in

Oh, there is a cool new feature added? And you are going to implement and use it?
Well, the brain of Bug lover is not working in that way, for me new feature is cool in terms of playing. It is a new place where hunt season is opened suddenly

Currently I am in Percona Live 2016 and you can catch me every time -> my name is some sort of pain to pronounce but you can just say Shako instead of Shahriyar.

Yesterday there was an interesting discussion about bug reports and in general what is a “Bug” and how i can identify that if it is a Bug or not?
Here are general rules:

1. Trust in yourself. If somebody says that, hey it is an expected behaviour, just do not believe. Go ahead and fill a report. Insist in your opinion at last it will be converted to DOC issue, pretty valid DOC Bug -> …

This Log Buffer Edition rounds up blog posts from Oracle, SQL Server and MySQL.

Oracle:

jq is a unix utility that can parse json files and pull out individual elements – think of it as sed/awk for json files.

Some thoughts about analyzing performance problems.

Microsites: Add a Map Component and Publish your Microsite

New Installation Cookbook: Oracle Linux 6.7 with Oracle 11.2.0.4 RAC

Are you worried about what to do now that …

In the earlier blogs in this series, we concluded that MaxScale with MariaDB Replication Manager still has some way to go as a failover solution.

The failover mechanism relied on MariaDB GTID, needed a wrapper script around the decoupled replication manager and had no protection against flapping. Since then, MaxScale and MariaDB Replication Manager (MRM) have received a couple of updates to improve them. For MaxScale, the greatest improvement must be the availability of the community edition repository.

Integration

Previously, to configure MaxScale to execute the MariaDB Replication Manager upon master failure, one would add a wrapper shell script to translate MaxScale’s parameters to the command line …

Today we are introducing a new MySQL Server feature called MySQL Document Store. Make sure to watch the announcement video on the MySQL YouTube Channel!

Find out more by looking into the following documents.

• Using MySQL as a Document Store – Manual
• X DevAPI – Tutorial for JavaScript
• X DevAPI – Tutorial for Python
• …