If you are use ckeditor for textarea and you need to fore ajax submit or form js submit but you cant find ckeditor value in your controller or php file So first you have to update field using CKEDITORinstances so you can try to following codepre classlanguagejavascriptfor instance i

We are glad to announce the new release of dbForge Studio for MySQL, v7.0.

We are glad to announce the release of the updated versions of dbForge Schema Compare for MySQL, v.4.0, dbForge Data Compare for MySQL, v5.0, and dbForge Query Builder for MySQL, v4.0. The tools come with support for MySQL 5.7, significantly redesigned user interface, redesigned Installation Wizard and other improvements to make your work more effective and comfortable.

This Log Buffer Edition covers Oracle, SQL Server and MySQL blog posts listing down few new tricks, tips and workarounds plus the news.

Oracle:

Displaying CPU Graphs For Different Time Ranges in Enterprise Manager

One of the cool things in 12c is that (finally after all these years) a sequence can be assigned as the default value for a column.

Jonathan Lewis demonstrates connect by after receiving an email.

Oracle 12c – PL/SQL “White List” via …

Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source databases.

Watch the replay: How to build scalable database infrastructures with MariaDB & HAProxy

You can now sign up to watch the replay of this week’s webinar with our partner WooServers - How CloudStats.me moved from MySQL to clustered MariaDB for High Availability. This webinar covered how CloudStats.me evaluated solutions from NDB Cluster to MySQL Replication with application sharding in order to scale MySQL write performance.  

Sign up to watch the replay.

MySQL Replication failover: Maxscale vs MHA (Parts …

In this post, the first one of a Maxscale series, I describe how to use MariaDB’s MaxScale and MySQL-utilities with MySQL Asynchronous replication.

When we talk about high availability with asynchronous replication, we always think about MHA or PRM. But if we want to transparently use the slave(s) for READs, what can we use ?

Description:

• Three MySQL servers, but one has very limited resources and will …

“Leading enterprises have a firm grasp of the technology edge that’s relevant to them. Better data analysis and disambiguation through semantics is central to how they gain competitive advantage today.”–Alan Morrison.

I have interviewed Alan Morrison, senior research fellow at PwC, Center for Technology and Innovation.
Main topic of the interview is how the Big Data market is evolving.

RVZ

Q1. How do you see the Big Data market evolving? 

Alan Morrison: We should note first of all how true Big Data and analytics methods emerged and what has been disruptive. Over the course of a decade, web companies have donated IP and millions of lines of code that serves as the foundation for what’s being built on top.  In the …

Sometime DBAs have to deal with problematic queries and cannot tackle the problem at the source (problematic queries from ORMs, third party apps,... or source unknown...). MySQL 5.7 provides a pre and post parse query rewrite APIs where users can write their own plug-ins. With the post-parse query plugin, you can rewrite problematic queries without the need to make application changes, add hints, modify join order...

For the past few years I've been writing and speaking about time-series storage, a problem inspired by what I help build at VividCortex and also my personal projects. I've been thinking about a related problem for much longer, but I haven't had to work on it until now: ranking.

At VividCortex, we have a new tool called the Profiler. It allows you to rank within various categories of metrics, like MySQL or OS metrics, by a dimension, like count. You can rank top processes by total CPU time or memory, MySQL queries by execution time, and so on. We can do this for arbitrary time ranges.

The ranking is performed on the sums of values within each time range. If we're ranking by CPU usage during a 300 second window, we look at the CPU usage measurements for each process at every second, sum those values up, and …

The "mysql_real_connect" function is used by MySQL clients, including multi-threaded clients,  to connect to a MySQL server.  The "mysql_real_connect" function is allowed to be run by concurrent threads without application level serialization.  Unfortunately, the thread sanitizer found a data race in the "mysql_real_connect" function when processing the …