Showing entries 11503 to 11512 of 44813
« 10 Newer Entries | 10 Older Entries »
Use Oracle 12c Preinstall RPM with CentOS 6.5

If you want to install Oracle 12c on EL6 Linux Systems there are many pre-install steps that you should do before actually begin the database installation.

For ease Oracle provide as name states RPM package: oracle-rdbms-server-12cR1-preinstall
But it is only for Oracle Linux from Oracle Public YUM Repo.
Ofcourse you can activate this repo without trouble but in fact problem of this RPM is dependency of Oracle Linux Kernel exactly UEK. Output:

Installing:
 oracle-rdbms-server-12cR1-preinstall    x86_64    1.0-8.el6                  /oracle-rdbms-server-12cR1-preinstall-1.0-8.el6.x86_64     37 k
Installing for dependencies:
 compat-libcap1                          x86_64    1.10-1                     base                                                       17 k
 compat-libstdc++-33                     x86_64    3.2.3-69.el6               base                                                      183 k
 kernel-uek …
[Read more]
Multi-Valued INSERTs, AUTO_INCREMENT & Percona XtraDB Cluster

A common migration path from standalone MySQL/Percona Server to a Percona XtraDB Cluster (PXC) environment involves some measure of time where one node in the new cluster has been configured as a slave of the production master that the cluster is slated to replace. In this way, the new cluster acts as a slave of the production environment – traditional replication takes care of getting the data into the cluster, and then Galera replication handles the intra-cluster traffic. This often works without issue, although there is one case that I’ve encountered recently where special care must be taken to properly configure the stream to ensure that replication does not break. If you use multi-valued inserts with auto-increment columns, then this post is for you.

For purposes of our discussion, assume that we have a basic 3-node PXC cluster that we’ve set up …

[Read more]
Discover the MySQL Central @ OpenWorld Tutorials

MySQL Central @ OpenWorld is only 20 days away! It is therefore time to start planning your conference, and Schedule Builder is a useful tool we recommend to use.

On Monday, September 29, you have the opportunity to attend MySQL tutorials. Each tutorial will last 2 hours and help you acquire in-depth knowledge on a number of MySQL topics. You will be able to choose from:

10:15 am - 12:15 pm

How to Analyze and Tune MySQL Queries for Better Performance
Øystein Grøvlen, Senior Principal Software Engineer, Oracle

Moscone South - 250

[Read more]
MySQL Community Reception at Oracle OpenWorld


Are you using or interested in learning more about MySQL? Are you attending Oracle OpenWorld and looking for an opportunity to meet and exchange ideas or experiences with MySQL users?

Join us on Tuesday, September 30, 2014 to celebrate the dynamics and growth of the MySQL community. Whether you are attending MySQL Central @ OpenWorld, a member of local MySQL user groups, a MySQL user in the Bay Area, or simply interested in MySQL technology, you're all invited to Oracle's MySQL Community Reception.

  • Mingle with your peers and learn from real-world experiences.
  • Talk to MySQL engineers face-to-face and get the first-hand information on the latest product development.

Time: Tuesday, September 30, 2014 @ 7:00 p.m. - 9:00 p.m.

Location: Jillian's at Metreon …

[Read more]
OurSQL Episode 199: Make It Fast

Podcasts Performance Query Optimization Server Tuning

This week, we discuss common MySQL performance tips.

OurSQL Episode 199: Make It Fast

Podcasts Performance Query Optimization Server Tuning

This week, we discuss common MySQL performance tips.

Announcing Severalnines Package Repository

September 9, 2014 By Severalnines

We are excited to announce the availability of YUM/APT repositories for ClusterControl, making new releases of ClusterControl  easily accessible using YUM or APT package managers. The repo is found at http://repo.severalnines.com, with instructions provided on the landing page. Our Cluster Configurators will be using these repositories. As a result, users upgrading from s9s_upgrade_cmon starting from version v.1.2.8 will be configured with the package repository.

 

ClusterControl requires extra post-installation setup steps, such as generating an API token, configuring cmon/dcps database schema, grant privileges on cmon schema, setting up SSL and so on. We provide a post-installation script for this purpose at [Apache document …

[Read more]
MySQL Connector/NET 6.9.3 GA has been released

Dear MySQL users,
MySQL Connector/Net 6.9.3 is the first GA release for the 6.9.x series of the .NET driver for MySQL. It can be used for production environments.
It is appropriate for use with MySQL server versions 5.5-5.7.
It is now available in source and binary form from http://dev.mysql.com/downloads/connector/net/#downloadsandmirrorsites (note that not all mirror sites may be up to date at this point-if you can't find this version on some mirror, please try again later or choose another download site.)
Enjoy and thanks for the support!
On behalf of the MySQL Connector/NET and the MySQL/ORACLE RE Team.

How to calculate the correct size of Percona XtraDB Cluster’s gcache

When a write query is sent to Percona XtraDB Cluster all the nodes store the writeset on a file called gcache. By default the name of that file is galera.cache and it is stored in the MySQL datadir. This is a very important file, and as usual with the most important variables in MySQL, the default value is not good for high-loaded servers. Let’s see why it’s important and how can we calculate a correct value for the workload of our cluster.

What’s the gcache?
When a node goes out of the cluster (crash or maintenance) it obviously stops receiving changes. When you try to reconnect the node to the cluster the data will be outdated. The joiner node needs to ask a donor to send the changes happened during the downtime.

The donor …

[Read more]
Pythian Hires Francisco Alvarez as Vice President of Asia Pacific

Alvarez will help deliver industry-leading database management services to the Asia-Pacific region

OTTAWA, Ontario — September 8, 2014 — Pythian, the global leader in data management consulting and services, today appointed Francisco Alvarez as Vice President, Asia Pacific to oversee the company’s regional expansion effort and deliver high-level database and data infrastructure support to an underserved region.

In his new role, Alvarez will oversee a team of more than 50 Pythian experts. Alvarez will be based out of Pythian’s Macquarie Park, Australia office and be responsible for extending Pythian services in major practice areas, including Oracle, MySQL, Microsoft SQL Server, big data, DevOps, and system administration. He will also manage all Pythian user groups in the Asia-Pacific region.

“In a career spanning more than two …

[Read more]
Showing entries 11503 to 11512 of 44813
« 10 Newer Entries | 10 Older Entries »