Month: May 2016

Oracle Database 12c SQL Certification? Am I an Associate or Expert?

1024×768

Do
you know which exam you should take now that we just released the new Oracle
Database 12c SQL Certified Associate exam?

If not, use
this as a guide:

  1. This
    new exam
    1Z0-071 is a midpoint knowledge exam. It’s
    proctored, so its cost is the same as our other proctored exams. Pass this exam and get an Oracle Certified Associate badge.
  2. If
    you are already an Oracle Certified Expert having passed the 1Z0-047
    exam, there is no need to take 1Z0-071 too. The Oracle Certified Expert exam is harder and it covers a lot, so deep subject
    knowledge is needed to pass.
  3. If you’re not ready to attempt full certification, we have two SQL Fundamental exams; 1Z0-051
    for 11g and 1Z0-061 for 12c. They are not proctored so you don’t become Oracle
    certified after passing. They have a lower
    cost and are not as difficult.

Are you ready to become
an Oracle
Database 12c SQL Certified Associate
?

Test Your
Oracle Database 12c SQL skills with three practice exam questions
In Oracle
Magazine May-June 2016 issue.  See Inside OCP, to test your depth of knowledge of
SQL and how to use it with Oracle Database 12c

Ready to test?  Schedule your exam at http://www.pearsonvue.com/oracle/ and join the close to 2 million others who’ve become
Oracle certified!

Normal
0

false
false
false

EN-US
X-NONE
X-NONE

MicrosoftInternetExplorer4

/* Style Definitions */
table.MsoNormalTable
{mso-style-name:”Table Normal”;
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-priority:99;
mso-style-qformat:yes;
mso-style-parent:””;
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:”Calibri”,”sans-serif”;
mso-ascii-font-family:Calibri;
mso-ascii-theme-font:minor-latin;
mso-hansi-font-family:Calibri;
mso-hansi-theme-font:minor-latin;}

Database APIs – the rethink

Previos post: How to Speed up Database APIsIn a recent article on news hacker, I saw this post from Derek SiversThere, he talks about simplifying work and how the database has stayed the same through out the years, but his code and coding languages have changed many times.He recommends to put all the data-related logic (not business logic) in the database. Things like constraints, data quality functions as well as JSON outputs.I feel that this is similar idea to database APIs and now even MySQL 5.7 allows you to connect with JSON to it directly which may well remove the need to have a database API in some cases.In MySQL you cannot actually have this sort of data logic like you can in Postgres, because MySQL triggers are way too slow. The whole premise of MySQL and indeed all NoSQL databases is to make the database as dumb as possible. In fact, database APIs are usually written to make the API database agnostic and therefore as basic as possible so that you may one day move over to a better database if such a case arises.I agree with Derek that the database rarely changes and that data-logic, in an ideal world, should be in the database. This will not make the database a bottleneck. If for example, you write a stored procedure that dramatically saves data from being sent over the network that would be a good scenario. Versus sending a ton of data over the network and then processing it in your application which would actually take more time even if you try to parallel process it.The thing I am wondering, how would you keep this data-logic in MySQL anyway?Bite the bullet and use triggers?Or would you still use a database API, but either keep it close to the database server or give it some cache?Please comment your opinion below.

Changes in BI Server Cache Behaviour in OBIEE 12c : OBIS_REFRESH_CACHE

The OBIEE BI Server cache can be a great way of providing a performance boost to response times for end users – so long as it’s implemented carefully. Done wrong, and you’re papering over the cracks and heading for doom; done right, and it’s the ‘icing on the cake’. You

How to Install Nginx, PHP and MySQL (LEMP Stack) on OpenSUSE Leap 42.1

LEMP or Linux, Engine-x, MySQL, and PHP is a collection of software installed on the Linux operating system to get your PHP based web applications up and running on the fast Nginx web server. In this tutorial, I will show you how to install Nginx, MariaDB, and PHP-FPM on openSUSE leap 42.1. Then I will configure the OpenSUSE firewall with SuSEfirewall2 to allow access to the Nginx web server and show you how you can add a new virtual host configuration on the Nginx web server.

Press Release: Severalnines protects the UK insurance industry from risky bets

Fast, thorough database technology helps IIL handle over 100 million transactions a day
Stockholm, Sweden and anywhere else in the world – 31st May 2016 – Severalnines, the award-winning provider of database infrastructure management software, today announced its latest customer, IIL, a UK-based data and technology company. IIL specialises in providing pricing, fraud and compliance technology for insurance and credit providers.

Insurance providers rely on IIL to authenticate customer details by aggregating private, public and industry data throughout the whole insurance lifecycle from quote generation to claims management. This means IIL processes over 100 million transactions every day in real-time. It is therefore imperative the supporting databases can handle the volume, variety and velocity of data transactions.
To accommodate new customers and meet growth projections, IIL realised its existing service platform needed more capacity without sacrificing on performance. To meet the goal of having enough capacity for the next three years, database operations was made more complex with the addition of clustering, load-balancing and high-availability. IIL required an effective way to manage and monitor the clusters, as the previous approach was too manual and took away hours of valuable time a day from the IT team which could be spent on other projects.

After being recommended and trialled by the IT team at IIL, Severalnines’ ClusterControl platform was deployed within weeks to resolve the database challenges. ClusterControl now automates the management and monitoring of a number of clustered MySQL systems, which in total handle over 40 Terabytes of data. IIL can meet market expansion without compromising on database reliability and resilience.
Andy McCulloch, IT Manager at IIL, said: “The majority of our customers need to deliver online insurance quotes in real-time and this requires IIL to be as fast in providing customer checks. ClusterControl gives us detailed insight into our database clusters in an intuitive format. Now we can see what is really going on under the hood quickly without a lot of time to go through the logs. Automating database management saves us time in writing new code for checks and maintenance tools. If we need further optimisation in the future, we want to work with Severalnines again.”
Vinay Joosery, Severalnines Founder and CEO said: “There are two forces which are threatening to pull the insurance industry apart. At one end billions of pounds are lost every year due to fraud and non-compliance, whilst at the other end comparison websites are making it easier for customers to compare and buy policies in real-time and this reduces brand loyalty. IIL has a very important job in future-proofing the insurance industry by sharing reliable information and identifying risks such as fraud. Severalnines is glad to support IIL in a fast-moving insurance sector.”
About Severalnines
Severalnines provides automation and management software for database clusters. We help companies deploy their databases in any environment, and manage all operational aspects to achieve high-scale availability.
Severalnines’ products are used by developers and administrators of all skills levels to provide the full ‘deploy, manage, monitor, scale’ database cycle, thus freeing them from the complexity and learning curves that are typically associated with highly available database clusters. The company has enabled over 8,000 deployments to date via its popular online database configurator. Currently counting BT, Orange, Cisco, CNRS, Technicolour, AVG, Ping Identity and Paytrail as customers. Severalnines is a private company headquartered in Stockholm, Sweden with offices in Singapore and Tokyo, Japan. To see who is using Severalnines today visit, http://www.severalnines.com/company.
About IIL
IIL uses data and technology to deliver intelligence at key data driven decision points throughout the customer lifecycle in a variety of industries. . Launched in 2008, IIL’s data solutions enable our clients to deliver next generation products and services to their customers. Find out more.

Tags: clustercontrolMySQLdatabase managementhigh availabilityinsurance

How fall in love with Failing assertion: !m_fatal?

The story about real love.
Once upon a time there was a bug about resizing innodb buffer pool size online ->
#77564 which was fixed on version MySQL 5.7.9.
But you can not stop the real love. Suddenly she came up and truely surprised me,because I was recently freed from depression. And now the same thing is happening again. With MySQL 5.7.12 if you try to resize:
mysql> set global innodb_buffer_pool_size = 107374182400;
Query OK, 0 rows affected (0.01 sec)
2016-05-31 11:50:18 0x7f7926ba1740 InnoDB: Assertion failure in thread 140158317500224 in file ut0ut.cc line 935
InnoDB: Failing assertion: !m_fatal
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xef0a4b]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x7aef91]
/lib64/libpthread.so.0(+0xf100)[0x7f75f1ada100]
/lib64/libc.so.6(gsignal+0x37)[0x7f75f04ce5f7]
/lib64/libc.so.6(abort+0x148)[0x7f75f04cfce8]
/usr/sbin/mysqld[0x77f3ee]
/usr/sbin/mysqld(ib::fatal_or_error::~fatal_or_error()+0x2f8)[0x10c5ba8]
/usr/sbin/mysqld[0x11b1e46]
/usr/sbin/mysqld(hash0_create(unsigned long)+0x63)[0x11b2f73]
/usr/sbin/mysqld(ib_create(unsigned long, latch_id_t, unsigned long, unsigned long)+0x41)[0x11b0411]
/usr/sbin/mysqld(btr_search_sys_resize(unsigned long)+0x1d1)[0x10f0ec1]
/usr/sbin/mysqld(buf_pool_resize()+0xcfc)[0x110ccfc]
/usr/sbin/mysqld(buf_resize_thread+0x197)[0x110e5a7]
/lib64/libpthread.so.0(+0x7dc5)[0x7f75f1ad2dc5]
/lib64/libc.so.6(clone+0x6d)[0x7f75f058f28d]
Oh no please, stop it. She said no, I will appear again and again with different options -> #81654
If you try to start MySQL with maximum innodb_log_buffer_size=4294967295, you will see the same:
2016-05-31 11:50:18 0x7f7926ba1740 InnoDB: Assertion failure in thread 140158317500224 in file ut0ut.cc line 935
InnoDB: Failing assertion: !m_fatal
/usr/sbin/mysqld(my_print_stacktrace+0x3b)[0xef0a4b]
/usr/sbin/mysqld(handle_fatal_signal+0x461)[0x7aef91]
/lib64/libpthread.so.0(+0xf100)[0x7f7926780100]
/lib64/libc.so.6(gsignal+0x37)[0x7f79251745f7]
/lib64/libc.so.6(abort+0x148)[0x7f7925175ce8]
/usr/sbin/mysqld[0x77f3ee]
/usr/sbin/mysqld(_ZN2ib14fatal_or_errorD2Ev+0x2f8)[0x10c5ba8]
/usr/sbin/mysqld[0xf8469e]
/usr/sbin/mysqld(_Z8log_initv+0xdd)[0xf8e8dd]
/usr/sbin/mysqld(_Z34innobase_start_or_create_for_mysqlv+0x1fd2)[0x106e942]
/usr/sbin/mysqld[0xf38c45]
/usr/sbin/mysqld(_Z24ha_initialize_handlertonP13st_plugin_int+0x51)[0x7fa341]
/usr/sbin/mysqld[0xce3675]
/usr/sbin/mysqld(_Z11plugin_initPiPPci+0x620)[0xcea5a0]
/usr/sbin/mysqld[0x7a7efd]
/usr/sbin/mysqld(_Z11mysqld_mainiPPc+0x842)[0x7a9422]
/lib64/libc.so.6(__libc_start_main+0xf5)[0x7f7925160b15]
/usr/sbin/mysqld[0x79f255]
And for the next time do not mess up with real love.

Speaking in June 2016

I have a few upcoming speaking engagements in June 2016:

Nerdear.la – June 9-10 2016 – Buenos Aires, Argentina – never been to this event but MariaDB Corporation are sponsors and I’m quite excited to be back in Buenos Aires. I’m going to talk about the MySQL ecosystem in 2016.
SouthEast LinuxFest – June 10-12 2016 – Charlotte, NC, USA – I have a few talks here, a bit bummed that I’m going to be missing the speaker dinner, but I expect this to be another great year. Learn about MariaDB Server/MySQL Security Essentials, the MySQL ecosystem in 2016, and about distributions from the view of a package.
NYC MySQL Meetup – June 27 2016 – New York, USA – I’m going to give a talk on lessons you can learn from other people’s database failures. I did this at rootconf.in, and it was well received so I’m quite excited to give this again.
Community Open House for MongoDB – June 30 2016 – New York, USA – I’m going to give my first MongoDB talk at the Community Open House for MongoDB – My First Moments with MongoDB, from the view of someone who’s been using MySQL for a very long time.

So if you’re in Buenos Aires, Charlotte or New York, I’m looking forward to seeing you to talk all things databases and open source.

Codership Galera Cluster Webinar – Using Galera Replication to Create Geo-distributed Clusters on the WAN-June 9th

DescriptionIn this webinar, we will show the advantages of having a geo-distributed database cluster and how to create one using Galera Cluster for MySQL. We will also discuss the configuration and status variables that are involved and how to deal with typical situations on the WAN such as slow, untrusted or unreliable links, latency and packet loss. We will demonstrate a multi-region cluster on Amazon EC2 and perform some throughput and latency measurements in real-time.USA Time:  10-11 AM PDT (Pacific Standard Time), 9th of JuneSpeakers: Philip Stoev, Quality and Release Manager, Codership                    Sakari Keskitalo, COO, Codership REGISTER TO USA WEBINAR WITH THIS LINK                    EMEA Time:  11-12 AM EEST (Eastern European Standard Time), 9th of JuneSpeakers: Philip Stoev, Quality and Release Manager, Codership                    Sakari Keskitalo, COO, Codership REGISTER TO EMEA WEBINAR WITH THIS LINK                                                      

TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569