With tons of new No-SQL database offerings everyday, developers & architects have a lot of options. Cassandra, Mongodb, Couchdb, Dynamodb & Firebase to name a few. Join 33,000 others and follow Sean Hull on twitter @hullsean. What’s more in the data warehouse space, you have Hadoop, which can churn through terabytes of data and get … Continue reading Will SQL just die already? →
So glad to have had a successful Percona Live last week. Continuent were Diamond Sponsors and now that we are back into a company and not part of VMware we have a little more freedom to get back into the MySQL community.
I had two primary sessions, both on the replicator/ But one was looking specifically at the replicator and how we get data into Big Data targets, the other on general problems of replicating between heterogeneous sources. After the first of those, David from Percona interviewed me to understand a bit more about what I was talking about
I was also on the keynote panel where we discussed a variety of different …[Read more]
Welcome to the second day of the Percona Live Open Source Database Conference 2017, and the second set of Percona Live keynotes! It’s a bit rainy outside today, but that isn’t bothering the Percona Live attendees (we’re all indoors learning about new open source technologies)!
Day two of the conference kicked off with another four keynote talks, all of which discussed issues and technologies that are addressed by open source solutions:
Paul Dix (InfluxData)
Paul Dix’s keynote may have ruffled a few feathers, as he looked at possible futures for the open …[Read more]
In this blog post, I’ll discuss some of my thoughts about the future of MariaDB after attending the M17 Conference.
Let me start with full disclosure: I’m the CEO of Percona, and we compete with the MariaDB Corporation in providing Support for MariaDB and other services. I probably have some biases!
Last week I attended the MariaDB Developers UnConference and the M17 Conference, which provided great insights into MariaDB’s positioning as a project and as a business. Below are some of my thoughts as I attended various sessions at the …[Read more]
Consider the scenario that you execute a query. You expect it to
be fast - typically subsecond - but now it take not return until
after 50 seconds (innodb_lock_wait_timeout seconds) and then it
returns with an error:
mysql> UPDATE world.City SET Population = Population + 999 WHERE ID = 130; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction
Note: …[Read more]
In my previous working environment it was typical to consider
MariaDB Server as just a set of "random" storage engines mixed
together, sometimes for unclear reasons and with questionable
extra value. But even at that times I was already impressed by
some features of one of the engines supported only by MariaDB,
CONNECT. PIVOT table type specifically was of
interest in a couple of customer cases I had to work on, but I
quickly found out that the engine does not work with Oracle's
MySQL or Percona Server, and thus had to forget about it for some
Recently while working in MariaDB I've got several more chances to deal with some new CONNECT use cases (and some related problems, that ended up mostly minor or caused by ignorance). This engine …
This Log Buffer Edition covers Oracle, SQL Server and MySQL.
Compiling views: When the FORCE Fails You
Goldengate 12c Troubleshooting XAGENABLE
A performance Deep Dive into Tablespace Encryption
EBS Release 12 Certified with Safari 10 and MacOS Sierra 10.12
Oracle Database 12c (220.127.116.11.0) on VirtualBox
When you see the above error , first thing come
into mind is
Is our tnsnames.ora file
is exist , if its there used connection string is
If you have it correctly and still
issue is persist .. Then whats happens everything is
1.First thing you have to check if
tnsnames is fine
you have password having '@' symbol
2.Then change it as below , you will be able to
load the millions of files into oracle
Make it useful
Welcome to another post in the series of Percona Live featured session blogs! In these blogs, we’ll highlight some of the session speakers that will be at this year’s Percona Live conference. We’ll also discuss how these sessions can help you improve your database environment. Make sure to read to the end to get a special Percona Live 2017 registration bonus!
In this Percona Live featured session, we’ll meet Luís Soares, Principal Software Engineer at Oracle. His session is The New MySQL Replication Features in MySQL 8 (with fellow presenter Lars Thalmann, Development Director at Oracle). The most popular high availability …[Read more]
This Log Buffer edition covers Oracle, SQL Server and MySQL blog posts with a touch of Cloud.
Provisioning EBS on Oracle Cloud: Latest Enhancements
ORA-54002 when trying to create Virtual Column using REGEXP_REPLACE on Oracle 12cR2
Business rules, common sense and query performance
Problem with V$RECOVERY_AREA_USAGE view and FRA space not being reclaimed
Updated …[Read more]