MySQL Server has an extensive collection of SQL modes which control a range of behavior ranging from compatibility modes for other RDBMS dialects (ANSI_QUOTES, PIPES_AS_CONCAT) to security (NO_AUTO_CREATE_USER) to explicit storage engine selection (NO_ENGINE_SUBSTITUTION) to restricting lossy implicit data conversions ( …
[Read more]
Feb
09
2016
Feb
09
2016
If you are working on php and you need to print your php variable inside the javascript then you can simple get value you can use for get value of php variable in following example you can see strongExamplestrongpre classcode languagehtmlltscript typetextjavascriptgtva
Feb
08
2016
This Log Buffer Edition arranges few tips and tricks from the blogs of Oracle, SQL Server and MySQL.
Oracle:
Oracle ® Solaris innovation is due in part to the UNIX® the standard (1), the test suites (2) and the certification (3). By conforming to the standard, using the test suites and driving to certification, Oracle ® Solaris software engineers can rely on stable interfaces and an assurance that any regressions will be found quickly given more than 50,000 test cases.
Building on the program established last year to provide evaluation copies of popular FOSS components to Solaris users, the Solaris team has announced the immediate availability of additional and newer software, ahead of official …
[Read more]
Feb
08
2016
Percona is glad to announce the second release candidate of Percona Server 5.7.10-2 on February 8, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories.
Based on MySQL 5.7.10, including all the bug fixes in it, Percona Server 5.7.10-2 is the current Release Candidate release in the Percona Server 5.7 series. All of Percona’s …
[Read more]
Feb
08
2016
Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories.
This is a Release Candidate quality release and it is not intended for production. If you want a high quality, Generally Available release, the current Stable version should be used (currently …
[Read more]
Feb
08
2016
Join us Tuesday, February 16, 2016 9:00am PST (UTC-8) for a webinar on the operational and monitoring features of MySQL 5.7 with Percona CEO Peter Zaitsev.
MySQL 5.7 is a great release, providing valuable features for both daily operations and ongoing development. In this, part two of our ongoing 5.7 webinar series, we will look into the new MySQL 5.7 features and enhancements that improve operations, with a specific focus on monitoring. These include:
- An improved optimizer, including updates to EXPLAIN and enhanced JSON support
- Performance and scalability improvements for the InnoDB storage engine, including temp tables, spatial types and full text search parsing …
Feb
08
2016
MySQL Replication is used in a variety of use cases - scale out read workloads, provide high availability and geographic redundancy, offload backups and reporting/analytic jobs. However it has a big drawback - the application needs to be able to send writes to the master only. Updating more than one master in a replication setup can result in data inconsistency and cause replication to break.
An SQL-aware load balancer like MaxScale could help here, as it could redirect SQL to the appropriate node. If you are using HAProxy and the application is written in PHP, read-write splitting is still achievable with the PHP MySQL native driver with master slave plugin (aka php-mysqlnd_ms). The driver can perform the …
[Read more]
Feb
08
2016
We will learn how to convert an image to its text representation
using PHP that can be used in an html page (if any such
requirement arises in your application or just for fun sake :)
).
The steps followed to convert the image to text representation
are:
1. Get the width and height of the image to be
converted.
2. Loop through every pixel value in the image.
3. At every pixel value, find the color at that
position.
4. Apply that color to a # symbol we use to represent that
pixel.
5. Finally we get the text representation of the image
represented by # (hashes).
Code:
<html>
<body style="background-color:
#000000;">
…
Feb
06
2016
In this post you can find how can use rakuten linkshare API in our php website first you need to create class for retrieve data from httpspubhelprakutenmarketingcomhcenus website now i give to example of product search but if you use this class then you can easy to implement your other
Feb
06
2016
MariaDB won the 2013 and the 2014 LinuxQuestions.org Members Choice Award Database of the Year, and is in the running again for 2015 winner. Up until 2012, MySQL held a near-monopoly on the title, having won every year since at least 2001 (except for 2002, won by PostgreSQL). Since 2013, however, it’s been all MariaDB, […]
The post MariaDB in the Running for 2015 LinuxQuestions.org Members Choice Database of the Year appeared first on MariaDB.org.