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)
310 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)
364 Reads
The 86it Social Network
User Menu
Good afternoon 
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
04. Network Guest
05. Network Guest
06. Network Guest
07. Network Guest
 
Network Visitors
yrabafe
01 day
ibopa
03 days
odelyzes
04 days
uvejetuk
05 days
JerroldSar
06 days
Aron
06 days
oqideb
01 week
ybonoq
01 week
mojuniaiduj
01 week
iwawena
01 week
MarisaC98
01 week
BonitaHarm
01 week
Christa62C
01 week
DianKell17
01 week
Magdalena7
01 week
MargaretaM
01 week
FranklynSo
01 week
ikizuwupu
01 week
aluce
01 week
KieraPrime
02 weeks
GertieChri
02 weeks
izysaji
02 weeks
atyguzol
02 weeks
odylit
02 weeks
GradyScott
02 weeks
ShelliBodd
03 weeks
RondaWarfi
03 weeks
ypovokyt
03 weeks
TYRSalvado
03 weeks
ywytyqiz
03 weeks
FinnCoffma
04 weeks
arehyhep
04 weeks
LewisClore
04 weeks
exyqynad
04 weeks
okaqyb
04 weeks
iqiki
04 weeks
ojifybav
04 weeks
Ernest Buffington
04 weeks
oloniha
05 weeks
ijokiwu
05 weeks
ibuvavihu
05 weeks
ycohevu
05 weeks
yluwata
05 weeks
awebam
06 weeks
eqegev
06 weeks
ydiqike
06 weeks
oregogix
06 weeks
lukejamie07
06 weeks
arexic
07 weeks
yfocus
07 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.07 Seconds | Memory Used: 1.29 MB | (cvs.86it.us) DB Queries: 32 | Network User DB Queries: 12 | Network Music DB Queries: 1 ]