Finally I’ve decided to publish the slides about Galera Cluster that I’ve presented twice, at the internal Trivadis TechEvent conference past April and at the Linux Day 2013.
They are a little dated since the new Galera library 3.0 is out and it supports MySQL 5.6.
Hope you find them interesting.
Cheers
—
Ludovico
I’ve realized these days that the great list of articles by Oracle Alchemist does not contain any articles describing a little more in depth common roles and Users.
I’ve found these ones by Pete Finnigan and Bobby Curtis:
http://www.petefinnigan.com/weblog/archives/00001366.htm
http://dbasolved.com/2013/06/29/common-user-vs-local-user-12c-edition/
http://www.petefinnigan.com/weblog/archives/00001370.htm
But I would like to investigate a little more.
My test environment
Just to give you an idea, I have two PDBs (HR and HR2), each containing an HR schema.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 |
SQL> alter session set container=CDB$ROOT; Session altered. SQL> select NAME, CON_ID from v$containers; NAME CON_ID ------------------------------ ---------- CDB$ROOT 1 PDB$SEED 2 HR 3 HR2 4 4 rows selected. SQL> r 1* select username, con_id from cdb_users where username ='HR' USERNAME CON_ID ------------------------------ ---------- HR 4 HR 3 2 rows selected. |
Creating the common user
As already pointed by the existing articles, I can’t create a common user into the root container without the c## prefix, unless I’m altering the hidden parameter _common_user_prefix.
|
1 2 3 4 5 |
SQL> create user goofy identified by pippo; create user goofy identified by pippo * ERROR at line 1: ORA-65096: invalid common user or role name |
so I specify the correct prefix, and it works:
|
1 2 3 4 5 6 7 |
SQL> create user C##GOOFY identified by pippo; User created. SQL> grant create session, alter session to c##goofy; Grant succeeded. |
The user is common, so it appears in all the containers, I can check it by querying CDB_USERS from the root container.
|
1 2 3 4 5 6 7 |
SQL> select username, con_id from cdb_users where username like '%GOOFY%'; USERNAME CON_ID -------------------------------------------------- ---------- C##GOOFY 1 C##GOOFY 3 C##GOOFY 4 |
Creating the local user
Then I create also a local user into the HR PDB.
|
1 2 3 4 5 6 7 8 9 10 11 |
SQL> alter session set container=HR; Session altered. SQL> create user goofy identified by pippo; User created. SQL> grant create session, alter session to goofy; Grant succeeded. |
CDB_USERS scope
From the PDB I see only the users in the PDB scope:
|
1 2 3 4 5 6 |
SQL> select username, con_id from cdb_users where username like '%GOOFY%'; USERNAME CON_ID -------------------------------------------------- ---------- C##GOOFY 3 GOOFY 3 |
If I change to the root, I see the users valid into all the containers:
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> alter session set container=CDB$ROOT; Session altered. SQL> select username, con_id from cdb_users where username like '%GOOFY%'; USERNAME CON_ID -------------------------------------------------- ---------- C##GOOFY 1 C##GOOFY 3 C##GOOFY 4 GOOFY 3 |
Creating a common role
Do the roles obey to the same rules valid for the users?
|
1 2 3 4 5 6 7 8 9 |
SQL> alter session set container=CDB$ROOT; Session altered. SQL> create role country_reader; create role country_reader * ERROR at line 1: ORA-65096: invalid common user or role name |
Yes, they do! So, let’s create a common role with the C## prefix:
|
1 2 3 |
SQL> create role C##COUNTRY_ROLE container=ALL; Role created. |
It works, but if I try to create a common role into the root container only, I get an error:
|
1 2 3 4 5 |
SQL> create role C##REGIONS_ROLE container=current; create role C##REGIONS_ROLE container=current * ERROR at line 1: ORA-65094: invalid local user or role name |
And also if I try to create a local role into the root, I can’t:
|
1 2 3 4 5 |
SQL> create role REGIONS_ROLE container=current; create role REGIONS_ROLE container=current * ERROR at line 1: ORA-65049: creation of local user or role is not allowed in CDB$ROOT |
Note that the error ORA-65049 is different from the ORA-65096 that I’ve got before.
My conclusion is that the clause container of the create role and create user statements doesn’t make sense as you can ONLY create common users and roles into the root container and only local ones into the PDBs.
Creating a local role
Just as experiment, I’ve tried to see if I can create a local role with container=ALL. It doesn’t work:
|
1 2 3 4 5 6 7 8 9 |
SQL> alter session set container=hr; Session altered. SQL> create role REGION_ROLE container=ALL; create role REGION_ROLE container=ALL * ERROR at line 1: ORA-65050: Common DDLs only allowed in CDB$ROOT |
So I create the local role with container=current:
|
1 2 3 |
SQL> create role REGION_ROLE container=CURRENT; Role created. |
Now, from the PDB I can see the two roles I can access, whereas from the root I can see all the roles I’ve defined so far: the common role is available from all the PDBs, the local role only from the db where it has been defined, just like the users.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
SQL> select role, con_id from cdb_roles where role like '%COUNTRY%' or role like '%REGION%'; ROLE CON_ID ----------------------------------------------- ---------- REGION_ROLE 3 C##COUNTRY_ROLE 3 SQL> alter session set container=CDB$ROOT; Session altered. SQL> select role, con_id from cdb_roles where oracle_maintained='N'; ROLE CON_ID ----------------------------------------- ---------- C##COUNTRY_ROLE 1 C##COUNTRY_ROLE 4 C##COUNTRY_ROLE 3 REGION_ROLE 3 4 rows selected. |
Granting object privileges to the roles
From the root I can’t give grants on objects that reside in a PDB since I cannot see them: I need to connect to the PDB and give the grants from there:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SQL> grant select on hr.countries to C##country_role; grant select on hr.countries to C##country_role * ERROR at line 1: ORA-00942: table or view does not exist SQL> alter session set container=hr; Session altered. SQL> grant select on hr.countries to C##COUNTRY_ROLE; Grant succeeded. SQL> grant select on hr.regions to REGION_ROLE; Grant succeeded. |
Now, if I query CDB_TAB_PRIVS from the root, I see that the grants are given at a local level (con_id=3 and common=N):
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SQL> alter session set container=cdb$root; Session altered. SQL> select GRANTEE, OWNER, TABLE_NAME, PRIVILEGE, COMMON, CON_ID from cdb_tab_privs where owner='HR'; GRANTEE OWNER TABLE_NAME PRIVILEGE COM CON_ID -------------------- -------- ---------------- ------------- --- ---------- REGION_ROLE HR REGIONS SELECT NO 3 C##COUNTRY_ROLE HR COUNTRIES SELECT NO 3 2 rows selected. |
Granting common and local roles to commond and local users
From a PDB, I can grant local roles to local users or common users:
|
1 2 3 4 5 6 7 |
SQL> grant REGION_ROLE to goofy; Grant succeeded. SQL> grant REGION_ROLE to c##goofy; Grant succeeded. |
But I can’t grant a common role to a common user with container=all if I’m in a PDB:
|
1 2 3 4 5 |
SQL> grant C##COUNTRY_ROLE to c##goofy container=all; grant C##COUNTRY_ROLE to c##goofy container=all * ERROR at line 1: ORA-65050: Common DDLs only allowed in CDB$ROOT |
To grant the a common role to a common user I can decide either to:
|
1 2 3 4 5 |
SQL> grant C##COUNTRY_ROLE to c##goofy container=current; Grant succeeded. SQL> |
|
1 2 3 4 5 6 7 |
SQL> alter session set container=cdb$root; Session altered. SQL> grant C##COUNTRY_ROLE to c##goofy container=all; Grant succeeded. |
I can also grant locally both roles and system privileges to common users while connected to the root container: in this case the privileges are applied to the root container only. Finally having the clause container finally starts to make sense:
|
1 2 3 4 5 6 7 |
SQL> grant C##COUNTRY_ROLE to c##goofy container=current; Grant succeeded. SQL> grant select any table to c##goofy container=current; Grant succeeded. |
Verifying the grants
Ok, I’ve given the grants and I’ve never verified if they work, so far.
Let’s try with the select any table privilege I’ve given in the last snippet. I expect C##GOOFY to select any table from the root container and only HR.COUNTRIES and HR.REGIONS on the HR PDB bacause they have been granted through the two roles.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> connect c##goofy/pippo; Connected. SQL> select count(*) from APEX_040200.WWV_FLOW_TABS; COUNT(*) ---------- 609 1 row selected. SQL> connect c##goofy/pippo@node4:1521/hr ERROR: ORA-01045: user C##GOOFY lacks CREATE SESSION privilege; logon denied Warning: You are no longer connected to ORACLE. |
What’s the mess? When I’ve created the user c##goofy, I’ve granted create and alter session without the container=all:
|
1 |
SQL> grant create session, alter session to c##goofy; |
According to the documentation, the grant command uses container=current by default (common=N):
|
1 2 3 4 5 6 7 8 9 |
SQL> select * from dba_sys_privs where grantee='C##GOOFY'; GRANTEE PRIVILEGE ADM COM ------------------------------ ---------------------------------------- --- --- C##GOOFY SELECT ANY TABLE NO NO C##GOOFY ALTER SESSION NO NO C##GOOFY CREATE SESSION NO NO 3 rows selected. |
So, I need to give the grants commonly to let c##goofy connect to all the PDBs:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 |
SQL> grant create session, alter session to c##goofy container=all; Grant succeeded. SQL> select * from dba_sys_privs where grantee='C##GOOFY'; GRANTEE PRIVILEGE ADM COM ------------------------------ ---------------------------------------- --- --- C##GOOFY SELECT ANY TABLE NO NO C##GOOFY ALTER SESSION NO NO C##GOOFY CREATE SESSION NO NO C##GOOFY ALTER SESSION NO YES C##GOOFY CREATE SESSION NO YES 5 rows selected. |
Now I see that the grants give two distinct permissions : one local and the other common.
If I revoke the grants without container clause, actually only the local one is revoked and the user can continue to login. To revoke the grants I would need to check and revoke both local and common privileges.
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SQL> revoke create session, alter session from c##goofy; Revoke succeeded. SQL> select * from dba_sys_privs where grantee='C##GOOFY'; GRANTEE PRIVILEGE ADM COM ------------------------------ ---------------------------------------- --- --- C##GOOFY SELECT ANY TABLE NO NO C##GOOFY ALTER SESSION NO YES C##GOOFY CREATE SESSION NO YES 3 rows selected. SQL> connect C##GOOFY/pippo; Connected. |
After the first revoke statement, I can still connect to HR and verify that my select any table privilege doesn’t apply to the PDB as it’s local to the root container:
|
1 2 3 4 5 6 7 |
SQL> connect C##GOOFY/pippo@node4:1521/hr Connected. SQL> select count(*) from hr.DEPARTMENTS; select count(*) from hr.DEPARTMENTS * ERROR at line 1: ORA-00942: table or view does not exist |
After that, I want to check the privileges given through the local and common roles.
I expect both users to select from hr.countries and hr.regions since they have been granted indirectly by the roles.
Let’s try the local user first:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SQL> connect goofy/pippo@node4:1521/hr Connected. SQL> select count(*) from hr.regions; COUNT(*) ---------- 4 1 row selected. SQL> select count(*) from hr.countries; COUNT(*) ---------- 25 1 row selected. |
Yeah, it works as expected.
Now let’s try the common user:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SQL> connect c##goofy/pippo@node4:1521/hr Connected. SQL> select count(*) from hr.regions; COUNT(*) ---------- 4 1 row selected. SQL> select count(*) from hr.countries; COUNT(*) ---------- 25 1 row selected. |
It also work, so everything is ok.
Common and local grants, why you must pay attention
During the example, I’ve granted the C##COUNTRY_ROLE many times: locally to PDB, locally to the ROOT, commonly. The result is that I’ve flooded the grant table with many entries:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
SQL> alter session set container=CDB$ROOT; Session altered. SQL> select grantee, GRANTED_ROLE, COMMON, CON_ID from cdb_role_privs where grantee like '%GOOFY' order by GRANTEE, GRANTED_ROLE; GRANTEE GRANTED_ROLE COM CON_ID ------------------------------ ------------------------------ --- ---------- C##GOOFY C##COUNTRY_ROLE YES 4 C##GOOFY C##COUNTRY_ROLE YES 3 C##GOOFY C##COUNTRY_ROLE YES 1 C##GOOFY C##COUNTRY_ROLE NO 1 C##GOOFY C##COUNTRY_ROLE NO 3 C##GOOFY REGION_ROLE NO 3 GOOFY C##COUNTRY_ROLE NO 3 GOOFY REGION_ROLE NO 3 8 rows selected. |
Let’s try to clean things: for sure I don’t need the grant local to the root:
|
1 2 3 |
SQL> revoke C##COUNTRY_ROLE from C##GOOFY container=current; Revoke succeeded. |
Then I can choose between revoking the common privilege or the local one. Let’s try to remove the local one:
|
1 2 3 4 5 6 7 |
SQL> alter session set container=hr; Session altered. SQL> revoke C##COUNTRY_ROLE from C##GOOFY container=current; Revoke succeeded. |
I’ve removed the local one, but I have still the common one (I’m connected to the PDB so the entries from the other containers are not displayed):
|
1 2 3 4 5 6 7 8 9 10 |
SQL> select grantee, GRANTED_ROLE, COMMON, CON_ID from cdb_role_privs where grantee like '%GOOFY' order by GRANTEE, GRANTED_ROLE; GRANTEE GRANTED_ROLE COM CON_ID ------------------------------ ------------------------------ --- ---------- C##GOOFY C##COUNTRY_ROLE YES 3 C##GOOFY REGION_ROLE NO 3 GOOFY C##COUNTRY_ROLE NO 3 GOOFY REGION_ROLE NO 3 4 rows selected. |
I still have access to the tables as expected:
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
SQL> connect C##GOOFY/pippo@node4:1521/hr Connected. SQL> select count(*) from hr.countries; COUNT(*) ---------- 25 1 row selected. SQL> select count(*) from hr.regions; COUNT(*) ---------- 4 1 row selected. |
So, you must pay attention to a couple of things:
As always, I look for opinions and suggestions, feel free to comment!
🙂
—
Ludovico
During the MySQL Connect @ Open World, Oracle has announced the release of MySQL Enterprise Monitor 3.0.
I’ve had the chance to propose a POC on MEM 3.0 to a customer currently relying on MEM 2.3, so we set up a VM to make some tests on it. I want to share my very first experience with it.
The binaries
The binaries you can download from edelivery belong to the “base” 3.0.2 version. But the release 3.0.3 is available since November 1st: in order to get it you must download two patchsets from the My Oracle Support. (Patches & Updates).
So, as it is for Oracle RDBMS, now the new versions are released as patchsets that can be installed from scratch.
The installation
The installation of the new product is as straightforward as it was for the previous release. You can still choose between using an existent MySQL database or a new one created my the installer. The installation steps have not changed at all, so I won’t list them here.
If you’re new to MEM installations, just refer to the official documentation.
New vest
MEM3 comes with a new graphic vest, definitely more “Oracle style” and eye-candy. Globally I have to say that the experience is really improved. The overview page resumes well the overall availability, workload and alerts.
The new graph browser allows to choose the correspondent object from the left tree-view pane. You can see from the screenshot that now the agent collects data from the system and regroup the items differently, e.g. the filesystems are now separated objects belonging to the server.
New agent behavior
The new MySQL Enterprise Agent brings some benefits comparing to the old one. Now a single agent installation can monitor all database instances on the server and actively discover new ones.
When a new instance is discovered is not monitored by default: an event is raised so you can create an handle that sends you an email that reminds to enable the monitoring for that instance.
Other remarks
The Query Analyzer is now active by default for instances that have the performance_schema enabled.
Many new graphs are displayed by default providing great information on database statistics trends.
The Event Handling is simpler to manage IMO, but the only choices are still sending an email and/or an SNMP trap. I regret that it’s still impossible to take actions like hooking shell scripts or send WS calls.
The other functionalities are still present and basically unchanged.
Conclusion
Oracle have done a very good job in restyling everything. The new Enterprise Monitor dashboard is really responsive and I haven’t found bugs so far. But I have to say that there is still a lack of features that would make it really “enterprise ready”, such as a plugin mechanism that would allow to interact directly with common event management softwares like EM12c, Tivoli, Remedy or CA SM without relying on SNMP only. Also, it would be great to run actions directly when an event raises.
The POC however has been a complete success and we’ll start next week with the definitive migration! 🙂
According to Exadata consolidation guide, this is what you can consolidate on Oracle specialized Hardware:
NOTE: The maximum number of database instances per cluster is 512 for Oracle 11g Release 1 and higher. An upper limit of 128 database instances per X2-2 or X3-2 database node and 256 database instances per X2-8 or X3-8 database node is recommended. The actual number of database instances per database node or cluster depends on application workload and their corresponding system resource consumption.
But how many instances are actually beeing consolidated by DBAs from all around the world?
I’ve asked it to the Twitter community
I’ve sent this tweet a couple of weeks ago and I would like to consolidate some replies into a single blog post.
who has done more than this on a single server? $ ps -eaf | grep ora_pmon | wc -l 77 #oracle #consolidation
— Ludovico Caldara (@ludovicocaldara) October 25, 2013
My customer environment however, was NOT a production one. On the production they have 45.
Some replies…
@CacheFlush @kevinclosson @ludovicocaldara I know one customer with 58
— Bjoern Rost (@brost) October 25, 2013
@ludovicocaldara I have more 🙂 — Wissem El Khlifi (@orawiss) October 25, 2013
@ludovicocaldara ay cant believe it, think they removed some DBs, i have now 73. Ok u win 🙁 — Wissem El Khlifi (@orawiss) October 25, 2013
Wissem cores 73 on a production system, 1TB memory!
@ludovicocaldara about 150 TB of storage, 1TB memory, 40 Cores …
— Wissem El Khlifi (@orawiss) October 25, 2013
@ludovicocaldara we have at least 4 servers like this , big ones! 2 for prods …
— Wissem El Khlifi (@orawiss) October 25, 2013
Chris correctly suggests to give a try to the new 12c consolidation features:
.@ludovicocaldara a good playground for either threaded_execution=true or multitenant 😉
— Christian Antognini (@ChrisAntognini) October 25, 2013
Kevin, as a great expert, already experimented one hundred instances environment:
.@ludovicocaldara up to 100 instances/host when researching for this paper: http://t.co/sIAuvnDJ2D Proof point stayed much lower though
— Kevin (@kevinclosson) October 25, 2013
But Bertrand impresses with his numbers!
@ludovicocaldara Will give you the right number on Monday but I would say around 120 🙂
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
@ludovicocaldara Here is the exact number dude: ps -ef | grep -c ora_smon 131
— Bertrand Drouvot (@BertrandDrouvot) October 28, 2013
@BertrandDrouvot @ludovicocaldara damn your the winner, i can’t higher then 118 but this customer is still busy migrating more.
— Klaas-Jan Jongsma (@futureveterans) October 28, 2013
@ludovicocaldara capacity planning is a big challenge here with currently around 1800 databases and this is constantly increasing…
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
@ludovicocaldara @orawiss 1TB is our default as of a few months 🙂
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
Intel platform with 1TB of RAM = Xeon E7, suggests Kevin:
. @BertrandDrouvot @ludovicocaldara @orawiss so you standardize on Xeon E7 ?
— Kevin (@kevinclosson) October 25, 2013
@kevinclosson how did you guess ? 🙂 @ludovicocaldara @orawiss
— Bertrand Drouvot (@BertrandDrouvot) October 25, 2013
. @BertrandDrouvot @ludovicocaldara @orawiss because there are no 1TB EP offerings… at least not until after Haswell. Ivy EX does 12TB 🙂
— Kevin (@kevinclosson) October 25, 2013
Flashdba has seen 87 instances on a single host, but on a Multi-node RAC: but still huge and complex!
@ludovicocaldara @BertrandDrouvot @orawiss When I worked for Oracle I saw 87 instances on single a node – and it was six node RAC
— flashdba (@flashdba) October 25, 2013
@ludovicocaldara @BertrandDrouvot @orawiss It was a production system too – and yes, it was a nightmare!
— flashdba (@flashdba) October 25, 2013
@kevinclosson @ludovicocaldara @BertrandDrouvot @orawiss The cluster had around 120 DBs, not every database had an instance on every node
— flashdba (@flashdba) October 25, 2013
@kevinclosson @ludovicocaldara @BertrandDrouvot @orawiss The result was between 50 and 87 instances running per node #complicated
— flashdba (@flashdba) October 25, 2013
Conclusion
Does this thread of tweets reply to the question? Are you planning to consolidate your Oracle environment? If you have questions about how to plan your consolidation, don’t hesitate to get in touch! 🙂
—
Ludo
I’ve just noticed that my room mate at #OOW13 has been recognised as ACE Director.
It is my honour to announce that @ChrisAntognini have been finally recognised as Oracle ACE Director! Please join me to congratulate him 🙂
— Yury (@yvelik) November 1, 2013
Even if he was already a world-known performance specialist, this announcement makes me one more time proud to know him. Well deserved Chris! 🙂
In my previous post I’ve talked about some news from the Open World. Now it’s time to talk about MY week and why I’ve loved it…
It’s all about community involvement
The most exciting thing about the OOW is the possibility to interact with great people, bloggers, speakers, experts, and now I can also say friends. In the last decade, I’ve worked hard for customers and dealt with almost all the problems and architectures that an Oracle DBA can face, but I’ve always done few efforts for the community, sometimes because I was having no time, sometimes because I was perceiving it as time-expensive and gainless. I was wrong. It’s time-consuming, yes, but it lets me feel richer.
The first good news
When I’ve landed in the USA, the first mail I’ve read was the following:
Congratulations Bjoern. Bobby, Gokhan and Ludovico on being elected as RAC SIG Office bearers!!!
Vice President: Bjoern Rost
US Conference Events Chair: Bobby Curtis
Website Chair : Gokhan Atil
Regional Chair Europe: Ludovico Cadara
We look forward for you all to take us to the next level. I will include you on our board member email group.
Congratulations again!!
K.P.Singh
Current President, RAC SIG
We’ve made an official announcement on twitter recently:
Welcome new @RACSIG board members! @dbasolved @ludovicocaldara @gokhanatil. New energy! New projects! Community Win!
— Oracle RAC SIG (@racsig) October 23, 2013
So I’ve attended my first RAC SIG meeting at OOW13 at the OTN lounge.
RAC SIG meeting at OOW13
Now I’m weekly (or even daily) in contact with the board by e-mail, tomorrow we’ll have a conf-call to put the bases to work on for the next year. Wish us good luck! 🙂
RAC Attack 12c
Well, I’ve talked about the RAC ATTACK in my previous posts. The event has been a success, we’ve had many attendants, curious people and friends coming to do the lab or get in touch. It has been a great opportunity to collaborate with (and be praised by) several community experts including Oracle ACEs and ACE directors:
The Ninjas:
Seth Miller (@Seth_M_Miller)
Bjoern Rost (@brost)
Yury Velikanov (@yvelik)
Leighton Nelson (@leight0nn)
Bertrand Drouvot (@BertrandDrouvot)
Kamran Agayev (@KamranAgayev)
Martin Nash (@mpnsh)
Maaz Anjum (@maaz_anjum)
Hans Forbrich (@HansForbric)
Tim Hall (@oraclebase)
Ludovico Caldara (@ludovicocaldara) that’s me! 🙂
Other contributors and great people that worked on the project:
Laura Ramsey (@OracleDBDev)
Jeremy Schneider (@jer_s)
Osama Mustafa (@OsamaOracle)
Bobby Curtis (@dbasolved)
Alex Gorbachev (@alexgorbachev)
(If someone is missing please raise the hand!)
Visit the official facebook page for more information.
Also note that the RAC Attack will be present at the UKOUG Tech 2013 and RMOUG 2014, so don’t miss it if you plan to attend these conferences.
The Blogger Meetup
This meeting, organized by Pythian and OTN, allows to meet the most famous and active bloggers in the Oracle Community. This GREAT VIDEO from Björn Rost should give you an idea (I appear at 19”):
Here’s another one, always from Björn:
The Swim in the bay
Literally, a meetup of crazy guys willing to freeze themselves in the bay the early morning!
Chet Justice has organized this and he managed to get sponsorship for swim-caps and T-shirts 🙂 I’m the third from the left, you may recognize many famous people here 🙂
See the facebook page for more information.
Also for this event there is a video, actually I’m closing the video with a dive 🙂
The Golden Gate Run
Jeff Smith has organized this run Sunday morning, a good way to start the week and my first opportunity to meet many new friends!
Once again, see the Facebook page!
Other events
Well, I’ve participated also to the Friends of Pythian Party, the IOUG Party, the Oracle Swiss Partner Lounge, and had many nice evenings.
No, I haven’t attended the appreciation event: I was possessing the ticket but I’ve decided to skip it in favor of a dinner with many great people.
Networking and fun
See some pictures I’ve loaded on Flickr:
You can see the whole set here.
So why everything has changed?
Now I’m part of a community, I’m involved, I learn from others and I let others to learn from me… where applicable! 🙂 Interacting with people from all around the world let me feel stronger and more open to new challenges. And I know that if I have a dream is up to me to chase it and make it come true.
PS: This is an incomplete list of the people I’ve met (other than the RAC Attack contributors).
Make sure to follow them!
Vit Spinka (@vitspinka)
Vanessa Simmons (@pythiansimmons)
Riyaj Shamsudeen (@riyajshamsudeen)
Øyvind Isene (@OyvindIsene)
Carlos Sierra (@csierra_usa)
Gregory Guillou (@ArKZoYd)
Heli Helskyaho (@HeliFromFinland)
Marc Fielding (@mfild)
Jonathan Lewis (@JLOracle)
Fuad Arshad (@fuadar)
Chet Justice (@oraclenerd)
Tim Gorman (@timothyjgorman)
Mark W. Farnham (@pudge1954)
Kerry Osborne (@KerryOracleGuy)
Arjen Visser (@dbvisit)
Kyle Hailey (@kylehhailey)
Steve Karam (@OracleAlchemist)
Eric Grancher (@EricGrancher)
Arup Nanda (@arupnanda)
Kent Graziano (@KentGraziano)
Andrey Goryunov (@goryunov)
James Morle (@JamesMorle)
Christo Kutrovsky (@kutrovsky)
Brian Fitzgerald (@ExaGridDba)
Kellyn Pot’Vin (@DBAKevlar)
Karl Arao (@karlarao)
Jason Arneil (@jarneil)
Gustavo Rene Antunez (@grantunez)
Frits Hoogland (@fritshoogland)
Luca Canali (@LucaCanaliDB)
Chris Buckel (@flashdba)
Cary Millsap (@CaryMillsap)
Paul Vallee (@paulvallee)
Tanel Poder (@TanelPoder)
Connor McDonald (@connor_mc_d)
Gwen (Chen) Shapira (@gwenshap)
Christian Antognini (@ChrisAntognini)
Mauro Pagano (@Mautro)
Jérôme Françoisse (@JeromeFr)
Ittichai (@ittichai)
Jeff Smith (@thatjeffsmith)
Michelle Malcher (@malcherm)
Debra Lilley (@debralilley)
Doug Burns (@orcldoug)
I’m back at work now, safely, after the week in San Francisco.
It’s time to sit down, and try to pull out some thought about what I’ve experienced and done.
I’ll start from the new announcements, what is most important for most people, and leave my personal experience for my next post.
In-memory Database Option
Oracle has announced the In-Memory option for the Oracle Database. This feature will store the data simultaneously in traditional row-based and into a new in-memory columnar format, to serve optimally both analytics and OLTP workloads AT THE SAME TIME. Because column-based storage is redundant, it will work without logging mechanism, so the overhead will be minimal. The marketing message claims “ungodly speed”: 100x faster queries for analytics and 2x faster queries in OLTP environments.
By separating Analytics and OLTP with different storage formats, the indexes on the row-based version of the table can be reduced to make the transactions faster, getting the rid of the analytical indexes thank to the columnar format that is already optimized for that kind of workload. The activation of the option will be transparent to the applications.
How it will be activated?
|
1 2 3 |
inmemory_size = XXX GB alter table foo ... inmemory; |
Now my considerations:
M6-32 Big Memory Machine
I’ve paid much less attention for this new announcement. The new big super hyper machine engineered by Oracle will have:
This huge memory machine can be connected through InfiniBand to an Exadata to rely on its storage cells.
But it will cost 3M$, so it’s not really intended for SMBs or for the average DBA, that’s why I don’t care too much about it…
Oracle Database Backup, Logging, Recovery Appliance
Only 8 minutes in the keynote to introduce this appliance that is really hot, IMHO. This… oh my… let’s call it ODBLRA, is a backup appliance (based on the same HW of Exadata) capable of receiving the stream of redo logging over SQL*Net, the same way as it’s done with DataGuard, except that instead of having a standby database, you’ll have an appliance capable of storing all the redo stream of your entire DB farm and have a real-time backup of your transactions. That’s it: no transactions lost between two backup archives and no need to have hundreds of DataGuard setups or network filesystems as secondary destinations in order to make your redo stream safer.
I guess that it will host an engine RMAN-aware that can create incremental-updated backups, so that you can almost forget about full backups. You can leverage an existent tape infrastructure to offload the appliance if it starts getting full.
Your ODBLRA can also replicate your backups to an another appliance hosted on the Oracle Cloud: ODBLRAaaS! 🙂
To conclude, Oracle is pushing for bigger, dedicated, specialized SPARC machines instead of relying on commodity hardware…
Oracle Multi-tenant Self-Service Provisioning
There’s a new APEX application, now in BETA, that can be downloaded from the Oracle Multitenant Page that provides self-service provisioning of databases in a Multitenant architecture. It’s worth a try… if you plan to introduce the Multitenant option in your environment!
All products in the Cloud
Oracle now offers (as a preview) its Database, Middleware and Applications as a Service, in its public cloud. For a DBA can be of interest:
The Storage aaS, use Java & REST API (Openstack SWIFT) for block level access to the storage.
The Computing aaS allows you to scale the computing power to follow your computing needs.
The Database aaS is the standard, full-featured Oracle Database (in the cloud!) 11gR2 or 12c in all editions (SE, SE1, EE). You can choose five different sizes, up to 17cores and 256Gb of RAM, and choose 3 different formulas:
My considerations:
Oracle on Azure
Microsoft starts offering preconfigured Oracle platforms, Database and WebLogic, on Azure on both Linux and Windows systems. I haven’t seen the price list yet, but IMHO Azure has been around since longtime now, and it appears as a reliable and settled alternative comparing to Oracle Cloud. Nice move Microsoft, I think it deserves special attention.
Keynotes recordings
You can see the full keynote recordings here:
Oracle OpenWorld Keynote Highlights
Larry Ellison — Oracle OpenWorld Keynote 9-22-2013
Oracle OpenWorld General Session 2013: Database
Kurian and Fowler — Oracle OpenWorld Keynote 9-24-2013
Will these announcements change your life? Let me know…
…and stay tuned, I’ll come soon with a new post about the my “real” week at the Open World and why I’ve loved it.
Ludovico
One of the new features of Oracle 12c is the new is the MySQL C API implementation for Oracle, so that all applications and tools built on this API can use transparently a MySQL or an Oracle database as backend.
API Reference for Oracle MySQL Client Library Driver
Oracle says that this will facilitate the migration from MySQL to Oracle, but I ask myself: Won’t be attractive for many developers to start developing applications with the MySQL API rather than with the Oracle libraries? This can potentially permit new applications to be migrated quickly in the opposite direction… (Oracle -> MySQL).
Time will tell.
Ludo
I’ve decided to write about how I’ve got my OCP 11g certification. Why? It’s not always clear that the step order indicated by the official Oracle Certification pages is not mandatory, and that it can be changed to better fit your needs.
What the Certification pages states
According to the page, you should go through the steps in the following order:
What you can do
Actually, you can go through the steps in any order, and get your result when all the required steps have been completed
My goal was to achieve the OCP certification first and then get the OCE Performance and Tuning. Since I was longtime and largely prepared for the OCP, I’ve decided to change my path as follows:
By doing it this way, I’ve been able to get the Perf&Tuning exam just after the specific training.
For any question, just contact the Oracle University, they will clarify any doubt about the possible paths.
Note: the P&T training I’ve taken is no more valid for the OCM path since I’ve already submitted it for the OCP. If you plan to do the same you’ll need TWO additional trainings in order to get the OCM.
Hope it helps
Ludovico
You’re going to head at OOW this year. Your count down has started and you feel excited about that.
Have you planned carefully your AGENDA? If you’re a RAC geek and you’re not going to attend #RACAttack, the answer is NO!! 🙂 This year the RAC Attack we’ll be mentored by real Ninjas, just come along to be part of them!
Reserve from one to three slots on your agenda and go to the OTN Lounge (@ the lobby of Moscone South)
What differs this year?
The new book covers the installation of a brand new Oracle RAC in release 12c on Oracle VirtualBox. Still not enough?
Among the volunteers we’ll have 5 Oracle ACEs or ACE Directors, some Certified Masters and a great representative of the RAC SIG board. You’ll recognize us because of our bandanas… Don’t worry, we are not an elite, we’re just good DBAs eager to share our experience, ear from you, and share good time. Sounds good?
If you attend, you’ll earn a special “RAC Attack Ninja” ribbon, so you can go back to work and boast with your colleagues (and your boss!).
And why not, propose a new RAC environment at your company and get it done with a little more confidence, for what it’s worth, that’s the real objective: practice with the RAC technology and get ready for a real scenario.
Maximize your experience @ RAC Attack
You can cheat and start reading the new version of the book (still in development): http://en.wikibooks.org/wiki/RAC_Attack_-_Oracle_Cluster_Database_at_Home/RAC_Attack_12c
Make sure that you accomplish some steps before starting your journey to OOW:
Give us your feedback and spread the word!
If you plan attend (good choice! :-)) , take a business card with you and get in touch with us. It’s a great networking opportunity. Take a lot of pictures, upload them on the social networks (the #RACAttack hashtag on twitter, the facebook page, the RAC SIG group on LinkedIn) and give us your feedback. Other RAC Attack events will be planned, so we can improve thank to your suggestions.
Hope to see you there.
Ludovico