Some application required one time zone to convert another time zone PHP provide some readymade timezone conversion classes but it a very complecated so we have try to define this function simple wayYou can createe a simple class and write one function into the class then you able to use thi

strongWhy remove query stringsstrongMain two reasons for this1 Clear URL alwaya look better than the long URL2 When you are not remove your query string from URL then all get variable show in you URL string sometime it not good for a security You can remove your query string using th

Whenever you require to use any image plugin for select image and cropresizeeffectsframesstrickers ect so you have to use Aviary api like as you see of facebook twitter ect that site plugin provide lots of efects and api guide that way you can use easily in your web app and as well as on mob

It was a long time since I updated mysqljsonimport or mysqljsonexport and I had a few things I wanted to do with them. This release is significant enough for me to bump it up to 2.0, and the same is in the works for mysqljsonexport. The one big thing that is now implemented is reasonably advanced support for MariaDB Dynamic Columns, and it is actually pretty flexible, allowing you to load a nested JSON object into a MariaDB Dynamic Column. But don't worry, it will still link and run with MySQL if that is what you want to do (but then you will not have the dynamic column features, for obvious reasons),

Download from Sourceforge as usual (yes, I know I am oldfashioned and that I should have put it on github). Also as usual is the documentation in pdf format that is also downloadable separately.

/Karlsson …

Let's look at how well MySQL and MariaDB support privileges (part of "access control" in standard terms), compared to other DBMSs, and consequences thereof.

Count the Privileges

I go to the DBMS manuals (here and starting here and here) and I count the privileges. This is like judging a town by the number of traffic lights it claims to have, but I'm trying to get an indicator for how granular the DBMS's "authorization" is.

Number of privileges listed in the manuals

MySQL/MariaDB  Oracle 12c     DB2 9.7   SQL Server 2014
31             240            52        124

Pretty …

This article is the follow-up on discussion started around MySQL 5.7 results on OLTP_RW Benchmark.. -- the point was about the impact of PERFORMANCE_SCHEMA (PFS) enabled, and InnoDB checksums on MySQL 5.7 performance within this OLTP_RW workload.

As promised, here are the results:

Just in case if the legend naming in graphs is not obvious :

• PS-off : "performance_schema=off" was used
• PS-def : "performance_schema=on" was used (default PFS instrumentation)
• chksum0 : "innodb_checksums=0" was used
• chksum1 : "innodb_checksums=0, innodb_checksum_algorithm=crc32" was used

OLTP_RW 1M x8-tables MySQL 5.7 (config: trx_commit=2 double_write=0) :


OLTP_RW 1M x8-tables MySQL 5.7 …

Sometimes you require to change date format in your laravel app we have to use Carbon class for change format in laravel because it provide many date function for like change date formate count diffrence between two dates in days etc So Basically i am going to show you change date format using

MySQL has supported the GET_LOCK() function for a large part of its history. As the manual notes, GET_LOCK() can be used to implement application locks or to simulate record locks.

Changes in MySQL 5.7

In MySQL 5.7 we improved GET_LOCK() to be based on our internal meta-data locking system (MDL).…

The Severalnines team is pleased to announce the release of ClusterControl 1.2.12.

This release contains key new features, such as support for the latest versions of MySQL, MariaDB, MongoDB & PostgreSQL, operational reports and enhanced backup options, along with performance improvements and bug fixes.

Highlights

• New for MySQL, MariaDB, MongoDB & PostgreSQL
  • Operational Reports
  • Local Mirrored Repositories
  • Enhanced Backup Options
• New for MySQL
  • Support for Oracle 5.7
  • New Replication Features for Master & Slave
  • Manage Garbd and MaxScale configurations
• New for MariaDB
  • Support for 10.1
  • SSL Encryption of Galera Replication Links …

This blog will address how the MariaDB Auditing Plugin can help monitor database activity to help with security, accountability and troubleshooting.

Why Audit Your Databases?

Auditing is an essential task for monitoring your database environment. By auditing your database, you can achieve accountability for actions taken or content accessed within your environment. You will also deter users (or others) from inappropriate actions.

If there is any bad behavior, you can investigate suspicious activity. For example, if a user is deleting data from tables, the admins could audit all connections to the database and all deletions of rows. You can also use auditing to notify admins when an unauthorized user manipulates or deletes data or that a user has more privileges than expected.

Auditing Plugins Available for MySQL

As Sergei Glushchenko said in a …