JavaScript and MySQLLast time I looked at using the new MySQL Shell in JavaScript mode to access documents. I promised that I would look at indexes this time but a few folks wanted to see how to use the MySQL Document Store with Javascript -- the language not the MySQL Shell mode-- specifically with the Node.JS connector. And they ask for a very simple example. So Indexes in the future, Node.JS now.

So this is a simple on using the MySQL Document Store from Node.JS.

InstallDownload the Node.JS connector and then follow the very simple installation instructions. And use your OS's instictions for installing Node.JS.

The documentation on using the Node.JS Connector with the …

The Debian project has today announced their 9th release, code named “Stretch”. This is a big milestone for MariaDB, because the release team decided to ship and support only one MySQL variant in this release, and MariaDB was chosen over MySQL. This is prominently mentioned in the press release about Debian 9 and more information […]

The post Debian 9 released with MariaDB as the only MySQL variant appeared first on MariaDB.org.

This is a story about why it's a good idea to test and verify the behavior of new software releases, even if the change log says that a particular bug was already fixed.
Background MySQL 5.6 and 5.7 both support the following CREATE USER syntax:

CREATE USER 'user'@'host'
  IDENTIFIED BY 'password';

This syntax create a user with the default authentication plugin (mysql_native_password unless configured otherwise) and the password provided. The IDENTIFIED BY syntax is also supported for GRANT command.
Both major versions also support the following syntax:

CREATE USER 'user'@'host'
  IDENTIFIED WITH mysql_native_password AS 'hash_string';

The password hash for "passw0rd" is "*74B1C21ACE0C2D6B0678A5E503D2A60E8F9651A3", you might then expect that the effects of the …

This Log Buffer Edition encompasses few of the nifty blog posts from Oracle, SQL Server and MySQL.

Oracle:

Introduction to Oracle Big Data Cloud Service

Interpreting wpad.dat using jrunscript from JDK 8 to work out the right proxy.

Nice Trick to Get ADF LOV Description Text

Presentation: Dynamic Actions, Javascript, & CSS for APEX Beginners

E4 Session …

This Log Buffer Edition encompasses few of the nifty blog posts from Oracle, SQL Server and MySQL.

Oracle:

Introduction to Oracle Big Data Cloud Service

Interpreting wpad.dat using jrunscript from JDK 8 to work out the right proxy.

Nice Trick to Get ADF LOV Description Text

Presentation: Dynamic Actions, Javascript, & CSS for APEX Beginners

E4 Session …

Today we welcome Derek Downey to the show. Derek is the Practice Advocate for the OpenSource Database practice at Pythian, helping to align technical and business objectives for companies and clients. Derek has also been a presenter at Percona Live Conference. The Percona Live Open Source Database Conference is the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software. The conference has a technical focus with an emphasis on the core topics of MySQL, MongoDB, and other open source databases.

In this episode, Derek focuses on the core topics of MySQL, MongoDB, and other open source databases and he shares more insights from his experience at the Percona Live Conference. Percona Live is an opportunity to network with peers and technology professionals by bringing together accomplished …

Today we welcome Derek Downey to the show. Derek is the Practice Advocate for the OpenSource Database practice at Pythian, helping to align technical and business objectives for companies and clients. Derek has also been a presenter at Percona Live Conference. The Percona Live Open Source Database Conference is the premier event for the diverse and active open source database community, as well as businesses that develop and use open source database software. The conference has a technical focus with an emphasis on the core topics of MySQL, MongoDB, and other open source databases.

In this episode, Derek focuses on the core topics of MySQL, MongoDB, and other open source databases and he shares more insights from his experience at the Percona Live Conference. Percona Live is an opportunity to network with peers and technology professionals by bringing together accomplished …

Today i would like to share with you integration of jquery full calendar events crud operation using bootstrap php mysql exampleFullcalendar is jquery library that provide us to display calendar with events and more Fullcalendar js provide year month week and day calendar for displaying an

Today i would like to share with you integration of jquery full calendar events crud operation using bootstrap php mysql exampleFullcalendar is jquery library that provide us to display calendar with events and more Fullcalendar js provide year month week and day calendar for displaying an

Before explaining how you can improve the speed for performing point-in-time recovery, let’s recall what is Point-In-Time Recovery and how it’s usually performed.

Point-in-Time Recovery, PTR

Point-In-Time recovery is a technique of restoring your data until a certain point (usually until an event that you would like that has never happened).

For example, a user did a mistake and you would like to recover your data up to that mistake to revert its effects like a drop table or a massive delete.

The usual technique consists to restore the last backup and replay the binary logs up to that unfortunate “event”.

So, as you might have already realized, backups and binary logs are required

The main spread technique to replace those binary logs event is to use the `mysqlbinlog` command. However, depending on your workload, this process can be quick or slow, depending on how much data there …