Portal Menu
PHP-Nuke Titanium
Concurrent Versions System
https://cvs.86it.us









 
PHP-Nuke Titanium Concurrent Versions System » Blogs
[ Topic » PHP-Nuke Titanium ] [ Subject » ]

Apache server status for venomous.86it.us

Server Version: Apache/2.4.27 (Unix) OpenSSL/1.0.1e-fips mod_bwlimited/1.4
Server MPM: prefork
Server Built: Oct 13 2017 09:14:05 pm


Posted by Ernest Buffington on Fri Oct 13, 2017 9:15 pm

(Read More... Network Upgrade Apache v2.2.34 to v2.4.27 | Network Updates | Score: 0)
252 Reads
The 86it Social Network
PHP-Nuke Titanium Concurrent Versions System » Blogs
[ Topic » PHP-Nuke Titanium ] [ Subject » ]

I just upgraded Rack 68, the main network server. We are now running MariaDB Version: 10.1.28 globally... We were running MySQL Version: 5.6 and using the Federated engine. It turns out that the Federated project was dropped and at one time that portion of the code was maintained by a few Oracle developers. This is no longer the case and now with MariaDB, since the federated engine project was dropped, there definitely needed to be something done about it. A wonderful idea came about and it was to keep the project alive and get some fresh souls working on it. I give you FederatedX which is taking the place of the old not very well maintained Federated engine and with fresh souls helping the engine progress. They have already done some new wonderful things... 

What is the FederatedX storage engine?

The FederatedX Storage Engine is a storage engine that works with both MariaDB and MySQL. Where other storage engines are built as interfaces to lower-level file-based data stores, FederatedX uses libmysql to talk to the data source, the data source being a remote RDBMS. Currently, since FederatedX only uses libmysql, it can only talk to another MySQL RDBMS. The plan is, of course, to be able to use other RDBMS systems as a data source. There is an existing project Federated ODBC which was able to use PostgreSQL as a remote data source, and it is this type of functionality which will be brought to FederatedX in subsequent versions.

History

The history of FederatedX is derived from the History of Federated. Cisco needed a MySQL storage engine that would allow them to consolidate remote tables on some sort of routing device, being able to interact with these remote tables as if they were local to the device, but not actually on the device, since the routing device had only so much storage space. The first prototype of the Federated Storage Engine was developed by JD (need to check on this- Brian Aker can verify) using the HANDLER interface. Brian handed the code to Patrick Galbraith and explained how it needed to work, and with Brian and Monty's tutelage and Patrick had a working Federated Storage Engine with MySQL 5.0. Eventually, Federated was released to the public in the MySQL 5.0 release. There is every indication that the Federated engine existed in previous versions of MySQL due to the fact that Ernest Allen Buffington had previously used it with PHP-Nuke Titanium early on through discoveries of his own and with little or no documentation.

We were not quite ready to upgrade all the way to MariaDB 10.0.2 but when we did FederatedX had new support for assisted table discovery. So there is that and the fact that new exciting things are happening with the new engine project. It looks like the fresh new souls are working their buns off to make it awesome and are going the extra miles needed.

Internal workings of FederatedX

Normal database files are local and as such: You create a table called 'users', a file such as 'users.MYD' is created. A handler reads, inserts, deletes, updates data in this file. The data is stored in particular format, so to read, that data has to be parsed into fields, to write, fields have to be stored in this format to write to this data file.

With the FederatedX storage engine, there will be no local files for each table's data (such as .MYD). A foreign database will store the data that would normally be in this file. This will necessitate the use of the MySQL client API to read, delete, update, insert this data. The data will have to be retrieved via an SQL call "SELECT * FROM users ". Then, to read this data, it will have to be retrieved via mysql_fetch_row
one row at a time and then converted from the column in the select into the format that the handler expects.

The basic functionality of how FederatedX works

  • The user issues an SQL statement against the local federatedX table. This statement is parsed into an item tree
  • FederatedX uses the MySQL handler API to implement the various methods required for the storage engine.
  • It has access to the item tree for the SQL statement issued, as well as the Table object and each of its Field members. 
  • With this information, FederatedX constructs an SQL statement
  • The constructed SQL statement is sent to the Foreign data source through libmysql using the MySQL client API
  • The Foreign database reads the SQL statement and sends the result back to the MySQL client API to the origin
  • If the original SQL statement has a result set from the Foreign data source, the FederatedX storage engine iterates
  • through the result set and converts each row and column to the internal handler format
  • If the original SQL statement only returns the number of rows returned (affected_rows), that number is added to the
  • table stats which results in the user seeing how many rows were affected.

Posted by Ernest Buffington on Thu Oct 12, 2017 6:45 am

(Read More... Network Upgrade from MySQL v5.6 to MariaDB v10.1.28 | Network Updates | Score: 5)
298 Reads
The 86it Social Network
User Menu
Good morning 
Anonymous



Create User Account
Lost Password
Check My Cookie

Enter e-Mail Address
Password

 Online Members:
Network Member(s):

Network Guest(s):
01. Network Guest
02. Network Guest
03. Network Guest
 
Network Visitors
apewos
03 days
agewufoh
04 days
LasonyaEdd
01 week
DarrenNort
01 week
MargaritaV
01 week
LonnaMcNei
01 week
IonaBzi947
02 weeks
Romildo Jose Dias
02 weeks
LydiaOldak
03 weeks
ClaribelKe
04 weeks
ClaudioWoo
07 weeks
JarrodYiy
07 weeks
GregoryMon
07 weeks
GarfieldBe
07 weeks
AnkeHansma
07 weeks
DarrenChes
07 weeks
EdwardCord
07 weeks
Ernest Buffington
07 weeks
ElvaQ2767
07 weeks
DinoNoblet
07 weeks
MahaliaSta
07 weeks
DarrelA118
07 weeks
NateDitter
07 weeks
EdwardoHil
07 weeks
HiltonTije
09 weeks
StanleySau
09 weeks
Christophe
09 weeks
KentonMask
14 weeks
RamonPutna
14 weeks
BEEPhoebe
14 weeks
MadieKnox4
14 weeks
BrentonMcc
16 weeks
DaveK84904
16 weeks
ColemanHun
16 weeks
Aaron Marshall
16 weeks
TresaTozer
21 weeks
KJBAlisa70
21 weeks
LorenFoutc
22 weeks
Geneva4132
22 weeks
Mauricio02
22 weeks
ulavihub
23 weeks
MaricelaEm
24 weeks
ChanelNale
27 weeks
LoisFelici
27 weeks
VHYMitch03
27 weeks
LillaHolli
27 weeks
Dena07225
27 weeks
ArcherDoe1
27 weeks
CornellLin
27 weeks
MadisonTag
27 weeks
 


[ About Us ] - [ Disclaimer Statement ] - [ Privacy Statement ] - [ Terms of Use ]
[Blogs Feed] [Forums Feed] [Downloads Feed] [Web Links Feed] Powered by HTML Purifier [Validate robots.txt] PHP-Nuke XHTML 1.0
[ Loaded In 0.09 Seconds | Memory Used: 1.27 MB | (cvs.86it.us) DB Queries: 32 | Network User DB Queries: 12 | Network Music DB Queries: 1 ]